Estimated Value: $488,000 - $549,000
Perfect E. Hyde Park location w/great floor plan! New roof 2013, Hi eff furnace, updated baths, Rookwood Fireplace, eat-in kitchen w/SS appliances, hardwood floors, crown molding, spacious rooms, Master BR w/adjoining bath + 2 closets, bonus room, fantastic deck + private fenced yard, walk to shopping, restaurants, Ault Park + Kilgour Elem school!
Last Agent to Sell the Property
Coldwell Banker Realty License #0000396750 Listed on: 10/16/2015
Home Type
Est. Annual Taxes
Year Built
Lot Details
Home Design
Interior Spaces
Kitchen
Flooring
Bedrooms and Bathrooms
Parking
Outdoor Features
Utilities
Community Details
$399,900
Welcome to 3743 Andrew Ave! This charming 3-story home blends original charm with thoughtful updates throughout. Enjoy a renovated kitchen, gorgeous hardwood floors on all 3 levels, beamed ceilings, stained glass windows, pocket doors, and a cozy deck perfect for entertaining or relaxing. Nestled on a quiet, gaslight, no-outlet street, this gem offers tranquility with the convenience of city
Ben Schreiber eXp Realty
$525,000
Timeless Treasure in the Heart of Historic Mariemont... this beloved 4-br, 2-ba vintage gem is on the market, offering a rare opportunity to own a piece of Mariemont's cherished history. Nestled on a tree-lined street in one of Ohio's most sought-after historic communities, this well-maintained home exudes charm, character, and warmth at every turn. Step inside to discover original architectural
Terri Cofskey Coldwell Banker Realty
$470,000
Fantastic remodel in Evanston! All new interior and exterior - new roof and gutters, siding, windows, HVAC, water heater, new wire and plumbing, driveway, garage, new front and back porch, fresh paint throughout. Everywhere you look - upgrades! Kitchen features all stainless steel appliances. Full bathroom on main level. Privacy fenced-in backyard. Don't miss your chance to move right in to this
Jamie Hurtubise Keller Williams Advisors
$425,000
Welcome to 5921 Havenwood Ct - Where Comfort Meets Elegance! This beautifully maintained 4-bedroom, 3.5-bathroom home offers the perfect blend of space, style, and functionality. Nestled on a quiet cul-de-sac, this residence features a spacious open floor plan, a gourmet kitchen with modern appliances, and a cozy family room ideal for entertaining. The luxurious primary suite includes a spa-like
Lakisha Scruggs Huff Realty
$556,000
Discover a stunning selection of Ranch, Two-Story, and First-Floor Suite home designs (see attached) tailored for modern living. Nestled in a prime Anderson location, this community offers a wide range of floor plans, Forest Hills School District, and easy access to parks, shopping, and dining. Experience comfort, convenience, and style in your new home! Featured here is the Anderson! All vinyl
Jeff Rosa eXp Realty
$506,000
Discover a stunning selection of Ranch, Two-Story, and First-Floor Suite home designs (see attached) tailored for modern living. Nestled in a prime Anderson location, this community offers a wide range of floor plans, Forest Hills School District, and easy access to parks, shopping, and dining. Experience comfort, convenience, and style in your new home! Featured here is The Zoe! All vinyl
Jeff Rosa eXp Realty
$560,000
Discover a stunning selection of Ranch, Two-Story, and First-Floor Suite home designs (see attached) tailored for modern living. Nestled in a prime Anderson location, this community offers a wide range of floor plans, Forest Hills School District, and easy access to parks, shopping, and dining. Experience comfort, convenience, and style in your new home! Featured here is the Maia! This 3BR, 2
Jeff Rosa eXp Realty
$500,000
To be built! Discover a stunning selection of Ranch, Two-Story, and First-Floor Suite home designs (see attached) tailored for modern living. Nestled in a prime Anderson location, this community offers a wide range of floor plans, Forest Hills School District, and easy access to parks, shopping, and dining. Experience comfort, convenience, and style in your new home! Featured here is the
Jeff Rosa eXp Realty
$425,000
Sitting in the much desired school district of Indian hill you will find this charming home. The current client is willing to provide plans that were completed and approved for an addition that would bring the home to 3900 Sq Ft. As you walk in, you will find a first floor primary bedroom, natural lighting all throughout and a fully finished walkout basement with a potential third bedroom or
Jamie Hurtubise Keller Williams Advisors
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Esslinger Jason J | $297,000 | -- | |
| Gilley Ryan P | $263,500 | 360 American Title Services | |
| Spurling Mary Ann | -- | None Available | |
| Meyer Mary Ann | $256,000 | -- | |
| Koehler Emily A | $260,000 | -- | |
| Hamilton Dennis Jacob | $170,000 | -- |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Esslinger Jason J | $167,000 | |
| Closed | Esslinger Jason J | $237,600 | |
| Previous Owner | Gilley Ryan P | $223,900 | |
| Previous Owner | Spurling Brian | $192,200 | |
| Previous Owner | Meyer Mary Ann | $204,800 | |
| Previous Owner | Koehler Emily A | $234,000 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 04/14/2016 04/14/16 | Off Market | $297,000 | -- | -- |
| 01/13/2016 01/13/16 | Sold | $297,000 | -2.6% | $194 / Sq Ft |
| 11/22/2015 11/22/15 | Pending | -- | -- | -- |
| 11/20/2015 11/20/15 | Price Changed | $304,900 | -4.7% | $200 / Sq Ft |
| 11/02/2015 11/02/15 | Price Changed | $319,900 | -4.5% | $209 / Sq Ft |
| 10/16/2015 10/16/15 | For Sale | $334,900 | +26.4% | $219 / Sq Ft |
| 06/25/2012 06/25/12 | Off Market | $265,000 | -- | -- |
| 03/26/2012 03/26/12 | Sold | $265,000 | -7.0% | $173 / Sq Ft |
| 02/22/2012 02/22/12 | Pending | -- | -- | -- |
| 01/10/2012 01/10/12 | For Sale | $285,000 | -- | $187 / Sq Ft |
| 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 |
|---|---|---|---|---|
| 2024 | $7,341 | $123,018 | $50,393 | $72,625 |
| 2023 | $7,507 | $123,018 | $50,393 | $72,625 |
| 2022 | $8,202 | $120,583 | $41,766 | $78,817 |
| 2021 | $7,896 | $120,583 | $41,766 | $78,817 |
| 2020 | $8,128 | $120,583 | $41,766 | $78,817 |
| 2019 | $7,659 | $103,951 | $36,005 | $67,946 |
| 2018 | $7,671 | $103,951 | $36,005 | $67,946 |
| 2017 | $7,288 | $103,951 | $36,005 | $67,946 |
| 2016 | $6,558 | $92,225 | $33,222 | $59,003 |
| 2015 | $5,911 | $92,225 | $33,222 | $59,003 |
| 2014 | $5,954 | $92,225 | $33,222 | $59,003 |
| 2013 | $5,731 | $87,238 | $30,478 | $56,760 |
Seller's Agent in 2016
Rick Finn
Coldwell Banker Realty
(513) 560-6513
79 in this area
909 Total Sales
Seller Co-Listing Agent in 2016
Finn Team
Coldwell Banker Realty
(513) 560-6513
50 in this area
492 Total Sales
Buyer's Agent in 2016
Christy Clement
eXp Realty
(513) 325-3963
3 in this area
96 Total Sales
Seller's Agent in 2012
Peter Chabris
Keller Williams Seven Hills Re
(513) 708-3000
11 in this area
1,128 Total Sales
Buyer's Agent in 2012
Jason Bowman
RE/MAX
(513) 646-3368
334 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1470299
APN: 038-0A03-0199
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2025, MLS of Greater Cincinnati, Inc. All rights reserved