Set on the shores of Upper Cold Stream Pond, The Big Narrows,' this beautifully maintained 3-bedroom, 2.5-bath home offers the kind of lake living that feels effortless from the moment you arrive.
Built in 1998 and thoughtfully updated throughout, the home blends classic warmth with modern upgrades. The main level features a bright, open-concept layout with a renovated kitchen complete with granite countertops, stainless appliances, and crisp white cabinetry. Hardwood floors carry throughout the living and dining spaces, all oriented to take in peaceful lake views. Step out onto the deck and you're immediately connected to the water.
Convenience meets flexibility on the first floor with a full bath and bedroom, making single-level living or guest accommodations easy.
Upstairs, you'll find two spacious bedrooms, including a primary with its own private balcony overlooking the pond. A fully renovated bathroom completes the second level, along with smart knee-wall storage in both bedrooms.
The finished walkout basement expands your living space with a bunkroom setup, crafting area, built-in storage, and a half bath--perfect for coming in from the lake without tracking water through the main home.
Additional upgrades include a new roof (2021), energy-efficient heat pump water heater, and a fully integrated Generac generator for peace of mind year-round.
Across the street, a one-bay garage with a boat-sized carport offers ideal storage for all your recreational gear. With 200 AMP service to the home and 100 AMP to the garage, the property is well-equipped for both everyday living and hobby use.
Upper Cold Stream Pond is known for its clear waters and exceptional fishing, with salmon, trout, perch, and more. A public boat launch is located just up the road, and nearby ATV trails make this a true four-season destination.
Active under contract
$575,000
454 Stanhope Mill Road, Lincoln, ME 04457
3beds
2,112sqft
Est.:
Single Family Residence
Built in 1998
0.63 Acres Lot
$558,500 Zestimate®
$272/sqft
$46/mo HOA
What's special
Renovated kitchenGranite countertopsCrisp white cabinetryHardwood floorsStainless appliancesBright open-concept layout
- 5 days |
- 710 |
- 41 |
Zillow last checked:
Listing updated:
Listed by:
United Country Lifestyle Properties of Maine 207-794-6164
Source: Maine Listings,MLS#: 1657370
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 239.25 Square Feet
- Dimensions: 14.5 x 16.5
Bedroom 1
- Features: Closet
- Level: First
- Area: 104.5 Square Feet
- Dimensions: 9.5 x 11
Bedroom 2
- Features: Closet
- Level: Second
- Area: 156 Square Feet
- Dimensions: 12 x 13
Bonus room
- Level: Second
- Area: 156 Square Feet
- Dimensions: 12 x 13
Dining room
- Level: First
- Area: 165 Square Feet
- Dimensions: 11 x 15
Family room
- Level: Basement
- Area: 441 Square Feet
- Dimensions: 21 x 21
Kitchen
- Level: First
- Area: 154 Square Feet
- Dimensions: 11 x 14
Laundry
- Level: Basement
- Area: 55 Square Feet
- Dimensions: 11 x 5
Living room
- Level: First
- Area: 192 Square Feet
- Dimensions: 16 x 12
Heating
- Baseboard, Heat Pump, Pellet Stove
Cooling
- Heat Pump
Features
- Flooring: Vinyl, Wood
- Windows: Double Pane Windows
- Basement: Interior Entry
- Has fireplace: No
Interior area
- Total structure area: 2,112
- Total interior livable area: 2,112 sqft
- Finished area above ground: 1,328
- Finished area below ground: 784
Property
Parking
- Total spaces: 1
- Parking features: Garage
- Garage spaces: 1
Features
- Has view: Yes
- View description: Scenic, Trees/Woods
- Body of water: Upper Cold Stream Pond
- Frontage length: Waterfrontage: 100,Waterfrontage Owned: 100
Lot
- Size: 0.63 Acres
Details
- Additional structures: Shed(s)
- Parcel number: LNCNM106L003
- Zoning: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence
Materials
- Roof: Shingle
Condition
- Year built: 1998
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Private Sewer, Septic Design Available
- Water: Private, Well
Community & HOA
HOA
- Has HOA: Yes
- HOA fee: $550 annually
Location
- Region: Lincoln
Financial & listing details
- Price per square foot: $272/sqft
- Tax assessed value: $332,700
- Annual tax amount: $7,534
- Date on market: 4/10/2026
Estimated market value
$558,500
$531,000 - $586,000
$2,469/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 4/15/2026 | Contingent | $575,000$272/sqft |
Source: | ||
| 4/10/2026 | Listed for sale | $575,000+125.5%$272/sqft |
Source: | ||
| 5/3/2019 | Sold | $255,000+17%$121/sqft |
Source: | ||
| 6/3/2015 | Sold | $218,000$103/sqft |
Source: | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $6,854 +6.8% | $332,700 +33.4% |
| 2023 | $6,415 +16.9% | $249,400 |
| 2022 | $5,487 +17.6% | $249,400 |
| 2021 | $4,664 -0.6% | $249,400 +14.8% |
| 2020 | $4,692 -6.5% | $217,200 |
| 2019 | $5,017 +18.2% | $217,200 +18.2% |
| 2018 | $4,243 +2.4% | $183,700 |
| 2017 | $4,142 +0.9% | $183,700 |
| 2016 | $4,104 +0.6% | $183,700 |
| 2015 | $4,078 -0.9% | $183,700 |
| 2014 | $4,115 -2.4% | $183,700 |
| 2013 | $4,218 +15.6% | $183,700 |
| 2012 | $3,648 +4.4% | $183,700 +5.8% |
| 2010 | $3,495 | $173,700 |
Find assessor info on the county website
Monthly payment
Est. payment
$3,524/mo
Principal & interest
$2965
Property taxes
$513
HOA Fees
$46
More affordability tools
Climate risks
Neighborhood: 04457
Nearby schools
GreatSchools rating
- 6/10Mattanawcook Jr High SchoolGrades: 4-8Distance: 5 mi
- 2/10Mattanawcook AcademyGrades: 9-12Distance: 5.9 mi
- 4/10Ella P Burr SchoolGrades: PK-3Distance: 5.8 mi
A local agent can set up tours, give advice and negotiate with sellers.
- Maine
- Penobscot County
- Lincoln
- 04457
- 454 Stanhope Mill Road




