NOT LISTED FOR SALE

Estimated Value: $2,251,000 - $3,058,000

4 Beds
5 Baths
6,552 Sq Ft
$407/Sq Ft Est. Value

Last Sold May 31, 2023

Last sale price $2,495,000 $381 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $18,056/month

24 Days on Market

Highlights

  • Deck
  • Family Room with Fireplace
  • Wood Flooring
  • Ayer Elementary School Rated A
  • Ranch Style House
  • High Ceiling

About This Home

As of May 2023

Spectacular & pristine custom built home sited on over 2 verdant acres in exclusive Riverview Estates of Coldstream*Over 7600 SF of high-end one floor living w/exceptional craftsmanship at every turn*Impeccably appointed w/only the finest fit/finish*Soaring tray ceilings w/custom millwork*Thoughtfully designed open flrplan*1st fl primary ste w/lux BA + custom walk-in*Gourmet KIT open to fam rm*Great rm w/fab wet bar*Sprawling fin LL*Attached 3-car GAR*2 Trex decks*Luxury living at its finest.

Last Agent to Sell the Property

Bob Dorger

Comey & Shepherd License #2003012566 Listed on: 03/01/2023

Comey & Shepherd

Co-Listed By

Robbie Dorger

Comey & Shepherd License #2018001348

Last Buyer's Agent

Scott Oyler

Coldwell Banker Realty License #2003011808

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $53,086

Year Built

  • Built in 2016

Lot Details

  • 2.03 Acre Lot
  • Lot Dimensions are 170 x 519
  • Property fronts a private road
  • Aluminum or Metal Fence
  • Sprinkler System

HOA Fees

  • $83 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Side Facing Garage
  • Driveway

Home Design

  • Ranch Style House
  • Transitional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stone

Interior Spaces

  • 6,552 Sq Ft Home
  • Crown Molding
  • High Ceiling
  • Ceiling Fan
  • Marble Fireplace
  • Stone Fireplace
  • Gas Fireplace
  • Double Pane Windows
  • Insulated Windows
  • Window Treatments
  • Picture Window
  • Wood Frame Window
  • Casement Windows
  • Sliding Doors
  • Entryway
  • Family Room with Fireplace
  • 3 Fireplaces
  • Great Room with Fireplace
  • Dining Room
  • Den with Fireplace
  • Game Room
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Double Convection Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms

Partially Finished Basement

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

Home Security

  • Home Security System
  • Smart Thermostat

Eco-Friendly Details

  • Air Purifier

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Exterior Lighting

Utilities

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

Community Details

  • Riverview Estates At Coldstream Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$53,086

Year Built

Built in 2016

Lot Details

0

HOA Fees

$83 per month

Parking

3

Listing Details

  • Cooling: Central Air, Ceiling Fans
  • Heating: Zoned, Forced Air, Natural Gas
  • Year Built: 2016
  • Above Grade Finished Sq Ft: 4822.0
  • Architecture: Ranch, Transitional
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Bedrooms: 4
  • Directions: Beechmont to Asbury to Ayers; home is on private drive.
  • GarageYN: Yes
  • ListOfficeEmail: mariemontadmin@comey.com
  • Lot Measurement: Square Feet
  • Showing Start Date: 2023-03-01
  • Ownership: Consumer
  • Property Subtype 1: Single Family Residence
  • RoadFrontageType: Private Road
  • StructureType: Detached Home
  • Suburb (SIC): Riverview Estates at Coldstream
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Crown Molding, High Ceilings, Eat In Kitchen, Granite Counters, Smart Thermostat
  • Property Type: Residential
  • Appliances: Other, Disposal, Microwave, Dishwasher, Double Oven, Gas Cooktop, Wine Cooler, Refrigerator, Convection Oven, Gas Water Heater
  • Basement: Full, Concrete, Walk Out Access, Partially Finished, Wall To Wall Carpeting
  • Flooring: Wood, Carpet
  • Levels: One
  • Total Bathrooms: 5
  • Door Features: Sliding Doors
  • Fireplace: Den, Gas, Stone, Marble, Basement, Great Room, Family Room
  • FireplaceYN: Yes
  • Fireplaces: 3
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 6552.0
  • Lot Size Area: 88222.0
  • Other Equipment: Air Purifier
  • Street Number Modifier: 7886
  • Windows: Wood Frames, Picture Windows, Casement Windows, Insulated Windows, Window Treatments, Double Pane Windows

Exterior Features

  • Fencing: Metal
  • Roof: Shingle
  • Construction: Brick, Stone
  • Outside Features: Lighting
  • Foundation: Poured
  • Listing Price: 2595000.0
  • Lot Features: Sprinklers
  • Acres: 2.0253
  • New Construction: No
  • Patio And Porch Features: Deck, Covered

Garage/Parking

  • Garage Spaces: 3.0
  • Parking: Attached, Driveway, Oversized, Heated Garage, Garage Faces Side

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • SecurityFeatures: Security System

Condo/Co-op/Association

  • HOA Fees: 1000.0
  • Fee Frequency: Annually
  • HOA Yes/No: Yes
  • ResoAssociationFeeFrequency: Annually

Schools

  • District: Forest Hills Local S

Lot Info

  • Lot Dimensions: 170 x 519
  • Lot Size Sq Ft: 88222.0
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Verification: No

Tax Info

  • Tax Annual Amount: 53086.0

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 21, 2016
Sold by
Kitzmiller David A Tr
Bought by
Squeri Barbara A Tr
Current Estimated Value
$2,664,954

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 3, 2015
Sold by
Family Builders Inc
Bought by
Kitzmiller David A and Hampton Lane Irrevocable Trust

Purchase Details

Closed on
Dec 17, 2014
Sold by
Riverview Estates Development Ltd
Bought by
Family Builders Inc
Source: Public Records
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
Squeri Barbara A Tr $320,000 --
Kitzmiller David A $300,000 None Available
Family Builders Inc $1,711,000 Attorney
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed Squeri Barbara A Tr --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/31/2023 05/31/23 Sold $2,495,000 -3.9% $381 / Sq Ft
03/26/2023 03/26/23 Pending -- -- --
03/01/2023 03/01/23 For Sale $2,595,000 -- $396 / 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 $48,454 $797,468 $138,509 $658,959
2023 $47,401 $797,468 $138,509 $658,959
2022 $53,108 $794,973 $125,335 $669,638
2021 $52,545 $791,000 $125,335 $665,665
2020 $51,955 $791,000 $125,335 $665,665
2019 $50,859 $700,000 $110,915 $589,085
2018 $47,682 $700,000 $110,915 $589,085
2017 $45,563 $700,000 $110,915 $589,085
2016 $7,405 $110,019 $110,019 $0
2015 $1,183 $110,019 $110,019 $0
2014 $1,181 $215,103 $215,103 $0
2013 $1,129 $210,886 $210,886 $0
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: 1765294

MLS of Greater Cincinnati (CincyMLS)

APN: 500-0182-0008