NOT LISTED FOR SALE

Estimated Value: $913,000 - $1,068,751

5 Beds
5.5 Baths
5,782 Sq Ft
$168/Sq Ft Est. Value

Last Sold November 01, 2024

Last sale price $910,000 $157 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $6,257/month

1 Day on Market

Highlights

  • Eat-In Gourmet Kitchen
  • View of Trees or Woods
  • Tiered Deck
  • Mercer Elementary School Rated A
  • 1.3 Acre Lot
  • Great Room with Fireplace

About This Home

As of November 2024

Private, Peaceful & Perfect! Custom-built transitional home situated on an idyllic setting on private drive in The Overlook of Ivy Hills with almost 6,000 sq ft. Home features 1st fl primary suite, 3 large bedrooms on 2nd & Lwr Lvl bedroom, 5 Full Baths & Powder Rm on 1st. 1st fl primary adjoins luxury bath w/custom walk-in closet, glass shower, dual vanities & soaking tub. Features include 1st-flr executive study w/bookcases, laundry & gourmet kitchen boasting white cabinetry, island, planning desk, breakfast rm, huge pantry, all new stainless appliances w/dbl oven, radiant cooktop & telescopic venting. 2-story great rm features wall of windows & gas fp for spectacular views & wet bar. Living rm to right of foyer & formal dining off kitchen. Bonus rm is on the right wing of the home w/full bath. 3 bdrms on left wing have 2 full baths. Lower lvl offers family rm w/gas fp, full bath, 5th bdrm & exercise/media rm w/walkout. Multi-level deck, lush backyard & 3-car oversized garage.

Last Agent to Sell the Property

Laura Kraemer

Comey & Shepherd License #2001007261 Listed on: 10/04/2024

Comey & Shepherd

Last Buyer's Agent

Elisa Ibold

Hoeting, REALTORS License #2002002732

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,330

Year Built

  • Built in 1997

Lot Details

  • 1.3 Acre Lot
  • Cul-De-Sac
  • Property has an invisible fence for dogs
  • Lot Has A Rolling Slope

HOA Fees

  • $59 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Property Views

  • Woods
  • Valley

Home Design

  • Transitional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 5,782 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Bookcases
  • Crown Molding
  • Vaulted Ceiling
  • Ceiling Fan
  • Chandelier
  • Marble Fireplace
  • Brick Fireplace
  • Gas Fireplace
  • Double Hung Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Great Room with Fireplace
  • 2 Fireplaces
  • Family Room
  • Formal Dining Room
  • Wood Flooring

Kitchen

  • Eat-In Gourmet Kitchen
  • Double Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Smart Appliances
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Finished Basement

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

Outdoor Features

  • Tiered Deck

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater

Community Details

  • Association fees include association dues, landscapingcommunity, professionalmgt
  • Stonegate Prop Mgt Association
  • Overlook Of Ivy Hills Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,330

Year Built

Built in 1997

Lot Details

0

HOA Fees

$59 per month

Parking

3

Listing Details

  • Suburb: Anderson Twp.
  • Cross Street: Overlook Hills
  • Land Description: 1 to 4.9 Acres
  • Access: County Road,Private Drive
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Busline Near,Cable,Ceiling Fan,Recessed Lights,Smoke Alarm
  • Census Tract Realist: 249.04
  • Cooling: Ceiling Fans, Central Air
  • Heating: Forced Air, Gas, Zoned
  • Lot Area Realist: 56628.00
  • Suburb S I C: Anderson Twp.
  • Price Per Acre: 700000.00
  • Basement Features: Finished,Fireplace,Walkout,WW Carpet
  • Bathroom 4: Full
  • Bathroom 4 Level: 2
  • Level 1 Bathroom Type: Full,Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Chandelier,Formal,WW Carpet
  • Entry Foyer: Marble/Slate,Open Foyer,Transom/Sidelit
  • Family Room Feat: Walkout,Wall-to-Wall Carpet,Wet Bar
  • Great Room Feat: Wall-to-Wall Carpet,Wet Bar,Fireplace
  • Living Great Rm Dim: 15 x 11
  • Living Room Feat: Wall-to-Wall Carpet
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Smart Technology: Appliances
  • Study Lib Den: 16x11 Level: 1
  • Study Lib Den Dim: 16 x 11
  • Water Heating: Gas
  • Year Built: 1997
  • Architecture: Transitional
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Bedrooms: 5
  • Directions: Little Dry Run to Overlook Hills to Dry Run View Lane. Second Home on Private Drive
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2024-10-04
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Overlook of Ivy Hills
  • Occupancy: At Closing
  • Second Floor Area: 1695
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, French Doors, Multi Panel Doors, Vaulted Ceiling
  • Bedroom 2: 15x12 Level: 2
  • Bedroom 3: 12x11 Level: 2
  • Bedroom 4: 15x11 Level: 2
  • Bedroom 5: 18x13 Level: Lower
  • Breakfast Room: 14x9 Level: 1
  • Dining Room: 15x12 Level: 1
  • Family Room: 39x17 Level: Lower
  • Living Room: 15x11 Level: 1
  • Recreation Room: 28x26 Level: 2
  • Formal Dining Room: Yes
  • Flex Rooms: Media Room,Bonus Room,Exercise Room
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $6165
  • Kitchen: 20x14 Level: 1
  • Appliances: Dishwasher, Double Oven, Dryer, Electric Cooktop, Garbage Disposal, Microwave, Oven/Range, Refrigerator, Washer
  • Kitchen Features: Pantry,Planning Desk,Solid Surface Ctr,Eat-In,Walkout,Gourmet,Island,Wood Cabinets,Wood Floor
  • Basement: Full
  • Study Features: Bookcases,Wall-to-Wall Carpet,French Doors,Panel Walls
  • Entry: 20x8 Level: 1
  • Bathrooms: 6.00
  • Great Room: 21x17 Level: 1
  • Kitchen Dim: 20 x 14
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Partial
  • Bathroom 2 Level: 1
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundry Room: 8x6 Level: 1
  • Laundryroom Dim: 8 x 6
  • Recreation Room Dim: 28 x 26
  • Fireplace: Brick, Marble, Gas
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 5782.00
  • Windows: Double Hung
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 18 x 15
  • Primary Bathrooms: Built-In Shower Seat,Shower,Double Vanity,Tub,Marb/Gran/Slate
  • PrimaryBedFeat: Bath Adjoins,Vaulted Ceiling,Walk-in Closet,Wall-to-Wall Carpet
  • P R I M A R Y B E D R O O M: 18x15 Level: 1

Exterior Features

  • View: Valley, Woods
  • Fencing: Invisible
  • Roof: Shingle
  • Construction: Brick
  • Outside Features: Cul de sac, Deck, Tiered Deck
  • Foundation: Poured
  • Listing Price: 950000.00
  • Acres: 1.3000
  • New Construction: No
  • TopographyDetails: Rolled

Garage/Parking

  • Garage Spaces: 3.00
  • Garage Carport: Built in,Side,Garage Attached
  • Parking: On Street, Driveway

Utilities

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

Condo/Co-op/Association

  • HOA Fees: 710.00
  • Fee Frequency: Annually
  • HOA Management Co: Stonegate Prop Mgt
  • HOA Yes/No: Yes
  • Association: Cincinnati Area Multiple Listing Service
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Inc.In HOA/Condo Fee: AssociationDues, LandscapingCommunity, ProfessionalMgt

Schools

  • District: Forest Hills Local S

Lot Info

  • Lot Size Sq Ft: 56628.00
  • Total Assessed Value: 0
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 4, 2024
Closed on
Oct 29, 2024
Sold by
Farris Phillip D and Farris Susan G
Bought by
Herberth Johann and Herberth Mary R
Seller's Agent
Laura Kraemer
Comey & Shepherd
Buyer's Agent
Elisa Ibold
Hoeting, REALTORS
List Price
$950,000
Sold Price
$910,000
Premium/Discount to List
-$40,000
-4.21%
Views
11
Current Estimated Value
$972,688

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$62,688
Avg. Annual Appreciation
6.96%
Original Mortgage
$350,000
Outstanding Balance
$346,489
Interest Rate
6.08%
Mortgage Type
New Conventional
Estimated Equity
$626,199

Purchase Details

Closed on
Oct 24, 1997
Sold by
M I Schottenstein Homes Inc
Bought by
Farris Phillip D and Farris Susan G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$335,000
Interest Rate
7.42%
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
Herberth Johann $910,000 None Listed On Document
Farris Phillip D $467,600 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Herberth Johann $350,000
Previous Owner Farris Phillip D $335,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/01/2024 11/01/24 Sold $910,000 -4.2% $157 / Sq Ft
10/05/2024 10/05/24 Pending -- -- --
10/04/2024 10/04/24 For Sale $950,000 -- $164 / 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 $12,989 $213,640 $35,945 $177,695
2023 $12,351 $213,640 $35,945 $177,695
2022 $12,418 $191,300 $36,663 $154,637
2021 $12,130 $191,300 $36,663 $154,637
2020 $12,263 $191,300 $36,663 $154,637
2019 $13,242 $187,551 $35,945 $151,606
2018 $12,404 $187,551 $35,945 $151,606
2017 $11,702 $187,551 $35,945 $151,606
2016 $13,126 $205,548 $38,591 $166,957
2015 $12,745 $205,548 $38,591 $166,957
2014 $12,753 $205,548 $38,591 $166,957
2013 $11,824 $201,520 $37,835 $163,685
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1820324

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0230-0125