NOT LISTED FOR SALE

Estimated Value: $900,745 - $1,082,000

4 Beds
3 Baths
3,899 Sq Ft
$251/Sq Ft Est. Value

Last Sold July 24, 2017

Last sale price $566,000 $145 Per Sq Ft

Est. 73% increase in value since last sale

Current estimated payment $6,626/month

4 Days on Market

Highlights

  • Gourmet Kitchen
  • View of Trees or Woods
  • Deck
  • Walnut Hills High School Rated A+
  • 0.82 Acre Lot
  • Contemporary Architecture

About This Home

As of July 2017

Over 4400 sf of modern, light filled living tucked away on a private drive. Loft feel w/25 ft ceilings in great room. First floor master suite w/vaulted ceiling, gas FP & walk-in closet. First floor study & laundry. Finished LL walkout w/2 bedrooms, kitchen, media rm, exercise rm. Over .8 acres of fenced privacy. Tax abated thru 2021.

Last Agent to Sell the Property

Shelley Miller Reed

Coldwell Banker Realty License #2007006085 Listed on: 06/01/2017

Coldwell Banker Realty

Co-Listed By

Amy Hackett Roe

Coldwell Banker Realty License #2009000052

Last Buyer's Agent

Pete Kopf

Kopf Hunter Haas License #0000419493

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,590

Year Built

  • Built in 2006

Lot Details

  • 0.82 Acre Lot
  • Cul-De-Sac

Parking

  • 2 Car Garage
  • Driveway
  • On-Street Parking

Home Design

  • Contemporary Architecture
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 3,899 Sq Ft Home
  • 1-Story Property
  • Cathedral Ceiling
  • 2 Fireplaces
  • Gas Fireplace
  • Insulated Windows
  • Family Room
  • Formal Dining Room
  • Wood Flooring
  • Views of Woods

Kitchen

  • Gourmet Kitchen
  • Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

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

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Deck
  • Porch

Utilities

  • Central Air
  • Geothermal Heating and Cooling

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,590

Year Built

Built in 2006

Lot Details

0

Parking

2

Listing Details

  • Suburb: Clifton
  • Cross Street: McAlpin
  • Degree Complete: Completed
  • Land Description: .5 to .9 Acres
  • Broker Approved: Yes
  • Miscellaneous: Cable,Ceiling Fan,Recessed Lights,Smoke Alarm
  • Basement Sq Ft: 2469
  • Census Tract Realist: 71.00
  • Cooling: Central Air
  • Heating: Geothermal
  • Lot Area Realist: 35802.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Clifton
  • Price Per Acre: 690243.90
  • Basement Features: Part Finished,Walkout,WW Carpet
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Wood Floor,Walkout,French Doors
  • Entry Area: 216
  • Entry Foyer: Wood Floor,Open Foyer
  • Family Room Feat: WW Carpet,Walkout
  • Living Great Rm Area: 646
  • Living Great Rm Dim: 34 x 19
  • Living Great Rm Len: 34
  • Living Great Rm Wid: 19
  • Mechanical Systems: Garage Door Opener,Security System
  • Single Family Desc: Single Family
  • Study Lib Den: 14x14 Level: 1
  • Study Lib Den Area: 196
  • Study Lib Den Dim: 14 x 14
  • Study Lib Den Len: 14
  • Year Built: 2006
  • School 1 Type: District Phone
  • Architecture: Contemporary/Modern
  • Full Bathrooms: 3
  • Bedrooms: 4
  • Directions: Private street of McAlpin between Middleton & Lafayette
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2017-06-01
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Cathedral Ceiling
  • Bedroom 2: 14x12 Level: 1
  • Bedroom 3: 14x12 Level: Lower
  • Bedroom 4: 12x11 Level: Lower
  • Dining Room: 14x12 Level: 1
  • Family Room: 24x23 Level: Lower
  • Living Room: 34x19 Level: 1
  • Formal Dining Room: Yes
  • Flex Rooms: Solarium
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-363-0000
  • Semi Annual Taxes: 3295.17
  • Kitchen: 19x12 Level: 1
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
  • Kitchen Features: Wood Floor,Marble/Granite/Slate,Gourmet,Wood Cabinets,Pantry,Island
  • Bedroom 2 Area: 168
  • Basement: Full
  • Bedroom 3 Area: 168
  • Study Features: Wood Floor
  • Bedroom 4 Area: 132
  • Entry: 18x12 Level: 1
  • Bathrooms: 3.00
  • Kitchen Area: 228
  • Kitchen Dim: 19 x 12
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Bathroom 3: Full
  • Bathroom 3 Level: Lower
  • Diningroom Area: 168
  • Family Room Area: 552
  • Laundry Room: 8x6 Level: 1
  • Laundry Room Area: 48
  • Laundryroom Dim: 8 x 6
  • Recreation Room Dim: 0 x 0
  • Fireplace: Gas
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 3899.00
  • Total Rooms: 10
  • Windows: Insulated
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 266
  • PrimaryBedroomDim: 19 x 14
  • PrimaryBedroomLen: 19
  • Primary Bathrooms: Double Vanity,Marb/Gran/Slate,Shower
  • PrimaryBedFeat: Wood Floor,Bath Adjoins,Walk-in Closet,Skylight
  • P R I M A R Y B E D R O O M: 19x14 Level: 1

Exterior Features

  • View: Woods
  • Roof: Shingle
  • Construction: Vinyl Siding
  • Outside Features: Deck, Porch, Cul de sac
  • Foundation: Poured
  • Listing Price: 559000.00
  • Acres: 0.8200
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Garage Attached,Built in,Front
  • Parking: Driveway, On Street

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Schools

  • District: Cincinnati City SD

Lot Info

  • Lot Dimensions: irregular
  • Lot Size Sq Ft: 35719.00
  • Total Assessed Value: of record
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 1, 2017
Closed on
Jul 24, 2017
Sold by
Hays Ryan M and Hays Virgina P Mischen
Bought by
Madelaine Frederic and Madelaine Florence
Seller's Agent
Shelley Miller Reed
Coldwell Banker Realty
Buyer's Agent
Pete Kopf
Kopf Hunter Haas
List Price
$559,000
Sold Price
$566,000
Premium/Discount to List
$7,000
1.25%
Current Estimated Value
$980,436

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$414,436
Avg. Annual Appreciation
6.71%
Original Mortgage
$376,000
Outstanding Balance
$314,071
Interest Rate
3.91%
Mortgage Type
New Conventional
Estimated Equity
$644,750

Purchase Details

Listed on
Aug 8, 2011
Closed on
Dec 23, 2011
Sold by
National Residential Nominee Services In
Bought by
Hays Ryan M and Mischen Hays Virginia P
Seller's Agent
David Dawson
Sibcy Cline, Inc.
Buyer's Agent
Shelley Miller Reed
Coldwell Banker Realty
List Price
$645,000
Sold Price
$425,000
Premium/Discount to List
-$220,000
-34.11%

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.32%
Original Mortgage
$340,000
Interest Rate
3.98%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 8, 2011
Sold by
Schoembs Steven G and Schoembs Kelly M
Bought by
National Residential Nominee Services In

Purchase Details

Closed on
Oct 25, 2008
Sold by
Thomas Rebecca L
Bought by
Schoembs Steven G and Schoembs Kelly M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$75,000
Interest Rate
6.11%
Mortgage Type
Unknown

Purchase Details

Closed on
Mar 2, 2006
Sold by
Ekd Properties Llc
Bought by
Butterfield Spencer L and Thomas Mary Beth

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
6.33%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Feb 10, 2006
Sold by
Durban Elizabeth J
Bought by
Ekd Properties Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
6.33%
Mortgage Type
Fannie Mae Freddie Mac
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
Madelaine Frederic $556,000 None Available
Hays Ryan M -- Attorney
National Residential Nominee Services In $645,000 Fidelity
Schoembs Steven G -- Chicago Title Insurance Co
Butterfield Spencer L $75,000 None Available
Ekd Properties Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Madelaine Frederic $376,000
Previous Owner Hays Ryan M $340,000
Previous Owner Schoembs Steven $75,000
Previous Owner Schoembs Steven G $417,000
Previous Owner Butterfield Spencer L $95,000
Previous Owner Butterfield Spencer L $417,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/22/2017 10/22/17 Off Market $566,000 -- --
07/24/2017 07/24/17 Sold $566,000 +1.3% $145 / Sq Ft
06/05/2017 06/05/17 Pending -- -- --
06/01/2017 06/01/17 For Sale $559,000 +31.5% $143 / Sq Ft
04/12/2012 04/12/12 Off Market $425,000 -- --
01/12/2012 01/12/12 Sold $425,000 -34.1% $109 / Sq Ft
12/07/2011 12/07/11 Pending -- -- --
08/08/2011 08/08/11 For Sale $645,000 -- $165 / 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 $15,533 $260,544 $70,298 $190,246
2023 $15,884 $260,544 $70,298 $190,246
2022 $13,465 $198,100 $62,986 $135,114
2021 $7,334 $198,100 $62,986 $135,114
2020 $7,549 $198,100 $62,986 $135,114
2019 $8,575 $202,587 $56,238 $146,349
2018 $8,588 $202,587 $56,238 $146,349
2017 $8,160 $202,587 $56,238 $146,349
2016 $6,588 $148,750 $50,484 $98,266
2015 $5,939 $148,750 $50,484 $98,266
2014 $5,981 $148,750 $50,484 $98,266
2013 $6,086 $148,750 $50,484 $98,266
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: 1539823

MLS of Greater Cincinnati (CincyMLS)

APN: 215-0066-0066