Property Attributes
- MLS® #NB142992
- TypeSingle Family
- Listing Status Active
- CityHartland
- AreaWoodstock & Area
- Postal CodeE7P 2R7
- Style
- Year Built2005
- Taxes$ 7828
- Price$ 699,000
- Bedrooms3
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage1890
- Lot Size2 Acres
Data Source:
New Brunswick Real Estate Board
Property Description
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.
| Price History | |
|---|---|
| 7/2/2026 | Listed $699,000 |
General Features
| Roof | Asphalt Shingle |
|---|---|
| Exclusions | Air compressor in shop |
| Occupancy | Owner |
| Water Supply | Well |
| Style | Home |
| Age | 21 |
| Property Type | Residential |
| Tax Year | 2026 |
| Parcel Number | 10105682 |
| Status | Active |
| Region | Fredericton |
| District | Carleton County |
| Year Built | 2005 |
| City | Hartland |
| Site Influences | Golf Course,Hospital,School(s) Nearby |
| Heating Cooling | Heat Pump - Ducted,Propane |
| Taxes | 7828.34 |
| Virtual Tour | https://my.matterport.com/show/?m=DYWDHJcqGQT |
| Schools | Hartland Community School (K-12) |
| Sale Type | Registered Owner |
| Street Name | McMullin |
| Public Remarks | 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 |
| Subdistrict | Woodstock & Area |
Interior Features
| Interior Features | Air Exchanger,Ensuite,Family Room – Main Floor,Laundry – Main Floor,Primary – Main Floor,Wired-In Generator |
|---|---|
| Basement | Full,Unfinished,Walkout |
| Floor Covering | Ceramic,Wood |
| Full Baths | 2 |
| Half Baths | 1 |
| Room Count | 10 |
| Sq Ft Total | 1890 |
| Beds Total | 3 |
Exterior Features
| Exterior | Vinyl |
|---|---|
| Foundation | ICF |
| Garage Type | Attached,Detached,Triple |
| Driveway | Asphalt |
| Land Features | Landscaped |
| Waterfront Name | Saint John River |
| Garage Capacity | Attached: 47x33 Detached: 40x70 with side addition 25x76 |
| Sewers | Municipal |
| Water View Y/N | Yes |
| Garage Y/N | Yes |
| Lot Size Unit | Acres |
| Street Number | 52 |
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
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