NOT LISTED FOR SALE

2649 Upper 5 Mile Rd Williamsburg, OH 45176

Estimated Value: $405,936 - $622,000

4 Beds
3 Baths
2,564 Sq Ft
$195/Sq Ft Est. Value

Sale Details

Date Sold: January 31, 2017

Last sale price $299,700 $117 Per Sq Ft

Est. 67% increase in value since last sale

Current estimated payment $2,896 / mo

73 Days on Market

Highlights

  • Barn
  • 10.04 Acre Lot
  • Partially Wooded Lot
  • Eat-In Gourmet Kitchen
  • Fireplace in Primary Bedroom
  • Traditional Architecture

About This Home

As of January 2017

Beautiful mini farm that has been updated galore. Kitchen has beautiful Hickory wood cab. w/ SS appliances. dbl oven with a warmer. 2 barns (1 w/heat/water/elec) Fenced pastures/pond. Newer standing seam roof, windows, gutters. Pex plumbing throughout, on demand propane WH. Too many things to list...This house is a must see. 2654 sqft. of living sp

Last Agent to Sell the Property

Gregory Traynor

Wyndham-Lyons Realty Services, License #2013002958 Listed on: 10/12/2016

Co-Listed By

Tina Mulvany

Comey & Shepherd License #2013001875

Last Buyer's Agent

Melissa Smith

Coldwell Banker Realty License #2020001150

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1896

Lot Details

  • 10.04 Acre Lot
  • Wood Fence
  • Aluminum or Metal Fence
  • Partially Wooded Lot

Parking

  • Driveway

Home Design

  • Traditional Architecture
  • Stone Foundation
  • Metal Roof
  • Vinyl Siding

Interior Spaces

  • 2,564 Sq Ft Home
  • 2-Story Property
  • Woodwork
  • Ceiling Fan
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • French Doors
  • Family Room with Fireplace
  • 2 Fireplaces
  • Tile Flooring

Kitchen

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

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms

Outdoor Features

  • Balcony
  • Patio
  • Porch

Farming

  • Barn

Utilities

  • Heating Available
  • Propane
  • Septic Tank

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Year Built

Built in 1896

Lot Details

10.04 Acres

Listing Details

  • Suburb: Sterling Twp.
  • Trees: Wooded-Partial
  • Degree Complete: Completed
  • Buildings: Barn
  • Land Description: 10 to 19 Acres
  • Access: County Road,State Highway,Paved Road
  • Broker Approved: Yes
  • Miscellaneous: Ceiling Fan
  • Census Tract Realist: 9512.02
  • Cooling: None
  • Heating: Electric
  • Lot Area Realist: 437342.00
  • Suburb S I C: Sterling Twp.
  • Price Per Acre: 29850.60
  • Accessibility Features: No
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Family Room Feat: Fireplace,Walkout,French Doors,Other
  • Living Great Rm Dim: 15 x 15
  • Living Room Feat: WW Carpet
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Year Built: 1896
  • School 1 Type: District Phone
  • Architecture: Traditional, Other
  • Full Bathrooms: 3
  • Bedrooms: 4
  • Directions: 32 East to left on Dela Palma to left on Upper 5 Mile
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2016-10-12
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • Second Floor Area: 1184
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Natural Woodwork, French Doors
  • Bedroom 2: 16x15 Level: 1
  • Bedroom 3: 15x12 Level: 2
  • Bedroom 4: 15x15 Level: 2
  • Family Room: 20x15 Level: 1
  • Living Room: 15x15 Level: 1
  • Formal Dining Room: No
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 937-444-2044
  • Semi Annual Taxes: of record
  • Kitchen: 20x15 Level: 1
  • Appliances: Oven/Range, Dishwasher, Refrigerator, Microwave
  • Kitchen Features: Marble/Granite/Slate,Tile Floor,Eat-In,Gourmet,Wood Cabinets,Counter Bar,Walkout,Other
  • Basement: None
  • Bathrooms: 3.00
  • Kitchen Dim: 20 x 15
  • Levels: Two
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Bathroom 3: Full
  • Bathroom 3 Level: 2
  • Laundry Room: 10x8 Level: 1
  • Laundryroom Dim: 10 x 8
  • Recreation Room Dim: 0 x 0
  • Fireplace: Gas
  • Fireplaces: 2
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2564.00
  • Windows: Vinyl, Aluminum
  • First Floor Family Room: Yes
  • PrimaryBedroomDim: 25 x 15
  • Primary Bathrooms: Double Vanity,Heated Floors,Marb/Gran/Slate,Shower,Tile Floor,Jetted Tub
  • PrimaryBedFeat: WW Carpet,Bath Adjoins,Walk-in Closet,Window Treatment,Walkout,Fireplace,Other
  • P R I M A R Y B E D R O O M: 25x15 Level: 2

Exterior Features

  • Fencing: Wood, Metal
  • Roof: Metal
  • Construction: Vinyl Siding
  • Outside Features: Patio, Porch, Balcony, Other
  • Foundation: Stone
  • Listing Price: 319000.00
  • Acres: 10.0400
  • New Construction: No
  • TopographyDetails: Cleared,Lake/Pond

Garage/Parking

  • Garage Carport: None
  • 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: Western Brown Local

Green Features

  • Energy Green Features: No

Lot Info

  • Farm Type: Horse
  • Lot Dimensions: of record
  • Lot Size Sq Ft: 437342.00
  • Total Assessed Value: of record
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 12, 2016
Closed on
Jan 31, 2017
Sold by
Ward Lori
Bought by
Bennett Lindsay L
Seller's Agent
Gregory Traynor
Wyndham-Lyons Realty Services,
Buyer's Agent
Melissa Smith
Coldwell Banker Realty
List Price
$329,000
Sold Price
$299,700
Premium/Discount to List
-$29,300
-8.91%
Current Estimated Value
$500,734

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$201,034
Avg. Annual Appreciation
5.69%
Original Mortgage
$284,715
Outstanding Balance
$231,720
Interest Rate
4.2%
Mortgage Type
New Conventional
Estimated Equity
$269,014

Purchase Details

Closed on
Oct 24, 2003
Sold by
Nielsen Michael G and Nielsen Connie J
Bought by
Ward Lori

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$184,950
Interest Rate
5.81%
Mortgage Type
Unknown

Purchase Details

Closed on
Jun 18, 2001
Sold by
Ober Elissa J
Bought by
Nielsen Michael G and Nielsen Connie J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$172,800
Interest Rate
7.16%
Mortgage Type
New Conventional
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

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
Bennett Lindsay L $299,700 None Available
Ward Lori $205,500 --
Nielsen Michael G $192,000 --
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 Bennett Lindsay L $284,715
Previous Owner Ward Lori $184,950
Previous Owner Nielsen Michael G $172,800
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
05/02/2017 05/02/17 Off Market $299,700 -- --
01/31/2017 01/31/17 Sold $299,700 -6.1% $117 / Sq Ft
12/24/2016 12/24/16 Pending -- -- --
11/09/2016 11/09/16 Price Changed $319,000 -3.0% $124 / Sq Ft
10/12/2016 10/12/16 For Sale $329,000 -- $128 / 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,679 $118,330 $39,920 $78,410
2024 $2,739 $118,330 $39,920 $78,410
2023 $2,739 $87,340 $26,870 $60,470
2022 $2,768 $89,670 $29,200 $60,470
2021 $2,737 $89,670 $29,200 $60,470
2020 $2,372 $74,720 $24,330 $50,390
2019 $2,545 $74,720 $24,330 $50,390
2018 $2,526 $74,720 $24,330 $50,390
2017 $2,144 $63,620 $24,330 $39,290
2016 $2,143 $63,620 $24,330 $39,290
2015 $2,103 $63,620 $24,330 $39,290
2014 $1,660 $49,280 $9,990 $39,290
2013 $1,656 $49,280 $9,990 $39,290
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: 1514260

MLS of Greater Cincinnati (CincyMLS)

APN: 37-071172-0300

Your Personal Tour Guide

Ask me questions while you tour the home.