NOT LISTED FOR SALE

Estimated Value: $646,217 - $818,000

3 Beds
3.5 Baths
3,790 Sq Ft
$191/Sq Ft Est. Value

Sale Details

Date Sold: September 29, 2023

Last sale price $625,000 $165 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $4,622 / mo

50 Days on Market

Highlights

  • Views of Trees
  • Fireplace in Primary Bedroom
  • Wooded Lot
  • Endeavor Elementary School Rated A
  • Deck
  • Vaulted Ceiling

About This Home

As of September 2023

Spectacular valley views from this Frank Lloyd Wright inspired home in the exclusive Treillage! Custom finished throughtout! This 3bd, 3.5 bath home boasts a two story water feature, bamboo flooring, custom blinds, gourmet kitchen, and amazing private wooded outdoor living. Exterior water feature and screened in porch. No maintenance- exterior landscaping and snow removal incl in HOA. Neighborhood Park and community spaces. Truly one of a kind home!

Last Agent to Sell the Property

Connie Bates

eXp Realty License #2017001300 Listed on: 07/06/2023

eXp Realty

Last Buyer's Agent

Apryll Fambro-Watkins

Keller Williams Advisors License #2011001260

Keller Williams Advisors

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,478

Year Built

  • Built in 2003

Lot Details

  • Cul-De-Sac
  • Wooded Lot
  • Property is in excellent condition

Parking

  • 2 Car Attached Garage
  • Side Facing Garage
  • Driveway
  • On-Street Parking

Property Views

  • Trees
  • Valley

Home Design

  • Modern Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stucco

Interior Spaces

  • 3,790 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Wood Frame Window
  • Casement Windows
  • Entryway
  • Great Room
  • Family Room
  • Living Room
  • Dining Room
  • Home Office
  • Library
  • Game Room
  • Laundry Room

Kitchen

  • Convection Oven
  • Gas Cooktop
  • Warming Drawer
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Disposal

Flooring

  • Wood
  • Carpet
  • Cork

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Fireplace in Primary Bedroom

Finished Basement

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

Outdoor Features

  • Balcony
  • Deck
  • Enclosed Patio or Porch
  • Exterior Lighting

Utilities

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

Community Details

  • Property has a Home Owners Association
  • Association fees include management, snow removal, maintenance unit, ground maintenance
  • Associa Association, Phone Number (888) 612-2299
  • Treillage Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,478

Year Built

Built in 2003

Lot Details

1,960 Sq Ft Lot

Parking

2

Listing Details

  • Cross Street: Hamilton Mason
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Zoning: Residential
  • Year Built: 2003
  • Above Grade Finished Sq Ft: 2964.0
  • Architecture: Modern
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: 747 West to Left on Once Upon a Time, Right on N. Observatory, Right on Primary Colors
  • GarageYN: Yes
  • ListOfficeEmail: oh.broker@exprealty.net
  • Lot Measurement: Square Feet
  • On Market Date: 2023-07-07
  • Ownership: Consumer
  • Property Subtype 1: Single Family Residence
  • RoadFrontageType: City Street
  • StructureType: Detached Home
  • Suburb (SIC): Treillage
  • ResoPropertyType: Residential
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: High Ceilings, Vaulted Ceilings
  • Property Type: Residential
  • Appliances: Disposal, Microwave, Dishwasher, Gas Cooktop, Wine Cooler, Refrigerator, Warming Drawer, Convection Oven, Gas Water Heater
  • Basement: Full, Finished, Walk Out Access, Wall To Wall Carpeting
  • Flooring: Cork, Wood, Carpet
  • Levels: Two
  • Total Bathrooms: 4
  • Fireplace: Gas, Master Bedroom
  • FireplaceYN: Yes
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 3790.0
  • Spa YN: No
  • Street Number Modifier: 4200
  • Windows: Wood Frames, Vinyl Windows, Casement Windows, Window Treatments

Exterior Features

  • View: Valley, Trees Woods
  • Roof: Shingle
  • Construction: Brick, Stucco
  • Outside Features: Balcony, Lighting
  • Foundation: Poured
  • Listing Price: 625000.0
  • Lot Features: Wooded, Cul De Sac
  • Patio And Porch Features: Deck, Patio, Porch, Enclosed
  • PropertyCondition: Excellent

Garage/Parking

  • Garage Spaces: 2.0
  • Parking: Attached, Driveway, On Street, Garage Faces Side

Utilities

  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Fee Frequency: Monthly
  • HOA Management Co: Associa
  • HOA Management Company: (888) 612-2299
  • HOA Yes/No: Yes
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Inc.In HOA/Condo Fee: Management, Snow Removal, Maintenance Unit, Maintenance Grounds

Schools

  • District: Lakota Local SD

Lot Info

  • Lot Dimensions: of record
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Verification: No

Tax Info

  • Tax Annual Amount: 7478.0

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 6, 2023
Closed on
Sep 29, 2023
Sold by
Bought by
Seller's Agent
Connie Bates
eXp Realty
Buyer's Agent
Apryll Fambro-Watkins
Keller Williams Advisors
List Price
$715,000
Sold Price
$625,000
Premium/Discount to List
-$90,000
-12.59%
Views
413
Current Estimated Value
$724,804

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$99,804
Avg. Annual Appreciation
5.43%

Purchase Details

Listed on
Nov 1, 2019
Closed on
Dec 9, 2019
Sold by
Bought by
Seller's Agent
Susanne Horner
Keller Williams Advisors
Buyer's Agent
Connie Bates
eXp Realty
List Price
$425,000
Sold Price
$425,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
10.68%
Original Mortgage
$365,000
Interest Rate
3.7%
Mortgage Type
Future Advance Clause Open End Mortgage

Purchase Details

Closed on
Jul 18, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 4, 2003
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$504,580
Interest Rate
4.75%
Mortgage Type
Purchase Money Mortgage
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$625,000 None Listed On Document
$425,000 None Available
$300,000 None Available
$630,732 --
-- First Title Agency Inc
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $612,000
Previous Owner $365,000
Previous Owner $504,580
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
09/29/2023 09/29/23 Sold $625,000 -7.4% $165 / Sq Ft
08/27/2023 08/27/23 Pending -- -- --
07/27/2023 07/27/23 Price Changed $675,000 -2.9% $178 / Sq Ft
07/14/2023 07/14/23 Price Changed $695,000 -2.8% $183 / Sq Ft
07/07/2023 07/07/23 For Sale $715,000 +68.2% $189 / Sq Ft
03/12/2020 03/12/20 Off Market $425,000 -- --
12/13/2019 12/13/19 Sold $425,000 0.0% $112 / Sq Ft View Prior Sale
11/02/2019 11/02/19 Pending -- -- --
11/01/2019 11/01/19 For Sale $425,000 -- $112 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $8,212 $210,660 $17,500 $193,160
2024 $8,212 $210,660 $17,500 $193,160
2023 $8,625 $209,080 $17,500 $191,580
2022 $7,651 $136,620 $17,500 $119,120
2021 $6,900 $130,940 $17,500 $113,440
2020 $7,064 $130,940 $17,500 $113,440
2019 $12,370 $129,080 $17,500 $111,580
2018 $7,491 $129,080 $17,500 $111,580
2017 $7,625 $129,080 $17,500 $111,580
2016 $7,635 $121,720 $17,500 $104,220
2015 $7,634 $121,720 $17,500 $104,220
2014 $44,196 $121,720 $17,500 $104,220
2013 $44,196 $139,310 $35,000 $104,310
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: 1776953

MLS of Greater Cincinnati (CincyMLS)

APN: M5620-051-000-056

Your Personal Tour Guide

Ask me questions while you tour the home.