1.29 km
Distance
5
Beds
5
Baths
-
Sq Ft
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.
Listing By: KIM LEGGE - eXp Realty 
- MLS® NB146492
- Date Listed09/08/2026
- Days on Realty 19 Days
- Bedrooms 5
- Bathrooms 4 Full baths, 1 Half baths
- Lot Size 316,246 sq. ft
- Sewer Public Sewer
- Property Type Single Family Residence
- County Kings
- Year Built 2004
- Water Well
Interior Features
- Flooring Ceramic, Hardwood , Heated, Marble, Wood
- Heating Fireplace-Gas, Heat Pump - Ducted, Heat Pump - Ductless, Propane
Exterior / Lot Features
- Roof Asphalt
- Lot Size Acres -
- Lot Size SQFT 316,245.60
- Lot Features Hilltop, Landscaped, Partially Fenced, Stream/ Pond, Treed
Sales & Tax History
Source: Public Records
Local Neighborhood Highlights for E2G 1L8
Discover key demographics, population statistics, and environmental insights for the Quispamsis, NB area.
0/100
Car-Dependent
Walk Score ®
0/100
Minimal Transit
Transit Score ®
26/100
Bikable
Bike Score ®
Overview
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
Walkability averages in the surrounding area
The average walkability score in the surrounding area is Walk Score: 3/100, Transit Score: 0/100, Bike Score: 23/100.
Points of Interest near 380 Model Farm Road, Quispamsis, NB E2G 1L8
Frequently Asked Questions for 380 Model Farm Road
Source: Realty.com
380 Model Farm Road, Quispamsis, NB E2G 1L8 in Quispamsis, NB E2G 1L8 is a single family residence listed at $2,895,000. Highlights include 5 bedrooms, 5 bathrooms, built in 2004. Realty.ca has 50 photos, sales history, school insights, and mortgage tools for this listing.
Realty.com has 50 photos of 380 Model Farm Road.
Our records indicate that 380 Model Farm Road was built in 2004.
The full address for this home is 380 Model Farm Road, Quispamsis, NB E2G 1L8.
380 Model Farm Road has been listed on Realty.com since Tue September 08, 2026
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 3/100, Transit Score: 0/100, Bike Score: 23/100.
Listing provided courtesy of:
eXp Realty
(tel: (506) 654-1727)
Listing agent:
KIM LEGGE
This content last refreshed on 2026-09-27 11:03:31. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.