NOT LISTED FOR SALE

Estimated Value: $5,605,209 - $7,047,000

6 Beds
7.5 Baths
14,528 Sq Ft
$453/Sq Ft Est. Value

Last Sold December 22, 2021

Last sale price $3,800,000 $262 Per Sq Ft

Est. 73% increase in value since last sale

Current estimated payment $40,721/month

7 Days on Market

Highlights

  • Spa
  • Eat-In Gourmet Kitchen
  • View of Trees or Woods
  • Indian Hill Primary School Rated A-
  • Sitting Area In Primary Bedroom
  • Heated Floors

About This Home

As of December 2021

An incredible 3-story limestone estate on 5.8 acres. Original Weil Barn, stocked pond with waterfall, pool, fire-pits. Custom built home of the highest-quality materials and workmanship. Exquisite formal spaces, beautiful bedroom suites and guest apartments, 8+car garages, 3 fully appointed kitchens; 4 laundry rooms, outdoor kitchen - all with meticulous attention to detail.

Last Listed By

Carol Harris

Comey & Shepherd License #0000381672 Listed on: 09/08/2021

Comey & Shepherd

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $38,382

Year Built

  • Built in 2006

Lot Details

  • Cul-De-Sac
  • Yard

Parking

  • 8 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Shingle Roof

Interior Spaces

  • 14,528 Sq Ft Home
  • 3-Story Property
  • Elevator
  • Crown Molding
  • Vaulted Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Insulated Windows
  • Double Hung Windows
  • Panel Doors
  • Family Room with Fireplace
  • 8 Fireplaces
  • Living Room with Fireplace
  • Formal Dining Room
  • Heated Floors
  • Views of Woods

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Solid Wood Cabinet
  • Trash Compactor
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Sitting Area In Primary Bedroom
  • Main Floor Bedroom
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Finished Basement

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

Outdoor Features

  • Spa
  • Deck
  • Patio
  • Fire Pit
  • Exterior Lighting
  • Outdoor Grill
  • Porch

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$38,382

Year Built

Built in 2006

Lot Details

0

Parking

8

Listing Details

  • Suburb: Indian Hill
  • Buildings: Barn,Guest House
  • Land Description: 5 to 9.9 Acres
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Cable,Recessed Lights,Smoke Alarm
  • Basement Sq Ft: 5152
  • Census Tract Realist: 244.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 252648.00
  • Property Ownership: Consumer
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Indian Hill
  • Basement Features: Finished,Fireplace,Walkout
  • Bathroom 4: Full
  • Bathroom 4 Level: 3
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Bedroom 5 Area: 378
  • Level 1 Bedroom: Yes
  • Breakfast Room Area: 180
  • Dining Room Feat: Chandelier,Fireplace,WW Carpet
  • Entry Area: 483
  • Entry Dim: 23 x 21
  • Entry Foyer: Closet,Double Doors,Marble/Slate,Open Foyer
  • Family Room Feat: Fireplace
  • Living Great Rm Area: 504
  • Living Great Rm Dim: 24 x 21
  • Living Great Rm Len: 24
  • Living Great Rm Wid: 21
  • Living Room Feat: Bookcases,Fireplace,Walkout,WW Carpet
  • Mechanical Systems: Garage Door Opener,Humidifier
  • Single Family Desc: Single Family
  • Study Lib Den: 20x15 Level: 1
  • Study Lib Den Area: 300
  • Study Lib Den Dim: 20 x 15
  • Study Lib Den Len: 20
  • Water Heating: Gas
  • Year Built: 2006
  • Architecture: Traditional
  • Full Bathrooms: 7
  • Half Bathrooms: 1
  • Bedrooms: 6
  • Directions: From Hopewell Road, turn left onto Weil Road, turn left onto Fawnmeadow Lane.
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2021-09-08
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • On Market: No
  • Third Party Approval Required: No
  • Second Floor Area: 4808
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Beam Ceiling, Crown Molding, Elevator, French Doors, Heated Floors, Multi Panel Doors, Skylight, Vaulted Ceiling
  • Bedroom 2: 21x20 Level: 2
  • Bedroom 3: 21x15 Level: 2
  • Bedroom 4: 22x18 Level: 2
  • Bedroom 5: 21x18 Level: 3
  • Breakfast Room: 15x12 Level: 1
  • Dining Room: 24x15 Level: 1
  • Family Room: 18x17 Level: 1
  • Living Room: 24x21 Level: 1
  • Recreation Room: 49x23 Level: Lower
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Bathrooms Display: 8 (7 1)
  • Reciprocal Listing: No
  • School Name1: Call SD 513-272-4500
  • Semi Annual Taxes: 19,191.23
  • Kitchen: 27x25 Level: 1
  • Appliances: Dishwasher, Dryer, Garbage Disposal, Microwave, Oven/Range, Refrigerator, Trash Compactor, Washer
  • Kitchen Features: Butler's Pantry,Counter Bar,Eat-In,Gourmet,Island,Marble/Granite/Slate,Pantry,Solid Surface Ctr,Walkout,Wood Cabinets
  • Bedroom 2 Area: 420
  • Basement: Full
  • Bedroom 3 Area: 315
  • Study Features: Bookcases,Fireplace,French Doors,Panel Walls,WW Carpet
  • Bedroom 4 Area: 396
  • Entry: 23x21 Level: 1
  • Bathrooms: 8.00
  • Kitchen Area: 675
  • Kitchen Dim: 27 x 25
  • Levels: Three
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Diningroom Area: 360
  • Family Room Area: 306
  • Laundry Room: 14x10 Level: 1
  • Laundry Room Area: 140
  • Laundryroom Dim: 14 x 10
  • Recreation Room Area: 1127
  • Recreation Room Dim: 49 x 23
  • Fireplace: Gas, Stone, Wood
  • Fireplaces: 8
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 14528.00
  • Total Rooms: 25
  • Windows: Casement, Double Hung, Insulated
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 360
  • PrimaryBedroomDim: 20 x 18
  • PrimaryBedroomLen: 20
  • Primary Bathrooms: Double Vanity,Heated Floors,Marb/Gran/Slate,Shower,Jetted Tub
  • PrimaryBedFeat: Bath Adjoins,Dressing Area,Fireplace,Sitting Room,Walk-in Closet,Walkout,Window Treatment,WW Carpet
  • P R I M A R Y B E D R O O M: 20x18 Level: 1

Exterior Features

  • View: Woods
  • Roof: Shingle
  • Pool: In-Ground
  • Construction: Stone
  • Outside Features: BBQ Grill, Cul de sac, Deck, Fire Pit, Hot Tub, Patio, Porch, Sprinklers, Wooded Lot, Yard Lights
  • Foundation: Poured
  • Listing Price: 3900000.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 8.00
  • Garage Carport: Garage Attached,Garage Detached,Oversized
  • Parking: Driveway

Utilities

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

Condo/Co-op/Association

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

Schools

  • District: Indian Hill Ex Vill

Lot Info

  • Lot Dimensions: 5.8 Acres
  • Total Assessed Value: 0.00
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 28, 2019
Closed on
Nov 15, 2019
Sold by
Azizkhan Geralyn Brindisi
Bought by
Ianni Peter B
Seller's Agent
Carol Harris
Comey & Shepherd
Buyer's Agent
Cliff Montgomery
Coldwell Banker Realty
List Price
$3,795,000
Sold Price
$2,950,000
Premium/Discount to List
-$845,000
-22.27%
Total Days on Market
7
Current Estimated Value
$6,585,052

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$3,635,052
Avg. Annual Appreciation
15.91%
Original Mortgage
$2,919,000
Outstanding Balance
$2,602,683
Interest Rate
3.75%
Mortgage Type
New Conventional
Estimated Equity
$3,982,369

Purchase Details

Closed on
Feb 10, 2009
Sold by
Doll Ramond
Bought by
Beard Justin A

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 6, 2009
Sold by
Beard Justin A
Bought by
Azizkhan Geralyn Brindisi and Geralyn Brindisi Azizkhan Revocable Trus

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 5, 2009
Sold by
Byington Brian T and Byington Dawn M
Bought by
Doll Raymond

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 30, 2004
Sold by
Schraffenberger Mark D
Bought by
Byington Brian T and Byington Dawn M

Purchase Details

Closed on
Jun 20, 2000
Sold by
Seaman Martha S
Bought by
Seaman Martha S and Martha S Seaman Revocable Trust

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
Ianni Peter B $2,950,000 Acs Title & Closing Services
Beard Justin A $3,700,000 Attorney
Azizkhan Geralyn Brindisi -- Attorney
Doll Raymond -- Attorney
Byington Brian T -- --
Schraffenberger Mark D $1,000,000 --
Seaman Martha S -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ianni Peter B $2,919,000
Previous Owner Azizkhan Geralyn Brindisi $450,000
Previous Owner Beard Justin A $600,000
Previous Owner Azizkhan Geralyn Brindisi $2,400,000
Previous Owner Byington Dawn M $3,500,000
Previous Owner Byington Brian T $1,000,000
Previous Owner Byington Brian T $2,500,400
Previous Owner Seaman Martha S $25,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/22/2021 12/22/21 Sold $3,800,000 -2.6% $262 / Sq Ft
09/16/2021 09/16/21 Pending -- -- --
09/08/2021 09/08/21 For Sale $3,900,000 +32.2% $268 / Sq Ft
03/16/2020 03/16/20 Off Market $2,950,000 -- --
11/19/2019 11/19/19 Sold $2,950,000 -15.6% $203 / Sq Ft
09/23/2019 09/23/19 Pending -- -- --
07/11/2019 07/11/19 Price Changed $3,495,000 -7.9% $241 / Sq Ft
03/19/2019 03/19/19 For Sale $3,795,000 -- $261 / 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 $47,606 $1,330,000 $370,440 $959,560
2023 $47,663 $1,330,000 $370,440 $959,560
2022 $44,952 $1,032,500 $277,830 $754,670
2021 $43,914 $1,032,500 $277,830 $754,670
2020 $38,382 $1,032,500 $277,830 $754,670
2019 $51,256 $1,252,892 $277,830 $975,062
2018 $51,324 $1,252,892 $277,830 $975,062
2017 $49,552 $1,252,892 $277,830 $975,062
2016 $51,443 $1,282,051 $290,161 $991,890
2015 $50,970 $1,282,051 $290,161 $991,890
2014 $50,506 $1,282,051 $290,161 $991,890
2013 $52,920 $1,295,000 $293,090 $1,001,910
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: 1714902

MLS of Greater Cincinnati (CincyMLS)

APN: 629-0290-0022