NOT LISTED FOR SALE

Estimated Value: $111,000 - $174,000

5 Beds
6 Baths
-- Sq Ft
47.94 Acres

Last Sold February 23, 2022

Last sale price $1,750,000

Current estimated payment $969/month

87 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • 47.94 Acre Lot
  • Family Room with Fireplace
  • View of Trees or Woods
  • Deck
  • Cathedral Ceiling

About This Home

As of February 2022

Secluded gated oasis set back off the road on nearly 48 acres. Over 7000 finished sq ft custom log home with soaring ceilings, slate floors, & tremendous millwork. Entertaining is a delight inside and out with stone patio overlooking the two tiered pool & log pool house. Spacious 4 stall horse barn with dutch doors, cobblestone surround, workshop & heated tack room. Secured fenced pastures, additional barn with hay loft & stocked pond. Conveniently located just 1 mile from Bel-wood Country club.

Last Agent to Sell the Property

Gina Dubell-Smith

eXp Realty License #0000423340 Listed on: 10/27/2021

eXp Realty

Last Buyer's Agent

Kevin Hildebrand

eXp Realty License #0000409383

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $17,959

Year Built

  • Built in 1989

Lot Details

  • 47.94 Acre Lot
  • Wood Fence
  • Yard

Parking

  • 4 Car Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Log Cabin
  • Shingle Roof
  • Slate Roof
  • Log Siding

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Woodwork
  • Cathedral Ceiling
  • Skylights
  • Wood Burning Fireplace
  • Stone Fireplace
  • Insulated Windows
  • Double Hung Windows
  • Panel Doors
  • Family Room with Fireplace
  • 3 Fireplaces
  • Living Room with Fireplace
  • Formal Dining Room
  • Wood Flooring
  • Views of Woods
  • Unfinished Basement
  • Basement Fills Entire Space Under The House

Kitchen

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

Bedrooms and Bathrooms

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

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heat Pump System
  • Septic Tank

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$17,959

Year Built

Built in 1989

Lot Details

0

Parking

4

Listing Details

  • Suburb: Hamilton Twp.
  • Cross Street: Morrow Cozaddale
  • Buildings: Barn,Pool House,Stable
  • Land Description: 20 to 49 Acres
  • Access: County Road
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Ceiling Fan,Recessed Lights,Smoke Alarm
  • Census Tract Realist: 323.00
  • Cooling: Central Air
  • Heating: Electric, Forced Air, Heat Pump
  • Lot Area Realist: 426496.00
  • Property Ownership: Consumer
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Hamilton Twp.
  • Price Per Acre: 36503.96
  • Basement Features: Unfinished
  • Bathroom 4: Full
  • Bathroom 4 Level: 1
  • Level 1 Bathroom Type: Full,Partial
  • Level 1 Bathroom: Yes
  • Bedroom 5 Area: 132
  • Level 1 Bedroom: Yes
  • Entry Area: 266
  • Entry Dim: 19 x 14
  • Entry Foyer: Closet,Marble/Slate,Open Foyer,Transom/Sidelit
  • Family Room Feat: Bookcases,Fireplace,Walkout,Wet Bar,WW Carpet,Other
  • Living Great Rm Area: 484
  • Living Great Rm Dim: 22 x 22
  • Living Great Rm Len: 22
  • Living Great Rm Wid: 22
  • Living Room Feat: Fireplace,Other
  • Mechanical Systems: Garage Door Opener
  • Single Family Desc: Single Family
  • Study Lib Den: 16x14 Level: 1
  • Study Lib Den Area: 224
  • Study Lib Den Dim: 16 x 14
  • Study Lib Den Len: 16
  • Water Heating: Electric,Propane
  • Year Built: 1989
  • Architecture: Log
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Bedrooms: 5
  • Directions: 22/3 to Morrow Cozaddale, L on Ludlum, Property on Right
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2021-11-05
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • On Market: No
  • Third Party Approval Required: No
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Beam Ceiling, Cathedral Ceiling, French Doors, Multi Panel Doors, Natural Woodwork, Skylight, Vaulted Ceiling
  • Bedroom 2: 20x13 Level: 2
  • Bedroom 3: 17x14 Level: 2
  • Bedroom 4: 15x14 Level: 2
  • Bedroom 5: 12x11 Level: 1
  • Dining Room: 25x19 Level: 1
  • Family Room: 39x35 Level: 1
  • Living Room: 22x22 Level: 1
  • Recreation Room: 19x19 Level: 1
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Bathrooms Display: 6 (4 2)
  • Other Tax Parcel I D: 17-17-177-005-2
  • Reciprocal Listing: No
  • School Name1: Call SD 513-899-2264
  • Semi Annual Taxes: 8979.46
  • Kitchen: 26x23 Level: 1
  • Appliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer
  • Kitchen Features: Counter Bar,Eat-In,Gourmet,Island,Marble/Granite/Slate,Planning Desk,Walkout,Wood Cabinets
  • Bedroom 2 Area: 260
  • Basement: Full
  • Bedroom 3 Area: 238
  • Bedroom 4 Area: 210
  • Entry: 19x14 Level: 1
  • Bathrooms: 6.00
  • Kitchen Area: 598
  • Kitchen Dim: 26 x 23
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 2
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Diningroom Area: 475
  • Family Room Area: 1365
  • Laundry Room: 16x7 Level: 1
  • Laundry Room Area: 112
  • Laundryroom Dim: 16 x 7
  • Recreation Room Area: 361
  • Recreation Room Dim: 19 x 19
  • Fireplace: Stone, Wood
  • Fireplaces: 3
  • Available for Lease: No
  • Total Rooms: 12
  • Windows: Bay/Bow, Double Hung, Insulated
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 754
  • PrimaryBedroomDim: 29 x 26
  • PrimaryBedroomLen: 29
  • Primary Bathrooms: Double Vanity,Marb/Gran/Slate,Shower,Tile Floor,Tub
  • PrimaryBedFeat: Bath Adjoins,Fireplace,Vaulted Ceiling,Walk-in Closet,Wood Floor
  • P R I M A R Y B E D R O O M: 29x26 Level: 2

Exterior Features

  • View: Lake/Pond, Woods
  • Fencing: Wood
  • Roof: Shingle, Slate
  • Pool: In-Ground,Slide
  • Construction: Log
  • Outside Features: Deck, Patio, Porch, Wooded Lot, Yard Lights
  • Foundation: Poured
  • Listing Price: 2000000.00
  • Acres: 47.9400
  • New Construction: No
  • TopographyDetails: Lake/Pond,Pasture

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

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

Schools

  • District: Little Miami Local S

Lot Info

  • Lot Dimensions: Of Record
  • Lot Size Sq Ft: 2088266.00
  • Total Assessed Value: Of Record
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 27, 2021
Closed on
Feb 23, 2022
Sold by
Schulte Leah C and Schulte Richard J
Bought by
Brewster David L
Seller's Agent
Gina Dubell-Smith
eXp Realty
Buyer's Agent
Kevin Hildebrand
eXp Realty
Sold Price
$1,750,000
Current Estimated Value
$142,500

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,607,500
Avg. Annual Appreciation
-11.63%
Original Mortgage
$752,800
Outstanding Balance
$709,605
Interest Rate
3.92%
Mortgage Type
New Conventional
Estimated Equity
$432,895

Purchase Details

Listed on
Jan 22, 2020
Closed on
Sep 24, 2020
Sold by
Lukens H
Bought by
Schulte Leah C and Schulte S
Seller's Agent
Gina Dubell-Smith
eXp Realty
Buyer's Agent
Gina Dubell-Smith
eXp Realty
List Price
$1,999,950
Sold Price
$1,450,000
Premium/Discount to List
-$549,950
-27.5%

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 7, 1992
Sold by
Lukens Joseph T and Lukens K
Bought by
Lukens and Lukens Joseph T

Purchase Details

Closed on
Dec 6, 1989
Sold by
Henkle-Schueler Assoc.Inc
Bought by
Lukens Lukens and Lukens Joseph T
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
Brewster David L $1,750,000 None Listed On Document
Schulte Leah C -- --
Lukens -- --
Lukens Lukens -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Brewster David L $752,800
Previous Owner Schulte Leah C --
Previous Owner Lukens H Kimberly $1,369,000
Previous Owner Lukens Joseph $700,000
Previous Owner Lukens Joseph $500,000
Closed Brewster David L $647,200
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/23/2022 02/23/22 Sold $1,750,000 -12.5% --
01/23/2022 01/23/22 Pending -- -- --
11/05/2021 11/05/21 For Sale -- -- --
11/04/2021 11/04/21 For Sale -- -- --
11/01/2021 11/01/21 For Sale -- -- --
10/29/2021 10/29/21 For Sale -- -- --
10/28/2021 10/28/21 For Sale -- -- --
10/27/2021 10/27/21 For Sale $2,000,000 +37.9% --
12/07/2020 12/07/20 Off Market $1,450,000 -- --
09/08/2020 09/08/20 Sold $1,450,000 -14.5% --
06/29/2020 06/29/20 Pending -- -- --
04/14/2020 04/14/20 Price Changed $1,695,000 -15.2% --
01/22/2020 01/22/20 For Sale $1,999,950 -- --
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 $2,182 $43,180 $43,180 $419,374
2023 $5,848 $29,505 $29,505 $373,509
2022 $112 $29,505 $29,505 $0
2021 $107 $29,505 $29,505 $0
2020 $187 $0 $0 $0
2019 $190 $0 $0 $0
2018 $193 $0 $0 $0
2017 $283 $0 $0 $0
2016 $288 $0 $0 $0
2015 $271 $0 $0 $0
2014 $157 $0 $0 $0
2013 $154 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1719991

MLS of Greater Cincinnati (CincyMLS)

APN: 4816269