$745,000
SOLD SEP 19, 2025

223 Sterling Rd Trumbull, CT 06611

5 Beds
3.5 Baths
4,177 Sq Ft
0.5 Acres

Recently Sold

$178 Per Sq Ft

7% Below List Price

51 Days on Market

Highlights

  • Indoor Pool
  • Contemporary Architecture
  • 1 Fireplace
  • Middlebrook School Rated A
  • Attic
  • Thermal Windows

About This Home

As of September 2025

This custom ranch-style home stands out with a rare and dramatic feature: a private, heated indoor pool in a two-story room with a diving board-offering year-round enjoyment and true WOW! factor. With 5 bedrooms and a versatile layout, the home is designed for both comfort and functionality. Four bedrooms are grouped together, connected by two Jack & Jill baths-ideal for family or guests-while the primary suite is privately located on the opposite side with its own en-suite bath. Vaulted ceilings and skylights in the living and family rooms create an open, airy feel that's perfect for everyday living or entertaining. A partially finished basement adds space for recreation, a gym, or hobbies. The 4 car under garage provides generous room for vehicles and storage. A solar energy system adds efficiency and long-term savings. This one owner home is being sold in "as is" condition, offering buyers the opportunity to update and personalize while enjoying a spacious layout and unique amenities. If you're looking for something with space, privacy, and an unforgettable feature that sets your home apart - this is a must-see!

Last Agent to Sell the Property

Bob and Richelle Ward

Coldwell Banker Realty License #RES.0761632 Listed on: 05/15/2025

Coldwell Banker Realty

Co-Listed By

Robert Ward

Coldwell Banker Realty License #RES.0761631

Last Buyer's Agent

Aziz Seyal

William Raveis Real Estate License #REB.0758112

William Raveis Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,897

Year Built

  • Built in 1987

Parking

  • 4 Car Garage

Home Design

  • Contemporary Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Wood Siding
  • Vertical Siding

Interior Spaces

  • 4,177 Sq Ft Home
  • 1 Fireplace
  • Thermal Windows
  • Attic or Crawl Hatchway Insulated
  • Storm Doors
  • Laundry on lower level

Kitchen

  • Electric Range
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms

Partially Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • Garage Access

Pool

  • Indoor Pool
  • Vinyl Pool

Schools

  • Jane Ryan Elementary School
  • Madison Middle School
  • Trumbull High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Cable TV Available

Additional Features

  • Heating system powered by active solar
  • Patio
  • 0.5 Acre Lot

Community Details

  • Community Indoor Pool

Listing and Financial Details

  • Assessor Parcel Number 392744

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,897

Year Built

Built in 1987

Lot Details

0

Listing Details

  • Neighborhood: Long Hill
  • Property Type: Single Family For Sale
  • Style: Contemporary
  • Sq Ft Est Heated Above Grade: 4177
  • Total Sq Ft: 4177
  • Year Built: 1987
  • New Construction: No/Resale
  • Remarks Public Addendum: Indoor pool room is approximately 1000 SF. Pool depth is 4' to 10' deep. Pool liner is approximately 15 years old. Area in pool room to add in a hot tub. House has 6 skylights. Generator hookup. House has an area from basement to Kitchen to add in an elevator.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Directions: Route 111 to Lake Avenue to left on Sterling. #223 is on right.
  • Financing Used: Cash
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 5
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Attic Description: Access Via Hatch
  • Basement Description: Full, Garage Access, Interior Access, Partially Finished
  • Interior Amenities: Cable - Pre-wired
  • Appliances: Electric Range, Refrigerator, Dishwasher
  • Laundry Room Info: Lower Level
  • Attic: Yes

Exterior Features

  • Exterior Features: Patio
  • Exterior Siding: Vertical Siding, Wood
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Waterfront Description: Not Applicable
  • Swimming Pool: Yes
  • Pool: Vinyl, Indoor Pool
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 4
  • Garage And Parking: Under House Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Domestic
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Green Features

  • Energy Features: Active Solar, Storm Doors, Thermopane Windows

Lot Info

  • Acres: 0.5
  • Lot Description: Level Lot Sloping Lot
  • Zoning: A
  • Parcel #: 392744

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 17897

MLS Schools

  • Elementary School: Jane Ryan
  • Middle Jr High School: Madison
  • High School: Trumbull

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 15, 2025
Closed on
Aug 14, 2025
Sold by
Swenson
Bought by
Shafi Ahsan
Seller's Agent
Bob and Richelle Ward
Coldwell Banker Realty
Buyer's Agent
Aziz Seyal
William Raveis Real Estate
List Price
$799,900
Sold Price
$745,000
Premium/Discount to List
-$54,900
-6.86%
Views
212
Current Estimated Value
$812,973

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$67,973
Avg. Annual Appreciation
29.28%

Purchase Details

Closed on
Apr 23, 2012
Sold by
Swenson Albert
Bought by
Swenson Joan

Purchase Details

Closed on
Dec 16, 1987
Sold by
Home Bldg Const Co
Bought by
Swenson Albert
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Deed $745,000 --
Warranty Deed -- --
Deed $485,500 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $50,000 No Value Available
Previous Owner $417,000 Stand Alone Refi Refinance Of Original Loan
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/19/2025 09/19/25 Sold $745,000 -3.9% $178 / Sq Ft
07/05/2025 07/05/25 Pending -- -- --
06/17/2025 06/17/25 Price Changed $775,000 -3.1% $186 / Sq Ft
05/15/2025 05/15/25 For Sale $799,900 -- $192 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $17,897 $487,060 $155,260 $331,800
2024 $17,391 $487,060 $155,260 $331,800
2023 $17,114 $487,060 $155,260 $331,800
2022 $16,838 $487,060 $155,260 $331,800
2021 $15,252 $419,440 $129,360 $290,080
2020 $14,959 $419,440 $129,360 $290,080
2018 $14,624 $419,440 $129,360 $290,080
2017 $14,353 $419,440 $129,360 $290,080
2016 $13,984 $419,440 $129,360 $290,080
2015 $14,442 $431,500 $129,400 $302,100
2014 $14,136 $431,500 $129,400 $302,100
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24096174

SmartMLS

APN: TRUM-000006E-000000-000391