$995,000

174 Barrett Hill Rd Unit 2 Union, ME 04862

3 beds
2 full
2,820 sqft
21.1 acres
House

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

Home typeSingle Family Residence
HeatingHot Water, Forced Air
StatusActive
CoolingHeat Pump
Size2,820 sqft
BasementYes
Lot size21.1 Acres
Year built1790
Parking11 - 20 Spaces, Gravel, On Site, Off Street
MLS #1618325
ViewFields, Mountain(s), Scenic, Trees/Woods

Virtual tour

Summary

  • MLS Number: 1618325
  • MLS Name: Maine Listings
  • Office Name: Camden Real Estate Company
  • Office Email: info@camdenre.com

IDXDisclaimer: 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. Equal Housing
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.¹

colonial-style house featuring roof with shingles, a chimney, and a front yard

$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.

All data from GreatSchools

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.

How much money do the neighbors make?

23%
<35k
56%
35k-100k
19%
100k-200k
2%
200k+

What level of education do the neighbors have?

High School Diploma
Post Secondary Degree
Masters Degree
Doctorate

What types of families live nearby?

37%
Single, No Kids
9%
Single, with Kids
36%
Married, No Kids
18%
Married, with Kids

Are the neighbors home owners or renters?

Home Owners
Renters

How old are people in this area?

13%
<11 yrs old
9%
12-17 yrs old
15%
18-34 yrs old
49%
35-64 yrs old
14%
65+ yrs old

What do the neighbors do for fun?

  • NASCARNASCAR
  • HuntingHunting
  • Figure SkatingFigure Skating

Where do the neighbors shop?

  • Bass Pro ShopsBass Pro Shops
  • Academy Sports & OutdoorsAcademy Sports & Outdoors
  • Wal-MartWal-Mart

Where do the neighbors go to eat?

  • Hardee'sHardee's
  • Jimmy JohnsJimmy Johns
  • ApplebeesApplebees

What do the neighbors drive?

  • GMCGMC
  • ChevroletChevrolet
  • RamRam

What do the neighbors listen to?

  • Classic CountryClassic Country
  • New CountryNew Country
  • OldiesOldies
All data provided by Home Junction and Claritas

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.

From Rocket Homes Real Estate and based on county public records data.

More resources