$751,000 - $963,000
RENTED APR 21, 2025
4 Beds
5 Baths
3,751 Sq Ft
$229 Price per Sq Ft

Last Sold September 17, 2020

Last sale price $560,000 $149 Per Sq Ft

Est. 54% increase in value since last sale

Current estimated payment $5,224/month

Highlights

  • Deck
  • Traditional Architecture
  • Wood Flooring
  • Indian Hill Primary School Rated A-
  • Cathedral Ceiling
  • Corner Lot

About This Home

As of April 2025

Amazing LUXURY rental opportunity with over 5000 sq ft in Indian Hill School District! Open floorplan with quality finishes on friendly no outlet street! This light filled home features neutral kitchen & baths and updates throughout! Spacious primary ensuite & 3 more bedrooms on 2nd level - includes shared bathroom suite bedrooms. Finished lower level with full bath, bar & optional 5th bedroom. Off Kenwood Rd, on Kenwood Ct.

Last Agent to Rent the Property

Rebecca Campbell

Coldwell Banker Realty License #2014000579 Listed on: 04/07/2025

Coldwell Banker Realty

Last Renter's Agent

Rebecca Campbell

Coldwell Banker Realty License #2014000579 Listed on: 04/07/2025

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,652

Year Built

  • Built in 1998

Lot Details

  • 0.3 Acre Lot
  • Privacy Fence
  • Wood Fence
  • Corner Lot
  • Level Lot

Parking

  • 2 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 3,751 Sq Ft Home
  • 2-Story Property
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Hung Windows
  • Living Room with Fireplace
  • Wood Flooring
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Oven or Range
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 5 Full Bathrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck

Utilities

  • Central Air
  • Heating System Uses Gas

Community Details

  • No Home Owners Association

Listing and Financial Details

  • No Smoking Allowed

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,652

Year Built

Built in 1998

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: Sycamore Twp.
  • Cross Street: Kenwood Rd.
  • Topography: Level
  • Trees: Pine/Timber
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: Ceiling Fan, Garage Door Opener, Security System, Pets Allowed
  • Basement Sq Ft: 1899
  • Census Tract Realist: 240.01
  • Cooling: Central Air
  • Heating: Gas
  • Lot Area Realist: 12981.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00.000-05:00
  • Suburb S I C: Sycamore Twp.
  • Zoning: Residential
  • Basement Features: Finished, Glass Blk Wind
  • Bathroom 4: Full
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Chair Rail, Chandelier, Window Treatments, Wood Floors
  • Entry Foyer: Wood Floors
  • Family Room Feat: Wood Floors
  • Living Room Feat: Fireplace, Wood Floors, Other
  • Study Lib Den: 15x13 Level: 1
  • Year Built: 1998
  • Association Board Approval: No
  • Bathroom 1 Features: Shower, Tub, Double Vanity
  • Extra Pet Deposit: Yes
  • Extra Smoking Depst: N/A
  • Furnishing: Unfurnished
  • Livinggreat Rm: 20x20 Level: 1
  • Separate Air Cond: Yes
  • Length of Lease: One Year
  • Architecture: Traditional
  • Full Bathrooms: 5
  • Bedrooms: 4
  • Directions: Kenwood Rd to Kenwood Ct.
  • Lot Measurement: Acres
  • Status: Leased
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • Second Floor Area: 1363
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, Cathedral Ceiling, French Doors
  • Bedroom 2: 14x12 Level: 2
  • Bedroom 3: 11x18 Level: 2
  • Bedroom 4: 11x21 Level: 2
  • Breakfast Room: 15x11 Level: 1
  • Dining Room: 12x13 Level: 1
  • Recreation Room: 31x21 Level: Lower
  • Flex Rooms: Bedroom, Bonus Room, Exercise Room, Other
  • Property Type: Residential Lease
  • Separate Furnace: Yes
  • Reciprocal Listing: No
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Dryer, Washer
  • Kitchen Features: Marble/Granite/Slate, Eat-In, Walkout, Wood Floor
  • Basement: Full
  • Study Features: Wood Floor
  • Entry: 8x10 Level: 1
  • Bathrooms: 5.00
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 2
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundry Room: 8x7 Level: 1
  • Heat Paid By: Tenant
  • Fireplace: Gas
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 3751.00
  • Total Rooms: 14
  • Windows: Double Hung, Wood
  • First Floor Family Room: 14x12 Level: 1
  • PrimaryBedFeat: Walk-in Closet, Wall-to-Wall Carpet, Window Treatment
  • P R I M A R Y B E D R O O M: 15x17 Level: 2

Exterior Features

  • Fencing: Wood
  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Deck, Privacy Fence, Cul-de-sac St, Corner Lot
  • Foundation: Poured
  • Listing Price: 5800.00
  • Acres: 0.2980
  • New Construction: No

Garage/Parking

  • Garage: Attached, Side
  • Garage Spaces: 2.00
  • Parking: Driveway, On Street

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public
  • Water Paid By: Tenant
  • Separate Gas/Elec: Yes

Condo/Co-op/Association

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

Schools

  • District: Indian Hill Ex Vill

Lot Info

  • Lot Size Sq Ft: 12981.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 8, 2020
Sold by
Ning Wei and Han Chunlian
Bought by
Destefanis Charles B and Bhavsar Kanan B
Current Estimated Value
$860,731

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$448,000
Interest Rate
2.9%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jun 26, 2013
Closed on
Aug 6, 2013
Sold by
Ibrahim Ezzeldin M and Hammad Salma S
Bought by
Ning Wei and Han Chunlian
Seller's Agent
Fadia Rawas
Keller Williams Advisors
Buyer's Agent
Deborah Gaunt
RE/MAX Victory + Affiliates
List Price
$460,000
Sold Price
$440,000
Premium/Discount to List
-$20,000
-4.35%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.62%
Original Mortgage
$350,000
Interest Rate
4.53%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 18, 1998
Sold by
Hoffsis Stephen B
Bought by
Ibrahim Md Ezzeldin M and Hammad Md Salma S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$85,000
Interest Rate
6.95%
Mortgage Type
Unknown
Source: Public Records

Range of Values:

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
Destefanis Charles B $560,000 Landsel Title Agency Inc
Ning Wei $440,000 Attorney
Ibrahim Md Ezzeldin M -- --
Hoffsis Stephen B $397,700 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Destefanis Charles B $448,000
Previous Owner Ning Wei $350,000
Previous Owner Ibrahim Md Ezzeldin M $60,000
Previous Owner Ibrahim Md Ezzeldin M $248,000
Previous Owner Ibrahim Md Ezzeldin M $85,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/21/2025 04/21/25 Rented $5,800 0.0% --
04/21/2025 04/21/25 Under Contract -- -- --
04/09/2025 04/09/25 Off Market $5,800 -- --
04/07/2025 04/07/25 For Rent $5,800 +0.9% --
07/15/2024 07/15/24 Rented $5,750 0.0% --
06/03/2024 06/03/24 Under Contract -- -- --
05/10/2024 05/10/24 For Rent $5,750 +4.5% --
10/16/2023 10/16/23 Rented $5,500 0.0% --
10/16/2023 10/16/23 Under Contract -- -- --
09/15/2023 09/15/23 For Rent $5,500 0.0% --
12/16/2020 12/16/20 Off Market $560,000 -- --
10/14/2020 10/14/20 Off Market $440,000 -- --
09/17/2020 09/17/20 Sold $560,000 -9.2% $149 / Sq Ft
08/22/2020 08/22/20 Pending -- -- --
07/16/2020 07/16/20 For Sale $616,500 +40.1% $164 / Sq Ft
08/06/2013 08/06/13 Sold $440,000 -4.3% $109 / Sq Ft
06/29/2013 06/29/13 Pending -- -- --
06/26/2013 06/26/13 For Sale $460,000 -- $114 / Sq Ft
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 $7,652 $196,000 $40,600 $155,400
2023 $7,698 $196,000 $40,600 $155,400
2022 $9,402 $196,000 $30,562 $165,438
2021 $9,159 $196,000 $30,562 $165,438
2020 $9,197 $220,710 $30,562 $190,148
2019 $8,651 $193,606 $26,810 $166,796
2018 $8,669 $193,606 $26,810 $166,796
2017 $8,266 $193,606 $26,810 $166,796
2016 $6,635 $154,000 $24,990 $129,010
2015 $6,682 $154,000 $24,990 $129,010
2014 $6,641 $154,000 $24,990 $129,010
2013 $7,115 $159,208 $24,500 $134,708
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1836357

MLS of Greater Cincinnati (CincyMLS)

APN: 600-0093-0270