$2,895,000
Unlock Price Rating!

380 Model Farm Road, Quispamsis, NB E2G1L8

 Contact
5 Beds
5 Baths
11,672 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. (id:58753)

  • MLS® NB146492
  • Date Listed09/08/2026
  • Days on Realty 20 Days
  • Bedrooms 5
  • Bathrooms 5 baths
  • Lot Size 316,246 sq. ft
  • Sewer Public Sewer
  • Property Type Single Family Residence
  • Year Built 2004
  • Water Well
  • Square Feet 11,672 sq. ft
  • Price Per Sq. Ft $248.03

Interior Features

  • Flooring Hardwood, Marble, Ceramic, Wood
  • Cooling Heat Pump
  • Heating Heat Pump, Propane

Exterior / Lot Features

  • Roof -
  • Lot Size Acres -
  • Lot Size SQFT 316,245.60
  • Lot Features Treed, Balcony/ Deck/ Patio

Directions

From Hampton Rd turn onto Model Farm Rd

Sales & Tax History

Source: Public Records

Local Neighborhood Highlights for E2G1L8

Discover key demographics, population statistics, and environmental insights for the Quispamsis, NB area.

Walkability in NB / E2G1L8

Source: Walk Score

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 E2G1L8

Frequently Asked Questions for 380 Model Farm Road

Source: Realty.com

380 Model Farm Road, Quispamsis, NB E2G1L8 in Quispamsis, NB E2G1L8 is a single family residence listed at $2,895,000. Highlights include 5 bedrooms, 5 bathrooms, 11,672 sq. ft., built in 2004, $248 per sq. ft.. 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 E2G1L8.

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.

This content last refreshed on 2026-09-28 04:31:07. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.