Space
Finished area and layout
- Living Area
- 1,890 sqft
- Above Grade
- 1,890 sqft
- Finished Breakdown
- Above 1,890 sqft
- Bedrooms
- 3
- Bathrooms
- 3





Property Snapshot
MLS #NB142992
Finished area and layout
Type, style and structure
This 3-bedroom, 3-bathroom single family in Hartland offers 1,890 sqft of living area on a 2 ac lot. Built in 2005. The property has lot dimensions of 2. The home features ceramic and wood flooring, heat pump, propane heating, heat pump, a unfinished, full, walk out basement.
This spectacular 2-acre estate offers an unparalleled blend of luxury, functionality, and breathtaking views of the Saint John River and the historic world's longest covered bridge. At the heart of the property sits a sweeping ranch-style home. The expansive main level features a magnificent open-concept living area anchored by a cozy propane fireplace, a formal office, a family room, and a practical mudroom. Accommodations include three spacious bedrooms and two and a half bathrooms. The potential extends downward into a massive, full walk-out insulated concrete form (ICF) basement that opens toward the river, ready to be customized to your lifestyle. Two standout mechanical features include a fully integrated central heating and air conditioning system and a standby propane generator for ultimate peace of mind. Attached is an oversized 33'x47' attached four-car garage fully finished and insulated. Just steps from the main residence is an absolutely massive, 4,700-square-foot dream shop that commands attention. The core of this facility is a 40'x70' heated workspace boasting soaring 16-foot ceilings, an integrated mechanic's pit, a dedicated office or workspace with its own half bath, and two 14-foot overhead doors. Adding to its immense capability is a 25'x76' addition equipped with two more overhead doors, making it ideal for commercial endeavors, extensive vehicle collections, or heavy equipment storage. A provincial ATV and snowmobile trail is at the bottom of the hill. Furthermore, it is only a short drive to the Upper River Valley Hospital, local K-12 schooling, grocery shopping, and the fairways of the Covered Bridge Golf & Country Club, delivering a truly unique lifestyle opportunity. (id:60351)
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
The last house on McMullin Road
Listed by Greg Hayden, Re/Max Hartford 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 Greg Hayden, Re/Max Hartford Realty · MLS# NB142992
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.