NOT LISTED FOR SALE

5472 Sir Lancelot Ln Fairfield, OH 45014

Estimated Value: $292,000 - $331,000

3 Beds
2.5 Baths
1,909 Sq Ft
$163/Sq Ft Est. Value

Last Sold June 26, 2015

Last sale price $183,000 $96 Per Sq Ft

Est. 70% increase in value since last sale

Current estimated payment $2,030/month

13 Days on Market

Highlights

  • Traditional Architecture
  • No HOA
  • Forced Air Heating and Cooling System
  • Main Floor Bedroom
  • Formal Dining Room
  • Family Room

About This Home

As of June 2015

Beautiful remodeled home! Approximately 2,600 s/ft! Move-in ready! Granite counter tops, self-closing IKEA cabinets, tile floors, ss appliances, and 100 inch projector w/ surround sound! Roof, furnace, A/C and appliances less than 2 years old!

Last Agent to Sell the Property

James Roth

EquiRealty Group License #0000343567 Listed on: 05/08/2015

Last Buyer's Agent

Vicki Schlechtinger

Hoeting, REALTORS License #0000412989

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,528

Year Built

  • Built in 1975

Lot Details

  • Lot Dimensions are 118 x 140

Parking

  • 2 Car Garage
  • Driveway
  • On-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Shingle Roof
  • Wood Siding

Interior Spaces

  • 1,909 Sq Ft Home
  • Wood Burning Fireplace
  • Vinyl Clad Windows
  • Family Room
  • Formal Dining Room
  • Partial Basement

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Main Floor Bedroom

Utilities

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

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,528

Year Built

Built in 1975

Lot Details

0

Parking

2

Listing Details

  • Suburb: Fairfield
  • Degree Complete: Completed
  • Broker Approved: Yes
  • Basement Sq Ft: 493
  • Census Tract Realist: 109.03
  • Cooling: Central Air
  • Heating: Gas, Forced Air
  • Lot Area Realist: 16518.00
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Fairfield
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Living Great Rm Area: 216
  • Living Great Rm Dim: 12 x 18
  • Living Great Rm Len: 12
  • Living Great Rm Wid: 18
  • Single Family Desc: Single Family
  • Study Lib Den Dim: 0 x 0
  • Year Built: 1975
  • School 1 Type: District Phone
  • Architecture: Traditional
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Bedrooms: 3
  • Directions: S Route 4 (R) Winton (R) Niles (L) Bibury (L) Broadview (R) Sir Lancelot
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2015-05-08
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 12x12 Level: 1
  • Bedroom 3: 10x12 Level: 1
  • Dining Room: 10x12 Level: 1
  • Family Room: 18x12 Level: Lower
  • Living Room: 12x18 Level: 1
  • Formal Dining Room: Yes
  • Property Type: Residential
  • Reciprocal Listing: No
  • School Name1: Call SD 513-829-6300
  • Semi Annual Taxes: 764
  • Kitchen: 12x10 Level: 1
  • Bedroom 2 Area: 144
  • Basement: Partial
  • Bedroom 3 Area: 120
  • Bathrooms: 3.00
  • Kitchen Area: 120
  • Kitchen Dim: 12 x 10
  • Levels: 0
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Bathroom 3: Partial
  • Bathroom 3 Level: Lower
  • Diningroom Area: 120
  • Family Room Area: 216
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Fireplace: Wood
  • Fireplaces: 1
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 1909.00
  • Total Rooms: 7
  • Windows: Vinyl
  • First Floor Family Room: Yes
  • PrimaryBedroomArea: 144
  • PrimaryBedroomDim: 12 x 12
  • PrimaryBedroomLen: 12
  • P R I M A R Y B E D R O O M: 12x12 Level: 1

Exterior Features

  • Roof: Shingle
  • Construction: Brick, Wood Siding
  • Foundation: Poured
  • Listing Price: 194900.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Built in
  • Parking: Driveway, On Street

Utilities

  • Gas: Natural
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Schools

  • District: Fairfield City SD

Lot Info

  • Lot Dimensions: 118 x 140
  • Total Assessed Value: of rec
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 8, 2015
Closed on
Jun 26, 2015
Sold by
5472 Sir Lancelot Ln Land Trust
Bought by
Snyder Melissa M
Seller's Agent
James Roth
EquiRealty Group
Buyer's Agent
Vicki Schlechtinger
Hoeting, REALTORS
List Price
$194,900
Sold Price
$183,000
Premium/Discount to List
-$11,900
-6.11%
Total Days on Market
13
Current Estimated Value
$311,468

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$128,468
Avg. Annual Appreciation
5.43%
Original Mortgage
$130,500
Outstanding Balance
$103,727
Interest Rate
3.86%
Mortgage Type
New Conventional
Estimated Equity
$206,091

Purchase Details

Closed on
Mar 26, 2014
Sold by
Hershner Joshua L and Hershner Laura A
Bought by
5472 Sir Lancelot Ln Land Trust

Purchase Details

Listed on
Oct 25, 2012
Closed on
Jan 2, 2013
Sold by
Us Bank Na
Bought by
Hershner Joshua L and Hershner Laura A
Seller's Agent
Rebecca Spaulding
Coldwell Banker Heritage
Buyer's Agent
Christian Keitel
Sibcy Cline, Inc.
List Price
$134,900
Sold Price
$83,000
Premium/Discount to List
-$51,900
-38.47%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.19%
Original Mortgage
$113,000
Interest Rate
3.3%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 11, 2003
Sold by
Watt Carolyn R and Watt James H
Bought by
Liberto Doris M

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 3, 1995
Sold by
Betty Scheeres Trst
Bought by
Watt Carolyn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$94,500
Interest Rate
6.88%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 1, 1988
Source: Public Records

Similar Homes in Fairfield, OH

  • 5719 Crestview Dr, Fairfield, OH 45014

    $345,000

    • 4 Beds
    • 2 Baths
    • 5719 Crestview Dr
    • Fairfield, OH

    Beautiful remodel on this Centrally located Fairfield home. This fabulous home went through a complete makeover with brand new Kitchen cabinets, new appliances, granite countertops, new flooring, new water heater, brand new roof and a completely repainted inside. This home features 4 bedrooms, 2 full baths that were completely redone with new vanities, new tubs, and new flooring. The upstairs

    Patrick Lach Sibcy Cline Inc.

    Section Image
  • 2059 Rolling Hills Blvd, Fairfield, OH 45014

    $276,900

    • 3 Beds
    • 2 Baths
    • 1,804 Sq Ft
    • 2059 Rolling Hills Blvd
    • Fairfield, OH

    Move in Ready!!!!Lovely home on just over 1 acre wooded lot-Brand New Stainless steel appliances-Well kept hardwood floors on first floor-2 full baths-Freshly painted-Large living room and family room-oversized 2 car garage-This is a must see!!!

    Steve Elbert Around Town Realty

    Section Image
  • 965 Deis Dr, Fairfield, OH 45014

    $320,000

    • 3 Beds
    • 2 Baths
    • 965 Deis Dr
    • Fairfield, OH

    This is the one! Centrally located within walking distance of Village Green, this house has been meticulously maintained. A generous sized kitchen and family room creates a great place to entertain. An expansive unfinished basement is ready for your finishing touches. Updated kitchen, Pella windows, Newer HVAC and roof, and a dream garden round out this incredible home! Move in before the big

    Ian Lubbers RE/MAX Preferred Group

    Section Image
  • 846 Wesleyan Dr, Fairfield, OH 45014

    $315,000

    • 4 Beds
    • 2.5 Baths
    • 1,800 Sq Ft
    • 846 Wesleyan Dr
    • Fairfield, OH

    Check out this 4-bedroom, 2.5 bath home with partially finished basement! Updated kitchen and baths. Newer Vinyl flooring on main level. Newer carpet in both upper and lower level. Water heater and garage door both new in 2021. The large screened in back deck is the perfect place to enjoy the spring weather. Reach out to schedule a showing today!

    Noah Bradtke-Litwack Best Homes Real Estate Ltd.

    Section Image
  • 835 Wesleyan Dr, Fairfield, OH 45014

    $284,900

    • 2 Beds
    • 2.5 Baths
    • 1,692 Sq Ft
    • 835 Wesleyan Dr
    • Fairfield, OH

    Handicapped accessible home meticulously taken care of. Bathroom w/special shower & tub, full bath in LL. Fenced yard, covered patio, attached garage and so much more.

    Shawnda Partin Hand In Hand Realty, LLC

    Section Image
  • 785 Louise Ave, Fairfield, OH 45014

    $292,000

    • 3 Beds
    • 2 Baths
    • 1,008 Sq Ft
    • 785 Louise Ave
    • Fairfield, OH

    Welcome to this fabulous area! This home has Fresh Interior Paint, New flooring throughout the home, New Appliances. Discover a bright interior tied together with a neutral color palette. Step into the kitchen, complete with an eye catching stylish backsplash. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back

    DANIEL BEIRNE Opendoor Brokerage LLC

    Section Image
  • 919 Doris Jane Ave, Fairfield, OH 45014

    $275,000

    • 3 Beds
    • 2 Baths
    • 919 Doris Jane Ave
    • Fairfield, OH

    Beautifully remodeled 1107 sqft ranch featuring 3 spacious bedrooms and 2 fully updated bathrooms. Enjoy a brand-new kitchen with modern cabinets, countertops, and stainless steel appliances. The home includes new flooring throughout, updated lighting, some new energy-efficient windows, and a convenient washer and dryer. Both bathrooms have been completely redone with stylish finishes. Outside,

    Nasser Hussain Fiv Realty Co Ohio LLC

    Section Image
  • 1012 Wesleyan Dr, Fairfield, OH 45014

    $280,000

    • 3 Beds
    • 2.5 Baths
    • 1,356 Sq Ft
    • 1012 Wesleyan Dr
    • Fairfield, OH

    Well maintained 3 BR ranch on 1/3 acre (flat and level lot) w/ finished LL and 2 full baths! Fencyed in backyard w/ covered patio. Floors have been refinished w/ updates to baths and kitchen. Additionally, LL has been waterproofed, 1 car garage that walks out to back yard, transferrable home warranty to new buyer (Choice Home Warranty) Updates include Bath, flooring, additional insulation, new

    Timothy Hamblin Lohmiller Real Estate

    Section Image
  • 4980 Pleasant Ave, Fairfield, OH 45014

    $314,900

    • 3 Beds
    • 3 Baths
    • 1,170 Sq Ft
    • 4980 Pleasant Ave
    • Fairfield, OH

    Over 2300 sqft living space open floor cocnept ranch nestled in the heart of Fairfield. House has been completely remodeled about 1 year ago with 3 bedrooms and 2 full baths on first floor.Full finished basement with family room, laundry room, a full bath and 2 additonal rooms could be used as extra bedrooms or study/bonus rooms. Many upgrades including luxurious high-end finished bathrooms and

    Thuy Thi Le Nguyen-Meyer OwnerLand Realty, Inc.

    Section Image

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
Snyder Melissa M $183,000 Attorney
5472 Sir Lancelot Ln Land Trust -- None Available
Hershner Joshua L $83,000 None Available
Liberto Doris M $160,000 First Title Agency Inc
Watt Carolyn $105,000 --
-- $98,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Snyder Melissa M $130,500
Previous Owner Hershner Joshua L $113,000
Previous Owner Liberto Anthony $123,000
Previous Owner Liberto Doris M $90,000
Previous Owner Watt Carolyn R $33,000
Previous Owner Watt Carolyn $94,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/01/2015 10/01/15 Off Market $183,000 -- --
06/26/2015 06/26/15 Sold $183,000 -6.1% $96 / Sq Ft
05/21/2015 05/21/15 Pending -- -- --
05/08/2015 05/08/15 For Sale $194,900 +134.8% $102 / Sq Ft
04/11/2013 04/11/13 Off Market $83,000 -- --
01/07/2013 01/07/13 Sold $83,000 -38.5% $43 / Sq Ft
12/11/2012 12/11/12 Pending -- -- --
10/25/2012 10/25/12 For Sale $134,900 -- $71 / 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 $3,451 $93,680 $12,880 $80,800
2023 $3,434 $92,030 $12,880 $79,150
2022 $3,140 $65,780 $12,880 $52,900
2021 $2,716 $64,750 $12,880 $51,870
2020 $2,825 $64,750 $12,880 $51,870
2019 $5,427 $62,860 $13,320 $49,540
2018 $3,115 $62,860 $13,320 $49,540
2017 $3,146 $62,860 $13,320 $49,540
2016 $3,098 $58,940 $13,320 $45,620
2015 $2,950 $58,940 $13,320 $45,620
2014 $2,343 $29,050 $8,780 $20,270
2013 $2,343 $29,050 $8,780 $20,270
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: 1448321

MLS of Greater Cincinnati (CincyMLS)

APN: A0700-123-000-026