This home's estimate is 50.6% higher than the average sale price ($515K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
152 Great Hill Pond Rd, Portland, CT 06480
About this home
Custom built in 2002 trilevel contemporary home on great hill pond! Top level is garage to foyer and 2nd bdrm with full bath. Stairs to great rm with flr to ceiling views! Gourmet kitchen, master bedroom with floor to ceiling views . Lower level rec room central air, central vac, automatic back up generac system.
Redfin Estimate
Earn from this home
List your home with Redfin and save $7,763
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 152 Great Hill Pond Rd
$252/sq ft
$252/sq ft
$258/sq ft
$79/sq ft
Tax history for 152 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: Attached Garage
- Garages Number: 2
Interior
- Interior Information
- Total Rooms: 5
- Laundry Room Location: Lower Level
- Interior Features: Cable - Available, Central Vacuum, Auto Garage Door Opener, Open Floor Plan
- Fireplaces Total: 2
- Cooling System: Central Air
- Appliances Included: Dishwasher, Disposal, Dryer, Oven/Range, Refrigerator, Range Hood, Washer
- Bathroom Information
- # of Baths (Full): 2
- # of Baths (Half): 1
- Bedroom Information
- Beds Total: 2
- Room Information
- Room Count: 6
- Basement Description: Full With Walk-Out, Partially Finished
Exterior
- Exterior Features
- Exterior Siding: Stucco
- Exterior Features: Grill, Patio, Stone Wall
- Lot Information
- Lot Description: Open Lot, Sloping Lot, Fence - Partial, Professionally Landscaped
- Building Information
- Color: TAN
- Property Information
- Waterfront Description: Dock or Mooring, Frontage, Lake, View
- Property Type: Single Family For Sale
- Driveway Type: Cement
Financial
- Assessments Information
- Assessed Value: $233,730
- Rental Information
- Lease Purchase YN: No
Utilities
- Utility Information
- Water Source: Private Well
- Sewage System: Septic
- Hot Water Description: Domestic
- Heat Type: Radiant
- Heat Fuel Type: Oil
- Fuel Tank Location: Above Ground
- Energy Features: Generator, Thermopane Windows
Location
- School Information
- High School: Boe
- Elementary School: Boe
- Location Information
- State: Connecticut
- Directions: Rte 66 to depot hill rd keep going straight turns into great hill pond road
- Direct Waterfront
- County: Middlesex
Public facts
- Beds: 2
- Baths: 2.5
- Sq. Ft.: 1,782
- Stories: 2.0
- Lot Size: 9,148 square feet
- Style: Single Family Residential
- Year Built: 2002
- Year Renovated: —
- County: Middlesex County
- APN: 1033898
Other
- Documents & Disclosures
- Supplement Count Public: 2
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 152 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 |
2 Beds | 1 Baths | 830 Sq. Ft. | $448,302 |
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 |
3 Beds | 1 Baths | 1930 Sq. Ft. | $503,836 |
3 Beds | - Baths | 446 Sq. Ft. | $357,087 |
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 | 662 Sq. Ft. | $362,108 |
3 Beds | 2.5 Baths | 2845 Sq. Ft. | $794,658 |
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
- Zip Codes
- Cities
- Minor Civil Divisions
- Popular Searches
| 06416 homes for sale | |||
| 06457 homes for sale | |||
| 06480 homes for sale |
| West Hartford homes for sale | |||
| North Haven homes for sale | |||
| Hartford 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