#1618039, Listing Office: RE/MAX JARET & COHN
174 Barrett Hill Rd Unit 2 Union, ME 04862
Property details
About 174 Barrett Hill Rd Unit 2
A historic and architecturally significant Colonial home, beautifully-restored and thoughtfully-updated to offer comfort, warmth, and abundant natural light, all set in a spectacular location overlooking rolling fields and the hills of Union. The heart of the home is a stunning kitchen that blends authentic charm with modern convenience, featuring custom cabinetry, updated appliances, a classic walk-in pantry, a cozy eat-in breakfast area, and a separate laundry room. Designed with flexibility in mind, the main floor includes a spacious bedroom and full bath, perfect for one-floor living, along with a welcoming living room with fireplace, a charming dining room, and a warm study with woodstove hookup. Upstairs, four additional rooms include three bedrooms, and a versatile space currently used as an exercise room—easily adapted to suit your needs. A full bath completes the second floor. Set on an expansive lot with mature landscaping, the property features open fields that gently slope toward wooded borders, stone walls and a tranquil pond. An attached one-car garage and additional finished and unfinished spaces offer ample room for hobbies, storage, or creative pursuits. Located just minutes from the conveniences of Union Village, this home offers a rare and seamless blend of historic character and modern living—with unforgettable sunsets to match.
Highlights
Virtual tour
Summary
- MLS Number: 1618325
- MLS Name: Maine Listings
- Office Name: Camden Real Estate Company
- Office Email: info@camdenre.com
Disclaimer: Based on information from the Maine Real Estate Information System, Inc. (d/b/a Maine Listings. Listing data is derived in whole or in part from the Maine IDX and is for consumers' personal, noncommercial use only. Dimensions are approximate and not guaranteed. All data should be independently verified. Copyright © 2025 Maine Real Estate Information System, Inc. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 4/18/2025, 12:50:54 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹

$995,000
174 Barrett Hill Rd Unit 2
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
4
Union Elementary School
Public District PK-6
0.7 mi
•1070 Heald Hwy
2
Warren Community School
Public District PK-6
6.4 mi
•117 Eastern Rd
10
Prescott Memorial School
Public District KG-6
6.4 mi
•100 Waldoboro Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $62,656. The majority of Union, ME residents have income between $35k-100k annually. The most common type of family is single, no kids. Residents of this area typically have post secondary degree education.
Similar homes for sale
Frequently asked questions
About 174 Barrett Hill Rd Unit 2
This home is located at 174 Barrett Hill Rd Unit 2 in Union, ME and zip code 04862. This 2,820 square foot home, which was built in 1790, sits on a 21.10 acre lot. Features: 3 bedrooms, 2 bathrooms. It is currently priced at $995,000.