NOT LISTED FOR SALE

Estimated Value: $874,000 - $1,181,000

5 Beds
3.5 Baths
4,092 Sq Ft
$267/Sq Ft Est. Value

Last Sold September 26, 2014

Last sale price $600,000 $147 Per Sq Ft

Est. 82% increase in value since last sale

Current estimated payment $7,048/month

9 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • 5 Acre Lot
  • Vaulted Ceiling
  • View of Trees or Woods
  • Deck
  • Ranch Style House

About This Home

As of September 2014

Gorgeous Custom Home sitting on 5 acres in rural Loveland. Loaded with custom features, multiple walkouts, finished basement w/ wet bar. Separate building with sep HVAC & Garage for Guest Quarters or private office space.

Last Agent to Sell the Property

Eric Zwarg

Keller Williams Advisors License #2011001762 Listed on: 07/17/2014

Keller Williams Advisors

Last Buyer's Agent

Beverly Corsmeier

Coldwell Banker Realty License #2003017955

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,154

Year Built

  • Built in 2003

Lot Details

  • 5 Acre Lot
  • Level Lot
  • Partially Wooded Lot

Parking

  • 4 Car Garage
  • Driveway

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 4,092 Sq Ft Home
  • Wet Bar
  • Crown Molding
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • Stone Fireplace
  • Insulated Windows
  • Double Hung Windows
  • Sliding Windows
  • Panel Doors
  • Family Room
  • Living Room with Fireplace
  • Views of Woods

Kitchen

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

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet

Finished Basement

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

Outdoor Features

  • Deck
  • Patio

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

$11,154

Year Built

Built in 2003

Lot Details

0

Parking

4

Listing Details

  • Suburb: Hamilton Twp.
  • Cross Street: State Route 48
  • Trees: Wooded-Partial
  • Degree Complete: Completed
  • Buildings: Guest House
  • Land Description: 5 to 9.9 Acres
  • Access: County Road
  • Broker Approved: Yes
  • Miscellaneous: Ceiling Fan,Recessed Lights,Smoke Alarm,Home Warranty
  • Basement Sq Ft: 1364
  • Census Tract Realist: 322.02
  • Cooling: Central Air
  • Heating: Gas, Forced Air
  • Lot Area Realist: 217669.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Hamilton Twp.
  • Price Per Acre: 120000.00
  • Basement Features: Finished,Walkout,WW Carpet,Other
  • Bathroom 4: Full
  • Bathroom 4 Level: Lower
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Bedroom 5 Area: 195
  • Level 1 Bedroom: Yes
  • Dining Room Feat: Chandelier,Walkout,French Doors
  • Entry Area: 221
  • Entry Foyer: Wood Floor,Open Foyer,Other
  • Family Room Feat: WW Carpet,Walkout,Wet Bar
  • Living Great Rm Area: 300
  • Living Great Rm Dim: 15 x 20
  • Living Great Rm Len: 15
  • Living Great Rm Wid: 20
  • Living Room Feat: WW Carpet,Fireplace,Great Room
  • Mechanical Systems: Air Cleaner,Garage Door Opener,Humidifier,Sump Pump w/oBattery
  • Single Family Desc: Single Family
  • Study Lib Den: 13x14 Level: 1
  • Study Lib Den Area: 182
  • Study Lib Den Dim: 13 x 14
  • Study Lib Den Len: 13
  • Year Built: 2003
  • School 1 Type: District Phone
  • Architecture: Ranch
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bedrooms: 5
  • Directions: North on State Route 48 out of Loveland. Right on Harrison.
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2014-07-17
  • Property Subtype 1: Single Family Residence
  • Occupancy: At Closing
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Multi Panel Doors, Crown Molding, Vaulted Ceiling, French Doors
  • Bedroom 2: 13x12 Level: 1
  • Bedroom 3: 13x11 Level: 1
  • Bedroom 4: 10x15 Level: Lower
  • Bedroom 5: 13x15 Level: Lower
  • Dining Room: 12x14 Level: 1
  • Family Room: 16x38 Level: Lower
  • Living Room: 15x20 Level: 1
  • Recreation Room: 13x19 Level: Lower
  • Formal Dining Room: No
  • Flex Rooms: Media,Bonus Room
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-899-2264
  • Semi Annual Taxes: 5577
  • Kitchen: 13x17 Level: 1
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Refrigerator, Microwave
  • Kitchen Features: Tile Floor,Eat-In,Gourmet,Wood Cabinets,Pantry,Counter Bar,Solid Surface Ctr,Other
  • Bedroom 2 Area: 156
  • Basement: Full
  • Bedroom 3 Area: 143
  • Study Features: WW Carpet
  • Bedroom 4 Area: 150
  • Entry: 13x17 Level: 1
  • Bathrooms: 4.00
  • Kitchen Area: 221
  • Kitchen Dim: 13 x 17
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Bathroom 3: Partial
  • Bathroom 3 Level: 1
  • Diningroom Area: 168
  • Family Room Area: 608
  • Laundry Room: 11x8 Level: 1
  • Laundry Room Area: 88
  • Laundryroom Dim: 11 x 8
  • Recreation Room Area: 247
  • Recreation Room Dim: 13 x 19
  • Fireplace: Wood, Stone
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 4092.00
  • Total Rooms: 12
  • Windows: Insulated, Wood, Double Hung, Slider
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 280
  • PrimaryBedroomDim: 14 x 20
  • PrimaryBedroomLen: 14
  • Primary Bathrooms: Double Vanity,Shower,Tile Floor,Tub,Jetted Tub
  • PrimaryBedFeat: WW Carpet,Bath Adjoins,Walk-in Closet,Walkout,Vaulted Ceiling
  • P R I M A R Y B E D R O O M: 14x20 Level: 1

Exterior Features

  • View: Woods
  • Roof: Shingle
  • Construction: Brick, Stone
  • Outside Features: Patio, Deck
  • Foundation: Poured
  • Listing Price: 669000.00
  • Acres: 5.0000
  • New Construction: No
  • TopographyDetails: Level

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

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

Schools

  • District: Little Miami Local S

Lot Info

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 17, 2014
Closed on
Sep 26, 2014
Sold by
Collins Steven D and Collins Christina M
Bought by
Mazzaro Brett A and Mazzaro Erin M
Seller's Agent
Eric Zwarg
Keller Williams Advisors
Buyer's Agent
Beverly Corsmeier
Coldwell Banker Realty
List Price
$669,000
Sold Price
$600,000
Premium/Discount to List
-$69,000
-10.31%
Current Estimated Value
$1,093,001

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$493,001
Avg. Annual Appreciation
5.64%
Original Mortgage
$540,000
Interest Rate
4.12%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Dec 15, 2003
Sold by
Harvest Homes Inc
Bought by
Collins Steven D and Collins Christina M

Home Financials for this Owner

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

Purchase Details

Closed on
May 8, 2003
Sold by
Collins Steven D and Collins Christina
Bought by
Harvest Homes Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$381,600
Interest Rate
5.87%
Mortgage Type
Construction

Purchase Details

Closed on
Oct 22, 2002
Sold by
Chatsworth Est Llc
Bought by
Collins Steven D and Collins Christina

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$62,800
Interest Rate
6.24%
Mortgage Type
New Conventional
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
Mazzaro Brett A $600,000 American Homeland Title
Collins Steven D -- American Homeland Title
Collins Steven D $591,933 Superior Title Agency Inc
Harvest Homes Inc -- Tri Star Title
Collins Steven D $78,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mazzaro Brett A $284,000
Closed Mazzaro Erin M $275,000
Closed Mazzaro Brett A $417,000
Closed Mazzaro Brett A $65,000
Closed Mazzaro Brett A $540,000
Closed Collins Steven D $416,000
Closed Collins Steven D $150,000
Closed Collins Steven D $19,000
Closed Collins Steven D $42,500
Closed Collins Steven D $525,000
Closed Collins Steven D $333,700
Previous Owner Harvest Homes Inc $381,600
Previous Owner Collins Steven D $62,800
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/26/2014 12/26/14 Off Market $600,000 -- --
09/26/2014 09/26/14 Sold $600,000 -10.3% $147 / Sq Ft
07/26/2014 07/26/14 Pending -- -- --
07/17/2014 07/17/14 For Sale $669,000 -- $163 / 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 $13,656 $307,440 $60,180 $247,260
2023 $11,902 $239,274 $38,836 $200,438
2022 $11,248 $228,862 $38,836 $190,026
2021 $10,720 $228,862 $38,836 $190,026
2020 $11,310 $206,182 $34,986 $171,196
2019 $11,500 $206,182 $34,986 $171,196
2018 $11,262 $206,182 $34,986 $171,196
2017 $10,052 $184,839 $33,590 $151,249
2016 $10,296 $184,839 $33,590 $151,249
2015 $10,290 $184,839 $33,590 $151,249
2014 $11,350 $180,060 $33,220 $146,840
2013 $11,154 $203,000 $34,990 $168,010
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1412375

MLS of Greater Cincinnati (CincyMLS)

APN: 16-01-276-010