NOT LISTED FOR SALE

8875 Camargo Rd Cincinnati, OH 45243

Estimated Value: $2,633,000 - $3,050,000

5 Beds
7 Baths
9,100 Sq Ft
$305/Sq Ft Est. Value

Last Sold January 30, 2018

Last sale price $1,190,001 $131 Per Sq Ft

Est. 133% increase in value since last sale

Current estimated payment $16,216/month

52 Days on Market

Highlights

  • Wine Cellar
  • View of Trees or Woods
  • Dining Room with Fireplace
  • Indian Hill Primary School Rated A-
  • Deck
  • Cathedral Ceiling

About This Home

As of January 2018

Beautiful, Classic Indian Hill Country Home Built By Stewart & Jervis. Striking Finishes & Craftsmanship. 1St Flr Mstr with spacious walk-in closet. Gourmet eat in kitchen overlooks the wooded lot. 4 Bedrooms and 4 baths on 2nd floor. Finished lower level with bar, wine cellar, sauna, exercise room and more. Make this one of a kind home your own.

Last Agent to Sell the Property

Brian Brockman

Bang Realty, Inc. License #2009000214 Listed on: 09/29/2017

Last Buyer's Agent

Matt O'Connor

Union Village Realty LLC License #2018001460

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2003

Lot Details

  • Wood Fence

Parking

  • 4 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Poured Concrete
  • Shingle Roof
  • Wood Siding
  • Stone

Interior Spaces

  • 9,100 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Crown Molding
  • Beamed Ceilings
  • Cathedral Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Marble Fireplace
  • Insulated Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Wine Cellar
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • 5 Fireplaces
  • Formal Dining Room
  • Wood Flooring
  • Views of Woods
  • Eat-In Kitchen

Bedrooms and Bathrooms

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

Finished Basement

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

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Propane
  • Aerobic Septic System

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 2003

Lot Details

0

Parking

4

Listing Details

  • Suburb: Indian Hill
  • Cross Street: Given
  • Broker Approved: Yes
  • Miscellaneous: Ceiling Fan,Recessed Lights
  • Census Tract Realist: 244.00
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 130680.00
  • Suburb S I C: Indian Hill
  • Basement Features: Finished,Fireplace,Walkout
  • Bathroom 4: Full
  • Bathroom 4 Level: 2
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Fireplace,Wood Floor
  • Entry Foyer: Open Foyer,Wood Floor
  • Family Room Feat: Fireplace,French Doors,Walkout,Wood Floor
  • Living Great Rm Dim: 31 x 19
  • Living Room Feat: Bookcases,Fireplace,Wood Floor
  • Single Family Desc: Single Family
  • Study Lib Den: 19x15 Level: 1
  • Study Lib Den Dim: 19 x 15
  • Water Heating: Other
  • Year Built: 2003
  • School 1 Type: District Phone
  • Architecture: Traditional
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Bedrooms: 5
  • Directions: Shawnee Run to N on Given to corner of Camargo & Given
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2017-09-29
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • Second Floor Area: 2825
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Beam Ceiling, Cathedral Ceiling, Crown Molding, French Doors, Multi Panel Doors, Skylight, Vaulted Ceiling
  • Bedroom 2: 18x18 Level: 2
  • Bedroom 3: 16x18 Level: 2
  • Bedroom 4: 16x15 Level: 2
  • Bedroom 5: 13x17 Level: 2
  • Dining Room: 20x16 Level: 1
  • Family Room: 18x21 Level: 1
  • Living Room: 31x19 Level: 1
  • Formal Dining Room: Yes
  • Flex Rooms: Wine Cellar
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-272-4500
  • Semi Annual Taxes: TBD
  • Kitchen: 19x24 Level: 1
  • Kitchen Features: Eat-In,Marble/Granite/Slate,Wood Floor
  • Basement: Full
  • Study Features: Bookcases,Fireplace,Panel Walls,Wood Floor
  • Entry: 20x12 Level: 1
  • Bathrooms: 7.00
  • Kitchen Dim: 19 x 24
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundry Room: 9x13 Level: 1
  • Laundryroom Dim: 9 x 13
  • Recreation Room Dim: 0 x 0
  • Fireplace: Marble, Stove, Wood
  • Fireplaces: 5
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 9100.00
  • Windows: Insulated
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 17 x 19
  • Primary Bathrooms: Double Vanity,Shower,Tub,Jetted Tub
  • PrimaryBedFeat: Bath Adjoins,Walk-in Closet,Wood Floor
  • P R I M A R Y B E D R O O M: 17x19 Level: 1

Exterior Features

  • View: Woods
  • Fencing: Wood
  • Roof: Shingle
  • Construction: Stone, Wood Siding
  • Outside Features: Balcony, Deck, Patio, Porch
  • Foundation: Poured
  • Listing Price: 1620000.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 4.00
  • Garage Carport: Garage Attached,Oversized
  • Parking: Driveway

Utilities

  • Gas: Propane
  • Sewer: Aerobic Septic
  • 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: irregular
  • Total Assessed Value: OR
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 29, 2017
Closed on
Dec 6, 2017
Sold by
Deutsche Bank National Trust Company
Bought by
Denton D Brock and 8875 Camargo Road Revocable Trust
Seller's Agent
Brian Brockman
Bang Realty, Inc.
Buyer's Agent
Matt O'Connor
Union Village Realty LLC
List Price
$1,620,000
Sold Price
$1,190,001
Premium/Discount to List
-$429,999
-26.54%
Current Estimated Value
$2,777,253

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,587,252
Avg. Annual Appreciation
11.29%
Original Mortgage
$500,000
Interest Rate
3.95%
Mortgage Type
Future Advance Clause Open End Mortgage

Purchase Details

Closed on
Sep 19, 2017
Sold by
Havens Terenca and Havens Ramona A
Bought by
Deutsche Bank National Trust Company

Purchase Details

Closed on
May 23, 2017
Sold by
Havens Terrence and Havens Ramona A
Bought by
Deutsche Bank National Trust Company and Bcap Trust Llc

Purchase Details

Closed on
Nov 7, 2003
Sold by
Stewart & Jervis Builders Inc
Bought by
Havens Terence and Havens Ramona A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,657,500
Interest Rate
3.12%
Mortgage Type
Unknown

Purchase Details

Closed on
Sep 30, 2002
Sold by
Troutman Laverne J Trs
Bought by
Stewart & Jervis Builders Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,500,000
Interest Rate
6.39%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Denton D Brock $1,190,001 None Available
Deutsche Bank National Trust Company $1,500,000 None Available
Deutsche Bank National Trust Company -- None Available
Havens Terence $2,550,000 --
Stewart & Jervis Builders Inc $750,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Denton D Brock $500,000
Previous Owner Havens Terence $1,657,500
Previous Owner Stewart & Jervis Builders Inc $2,500,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/02/2018 05/02/18 Off Market $1,190,001 -- --
01/30/2018 01/30/18 Sold $1,190,001 -26.5% $131 / Sq Ft
11/20/2017 11/20/17 Pending -- -- --
10/31/2017 10/31/17 For Sale $1,620,000 +36.1% $178 / Sq Ft
10/27/2017 10/27/17 Off Market $1,190,001 -- --
09/29/2017 09/29/17 For Sale $1,620,000 -- $178 / 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 $20,494 $547,561 $267,904 $279,657
2023 $20,200 $547,561 $267,904 $279,657
2022 $18,632 $416,500 $193,200 $223,300
2021 $18,500 $416,500 $193,200 $223,300
2020 $15,906 $416,500 $193,200 $223,300
2019 $17,039 $416,500 $193,200 $223,300
2018 $17,062 $416,500 $193,200 $223,300
2017 $27,263 $689,322 $193,200 $496,122
2016 $28,684 $714,872 $201,663 $513,209
2015 $28,421 $714,872 $201,663 $513,209
2014 $28,162 $714,872 $201,663 $513,209
2013 $29,508 $722,092 $203,700 $518,392
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1555502

MLS of Greater Cincinnati (CincyMLS)

APN: 629-0220-0047