NOT LISTED FOR SALE

8625 Hopewell Rd Cincinnati, OH 45242

Estimated Value: $1,752,000 - $3,129,000

5 Beds
6 Baths
6,085 Sq Ft
$433/Sq Ft Est. Value

Last Sold August 10, 2022

Last sale price $2,399,900 $394 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $16,641/month

3 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • Sitting Area In Primary Bedroom
  • 3.82 Acre Lot
  • Indian Hill Primary School Rated A-
  • View of Trees or Woods
  • Dining Room with Fireplace

About This Home

As of August 2022

World Class French inspired chateau'esque beauty!One of a kind!Perfect blend of historic elegance w/modern comforts!Elaborate craftsmanship thru-out/Clive Christian baths & closets!1st floor study millwork by Whitehouse artesian!Private exqusite grounds(pillars stay)!Antique English Pub Bar+built ins w/icemaker!Gourmet chef's kitchen w/Viking pro series & Sub Zero!Organic garden area!Gunite heated saline pool!3 blue stone patios!2 laundry rooms!Gated entry!LL Laundry: 16x10.LL exercise rm:16x13!

Last Agent to Sell the Property

Julia Packer Wesselkamper

Coldwell Banker Realty License #0000339877 Listed on: 06/20/2022

Coldwell Banker Realty

Last Buyer's Agent

Michelle Hudepohl

Coldwell Banker Realty License #2006000198

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,800

Year Built

  • Built in 1951

Lot Details

  • 3.82 Acre Lot
  • Wooded Lot

Parking

  • 4 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Poured Concrete
  • Shingle Roof
  • Slate Roof

Interior Spaces

  • 6,085 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Cathedral Ceiling
  • Skylights
  • Chandelier
  • Wood Burning Fireplace
  • Marble Fireplace
  • Gas Fireplace
  • Awning
  • Tinted Windows
  • Window Treatments
  • Picture Window
  • Wood Frame Window
  • Casement Windows
  • Double Door Entry
  • French Doors
  • Panel Doors
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • 5 Fireplaces
  • Formal Dining Room
  • Views of Woods

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Oven or Range
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Concrete

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Sitting Area In Primary Bedroom
  • Walk-In Closet
  • Dressing Area

Partially Finished Basement

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

Eco-Friendly Details

  • Smart Irrigation

Outdoor Features

  • Patio
  • Outdoor Fireplace
  • Outdoor Kitchen
  • Fire Pit
  • Exterior Lighting
  • Outdoor Grill
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Septic Tank

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,800

Year Built

Built in 1951

Lot Details

3.82 Acres

Parking

4

Listing Details

  • Suburb: Indian Hill
  • Cross Street: Montgomery
  • Buildings: Pool House,Shed,Other
  • Land Description: 1 to 4.9 Acres
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Cable,Ceiling Fan,Fountain,Laundry Chute,Recessed Lights,Smoke Alarm,Tech Wiring
  • Census Tract Realist: 244.02
  • Cooling: Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 166573.00
  • Property Ownership: Consumer
  • Suburb S I C: Indian Hill
  • Price Per Acre: 627588.91
  • Basement Features: Concrete Floor,Part Finished,Walkout,Other
  • Bathroom 4: Full
  • Bathroom 4 Level: 2
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Chandelier,Fireplace,French Doors,Walkout,Wood Floor,Other
  • Entry Dim: 21 x 14
  • Entry Foyer: Closet,Double Doors,Marble/Slate,Open Foyer,Other
  • Family Room Feat: Bookcases,Fireplace,Walkout,Wood Floor
  • Living Great Rm Dim: 22 x 19
  • Living Room Feat: Bookcases,Fireplace,Walkout,Wood Floor,Other
  • Mechanical Systems: Garage Door Opener,Security System
  • Single Family Desc: Single Family
  • Smart Technology: Irrigation System
  • Study Lib Den: 15x14 Level: 1
  • Study Lib Den Dim: 15 x 14
  • Water Heating: Gas,Tankless
  • Year Built: 1951
  • Architecture: Traditional, Other
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Bedrooms: 5
  • Directions: Montgomery to Hopewell, house on right just past Peterloon. Gated driveway.
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2022-06-20
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • On Market: No
  • Third Party Approval Required: No
  • Second Floor Area: 2804
  • 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, Natural Woodwork, Skylight, Vaulted Ceiling, Other
  • Bedroom 2: 20x15 Level: 2
  • Bedroom 3: 21x11 Level: 2
  • Bedroom 4: 15x13 Level: 2
  • Bedroom 5: 15x14 Level: 2
  • Breakfast Room: 20x15 Level: 1
  • Dining Room: 20x19 Level: 1
  • Family Room: 22x18 Level: 1
  • Living Room: 22x19 Level: 1
  • Recreation Room: 25x14 Level: 1
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Bathrooms Display: 6 (4 2)
  • Reciprocal Listing: No
  • School Name1: Call SD 513-272-4500
  • Semi Annual Taxes: 8900.16
  • Kitchen: 18x15 Level: 1
  • Appliances: Dishwasher, Garbage Disposal, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Other
  • Kitchen Features: Counter Bar,Eat-In,Gourmet,Island,Marble/Granite/Slate,Pantry,Planning Desk,Walkout,Wood Cabinets,Wood Floor,Other
  • Basement: Full
  • Study Features: Bookcases,Panel Walls,Walkout,Wood Floor
  • Entry: 21x14 Level: 1
  • Bathrooms: 6.00
  • Kitchen Dim: 18 x 15
  • 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: 12x11 Level: 1
  • Laundryroom Dim: 12 x 11
  • Recreation Room Dim: 25 x 14
  • Fireplace: Gas, Marble, Wood
  • Fireplaces: 5
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 6085.00
  • Windows: Awning, Casement, Picture, Tinted, Wood, Other
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 35 x 15
  • Primary Bathrooms: Double Vanity,Marb/Gran/Slate,Shower,Tile Floor,Tub,Other
  • PrimaryBedFeat: Bath Adjoins,Dressing Area,Sitting Room,Walk-in Closet,Window Treatment,WW Carpet,Other
  • P R I M A R Y B E D R O O M: 35x15 Level: 2

Exterior Features

  • View: Woods, Other
  • Fencing: Other
  • Roof: Shingle, Slate
  • Pool: Automated Cover,Cleaner,Gunite,Heated,In-Ground,Salt Water
  • Construction: Brick
  • Outside Features: BBQ Grill, Fire Pit, Fireplace, Kitchen – Outdoor, Patio, Porch, Sprinklers, Wooded Lot, Yard Lights, Other
  • Foundation: Block, Poured
  • Listing Price: 2499900.00
  • Acres: 3.8240
  • New Construction: No

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

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

Schools

  • District: Indian Hill Ex Vill

Green Features

  • Energy Green Features: No

Lot Info

  • Lot Dimensions: irreg
  • Lot Size Sq Ft: 166573.00
  • Total Assessed Value: of rec
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 10, 2023
Sold by
Swormstedt Tedd and Swormstedt Pamela
Bought by
Swormstedt-Kalkhoff Family Revocable Trust and Swormstedt
Current Estimated Value
$2,635,078

Purchase Details

Listed on
Jun 20, 2022
Closed on
Aug 20, 2022
Sold by
Lindner Vanessa Falk
Bought by
Tedd Swormstedt and Kalkhoff Pamela
Seller's Agent
Julia Packer Wesselkamper
Coldwell Banker Realty
Buyer's Agent
Michelle Hudepohl
Coldwell Banker Realty
List Price
$2,499,900
Sold Price
$2,399,900
Premium/Discount to List
-$100,000
-4%
Views
1

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.61%
Interest Rate
5.13%

Purchase Details

Listed on
Jun 20, 2022
Closed on
Jul 29, 2022
Sold by
Falk Lindner Vanessa
Bought by
Swormstedt Tedd and Kalkhoff Pamela
Seller's Agent
Julia Packer Wesselkamper
Coldwell Banker Realty
Buyer's Agent
Michelle Hudepohl
Coldwell Banker Realty
List Price
$2,499,900
Sold Price
$2,399,900
Premium/Discount to List
-$100,000
-4%
Views
1

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Interest Rate
5.13%

Purchase Details

Closed on
Jun 1, 2022
Sold by
Carl H Lindner Iv Special Residence Trus
Bought by
Lindner Venessa Fald and Lindner Carl H

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,919,920
Interest Rate
3.88%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 13, 2021
Sold by
Blue Marlin Llc
Bought by
Lindner Carl H and Carl H Lindner Iv Special Resi

Purchase Details

Listed on
Jan 21, 2016
Closed on
Jul 20, 2016
Sold by
Kirkland Macy
Bought by
Blue Marlin Llc
Seller's Agent
Julia Packer Wesselkamper
Coldwell Banker Realty
Buyer's Agent
Doris Swayne
Huff Realty
List Price
$2,750,000
Sold Price
$1,925,000
Premium/Discount to List
-$825,000
-30%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.30%

Purchase Details

Closed on
Mar 25, 2010
Sold by
Espy Thomas P
Bought by
Kirkland Mary

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 14, 2006
Sold by
Espy Thomas
Bought by
Espy Thomas P and Thomas P Espy Revocable Trust

Purchase Details

Closed on
Nov 10, 2005
Sold by
Fingerman David M
Bought by
Espy Thomas

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 14, 2003
Sold by
Tierney James P and Tierney Selena M
Bought by
Muth C Christopher and The Glade Revocable Trust

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$115,000
Interest Rate
6.07%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jul 22, 2002
Sold by
Casper Bradley A and Casper Kay M
Bought by
Cendant Mobility Financial Corp

Purchase Details

Closed on
Jul 30, 1998
Sold by
Comisar Kathleen G
Bought by
Casper Bradley A and Casper Kay M

Purchase Details

Closed on
May 29, 1998
Sold by
Macfarlane Charles E and Macfarlane Jean M
Bought by
Comisar Kathleen G

Purchase Details

Closed on
May 30, 1997
Sold by
Donenfeld Jack
Bought by
Macfarlane Ii Charles E and Macfarlane Jean M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$462,000
Interest Rate
8.17%
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
Swormstedt-Kalkhoff Family Revocable Trust $250 None Listed On Document
Tedd Swormstedt $2,399,900 --
Swormstedt Tedd -- --
Swormstedt Tedd -- None Listed On Document
Lindner Venessa Fald -- None Listed On Document
Lindner Carl H -- None Available
Blue Marlin Llc $1,925,000 --
Kirkland Mary $1,500,000 Attorney
Espy Thomas P -- None Available
Espy Thomas -- The Guarantee Title & Trust
Fingerman David M -- The Guarantee Title & Trust
Muth C Christopher -- --
Tierney James P -- --
Muth C Christopher -- --
Graf Andrew $1,300,000 --
Cendant Mobility Financial Corp $1,575,000 --
Casper Bradley A -- --
Comisar Kathleen G $747,000 --
Macfarlane Ii Charles E -- --
Donenfeld Jack $700,000 --
Hinkle Sharan -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Tedd Swormstedt --
Previous Owner Swormstedt Tedd $1,919,920
Previous Owner Kirkland Mary $1,000,000
Previous Owner Espy Thomas $1,332,800
Previous Owner Graf Andrew $115,000
Previous Owner Tierney James P $975,000
Previous Owner Macfarlane Ii Charles E $462,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/10/2022 08/10/22 Sold $2,399,900 -4.0% $394 / Sq Ft
06/24/2022 06/24/22 Pending -- -- --
06/20/2022 06/20/22 For Sale $2,499,900 +29.9% $411 / Sq Ft
10/24/2016 10/24/16 Off Market $1,925,000 -- --
07/22/2016 07/22/16 Sold $1,925,000 -14.4% $316 / Sq Ft View Prior Sale
07/02/2016 07/02/16 Pending -- -- --
04/07/2016 04/07/16 Price Changed $2,249,000 -9.7% $370 / Sq Ft
04/06/2016 04/06/16 Price Changed $2,490,000 -6.0% $409 / Sq Ft
02/25/2016 02/25/16 Price Changed $2,649,000 -3.7% $435 / Sq Ft
01/21/2016 01/21/16 For Sale $2,750,000 -- $452 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

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
2025 $30,733 $839,966 $291,631 $548,335
2024 $30,058 $839,966 $291,631 $548,335
2023 $30,097 $839,966 $291,631 $548,335
2022 $17,499 $400,743 $218,722 $182,021
2021 $17,800 $400,743 $218,722 $182,021
2020 $15,305 $400,743 $218,722 $182,021
2019 $16,394 $400,743 $218,722 $182,021
2018 $16,416 $400,743 $218,722 $182,021
2017 $15,849 $400,743 $218,722 $182,021
2016 $19,794 $519,751 $228,358 $291,393
2015 $19,849 $519,751 $228,358 $291,393
2014 $19,697 $519,751 $228,358 $291,393
2013 $20,640 $525,000 $230,664 $294,336
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: 1743121

MLS of Greater Cincinnati (CincyMLS)

APN: 629-0300-0016

Your Personal Tour Guide

Ask me questions while you tour the home.