NOT LISTED FOR SALE

Estimated Value: $771,000 - $834,000

3 Beds
4 Baths
2,252 Sq Ft
$353/Sq Ft Est. Value

Last Sold July 17, 2024

Last sale price $770,000 $342 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $4,341/month

5 Days on Market

Highlights

  • Spa
  • Gourmet Kitchen
  • Vaulted Ceiling
  • Walnut Hills High School Rated A+
  • Great Room with Fireplace
  • Transitional Architecture

About This Home

As of July 2024

Beautiful custom built (2017) Andrew James home in Columbia Tusculum. Neutral decor featuring hw flrs & open flr plan. Gourmet kit has a lrg island w/seating, SS appliances, Bosch fridge, Bertazzoni gas range w/conv. oven & granite. DR adjoins the kit. FP anchors Great Rm & walks out to 3 season rm. Patio off of sunroom. Go up steps to a yard to enjoy firepit. 3 bedrooms, 2 full BA's & laundry are located upstairs. Finished LL w/powder & rec rm. Walk to shopping & restaurants. LEED Gold certified through 2032. Pella windows & doors. Telsa wall connector in garage. Updated kit faucet. New cordless blinds in nursery. Added sensors to security system. New ozonator in hot tub to reduce maintenance.

Last Agent to Sell the Property

Sarah Goldman

Sibcy Cline, Inc. License #0000439686 Listed on: 06/07/2024

Sibcy Cline, Inc.

Last Buyer's Agent

Meg Casper

Kopf Hunter Haas License #0000398640

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2017

Lot Details

  • 4,051 Sq Ft Lot
  • Lot Dimensions are 25 x 150

Parking

  • 2 Car Attached Garage
  • On-Street Parking

Home Design

  • Transitional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 2,252 Sq Ft Home
  • 2-Story Property
  • Crown Molding
  • Vaulted Ceiling
  • Ceiling Fan
  • Chandelier
  • Gas Fireplace
  • Double Pane Windows
  • Insulated Windows
  • Panel Doors
  • Great Room with Fireplace
  • 2 Fireplaces
  • Formal Dining Room
  • Sun or Florida Room
  • Wood Flooring

Kitchen

  • Gourmet Kitchen
  • Breakfast Bar
  • Double Convection Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Finished Basement

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

Outdoor Features

  • Spa
  • Patio
  • Porch

Utilities

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

Community Details

  • No Home Owners Association
  • Cottage Hill Sub Bl Subdivision

Listing and Financial Details

  • $2 Total Annual Tax

Home Details

Home Type

Single Family

Year Built

Built in 2017

Lot Details

4,051 Sq Ft Lot

Parking

2

Listing Details

  • Suburb: Columbia/Tusculum
  • Land Description: Less than .5 Acre
  • Access: City Street
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt,Ceiling Fan,Smoke Alarm
  • Census Tract Realist: 47.03
  • Cooling: Ceiling Fans, Central Air
  • Heating: Forced Air, Gas
  • Lot Area Realist: 4051.00
  • Suburb S I C: Columbia/Tusculum
  • Price Per Acre: 8279569.89
  • Basement Features: Finished,Walkout,WW Carpet
  • Bathroom 4: Partial
  • Bathroom 4 Level: 2
  • Level 1 Bathroom Type: Partial
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: No
  • Dining Room Feat: Chandelier,Wood Floor
  • Entry Foyer: Wood Floor
  • Great Room Feat: Fireplace,Wood Floor
  • Living Great Rm Dim: 0 x 0
  • Mechanical Systems: Garage Door Opener,Security System
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Gas
  • Year Built: 2017
  • Architecture: Transitional
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Bedrooms: 3
  • Directions: Columbia Parkway to North on Hoge.
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2024-06-06
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Cottage Hill Sub Bl
  • Occupancy: Negotiable
  • Second Floor Area: 1032
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Crown Molding, Multi Panel Doors, Vaulted Ceiling
  • Bedroom 2: 11x11 Level: 2
  • Bedroom 3: 10x12 Level: 2
  • Dining Room: 12x13 Level: 1
  • Recreation Room: 16x17 Level: Lower
  • Formal Dining Room: Yes
  • Flex Rooms: 3 Season
  • Property Type: Residential
  • Reciprocal Listing: No
  • Semi Annual Taxes: $1,477.86
  • Kitchen: 14x23 Level: 1
  • Appliances: Convection Oven, Dishwasher, Double Oven, Garbage Disposal, Gas Cooktop, Microwave, Refrigerator
  • Kitchen Features: Counter Bar,Gourmet,Island,Marble/Granite/Slate,Wood Cabinets,Wood Floor
  • Basement: Full
  • Entry: 7x17 Level: 1
  • Bathrooms: 4.00
  • Great Room: 16x19 Level: 1
  • Kitchen Dim: 14 x 23
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 2
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Laundry Room: 7x8 Level: 2
  • Laundryroom Dim: 7 x 8
  • Recreation Room Dim: 16 x 17
  • Fireplace: Ceramic, Gas
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2252.00
  • Windows: Double Pane, Insulated
  • PrimaryBedroomDim: 14 x 17
  • Primary Bathrooms: Built-In Shower Seat,Double Vanity,Marb/Gran/Slate,Shower,Tile Floor
  • PrimaryBedFeat: Bath Adjoins,Walk-in Closet,WW Carpet
  • P R I M A R Y B E D R O O M: 14x17 Level: 2

Exterior Features

  • Roof: Shingle
  • Construction: Fiber Cement, Brick
  • Outside Features: Hot Tub, Patio, Porch
  • Foundation: Poured
  • Listing Price: 775000.00
  • Acres: 0.0930
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Garage Attached
  • Parking: On Street

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: Cincinnati City SD

Lot Info

  • Lot Dimensions: 25 x 150
  • Lot Size Sq Ft: 4051.00
  • Total Assessed Value: of record
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: Yes

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 7, 2024
Closed on
Jul 12, 2024
Sold by
Schneider Jason and Carron Hannah
Bought by
Hudson Anthony and Sartarelli Sara Elisabeth
Seller's Agent
Sarah Goldman
Sibcy Cline, Inc.
Buyer's Agent
Meg Casper
Kopf Hunter Haas
List Price
$775,000
Sold Price
$770,000
Premium/Discount to List
-$5,000
-0.65%
Views
68
Current Estimated Value
$794,378

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$24,378
Avg. Annual Appreciation
1.98%
Original Mortgage
$616,000
Outstanding Balance
$608,586
Interest Rate
6.95%
Mortgage Type
New Conventional
Estimated Equity
$185,792

Purchase Details

Listed on
Mar 4, 2021
Closed on
May 6, 2021
Sold by
Spieser John W and Spieser Ayn E
Bought by
Schneider Jason and Carron Hannah
Seller's Agent
Emily Godin
Coldwell Banker Realty, Anders
Buyer's Agent
Sarah Goldman
Sibcy Cline, Inc.
List Price
$689,000
Sold Price
$698,000
Premium/Discount to List
$9,000
1.31%

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.12%
Original Mortgage
$680,000
Interest Rate
2.37%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 6, 2016
Sold by
Andrew James Custom Builders
Bought by
John W Spieser and Ayn E Spieser

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 15, 2016
Sold by
Hoge Properties Llc
Bought by
Andrew James Custom Builders

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 29, 2014
Sold by
Lake Paul H and Lake Sharon L
Bought by
Hoge Properties Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$360,000
Interest Rate
4.33%
Mortgage Type
Unknown
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
Hudson Anthony $770,000 None Listed On Document
Schneider Jason $698,000 Lawyers Title
John W Spieser $117,597 --
Andrew James Custom Builders $222,000 --
Hoge Properties Llc -- Attorney
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hudson Anthony $616,000
Previous Owner Schneider Jason $680,000
Previous Owner Andrew James Custom Builders --
Previous Owner Andrew James Custom Builders --
Previous Owner Hoge Properties Llc $360,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/17/2024 07/17/24 Sold $770,000 -0.6% $342 / Sq Ft
06/13/2024 06/13/24 Pending -- -- --
06/07/2024 06/07/24 For Sale $775,000 +11.0% $344 / Sq Ft
05/06/2021 05/06/21 Sold $698,000 +1.3% $310 / Sq Ft View Prior Sale
03/06/2021 03/06/21 Pending -- -- --
03/05/2021 03/05/21 For Sale $689,000 +25.3% $306 / Sq Ft
08/09/2017 08/09/17 Off Market $550,000 -- --
05/08/2017 05/08/17 Sold $550,000 0.0% $452 / Sq Ft View Prior Sale
07/20/2016 07/20/16 Pending -- -- --
03/14/2016 03/14/16 For Sale $550,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 $2,989 $244,301 $48,521 $195,780
2024 $2,899 $244,301 $48,521 $195,780
2023 $2,964 $244,301 $48,521 $195,780
2022 $1,553 $219,451 $19,751 $199,700
2021 $1,580 $219,451 $19,751 $199,700
2020 $1,584 $219,451 $19,751 $199,700
2019 $1,326 $192,500 $17,325 $175,175
2018 $1,327 $17,325 $17,325 $0
2017 $1,278 $17,325 $17,325 $0
2016 $2,105 $36,800 $17,168 $19,632
2015 $2,482 $36,800 $17,168 $19,632
2014 $2,495 $36,800 $17,168 $19,632
2013 $2,329 $33,761 $15,750 $18,011
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: 1807742

MLS of Greater Cincinnati (CincyMLS)

APN: 028-0005-0090

Your Personal Tour Guide

Ask me questions while you tour the home.