Located in highly desirable Foster's Pointe, Kings School district. This gorgeous, expansive 5300 sqft home has SO much to offer for single family or multi-generational living, on flat .65 acre lot. Newly renovated - includes an exceptional 1st flr in-law suite that is a fully self contained ADU, with a full kitchen, laundry, family rm, bedroom, walk-in closet & full bath w/ large open shower. In-law suite has private patio & separate exterior entrance. Upstairs you'll discover the spacious primary BR with a gorgeous en suite bath, w/ large shower, 2 vanities, 2 closets, heated towel bar & more. The 2nd floor has 3 additional bedrooms and 2 full baths. Fully finished lower level has plenty of entertainment space, incl. large bar area. This larger than it looks home is approx 5300 sqft, finished, 3786 above grade plus 1600 sqft fin. in lower level. 3 car oversized garage. All new flooring, paint & finishes. 2 HVAC's, 2 Wtr heaters. Agent has ownership interest in property.
Sold for $840,000
$840,000
1040 Cheltenham Pl, Maineville, OH 45039
5beds
3,786sqft
Single Family Residence
Built in 1994
0.65 Acres Lot
$827,700 Zestimate®
$222/sqft
$4,536 Estimated rent
Home value
$827,700
$778,000 - $877,000
$4,536/mo
Zestimate® history
Owner options
List your home for rent
$4,536/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,536/mo
Rent Zestimate®
Refinance and save
$4,835/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,835/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Private patioFully finished lower levelFully self contained aduSpacious primary brLarge bar areaHeated towel barFamily rm
Zillow last checked:
Listing updated:
Listed by:
Rebecca Sequeira 513-312-5765,
Coldwell Banker Realty 513-891-8500
Bought with:
Dana A Nelson, 2001001878
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1841579
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 5
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Dressing Area, Wall-to-Wall Carpet
- Level: Second
- Area: 350
- Dimensions: 25 x 14
Bedroom 2
- Level: Second
- Area: 121
- Dimensions: 11 x 11
Bedroom 3
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bedroom 4
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 5
- Level: First
- Area: 154
- Dimensions: 14 x 11
Primary bathroom
- Features: Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Second
Bathroom 4
- Features: Full
- Level: First
Dining room
- Features: Chair Rail, Chandelier, WW Carpet
- Level: First
- Area: 208
- Dimensions: 16 x 13
Family room
- Features: Walkout, Wall-to-Wall Carpet, Fireplace
- Area: 462
- Dimensions: 22 x 21
Kitchen
- Features: Pantry, Planning Desk, Counter Bar, Gourmet, Kitchen Island, Wood Cabinets, Wood Floor, Marble/Granite/Slate
- Area: 168
- Dimensions: 14 x 12
Living room
- Features: Wall-to-Wall Carpet
- Area: 208
- Dimensions: 16 x 13
Office
- Features: Wall-to-Wall Carpet, French Doors
- Level: First
- Area: 156
- Dimensions: 13 x 12
Heating
- Forced Air, Gas
Cooling
- Ceiling Fan(s), Central Air, ENERGY STAR Qualified Equipment
Appliances
- Included: Dishwasher, Double Oven, Disposal, Gas Cooktop, Microwave, Refrigerator, Gas Water Heater
Features
- Crown Molding, Vaulted Ceiling(s), Ceiling Fan(s), Recessed Lighting
- Windows: Low Emissivity Windows, Slider, Double Hung, Double Pane Windows, Vinyl, Insulated Windows, Skylight(s)
- Basement: Full,Finished,Vinyl Floor,WW Carpet,Glass Blk Wind
- Number of fireplaces: 1
- Fireplace features: Wood Burning, Family Room
Interior area
- Total structure area: 3,786
- Total interior livable area: 3,786 sqft
Property
Parking
- Total spaces: 3
- Parking features: On Street, Driveway, Garage Door Opener
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Fencing: Privacy
Lot
- Size: 0.65 Acres
- Dimensions: 120 x 235
- Features: .5 to .9 Acres
Details
- Parcel number: 1609227009
- Zoning description: Residential
- Other equipment: Sump Pump
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1994
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Security
- Security features: Carbon Monoxide Detector(s), Smoke Alarm
Location
- Region: Maineville
- Subdivision: Foster's Pointe
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $500 annually
- Services included: Trash, Clubhouse, Community Landscaping, Other, Pool, Tennis
Other
Other facts
- Listing terms: No Special Financing,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 6/16/2025 | Sold | $840,000+5.1%$222/sqft |
Source:  Cincy MLS #1841579 Report a problem | ||
| 5/27/2025 | Pending sale | $799,000$211/sqft |
Source: Cincy MLS #1841579 Report a problem | ||
| 5/24/2025 | Listed for sale | $799,000+59.8%$211/sqft |
Source: Cincy MLS #1841579 Report a problem | ||
| 10/21/2024 | Sold | $500,000+36.6%$132/sqft |
Source: Public Record Report a problem | ||
| 6/12/2020 | Sold | $366,000-6.1%$97/sqft |
Source: Cincy MLS #1657279 Report a problem | ||
| 6/12/2020 | Price change | $389,900+2.6%$103/sqft |
Source: Irongate Inc., Realtors #813731 Report a problem | ||
| 5/15/2020 | Pending sale | $379,900$100/sqft |
Source: Irongate Inc., Realtors #813731 Report a problem | ||
| 5/4/2020 | Price change | $379,900-2.6%$100/sqft |
Source: Irongate Inc., Realtors #813731 Report a problem | ||
| 4/24/2020 | Listed for sale | $389,900$103/sqft |
Source: Irongate Inc., Realtors #813731 Report a problem | ||
| 4/20/2020 | Pending sale | $389,900$103/sqft |
Source: Irongate Inc., Realtors #813731 Report a problem | ||
| 4/8/2020 | Listed for sale | $389,900+6.9%$103/sqft |
Source: Irongate Inc., Realtors #813731 Report a problem | ||
| 11/20/2017 | Listing removed | $364,900$96/sqft |
Source: Irongate Inc., Realtors #743203 Report a problem | ||
| 10/31/2017 | Price change | $364,900-1.4%$96/sqft |
Source: Irongate Inc., Realtors #743203 Report a problem | ||
| 10/18/2017 | Price change | $369,900-2.6%$98/sqft |
Source: Irongate Inc., Realtors #743203 Report a problem | ||
| 9/19/2017 | Price change | $379,900+1.3%$100/sqft |
Source: Irongate Inc., Realtors #743203 Report a problem | ||
| 8/23/2017 | Price change | $374,900-1.3%$99/sqft |
Source: Irongate Inc., Realtors #743203 Report a problem | ||
| 7/29/2017 | Listed for sale | $379,900+16.9%$100/sqft |
Source: Irongate Inc., Realtors #743203 Report a problem | ||
| 2/14/2000 | Sold | $325,000+40.2%$86/sqft |
Source: Cincy MLS #680368 Report a problem | ||
| 7/25/1995 | Sold | $231,880-70%$61/sqft |
Source: Public Record Report a problem | ||
| 7/14/1994 | Sold | $773,875$204/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $12,726 +46.9% | $248,280 +46.8% |
| 2024 | $8,662 +20% | $169,100 +33.3% |
| 2023 | $7,217 +1% | $126,890 +0% |
| 2022 | $7,143 +19.6% | $126,889 |
| 2021 | $5,974 -22% | $126,889 -6.9% |
| 2020 | $7,657 -1.3% | $136,311 |
| 2019 | $7,758 +2.6% | $136,311 |
| 2018 | $7,560 +7.8% | $136,311 +18.7% |
| 2017 | $7,016 -2.3% | $114,790 |
| 2016 | $7,178 +10.5% | $114,790 |
| 2015 | $6,495 +2.6% | $114,790 +10% |
| 2014 | $6,330 +0.7% | $104,360 -15.4% |
| 2013 | $6,287 +0.4% | $123,420 |
| 2012 | $6,264 +2.1% | $123,420 +4.1% |
| 2011 | $6,134 +3.4% | $118,520 |
| 2010 | $5,930 +6.6% | $118,520 |
| 2009 | $5,562 -2.2% | $118,520 |
| 2008 | $5,684 | $118,520 |
| 2007 | -- | $118,520 +21% |
| 2006 | -- | $97,920 +0.9% |
| 2005 | -- | $97,090 |
| 2004 | -- | $97,090 |
| 2003 | -- | $97,090 +5% |
| 2002 | -- | $92,470 |
| 2001 | -- | $92,470 |
| 2000 | -- | $92,470 -18% |
| 1999 | -- | $112,830 |
Find assessor info on the county website
Neighborhood: 45039
Nearby schools
GreatSchools rating
- 8/10Columbia Elementary SchoolGrades: 5-6Distance: 2.6 mi
- 8/10Kings Junior High SchoolGrades: 7-8Distance: 2.7 mi
- 8/10Kings High SchoolGrades: 9-12Distance: 2.8 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$827,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$827,700
- Ohio
- Warren County
- Maineville
- 45039
- 1040 Cheltenham Pl
Nearby cities
Nearby zip codes
Other Maineville Topics
