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.
Single-familyProperty Type
1998Year Built
0.63 acresLot Size
$273Price/Sq.Ft.
$46/moHOA Dues
1 car garageParking
Listed by Morgan Espling• United Country Lifestyle Properties of Maine
Listed by Rebecca McKay• United Country Lifestyle Properties of Maine
Dreaming about a waterfront home? Here it is! Year round, 3 bedrooms, 2 full baths - large kitchen, dining room & living room. Open concept allows full enjoyment views of Cold Stream Pond! This panoramic view will help you relax and enjoy Maine's beautiful waterfront. Easy access to waters edge at your 102ft waterfront home. Full finished basement allows more recreational area! Large decks overlooking Cold Stream Pond. You won't be disappointed viewing this meticulously maintained home.
MREIS #1339460
Aug 8, 2018
Price Changed
$259,000
$123/sq ft
Jul 15, 2018
Price Changed
$265,000
$125/sq ft
Feb 23, 2018
Listed
$269,000
$127/sq ft
MREIS #1156616
Jun 3, 2015
Sold
$218,000
$103/sq ft
Mar 5, 2015
Listed
$235,900
$112/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$7,534 (+9.9%)
$122,000 + $311,000
$433,000
2024
$6,854 (+6.8%)
$93,500 + $239,200
$332,700
2023
$6,415 (+16.9%)
$65,400 + $184,000
$249,400
2022
$5,487 (+17.6%)
$65,400 + $184,000
$249,400
2021
$4,664 (−0.6%)
$65,400 + $184,000
$249,400
2020
$4,692 (−6.5%)
$63,900 + $153,300
$217,200
2019
$5,017 (+18.2%)
$63,900 + $153,300
$217,200
2018
$4,243 (+2.4%)
$49,600 + $134,100
$183,700
2017
$4,142 (+0.9%)
$49,600 + $134,100
$183,700
2016
$4,104 (+0.6%)
$49,600 + $134,100
$183,700
2015
$4,078 (−3.3%)
$49,600 + $134,100
$183,700
2013
$4,218
$49,600 + $134,100
$183,700
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
0.63 Acres
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Multi-Family (2-4 Unit)
County
Penobscot County
APN
370540
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 27, 2026.
Property details
Parking
Parking Information
Has Garage
# of Garage Spaces: 1
Parking Features: 1 - 4 Spaces, Paved
Vehicle Storage: 2 Car
Interior
Virtual Tour
Bathroom Information
# of Baths (1/2): 1
# of Baths (Full): 2
Room 1 Information
Type: Laundry
Level: Basement
Room 2 Information
Type: Bedroom 2
Level: Second
Features: Closet
Room 3 Information
Type: Kitchen
Level: First
Room 4 Information
Type: Living Room
Level: First
Room 5 Information
Type: Primary Bedroom
Level: Second
Room 6 Information
Type: Dining Room
Level: First
Room 7 Information
Type: Family Room
Level: Basement
Room 8 Information
Type: Bedroom 1
Level: First
Features: Closet
Room 9 Information
Type: Bonus Room
Level: Second
Basement Information
Basement Entry: Interior, Walk-Out Access, Finished, Full
Interior Features
# of Rooms: 9
Interior Features: 1st Floor Bedroom
Furnished: Negotiable
Washer, Refrigerator, Gas Range, Dryer, Dishwasher, Cooktop
Window Features: Double-Pane Windows
Flooring: Wood, Vinyl
Other Equipment: Generator
Exterior
Building Information
Construction Materials: Vinyl Siding, Wood Frame
Foundation Details: Concrete Perimeter
Roof: Shingle
Structure Type: Post & Beam
Total Building Area (Sq. Ft.): 2,112
Exterior Features
Other Structures: Shed(s)
Property Information
Property Sub Type: Single Family Residence
Year Built: 1998
Above-Grade Finished Area (Sq. Ft.): 1,328
Below-Grade Finished Area (Sq. Ft.): 784
Green Energy Efficient: Water Heater
Lot Information
Lot Size (Sq. Ft.): $27,442.80
Lot Size (Acres): 0.63
Lot Size Source: Public Records
Lot Features: Well Landscaped, Level, Near Shopping, Near Turnpike/Interstate, Near Town
Road Surface Type: Gravel, Dirt
Zoning: Residential
Waterfront Information
Waterfront: Yes
Water Body Name: Upper Cold Stream Pond
Water Body Type: Lake, Pond
Water View: Yes
Financial
Tax Information
Annual Tax Amount: $7,534.20
Tax Year: 2026
Utilities
Utility Information
Has Heating
Heating: Pellet Stove, Heat Pump, Baseboard
Has Cooling
Cooling: Heat Pump
Electric: Circuit Breakers
Sewer: Private Sewer, Septic Design Available
Water Source: Well, Private
Water Heater: Electric, Heat Pump
Location
HOA Information
Has Association
Association Fee: $550
Association Fee Frequency: Annually
Pets Allowed: No Restrictions
Location Information
Unparsed Address: 454 Stanhope Mill Road, Lincoln, ME 04457
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 0.63 acres
Style: Multi-Family (2-4 Unit)
Year Built: —
Year Renovated: —
County: Penobscot County
APN: 370540
Home facts updated by county records on Jul 27, 2026
Around this home
Schools
Some nearby schools may not be within this home's attendance zone. Please check the Regional School Unit 67 website to verify.
Northern Penobscot Technical Center Region 3
Public N/A • 5.0mi
Greater Lincoln Christian Academy
Private PreK-8 • 3.9mi
Provided by GreatSchools
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
1/10 Heat Factor
7 days above 89° expected this year, 15 days in 30 years
5/10 Wind Factor
26% chance of strong winds in next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Lincoln, ME • 04457
Average low and high temperatures (°F)
25
8
30
8
42
22
52
33
66
44
77
54
83
60
83
54
75
49
60
40
44
31
30
13
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
95/ 100
Exceptional sunlight
Sunscore
This home receives average direct sun exposure in Lincoln. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.