Address
380 Model Farm Road, Quispamsis, NB
Price
$ 2,895,000
Property Attributes
- MLS® #NB146492
- TypeSingle Family
- Listing Status Active
- CityQuispamsis
- AreaMeenan`s Cove-Hammond River
- Postal CodeE2G 1L8
- Style
- Year Built2004
- Taxes$ 22533
- Price$ 2,895,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage11672
- Lot Size7.26 Acres
Data Source:
New Brunswick Real Estate Board
Property 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.
| Price History | |
|---|---|
| 9/8/2026 | Listed $2,895,000 |
General Features
| Roof | Asphalt Shingle |
|---|---|
| Occupancy | Owner |
| Water Supply | Well |
| Style | Home |
| Age | 22 |
| Property Type | Residential |
| Tax Year | 2026 |
| Parcel Number | 00255257 |
| Status | Active |
| Region | Saint John |
| District | Rothesay & Quispamsis |
| Year Built | 2004 |
| City | Quispamsis |
| Site Influences | Churches,Hilltop,Recreation Nearby,School(s) Nearby,Shopping Nearby |
| Heating Cooling | Fireplace-Gas,Heat Pump - Ducted,Heat Pump - Ductless,Propane |
| Taxes | 22533.30 |
| Supplement Modification Timestam | 2026-09-07T20:45:14.020 |
| Virtual Tour | https://youtu.be/Ql0Y9UaVXYQ |
| Sale Type | Registered Owner |
| Street Name | Model Farm |
| Public Remarks | A remarkable estate where exceptional craftsmanship,extraordinary scale and resort-style living come together against a beautiful river backdrop. Extensively renovated with uncompromising attention t |
| Subdistrict | Meenan`s Cove/Hammond River |
Interior Features
| Basement | Full,Partially Finished |
|---|---|
| Floor Covering | Ceramic,Hardwood,Heated,Marble,Wood |
| Full Baths | 4 |
| Half Baths | 1 |
| Room Count | 18 |
| Sq Ft Total | 11672 |
| Beds Total | 5 |
Exterior Features
| Exterior | Stone |
|---|---|
| Foundation | Concrete |
| Garage Type | Attached,Detached,Triple,Other |
| Driveway | Asphalt,Private Parking,RV Parking,Width - Triple |
| Land Features | Hilltop,Landscaped,Partially Fenced,Stream/Pond,Treed |
| Garage Capacity | attached 3 car,detached 4 car/workshop,oversized RV garage |
| Sewers | Municipal |
| Water View Y/N | Yes |
| Garage Y/N | Yes |
| Lot Size Unit | Acres |
| Street Number | 380 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No Strata Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in E2G 1L8
Price
Year Built
Visits
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating