14 hours on Market

380 MODEL FARM ROAD, Quispamsis, New Brunswick E2G1L8

Detached
5
5 + 1
~11672 sqft
$2,895,000
Get pre-qualifiedPowered by nesto
Detached
5
5 + 1
~11672 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market14 hours

Estimated valueNot available

Price/Sqft$248/sqft

Monthly cost

Open Calculator

Description

A remarkable estate where exceptional craftsmanship, extraordinary scale and resort-style living come together against a beautiful river backdrop. Extensively renovated with uncompromising attention to detail, this residence impresses from the moment you enter the soaring 19 foyer, where a sweeping custom staircase introduces interiors rich in wainscoting, millwork, crystal lighting and heated Italian tile. At the heart of the home, an extraordinary kitchen features a 17 island, exotic granite, commercial-grade appliances and custom cabinetry, opening to an inviting hearth room and dramatic two-storey great room with a 19 stone fireplace,floating staircase and walls of glass capturing the view. The main-level primary retreat is exceptional, with a fireside sitting area, spa-inspired ensuite and spectacular 19 custom dressing room. Upstairs, beautifully appointed bedrooms, renovated baths and extensive built-ins continue the attention to detail. The finished lower level was designed for entertaining with a custom bar, dance floor, billiards area and gym. Outdoors, expansive decking, pool, hot tub and trout pond create a private four-season retreat. Completing this rare offering are exceptional attached 3 garage with epoxy floor, separate 4 car garage/workshop and oversized garage for RV with loft apartment above it. All buildings were reshingled 2 years ago. A remarkable space for a collector, entrepreneur or extended family. (id:39198)


Property Details

StyleHouse
ViewRiver view
Age of property2004
SqFt~11672 SqFt
Lot Size-
Parking Spaces-
MLS ®NumberNB146492
Community NameQuispamsis
Data SourceCREA
Listing byeXp Realty

Features

Heating: Heat Pump, Propane
Cooling: Heat Pump
Basement: Partially finished, Full

Main level Floor

Laundry room

10'10'' x 15'1''

Other

9'10'' x 18'2''

Sitting room

13'2'' x 13'6''

Foyer

13'7'' x 11'9''


Property History

Sep 8, 2026
ListedActive
$2,895,000
14 hours on market
history photo preview50
Listing by crea®
Property listed by eXp Realty, Brokerage
Agent Banner Image
Interested in this property?Get in touch to get the inside scoop.

Population and Demographics

Overview

Total population 19387
Average household income $144,431

Age (%)

0 to 19
25%
20 to 34
14%
35 to 49
21%
50 to 64
21%
65 and plus
18%

Household composition (%)

Single family
80%
Single person
19%
Multi person
2%
Multi family
0%

Mother tongue (%)

English
92%
French
4%
Others
3%

House tenancy (%)

Owners
90%
Renters
10%

What’s nearby?Essentials within 5 km

Local Logic

Transportation Scores

Estimated Budget

Powered by:
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.