NOT LISTED FOR SALE

870 Fiesta Ct Franklin, OH 45005

Estimated Value: $219,000 - $233,394

4 Beds
2 Baths
1,501 Sq Ft
$150/Sq Ft Est. Value

Last Sold September 30, 2021

Last sale price $173,000 $115 Per Sq Ft

Est. 29% increase in value since last sale

Current estimated payment $1,401/month

10 Days on Market

Highlights

  • Ranch Style House
  • 1 Car Attached Garage
  • Wood Siding
  • No HOA
  • Forced Air Heating and Cooling System

About This Home

As of September 2021

Larger than it looks & nicely updated thru-out. This cutie offers fresh paint thru-out interior & exterior, updates to bathrooms & kitchen, 4 bedrms & 2 full baths w/multiple living areas & options for office, play rm &/or addt'l family rm. Large lot (.79). Fenced-in rear yard for play & an addt'l yard beyond for a garden-like feel & privacy. Replacement windows thru-out, updated roof (5 years).

Last Agent to Sell the Property

Morgan Walz

Coldwell Banker Heritage License #2009002944 Listed on: 08/20/2021

Coldwell Banker Heritage

Last Buyer's Agent

Jessica Campagna

eXp Realty License #2020000588

eXp Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,671

Year Built

  • Built in 1963

Lot Details

  • 0.7

Parking

  • 1 Car Attached Garage

Home Design

  • Ranch Style House
  • Slab Foundation
  • Shingle Roof
  • Wood Siding
  • Aluminum Siding

Interior Spaces

  • 1,501 Sq Ft Home
  • Vinyl Clad Windows

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 2 Full Bathrooms

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Oil
  • Natural Gas Not Available
  • Well
  • Electric Water Heater

Community Details

  • No Home Owners Association
  • Meadowdale Estates Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,671

Year Built

Built in 1963

Lot Details

0

Parking

1

Listing Details

  • Suburb: Carlisle
  • Cross Street: Sheri
  • Broker Approved: Yes
  • Census Tract Realist: 301.02
  • Cooling: Central Air
  • Heating: Forced Air, Oil
  • Lot Area Realist: 34500.00
  • Property Ownership: Consumer
  • Sub Lease Expiration Date: 1800-01-01T00:00:00-05:00
  • Suburb S I C: Carlisle
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Entry Dim: 0 x 0
  • Living Great Rm Area: 182
  • Living Great Rm Dim: 14 x 13
  • Living Great Rm Len: 14
  • Living Great Rm Wid: 13
  • Single Family Desc: Single Family
  • Study Lib Den: 12x10 Level: 1
  • Study Lib Den Area: 120
  • Study Lib Den Dim: 12 x 10
  • Study Lib Den Len: 12
  • Water Heating: Electric
  • Year Built: 1963
  • Architecture: Ranch
  • Full Bathrooms: 2
  • Bedrooms: 4
  • Directions: 123 into Carlisle, W on Industry, L on Beachler (becomes Dubois), L on Chelsea, R on Sheri, L on Fiesta.
  • Lot Measurement: Acres
  • Status: Sold
  • Showing Start Date: 2021-08-20
  • Property Subtype 1: Single Family Residence
  • Suburb (SIC): Meadowdale Estates
  • Occupancy: At Closing
  • On Market: No
  • Third Party Approval Required: No
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Bedroom 2: 10x8 Level: 1
  • Bedroom 3: 11x11 Level: 1
  • Bedroom 4: 11x10 Level: 1
  • Family Room: 14x12 Level: 1
  • Living Room: 14x13 Level: 1
  • Property Type: Residential
  • Bathrooms Display: 2 (2 0)
  • Reciprocal Listing: No
  • School Name1: Call SD 937-746-0710
  • Semi Annual Taxes: 835.50
  • Kitchen: 13x12 Level: 1
  • Bedroom 2 Area: 80
  • Basement: None
  • Bedroom 3 Area: 121
  • Bedroom 4 Area: 110
  • Bathrooms: 2.00
  • Kitchen Area: 156
  • Kitchen Dim: 13 x 12
  • Levels: One
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Level 1 Bath: 1
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Family Room Area: 168
  • Laundryroom Dim: 0 x 0
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 1501.00
  • Total Rooms: 8
  • Windows: Vinyl
  • PrimaryBedroomArea: 165
  • PrimaryBedroomDim: 15 x 11
  • PrimaryBedroomLen: 15
  • P R I M A R Y B E D R O O M: 15x11 Level: 1

Exterior Features

  • Roof: Shingle
  • Construction: Aluminum Siding, Wood Siding
  • Foundation: Slab
  • Listing Price: 164000.00
  • New Construction: No

Garage/Parking

  • Garage Spaces: 1.00
  • Garage Carport: Garage Attached

Utilities

  • Gas: None
  • Sewer: Public Sewer
  • Water Source: Well

Condo/Co-op/Association

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

Schools

  • District: Carlisle Local SD

Lot Info

  • Lot Dimensions: .79 AC
  • Total Assessed Value: n/a
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Abatement: No

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 31, 2024
Sold by
Caudill Hayden and Bell Lauren
Bought by
Spence John Kipp and Spence Brandi
Current Estimated Value
$223,471

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$208,550
Outstanding Balance
$206,852
Interest Rate
7.17%
Mortgage Type
New Conventional
Estimated Equity
$18,497

Purchase Details

Listed on
Aug 20, 2021
Closed on
Sep 16, 2021
Sold by
Frantz Bryan T and Frantz Christina L
Bought by
Caudill Hayden and Bell Lauren
Seller's Agent
Morgan Walz
Coldwell Banker Heritage
Buyer's Agent
Jessica Campagna
eXp Realty
List Price
$164,000
Sold Price
$173,000
Premium/Discount to List
$9,000
5.49%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.07%
Original Mortgage
$155,700
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 8, 2019
Sold by
Frantz Charles T and Frantz Kathy A
Bought by
Frantz Bryan T and Frantz Christina L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$107,855
Interest Rate
5.25%
Mortgage Type
FHA

Purchase Details

Closed on
Jun 3, 2011
Sold by
Frantz Charles
Bought by
Frantz Charles T and Frantz Kathy A

Purchase Details

Closed on
Jun 9, 2008
Sold by
Wetzel Irene W
Bought by
Frantz Charles

Purchase Details

Closed on
May 16, 2008
Sold by
Wetzel Irene
Bought by
Wetzel Irene W and The Irene W Wetzel Trust

Purchase Details

Closed on
May 6, 2008
Sold by
Avelo Mortgage Llc
Bought by
Wetzel Irene

Purchase Details

Closed on
Feb 21, 2008
Sold by
Hudson Jeffrey C
Bought by
Avelo Mortgage Llc

Purchase Details

Closed on
Jul 25, 2006
Sold by
Lefeld Andrew B and Lefeld Volina D
Bought by
Hudson Jeffrey C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$96,800
Interest Rate
10.05%
Mortgage Type
Balloon

Purchase Details

Closed on
Nov 4, 1993
Sold by
Hall Bee and Hall Olene
Bought by
Lefeld and Lefeld Andrew B
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
Spence John Kipp $215,000 None Listed On Document
Caudill Hayden $173,000 None Available
Frantz Bryan T $135,000 None Available
Frantz Charles T -- Sterling Land Title Agency I
Frantz Charles $71,500 National Title Company
Wetzel Irene W -- M & M Title Co
Wetzel Irene $46,500 M & M Title Co
Avelo Mortgage Llc $87,500 None Available
Hudson Jeffrey C $121,000 Title First Agency Wva Llc
Lefeld $75,900 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Spence John Kipp $208,550
Previous Owner Caudill Hayden $155,700
Previous Owner Frantz Bryan T $107,855
Previous Owner Hudson Jeffrey C $24,200
Previous Owner Hudson Jeffrey C $96,800
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/30/2021 09/30/21 Sold $173,000 +5.5% $115 / Sq Ft
08/31/2021 08/31/21 Pending -- -- --
08/20/2021 08/20/21 For Sale $164,000 -- $109 / 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 $2,135 $54,520 $12,250 $42,270
2023 $1,972 $44,222 $9,842 $34,380
2022 $1,886 $44,223 $9,842 $34,381
2021 $1,821 $44,223 $9,842 $34,381
2020 $1,671 $35,378 $7,875 $27,503
2019 $1,733 $35,378 $7,875 $27,503
2018 $1,692 $35,378 $7,875 $27,503
2017 $1,703 $32,036 $7,242 $24,794
2016 $1,496 $32,036 $7,242 $24,794
2015 $1,500 $32,036 $7,242 $24,794
2014 $1,468 $32,040 $7,240 $24,790
2013 $1,464 $38,710 $8,750 $29,960
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1712883

MLS of Greater Cincinnati (CincyMLS)

APN: 1805011