Estimated payment $3,388/month
Discover the charm of this exquisite 3-bdrm, 2.5-bath residence in historic Columbia Tusculum. Inside you'll find a bright and airy layout, soaring 9-foot ceilings and stunning hardwood floors that add warmth and elegance. The kitchen is a chef's delight, boasting ample cabinetry, a gas stove, granite counters and a walk-in pantry. The generously sized primary suite is a true sanctuary, with an oversized tiled shower, a deep soaking tub, and a walk-in closet, along with a wall of built-in cabinets providing plenty of storage. Throughout the home, high-end finishes elevate each room, while a cozy gas fireplace sets the perfect ambiance for cool evenings. Step outside to the lovely paver patio, an inviting space ideal for relaxation and entertaining. Enjoy the convenience of a spacious 2-car garage, and revel in the unbeatable location just minutes from downtown Cincy, Mt. Lookout, and Hyde Park. This home offers the perfect blend of luxury and lifestyle. What a great spot to call home!
Home Type
Est. Annual Taxes
Year Built
Parking
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Laundry
Utilities
Additional Features
Community Details
| 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,869 | $148,751 | $39,785 | $108,966 |
| 2023 | $9,070 | $148,751 | $39,785 | $108,966 |
| 2022 | $8,089 | $119,001 | $16,195 | $102,806 |
| 2021 | $7,789 | $119,001 | $16,195 | $102,806 |
| 2020 | $8,018 | $119,001 | $16,195 | $102,806 |
| 2019 | $8,068 | $109,551 | $14,207 | $95,344 |
| 2018 | $8,080 | $109,551 | $14,207 | $95,344 |
| 2017 | $7,677 | $109,551 | $14,207 | $95,344 |
| 2016 | $6,687 | $94,077 | $14,077 | $80,000 |
| 2015 | $6,027 | $94,077 | $14,077 | $80,000 |
| 2014 | $6,071 | $94,077 | $14,077 | $80,000 |
| 2013 | $5,668 | $86,310 | $12,915 | $73,395 |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 06/13/2025 06/13/25 | For Sale | $499,000 | +17.4% | -- |
| 06/25/2021 06/25/21 | Sold | $425,000 | +1.4% | $215 / Sq Ft |
| 05/14/2021 05/14/21 | Pending | -- | -- | -- |
| 05/14/2021 05/14/21 | For Sale | -- | -- | -- |
| 05/12/2021 05/12/21 | For Sale | $419,000 | +23.2% | $212 / Sq Ft |
| 10/04/2017 10/04/17 | Off Market | $340,000 | -- | -- |
| 07/05/2017 07/05/17 | Sold | $340,000 | -5.5% | $172 / Sq Ft |
| 05/29/2017 05/29/17 | Pending | -- | -- | -- |
| 05/12/2017 05/12/17 | For Sale | $359,900 | +15.0% | $182 / Sq Ft |
| 12/09/2015 12/09/15 | Off Market | $313,000 | -- | -- |
| 09/09/2015 09/09/15 | Sold | $313,000 | -0.6% | $158 / Sq Ft |
| 07/28/2015 07/28/15 | Pending | -- | -- | -- |
| 07/24/2015 07/24/15 | For Sale | $314,900 | -- | $159 / Sq Ft |
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Survivorship Deed | $425,000 | None Available | |
| Quit Claim Deed | -- | -- | |
| Warranty Deed | $340,000 | Prominent Title Agency Llc | |
| Warranty Deed | $313,000 | 360 American Title Services | |
| Warranty Deed | $267,500 | Advanced Land Title Agency L | |
| Interfamily Deed Transfer | -- | -- | |
| Warranty Deed | $235,000 | -- |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $361,250 | New Conventional | |
| Previous Owner | $240,000 | New Conventional | |
| Previous Owner | $281,700 | New Conventional | |
| Previous Owner | $171,500 | Stand Alone Refi Refinance Of Original Loan | |
| Previous Owner | $189,500 | Unknown | |
| Previous Owner | $214,000 | Fannie Mae Freddie Mac | |
| Previous Owner | $35,000 | Unknown | |
| Previous Owner | $208,000 | Balloon | |
| Previous Owner | $25,000 | Unknown | |
| Previous Owner | $218,000 | Balloon | |
| Previous Owner | $199,700 | No Value Available |
$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
$480,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
$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
$575,000
Spectacular New Home in the most amazing Riverfront Community! HOA $850/year. Nestled along the tranquil riverbanks, our community offers an unparalleled blend of luxury living and natural beauty. With a host of amenities and a prime location, The Sanctuary at River Green is the perfect place to call home. Wake up to the soothing sounds of the river and enjoy stunning views every day while
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
$450,000
Wonderful brick ranch in desirable Anderson Twp. with a large .77 acre lot. Single level living with an open floorplan and split bedroom design. The kitchen is fully equipped with stainless appliances and nice island plus a walk-out. Other features include: hardwood floors throughout, a wood burning fireplace, 15x15ft patio,and a spacious 3 car garage.The full basement is ready for your finishing
Jeff Smith RE/MAX Victory + Affiliates
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1844149
APN: 028-0006-0096
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