About this home

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

Listed by: Greg Hayden, Salesperson, Re/Max Hartford Realty

Home facts and features

Price details

List Price

$699,000

Gross Taxes for 2026

$7,828

Home facts

Bedrooms

Full Bathrooms

Partial Bathrooms

Parking Details

Attached Garage, Garage, Detached Garage

Property Type

House

Lot Size

2.0 acres

Depth

Year Built

Built in 2005 (21 yrs old)

Title

Freehold

Style

Bungalow

Exterior Finish

Vinyl

Heating Type

Heat Pump, Propane

Cooling

Heat Pump

Basement Details

Unfinished, Full, Walk out

Features

Balcony/Deck/Patio, Golf course/parkland

Agent details

Primary Agent

Greg Hayden

Primary Broker

Re/Max Hartford Realty

Listing details

Days on REW

44 Days

Property Views

MLS® Number

NB142992

Source

Canadian Real Estate Association

Is this your listing? Help it to stand out.

Mortgage Calculator

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

Schools nearby

1 School is within 2km

Hartland Community School

n/a
K - 12
In Catchment

52 McMullin RoadHartland, NB, E7P 2R7