Estimated Value: $296,000 - $419,000
Historic charm meets modern updates in this move in ready home on a double lot. Open first floor offers lots of flexible living space. Large kitchen features island, quartz counters, subway tile, and newer cabinets and hardware. Both bedrooms feature en suite baths. Second floor laundry adds extra convenience. Gas firepit provides cozy outdoor gathering space. Near Ohio River Trail, Streetside Brewery, and all that Columbia Tusculum has to offer. New roof in '22. Showings start 8/26!
Last Agent to Sell the Property
Coldwell Banker Realty License #2021001584 Listed on: 08/25/2023
Last Buyer's Agent
David Hirschman
Comey & Shepherd License #2018005749
Home Type
Est. Annual Taxes
Year Built
Lot Details
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
$299,900
Welcome to this stunning ranch in the Mariemont School district! Beautifully renovated with attention to detail, this 3-bedroom, 2-bathroom home is perfect for those seeking a comfortable and stylish living space. The finished basement and new expansive back deck is an entertainer's dream, ideal for hosting gatherings and creating unforgettable memories. Newer roof and renovations makes this
Jordan Fiore eXp Realty
$275,000
**New Pictures Added!!** Invest smart near UC!! Looking for a future home sweet home for your Bearcat (or someone else's)? Minutes away from UC Campus - Ideal for investors, low maintenance & turnkey. Hardwood floors throughout, each flr has 2 spacious bedrooms, 1 of the 2 on the 1st flr features an ensuite bath and WIC/office w/a separate entrance. The living room was converted to a 4th bedroom,
Steven Douglass Comey & Shepherd
$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
$299,900
Beautiful 3 Bed, 2 full Bath Home in Silverton! Move-in ready, 1562 sqft, with New kitchen cabinets, quartz countertops, and slate appliances. Remodelled baths, new flooring, fresh paint, new gas furnace, new AC, new electric water heater, and electric panel. Features include a detached garage with new door, front porch with new concrete pad and railing, waterproofed basement, and ramp access.
Alexandra Parker OwnerLand Realty, Inc.
$289,900
Charming condo ready for new owners! The open first floor features vaulted ceilings, a skylight, and a fireplace, creating a warm and inviting atmosphere. The spacious great room leads out to a lovely deck with a serene wooded view. Upstairs, you will find two bedrooms, each with its own private bathroom. Additionally, the finished walkout basement includes another fireplace and a storage area
Michael Jennings Plum Tree Realty
$299,900
Discover this beautiful brick ranch nestled in desirable Union Township, offering the perfect blend of charm and functionality. This inviting home features 3 spacious bedrooms and 3 full bathrooms, with gleaming hardwood floors flowing throughout. The finished basement adds valuable living space, ideal for entertaining, relaxing, or working from home. Step outside to enjoy a peaceful, wooded
Jamie Hurtubise Keller Williams Advisors
$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
$369,900
Tucked in a park-like setting with no rear neighbors, this beautifully remodeled Tudor-style Bi-Level home offers 3 beds, 2.5 baths, and 1,900 sq ft of charm. The stunning kitchen spans the full width of the home and features vaulted ceilings, island seating, formal dining, 3 pantries, and abundant cabinetry. The primary suite includes an en-suite bath and 2 closets. Two additional bedrooms share
Tina Greene Irongate Inc.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Dreist Emma Tao | $308,500 | None Listed On Document | |
| Dunn Cassandra L | $285,000 | Prodigy Title | |
| Mueller Kyle L | $250,000 | Ltoc | |
| Phillips Joshua E | $25,000 | Attorney | |
| Household Realty Corp | $46,000 | None Available | |
| Glenn Jamie A | $81,000 | None Available | |
| Bates Heidi B | $74,000 | -- | |
| Bosken Robert A | -- | -- |
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Dreist Emma Tao | $277,650 | |
| Previous Owner | Dunn Cassandra L | $270,750 | |
| Previous Owner | Mueller Kyle L | $242,500 | |
| Previous Owner | Phillips Joshua E | $70,400 | |
| Previous Owner | Glenn Jamie A | $81,000 | |
| Previous Owner | Bates Heidi B | $50,000 | |
| Previous Owner | Bosken Robert A | $10,000 | |
| Previous Owner | Bosken Robert A | $64,400 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 10/10/2023 10/10/23 | Sold | $308,500 | -0.5% | $43 / Sq Ft |
| 09/05/2023 09/05/23 | Pending | -- | -- | -- |
| 08/25/2023 08/25/23 | For Sale | $310,000 | +8.8% | $44 / Sq Ft |
| 09/02/2022 09/02/22 | Sold | $285,000 | -5.0% | $141 / Sq Ft |
| 08/12/2022 08/12/22 | Pending | -- | -- | -- |
| 07/17/2022 07/17/22 | Price Changed | $299,900 | -7.7% | $149 / Sq Ft |
| 07/08/2022 07/08/22 | For Sale | $324,900 | +30.0% | $161 / Sq Ft |
| 09/27/2020 09/27/20 | Off Market | $250,000 | -- | -- |
| 06/25/2020 06/25/20 | Sold | $250,000 | 0.0% | $124 / Sq Ft |
| 05/12/2020 05/12/20 | Pending | -- | -- | -- |
| 05/11/2020 05/11/20 | For Sale | $250,000 | -- | $124 / 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 | $5,951 | $99,750 | $5,229 | $94,521 |
| 2023 | $6,085 | $99,750 | $5,229 | $94,521 |
| 2022 | $1,216 | $17,165 | $3,497 | $13,668 |
| 2021 | $1,194 | $17,165 | $3,497 | $13,668 |
| 2020 | $1,203 | $17,165 | $3,497 | $13,668 |
| 2019 | $1,159 | $15,054 | $3,066 | $11,988 |
| 2018 | $1,160 | $15,054 | $3,066 | $11,988 |
| 2017 | $1,116 | $15,054 | $3,066 | $11,988 |
| 2016 | $1,164 | $15,324 | $3,679 | $11,645 |
| 2015 | $1,041 | $15,324 | $3,679 | $11,645 |
| 2014 | $1,047 | $15,324 | $3,679 | $11,645 |
| 2013 | $1,044 | $15,022 | $3,605 | $11,417 |
Seller's Agent in 2023
Monica Roberts
Coldwell Banker Realty
(513) 478-5307
1 in this area
81 Total Sales
Buyer's Agent in 2023
David Hirschman
Comey & Shepherd
(513) 888-4666
Seller's Agent in 2022
Rick Finn
Coldwell Banker Realty
(513) 560-6513
7 in this area
909 Total Sales
Seller Co-Listing Agent in 2022
Finn Team
Coldwell Banker Realty
(513) 560-6513
5 in this area
492 Total Sales
Seller's Agent in 2020
Brett Butler
Comey & Shepherd
(513) 218-1751
108 Total Sales
Buyer's Agent in 2020
Erin Fay
Coldwell Banker Realty
(513) 608-0774
246 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1780802
APN: 029-0003-0147
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