Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
151 Front St, Middletown, CT 06457
About this home
Incredible buy for owner or investor. Tenants are month to month. One furnace and one electrical system so utilities are included in rent. First floor has living room, kitchen and bedroom, screened front porch. Second floor is two bedrooms, living room and kitchen. Full walk up attic for possible future expansion. Extra large two car garage used by landlord to store "family toys". So garage use not included in rent. Small level yard, good sized driveway. Exterior is maintenance free vinyl sided. Long-time tenants. Units have wood floors. Good location near schools, ballfields, shopping and route 9.
Redfin Estimate
Market trends in 06457, CT
Last updated September 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 151 Front St
$143/sq ft
$122/sq ft
$29/sq ft
Tax history for 151 Front St
*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: Detached Garage
- Garages Number: 2
Interior
- Interior Information
- Laundry Room Info: Basement Hook-Up(s)
- Bathroom Information
- # of Baths (Full): 2
- Bedroom Information
- Beds Total: 3
- Room Information
- Basement Description: Full With Hatchway
- Has Attic
- Attic Description: Walk-up
Exterior
- Exterior Features
- Roof Information: Asphalt Shingle
- Exterior Siding: Vinyl Siding
- Exterior Features: Porch-Screened
- Lot Information
- Lot Description: Level Lot
- Building Information
- Foundation Type: Stone
- Construction Description: Frame
- Color: cream
- Property Information
- Property Type: Multi-Family For Sale
- Property Sub Type: 2 Family
- Living Area SQFT Per Public Record: 1392
- Driveway Type: Paved
Financial
- Assessments Information
- Assessed Value: $107,630
Utilities
- Utility Information
- Water Source: Public Water Connected
- Sewage System: Public Sewer Connected
- Hot Water Description: Domestic
- Heat Type: Radiator
- Heat Fuel Type: Oil
- Fuel Tank Location: In Basement
Location
- Multi-Unit Information
- Unit Count: 2
- Total Rooms Multi Family: 7
- Total Number of Units: 2
- School Information
- High School: Middletown
- Elementary School: Farm Hill
- Location Information
- State: Connecticut
- Nearby Amenities: Basketball Court, Medical Facilities, Shopping/Mall
- Directions: GPS friendly
- County: Middlesex
Public facts
- Beds: 4
- Baths: 2.0
- Sq. Ft.: 1,392
- Stories: 2.0
- Lot Size: 6,534 square feet
- Style: Single Family Residential
- Year Built: 1889
- Year Renovated: —
- County: Middlesex County
- APN: 1014458
Other
- Documents & Disclosures
- Supplement Count Public: 2
Around this home
Schools
Public PreK-5 • Assigned • 0.4mi
Public 7-8 • Assigned • 0.4mi
Public 9-12 • Assigned • 3.0mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 96° expected this year, 16 days in 30 years
27% chance of strong winds in next 30 years
3 unhealthy days expected this year, 5 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 06457
Home values near 151 Front St
| Address | Redfin Estimate |
|---|---|
5 Beds | 2 Baths | 2341 Sq. Ft. | $396,007 |
3 Beds | 1 Baths | 1525 Sq. Ft. | $313,561 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 1506 Sq. Ft. | $304,998 |
4 Beds | 2 Baths | 2016 Sq. Ft. | — |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2 Baths | 2334 Sq. Ft. | $348,315 |
3 Beds | 1.5 Baths | 1249 Sq. Ft. | $327,896 |
More real estate resources
- Minor Civil Divisions
- Cities
- Zip Codes
- Popular Searches
| Guilford homes for sale | |||
| Wallingford homes for sale | |||
| Glastonbury homes for sale | |||
| Farmington homes for sale | |||
| Madison homes for sale |
| New Haven homes for sale | |||
| West Hartford homes for sale | |||
| Hartford homes for sale |
| 06416 homes for sale | |||
| 06450 homes for sale | |||
| 06457 homes for sale | |||
| 06480 homes for sale | |||
| 06037 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