This home's estimate is 11.9% higher than the average sale price ($450K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
154 Great Hill Pond Rd, Portland, CT 06480
About this home
Your dream of owning a waterfront property is answered TODAY!!!!! 50 FT of waterfront on 75 acre spring fed Great Hill Lake. Fishing year round, paddle boarding, kayaking, small motor boats (6 horse power max, NO jet ski's) only on this pristine lake. Beautiful wood floors and trim throughout, Newer roof 2018, New French door to deck overlooking the lake. Eat-in kitchen, 3 bedrooms, beautiful honey pine flooring throughout. Lower level basement potential to finish for additional living space/summer kitchen. Generator ready to run the essentials. This rare gem has many possibilities to make it your own! Perfect size lot to enjoy the amenities around you and not spend your weekends on lawncare. Property to be sold in "AS IS" condition.
Redfin Estimate
Earn from this home
List your home with Redfin and save $5,038
Get cash now or lower your monthly rate
List your home for rent
Market trends in 06480, CT
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 154 Great Hill Pond Rd
$190/sq ft
$190/sq ft
$201/sq ft
$201/sq ft
Tax history for 154 Great Hill Pond Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Garage Information
- Garage & Parking: Driveway, Off Street Parking
- Parking Information
- Parking Total Spaces: 2
Interior
- Virtual Tour Information
- Has Virtual Tour
- Interior Information
- Total Rooms: 5
- Laundry Room Location: 1st floor
- Laundry Room Info: Main Level
- In-Law Apartment: No
- Appliances Included: Electric Range, Refrigerator, Dryer
- Bathroom Information
- # of Baths (Full): 1
- Bedroom Information
- Beds Total: 3
- Room Information
- Room Count: 6
- Basement Description: Full
- Has Attic
- Attic Description: Pull-Down Stairs
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Wood
- Exterior Features: Deck, French Doors, Garden Area
- Lot Information
- Lot Description: Open Lot, Water View
- Building Information
- Foundation Type: Block, Concrete
- Construction Description: Frame, Block, Concrete
- Property Information
- Waterfront Description: Direct Waterfront, Frontage, Lake, Dock or Mooring
- Property Type: Single Family For Sale
- Living Area SQFT Per Public Record: 1930
- Driveway Type: Private
Financial
- Assessments Information
- Assessed Value: $186,690
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Septic
- Hot Water Description: Domestic, Oil
- Heat Type: Baseboard
- Heat Fuel Type: Oil
- Fuel Tank Location: In Basement
- Energy Features: Generator Ready
Location
- School Information
- Intermediate School: Per Board of Ed
- High School: Portland
- Elementary School: Per Board of Ed
- Location Information
- State: Connecticut
- Nearby Amenities: Golf Course, Putting Green, Stables/Riding
- Directions: GPS friendly
- Direct Waterfront
- County: Middlesex
Public facts
- Beds: 3
- Baths: 1.0
- Sq. Ft.: 1,930
- Stories: 2.0
- Lot Size: 4,356 square feet
- Style: Single Family Residential
- Year Built: 1924
- Year Renovated: —
- County: Middlesex County
- APN: 1033899
Other
- Documents & Disclosures
- Supplement Count Public: 5
Around this home
Schools
- K - 12
- Preschool & daycare
Public 2-4 • Assigned • 3.2mi
Public 7-8 • Assigned • 3.2mi
Public 9-12 • Assigned • 3.1mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
0.00% chance of being in a wildfire in next 30 years
7 days above 98° expected this year, 16 days in 30 years
27% chance of strong winds in next 30 years
3 unhealthy days expected this year, 4 days in 30 years
Sun exposure
In this area, properties receive around 9 hours in June and 4.5 hours in December, which is comparable to the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 06480
Home values near 154 Great Hill Pond Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1384 Sq. Ft. | $416,866 |
2 Beds | 1 Baths | 1156 Sq. Ft. | $348,017 |
3 Beds | - Baths | 446 Sq. Ft. | $357,087 |
1 Beds | 1 Baths | 592 Sq. Ft. | $194,354 |
3 Beds | 2 Baths | 1448 Sq. Ft. | $441,399 |
3 Beds | 1 Baths | 945 Sq. Ft. | $491,356 |
3 Beds | 1 Baths | 1109 Sq. Ft. | $427,132 |
| Address | Redfin Estimate |
|---|---|
1 Beds | 1 Baths | 754 Sq. Ft. | $335,070 |
2 Beds | 1 Baths | 662 Sq. Ft. | $362,108 |
3 Beds | 2.5 Baths | 2845 Sq. Ft. | $794,658 |
3 Beds | 1.5 Baths | 1752 Sq. Ft. | $401,661 |
2 Beds | 1.5 Baths | 1190 Sq. Ft. | $543,333 |
1 Beds | 1 Baths | 920 Sq. Ft. | $311,915 |
2 Beds | 1 Baths | 714 Sq. Ft. | $368,951 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 892 Sq. Ft. | $435,453 |
2 Beds | 1 Baths | 830 Sq. Ft. | $448,302 |
2 Beds | 2.5 Baths | 1782 Sq. Ft. | $776,250 |
2 Beds | 1 Baths | 982 Sq. Ft. | $382,807 |
2 Beds | 1 Baths | 585 Sq. Ft. | $303,820 |
3 Beds | 2 Baths | 3158 Sq. Ft. | $514,531 |
4 Beds | 3.5 Baths | 3560 Sq. Ft. | $689,927 |
More real estate resources
- Cities
- Zip Codes
- Minor Civil Divisions
- Popular Searches
| West Hartford homes for sale | |||
| North Haven homes for sale | |||
| Hartford homes for sale |
| 06416 homes for sale | |||
| 06457 homes for sale | |||
| 06480 homes for sale |
| Guilford homes for sale | |||
| Wallingford homes for sale | |||
| Glastonbury homes for sale | |||
| Farmington homes for sale | |||
| Madison homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.


















United States
Canada