RENTED JUN 30, 2025

Estimated Value: $432,000 - $495,000

3 Beds
2.5 Baths
1,718 Sq Ft
$266/Sq Ft Est. Value

Highlights

  • Traditional Architecture
  • Quartz Countertops
  • Porch
  • Walnut Hills High School Rated A+
  • No HOA
  • 2 Car Attached Garage

About This Home

As of June 2025

Great opportunity with this practically-new 3br 2.5ba in the heart of Madisonville. Right off Columbia Parkway, just minutes to downtown, Northern KY, I-75 & I-71. Open living on first floor. 2-car tandem garage enters from both front and back. Rear yard with privacy fence. All bedrooms have walk-in closets. Primary suite has full bath and 7x11 walk-in closet attached! Second floor laundry. Clean and updated. Deposit = to 1 month's rent. 1 dog ok w/ additional $250 deposit and $25/mo charge. Sorry; no cats. No smoking. $50 non-refundable application fee for all applicants 18 & older.

Last Agent to Rent the Property

Mylissa Johnson

eXp Realty License #2022004270 Listed on: 06/09/2025

eXp Realty

Co-Listed By

Anne Uchtman

eXp Realty License #2006000511

eXp Realty

Last Renter's Agent

Anne Uchtman

eXp Realty License #2006000511

eXp Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1905

Lot Details

  • 3,920 Sq Ft Lot
  • Privacy Fence
  • Wood Fence

Parking

  • 2 Car Attached Garage
  • Tandem Garage
  • Driveway
  • On-Street Parking

Home Design

  • Traditional Architecture
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 1,718 Sq Ft Home
  • 2-Story Property
  • Vinyl Clad Windows
  • Insulated Windows
  • Double Hung Windows
  • Vinyl Flooring
  • Unfinished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Quartz Countertops
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas

Community Details

  • No Home Owners Association

Listing and Financial Details

  • No Smoking Allowed

Home Details

Home Type

Single Family

Year Built

Built in 1905

Lot Details

0

Parking

2

Rental Info

  • Sub Lease: No
  • Pets: Yes
  • Pets Allowed: Yes
  • Security Deposit: One Month's Rent
  • Smoking Allowed: No

Listing Details

  • Suburb: Madisonville
  • Land Description: Less than .5 Acre
  • Broker Approved: Yes
  • Census Tract Realist: 56.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 3920.00
  • Suburb S I C: Madisonville
  • Zoning: Residential
  • Accessibility Features: No
  • Basement Features: Unfinished
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Living Room Feat: Walkout
  • Year Built: 1905
  • Association Board Approval: N/A
  • Bathroom 1 Features: Ceramic Tile, Shower
  • Extra Pet Deposit: Yes
  • Extra Smoking Depst: N/A
  • Furnishing: Unfurnished
  • Livinggreat Rm: 15x15 Level: 1
  • Length of Lease: One Year
  • Architecture: Traditional
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: Plainville to Merwin
  • Lot Measurement: Acres
  • Status: Leased
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • Second Floor Area: 1046
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 11x13 Level: 2
  • Bedroom 3: 11x13 Level: 2
  • Property Type: Residential Lease
  • Reciprocal Listing: No
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave, Dryer, Washer
  • Kitchen Features: Pantry, Quartz Counters, Vinyl Floor, Eat-In, Walkout, Wood Cabinets
  • Basement: Full
  • Bathrooms: 3.00
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 0x0 Level: 2
  • Heat Paid By: Tenant
  • Fireplace: None
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 1718.00
  • Windows: Vinyl, Double Hung, Insulated
  • PrimaryBedFeat: Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet
  • P R I M A R Y B E D R O O M: 15x13 Level: 2

Exterior Features

  • Fencing: Wood
  • Roof: Shingle
  • Construction: Vinyl Siding
  • Outside Features: Patio, Porch, Wood Fence, Privacy Fence
  • Foundation: Poured
  • Listing Price: 3000.00
  • Acres: 0.0900
  • New Construction: No

Garage/Parking

  • Garage: Built in, Tandem
  • Garage Spaces: 2.00
  • Parking: Driveway, On Street

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public
  • Water Paid By: Tenant

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Size Sq Ft: 3920.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 7, 2023
Closed on
Dec 20, 2023
Sold by
Aydelotit Justin
Bought by
6918 Merwin Holdings Llc
Seller's Agent
Anne Uchtman
eXp Realty
Buyer's Agent
Zakir Muradov
3CRE Residential Advisors, LLC
Sold Price
$2,875
Views
2
Current Estimated Value
$457,645

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$454,770

Purchase Details

Closed on
Jul 26, 2022
Sold by
6918 Merwin Holdings Llc
Bought by
Aydelotte Justin

Purchase Details

Closed on
Jul 6, 2021
Sold by
Aydelotee Justin
Bought by
6918 Merwin Holdings Llc

Purchase Details

Closed on
Jun 1, 2020
Sold by
6918 Merwin Avenue Llc
Bought by
Aydelotte Justin

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$352,240
Interest Rate
3.3%
Mortgage Type
VA

Purchase Details

Closed on
Dec 20, 2018
Sold by
Wells Fargo Bank Na
Bought by
6918 Merwin Ave Llc
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
6918 Merwin Holdings Llc -- None Listed On Document
Aydelotte Justin -- --
Aydelotte Justin -- None Listed On Document
6918 Merwin Holdings Llc -- None Available
Aydelotte Justin $340,000 None Available
6918 Merwin Ave Llc $78,960 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Aydelotte Justin $352,240
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/30/2025 06/30/25 Rented $2,800 -6.7% --
06/09/2025 06/09/25 For Rent $3,000 -1.6% --
04/06/2025 04/06/25 Off Market $3,050 -- --
04/02/2025 04/02/25 Rented $3,050 +1.7% --
03/24/2025 03/24/25 For Rent $3,000 +4.3% --
02/01/2024 02/01/24 Rented $2,875 -7.3% --
01/14/2024 01/14/24 Under Contract -- -- --
12/09/2023 12/09/23 For Rent $3,100 -- --
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History Compared to Growth

Source: Public Records

Tax History

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 $2,506 $135,744 $10,710 $125,034
2023 $2,510 $135,744 $10,710 $125,034
2022 $1,611 $119,001 $5,282 $113,719
2021 $1,581 $19,286 $5,282 $14,004
2020 $1,345 $19,286 $5,282 $14,004
2019 $1,308 $17,067 $4,673 $12,394
2018 $1,309 $17,067 $4,673 $12,394
2017 $574 $17,067 $4,673 $12,394
2016 $653 $18,144 $4,459 $13,685
2015 $596 $18,144 $4,459 $13,685
2014 $601 $18,144 $4,459 $13,685
2013 $577 $17,616 $4,330 $13,286
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1843681

MLS of Greater Cincinnati (CincyMLS)

APN: 037-0005-0024