380 Model Farm Road

$2,895,000

Roughly $13,470 a month with 20% down at 5% over 25 years, before property tax, insurance and heat. Add up the monthly cost ›

380 Model Farm Road

Quispamsis, New Brunswick

5 bed5 bath11,672 square feet

Want to see it?

I can arrange a showing and tell you honestly whether the asking price holds up.

Call (506) 650-1242Ask about this home

Listed by eXp Realty

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:66617)

The details

Property type
Single Family
Bedrooms
5
Bathrooms
5
Living area
11,672 square feet
Lot size
7.26 acres
Stories
2
Heating
Heat Pump, Propane
Cooling
Heat Pump
Basement
Partially finished, Full
Flooring
Hardwood, Marble, Ceramic
MLS® number
NB146492

Roughly $13,470/month principal and interest, assuming 20% down at 5% over 25 years — an illustration, not a quote. Run your own numbers.

Where it sits

Quispamsis
4.8 km
Hampton
9.0 km
Uptown Saint John
24.9 km

Straight-line distances from the coordinates the feed supplies.

On the map

Loading map…

The pin sits at the coordinates the feed supplies. Neighbourhood boundaries are the City of Saint John’s open data, drawn where the home falls inside one.

51 photos · tap any to view full size

Ask about this home

380 Model Farm Road

Whether the price holds up, what the neighbourhood is like, when you could see it. I’ll answer honestly, and if it’s not the right home I’ll say so.

Listed by eXp Realty

Andrew’s Assistant

AI concierge · Greater Saint John

Hi! I'm Andrew's assistant. Ask me about 380 Model Farm Road in Quispamsis, listed at $2,895,000: the facts the listing carries, how it compares to what else is for sale, or what happens next if you want to see it. For anything the listing does not say, I'll point you to Andrew.

AI-generated answers may be inaccurate and are general information only, not real estate, legal, or financial advice. For anything specific, call Andrew at (506) 650-1242.

Price watch

Hear if this home comes down in price

Sellers adjust. The site checks this home’s asking price every hour and emails you the moment it drops, with the old and new figures.

Watching

380 Model Farm Road, Quispamsis, New Brunswick

Keep looking

Homes like this one.

All 71 for sale in Quispamsis
Back to all listings

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

The information contained on this site is based in whole or in part on information that is provided by members of The Canadian Real Estate Association (CREA), who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members and assumes no responsibility for its accuracy. Listing content may include listings from real estate brokerages other than Andrew Shaw and REAL Broker; this website is operated by Andrew Shaw, a REALTOR® and member of CREA.

The listing content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically forbidden. The prohibited uses include commercial use, “screen scraping”, “database scraping”, and any other activity intended to collect, store, reorganize or manipulate data on the pages produced by or displayed on this website.