NOT LISTED FOR SALE

Estimated Value: $1,278,000 - $1,488,000

5 Beds
6 Baths
5,387 Sq Ft
$255/Sq Ft Est. Value

Last Sold August 01, 2023

Last sale price $1,125,000 $209 Per Sq Ft

Est. 22% increase in value since last sale

Current estimated payment $9,076/month

1 Day on Market

Highlights

  • Views of Trees
  • Fireplace in Primary Bedroom
  • Transitional Architecture
  • Indian Hill Primary School Rated A-
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of August 2023

IH Schools! Stunning exterior in all white, flagged by a HUGE outdoor living space w/ fireplace, built in bar/grill & a spacious lounge/dining area overlooking your private wooded lot. Inside offers space for everyone. 1st flr is complete w/ an impressive office, cozy family, room, formal living area & Great Room. Spacious primary BR w/ sitting area & fireplace. LL complete w/ rec area, exercise room, 2nd office & 5th BR. Interior is freshly painted. Hdwd flrs. Updated lighting. Roof June 2023.

Last Agent to Sell the Property

Scott Oyler

Coldwell Banker Realty License #2003011808 Listed on: 06/13/2023

Coldwell Banker Realty

Co-Listed By

Laura Wogen

Coldwell Banker Realty License #2003015773

Last Buyer's Agent

Scott Oyler

Coldwell Banker Realty License #2003011808 Listed on: 06/13/2023

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,259

Year Built

  • Built in 1994

Lot Details

  • 0.93 Acre Lot
  • Lot Dimensions are 87.47 x 301.53
  • Cul-De-Sac
  • Aluminum or Metal Fence

HOA Fees

  • $35 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Driveway
  • Off-Street Parking

Home Design

  • Transitional Architecture
  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 5,387 Sq Ft Home
  • 2-Story Property
  • Woodwork
  • Crown Molding
  • Vaulted Ceiling
  • Skylights
  • Brick Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Double Hung Windows
  • Bay Window
  • Wood Frame Window
  • French Doors
  • Sliding Doors
  • Great Room with Fireplace
  • 4 Fireplaces
  • Family Room
  • Living Room with Fireplace
  • Breakfast Room
  • Dining Room
  • Library
  • Game Room
  • Views of Trees

Kitchen

  • Eat-In Kitchen
  • <<OvenToken>>
  • Gas Cooktop
  • <<microwave>>
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Fireplace in Basement

Outdoor Features

  • Patio
  • Outdoor Fireplace
  • Built-In Barbecue

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Electric Water Heater

Community Details

  • Association fees include ground maintenance
  • Bluffs At River's Bend Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,259

Year Built

Built in 1994

Lot Details

0

HOA Fees

$35 per month

Parking

3

Listing Details

  • Cross Street: Humphrey Rd
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Zoning: Residential
  • Year Built: 1994
  • Above Grade Finished Sq Ft: 4387.0
  • Architecture: Transitional
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Bedrooms: 5
  • Directions: Loveland Madeira to Humphrey to Mistymorn
  • GarageYN: Yes
  • ListOfficeEmail: bill.heckman@cbws.com
  • Lot Measurement: Square Feet
  • Showing Start Date: 2023-06-15
  • Ownership: Consumer
  • Property Subtype 1: Single Family Residence
  • StructureType: Detached Home
  • Suburb (SIC): Bluffs at River's Bend
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Crown Molding, High Ceilings, Eat In Kitchen, Granite Counters, Natural Woodwork, Vaulted Ceilings
  • Property Type: Residential
  • Appliances: Oven, Disposal, Microwave, Dishwasher, Humidifier, Gas Cooktop, Refrigerator, Electric Water Heater
  • Basement: Full, Finished, Sump Pump, Walk Out Access, Wall To Wall Carpeting
  • Flooring: Wood, Carpet
  • Levels: Two
  • Total Bathrooms: 6
  • Door Features: French Doors, Sliding Doors
  • Fireplace: Gas, Brick, Outside, Basement, Great Room, Living Room, Master Bedroom
  • FireplaceYN: Yes
  • Fireplaces: 4
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 5387.0
  • Lot Size Area: 40554.0
  • Street Number Modifier: 9869
  • Windows: Skylights, Bow Windows, Double Hung, Wood Frames, Window Treatments, Double Pane Windows

Exterior Features

  • View: Trees Woods
  • Fencing: Metal
  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Built In Barbecue
  • Foundation: Poured
  • Listing Price: 1150000.0
  • Lot Features: Cul De Sac
  • Acres: 0.931
  • New Construction: No
  • Patio And Porch Features: Patio

Garage/Parking

  • Garage Spaces: 3.0
  • Parking: Attached, Driveway, Off Street, Garage Faces Side

Utilities

  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 425.0
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Inc.In HOA/Condo Fee: Maintenance Grounds

Schools

  • District: Indian Hill Ex Vill

Lot Info

  • Lot Dimensions: 87.47 x 301.53
  • Lot Size Sq Ft: 40554.0
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Verification: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 13, 2023
Closed on
Jul 28, 2023
Sold by
Holum David J and Holum Jill Nicole
Bought by
Lingenfelter Nicholas Peter and Lingenfelter Jessica Cooper
Seller's Agent
Scott Oyler
Coldwell Banker Realty
Buyer's Agent
Scott Oyler
Coldwell Banker Realty
List Price
$1,150,000
Sold Price
$1,125,000
Premium/Discount to List
-$25,000
-2.17%
Views
75
Current Estimated Value
$1,372,766

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$247,766
Avg. Annual Appreciation
8.12%
Original Mortgage
$900,000
Outstanding Balance
$883,522
Interest Rate
6.71%
Mortgage Type
New Conventional
Estimated Equity
$426,359

Purchase Details

Listed on
Apr 2, 2019
Closed on
Jun 27, 2019
Sold by
Lawson Niancy A and Simon Steven E
Bought by
Holum David J and Holum Jill Nicole
Seller's Agent
Judy Recker
Sibcy Cline, Inc.
Buyer's Agent
Carol Allmyer
Berkshire Hathaway HomeService
List Price
$849,500
Sold Price
$830,000
Premium/Discount to List
-$19,500
-2.3%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.70%
Original Mortgage
$664,000
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jul 15, 1994
Sold by
Schreiner Joanne M
Bought by
Lawson Nancy A and Simon Steven E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$557,404
Interest Rate
8.6%
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
Lingenfelter Nicholas Peter $1,125,000 None Listed On Document
Holum David J $830,000 None Available
Lawson Nancy A -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lingenfelter Nicholas Peter $900,000
Previous Owner Holum David J $79,920
Previous Owner Holum David J $664,000
Previous Owner Lawson Nancy A $657,500
Previous Owner Lawson Nancy A $30,000
Previous Owner Lawson Nancy A $674,500
Previous Owner Simon Steven E $665,000
Previous Owner Simon Steven E $75,000
Previous Owner Simon Steven E $135,000
Previous Owner Lawson Nancy A $557,404
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/01/2023 08/01/23 Sold $1,125,000 -2.2% $209 / Sq Ft
06/17/2023 06/17/23 Pending -- -- --
06/15/2023 06/15/23 For Sale $1,150,000 +38.6% $213 / Sq Ft
09/26/2019 09/26/19 Off Market $830,000 -- --
06/28/2019 06/28/19 Sold $830,000 -2.3% $154 / Sq Ft
06/10/2019 06/10/19 Pending -- -- --
05/24/2019 05/24/19 Price Changed $849,500 0.0% $158 / Sq Ft
05/24/2019 05/24/19 For Sale $849,500 +2.3% $158 / Sq Ft
05/13/2019 05/13/19 Off Market $830,000 -- --
04/02/2019 04/02/19 For Sale $875,000 -- $162 / 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 $17,259 $393,751 $57,173 $336,578
2023 $18,171 $417,428 $57,173 $360,255
2022 $15,626 $290,500 $81,270 $209,230
2021 $15,244 $290,500 $81,270 $209,230
2020 $13,793 $290,500 $81,270 $209,230
2019 $14,365 $299,250 $75,250 $224,000
2018 $14,381 $299,250 $75,250 $224,000
2017 $14,049 $307,976 $75,250 $232,726
2016 $11,704 $253,750 $75,250 $178,500
2015 $11,794 $253,750 $75,250 $178,500
2014 $11,593 $253,750 $75,250 $178,500
2013 $12,022 $253,750 $75,250 $178,500
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1775104

MLS of Greater Cincinnati (CincyMLS)

APN: 620-0160-0393