Beautifully updated, spacious home located in one of Hyde Park's favorite neighborhoods! Sunny renovated eat-in kitchen w marble countertops, tile backsplash & SS app's! Fin LL perfect for relaxing featuring bar'18 a built in fridg & kegerator & 2nd full ba. Third fl flex space! Elec box'17, H2O'18, Roof'16 Enjoy fab deck in flat, fenced'16 yard!
Last Agent to Sell the Property
Hallie Goldcamp
Coldwell Banker Realty License #2004005066 Listed on: 06/20/2018
Home Type
Est. Annual Taxes
Year Built
Lot Details
Parking
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
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
$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
$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
$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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $477,500 | None Available | |
| Deed | $460,000 | -- | |
| Warranty Deed | $410,600 | Attorney | |
| Warranty Deed | $344,800 | None Available | |
| Warranty Deed | $344,800 | None Available | |
| Warranty Deed | $218,000 | -- | |
| Deed | -- | -- |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $242,000 | New Conventional | |
| Open | $405,875 | New Conventional | |
| Previous Owner | $368,000 | New Conventional | |
| Previous Owner | $410,600 | Adjustable Rate Mortgage/ARM | |
| Previous Owner | $300,000 | Adjustable Rate Mortgage/ARM | |
| Previous Owner | $37,500 | Unknown | |
| Previous Owner | $269,563 | Unknown | |
| Previous Owner | $275,000 | Unknown | |
| Previous Owner | $69,205 | Unknown | |
| Previous Owner | $275,840 | Unknown | |
| Previous Owner | $130,400 | No Value Available |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 11/14/2018 11/14/18 | Off Market | $477,500 | -- | -- |
| 08/15/2018 08/15/18 | Sold | $477,500 | -2.5% | $218 / Sq Ft |
| 07/11/2018 07/11/18 | Pending | -- | -- | -- |
| 06/20/2018 06/20/18 | For Sale | $489,900 | +6.5% | $223 / Sq Ft |
| 07/09/2017 07/09/17 | Off Market | $460,000 | -- | -- |
| 04/10/2017 04/10/17 | Sold | $460,000 | -3.1% | $210 / Sq Ft |
| 02/14/2017 02/14/17 | Pending | -- | -- | -- |
| 02/10/2017 02/10/17 | Price Changed | $474,900 | -2.9% | $216 / Sq Ft |
| 02/03/2017 02/03/17 | For Sale | $489,000 | +19.1% | $223 / Sq Ft |
| 07/30/2014 07/30/14 | Off Market | $410,600 | -- | -- |
| 05/01/2014 05/01/14 | Sold | $410,600 | -4.5% | $187 / Sq Ft |
| 02/24/2014 02/24/14 | Pending | -- | -- | -- |
| 01/13/2014 01/13/14 | For Sale | $429,900 | -- | $196 / 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 | $10,539 | $176,019 | $58,492 | $117,527 |
| 2023 | $10,777 | $176,019 | $58,492 | $117,527 |
| 2022 | $11,404 | $167,125 | $48,468 | $118,657 |
| 2021 | $10,968 | $167,125 | $48,468 | $118,657 |
| 2020 | $11,289 | $167,125 | $48,468 | $118,657 |
| 2019 | $11,885 | $161,000 | $41,783 | $119,217 |
| 2018 | $11,904 | $161,000 | $41,783 | $119,217 |
| 2017 | $11,308 | $161,000 | $41,783 | $119,217 |
| 2016 | $10,239 | $143,710 | $38,549 | $105,161 |
| 2015 | $9,233 | $143,710 | $38,549 | $105,161 |
| 2014 | $9,298 | $143,710 | $38,549 | $105,161 |
| 2013 | $6,705 | $101,718 | $35,368 | $66,350 |
Seller's Agent in 2018
Hallie Goldcamp
Coldwell Banker Realty
Buyer's Agent in 2018
Heather Kopf
Kopf Hunter Haas
(513) 378-1167
24 in this area
154 Total Sales
Seller's Agent in 2017
Amy Hackett Roe
Coldwell Banker Realty
(513) 379-5445
12 in this area
271 Total Sales
Seller Co-Listing Agent in 2017
Shelley Miller Reed
Coldwell Banker Realty
(513) 476-8266
10 in this area
261 Total Sales
Buyer's Agent in 2017
Jennifer Vickroy
Coldwell Banker Realty
(513) 484-8618
2 in this area
34 Total Sales
Seller's Agent in 2014
Michael Hinckley
Coldwell Banker Realty
(513) 608-1886
115 in this area
355 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1584769
APN: 038-0A03-0202
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