Space
Finished area and layout
- Living Area
- 11,672 sqft
- Above Grade
- 8,937 sqft
- Finished Breakdown
- Above 8,937 sqft
- Bedrooms
- 5
- Bathrooms
- 5





Property Snapshot
MLS #NB146492
Finished area and layout
Type, style and structure
This 5-bedroom, 5-bathroom single family in Quispamsis offers 11,672 sqft of living area on a 7.26 ac lot. Built in 2004, 2 storeys. The property has lot dimensions of 7.26. The home features hardwood and marble and ceramic and wood flooring, heat pump, propane heating, heat pump, a partially finished, full basement, a fireplace.
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:60351)
From Hampton Rd turn onto Model Farm Rd
We can help you find properties matching your criteria, including exclusive listings not yet on the market.
Save favorites, track showings, view sold data & get market alerts — Free account — 100% free
Land, frontage and setting
Price, taxes and monthly charges
Listed by Kim Legge, eXp Realty
The listing data displayed is deemed reliable but is not guaranteed accurate by the Canadian Real Estate Association (CREA). 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 The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.
Not A Dream Realty Inc., Brokerage is a member of CREA and the Toronto Regional Real Estate Board. All information should be independently verified. © 2026 Not A Dream Realty Inc., Brokerage. All rights reserved.
Important notice: This website provides free general real estate information for consumer convenience. Listing data, maps, photos, descriptions, measurements, room sizes, lot sizes, taxes, prices, availability, school/market information, estimates, and other property details may be incomplete, delayed, approximate, generated from third-party sources, or changed without notice. We do not warrant that any information is complete, current, or error-free, and we have not independently verified all information shown. Do not rely on this website alone when making a purchase, sale, lease, financing, investment, tax, legal, valuation, or insurance decision. Verify all material facts directly with the listing brokerage, real estate board, municipality, lender, insurer, lawyer, inspector, surveyor, or other qualified professional, as applicable. Nothing on this website is an appraisal, market valuation, price opinion, professional recommendation, or legal, financial, tax, engineering, inspection, or investment advice. To the fullest extent permitted by law, the website operator, brokerage, and their representatives are not responsible for losses or damages arising from errors, omissions, delays, changes, or reliance on information displayed here.
Connect with a local real estate professional for a private showing or more details.
Listed by Kim Legge, eXp Realty · MLS# NB146492
Configured mortgage defaults and jurisdiction rules are required before property payment estimates can be calculated.
Disclaimer: The mortgage estimates and monthly cost calculations shown above are for illustrative purposes only and should not be relied upon as financial advice. Actual mortgage rates, terms, and eligibility depend on your personal financial situation, credit history, and current market conditions. Please consult a licensed mortgage broker, financial advisor, or your bank to determine your actual affordability and mortgage costs before making any purchasing decisions.
Calculating…
Estimate from the jurisdiction's published transfer-tax rates. Consult your lawyer for exact amounts.