Estimated Value: $411,000 - $518,791
This is the one! A fantastic opportunity to live on a private, quiet drive between Hyde Park and Mt Lookout Squares. Completely updated turnkey home that lives like it is much larger. Beautiful hardwood floors throughout. Large 4-seasons room with radiant heating that adds tons of square footage. New retaining wall and tiered patio for outdoor entertaining or quiet reading. Too many additional updates to list!
Last Agent to Sell the Property
Coldwell Banker Realty License #2016005061 Listed on: 09/22/2022
Home Type
Est. Annual Taxes
Year Built
Lot Details
Parking
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Laundry
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
$485,000
Step into this bright and inviting Hyde Park home featuring a spacious, relaxing covered front porch and beautiful hardwood floors. The open kitchen flows to a sunny deck and charming fenced backyard-great for gatherings. New carpet, large closets, and a stylishly remodeled bathroom await you upstairs. Enjoy movie nights or playtime in the finished lower-level family room. All just steps from
Jennifer Fehr Bastion, REALTORS
$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
$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
$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
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Lingler Julia Hattershire | $333,000 | None Available | |
| Meltzer Jack | $270,000 | Prodigy Title Agency | |
| Standridge J Shawn | $175,000 | Valley Title & Escrow Agency | |
| Us Bank Na Nd | -- | None Available | |
| Walker Christopher L | -- | -- | |
| Walker Christopher L | $251,000 | Advanced Land Title Agency L | |
| Florio Craig A | -- | -- |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Lingler Julia Hattershire | $103,000 | |
| Previous Owner | Meltzer Jack | $216,000 | |
| Previous Owner | Standridge J Shawn | $166,250 | |
| Previous Owner | Walker Christopher L | $250,000 | |
| Previous Owner | Walker Christopher L | $251,000 | |
| Previous Owner | Florio Craig A | $224,900 | |
| Previous Owner | Florio Craig A | $110,750 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 11/07/2022 11/07/22 | Sold | $428,200 | +7.1% | $378 / Sq Ft |
| 09/24/2022 09/24/22 | Pending | -- | -- | -- |
| 09/22/2022 09/22/22 | For Sale | $399,900 | +20.1% | $353 / Sq Ft |
| 08/24/2017 08/24/17 | Off Market | $333,000 | -- | -- |
| 05/24/2017 05/24/17 | Sold | $333,000 | -0.6% | $294 / Sq Ft |
| 04/10/2017 04/10/17 | Pending | -- | -- | -- |
| 04/06/2017 04/06/17 | Price Changed | $335,000 | -2.9% | $295 / Sq Ft |
| 03/16/2017 03/16/17 | For Sale | $345,000 | +27.8% | $304 / Sq Ft |
| 12/01/2014 12/01/14 | Off Market | $270,000 | -- | -- |
| 09/02/2014 09/02/14 | Sold | $270,000 | -10.0% | $238 / Sq Ft |
| 08/01/2014 08/01/14 | Pending | -- | -- | -- |
| 07/01/2014 07/01/14 | For Sale | $300,000 | -- | $265 / 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 | $8,908 | $149,545 | $36,712 | $112,833 |
| 2023 | $9,110 | $149,545 | $36,712 | $112,833 |
| 2022 | $9,239 | $136,053 | $34,815 | $101,238 |
| 2021 | $8,899 | $136,053 | $34,815 | $101,238 |
| 2020 | $9,160 | $136,053 | $34,815 | $101,238 |
| 2019 | $8,558 | $116,284 | $29,757 | $86,527 |
| 2018 | $8,572 | $116,284 | $29,757 | $86,527 |
| 2017 | $8,144 | $116,284 | $29,757 | $86,527 |
| 2016 | $6,623 | $93,251 | $27,381 | $65,870 |
| 2015 | $5,969 | $93,251 | $27,381 | $65,870 |
| 2014 | $6,012 | $93,251 | $27,381 | $65,870 |
| 2013 | $5,771 | $87,973 | $25,830 | $62,143 |
Seller's Agent in 2022
Vinni Brown
Coldwell Banker Realty
(513) 246-5114
4 in this area
76 Total Sales
Buyer's Agent in 2022
Anne Cavellier
Keller Williams Advisors
(513) 505-9633
5 in this area
25 Total Sales
Seller's Agent in 2017
Stacy Gendelman
Robinson Sotheby's Internat'l
(513) 900-7009
3 in this area
64 Total Sales
Buyer's Agent in 2017
Anne Wagner
eXp Realty
(513) 543-5806
89 Total Sales
Seller's Agent in 2014
Bryan Smith
eXp Realty
(513) 509-3259
154 Total Sales
S
Buyer's Agent in 2014
Shirley Sampson
Comey & Shepherd
(513) 515-0335
5 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1753832
APN: 044-0004-0130
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