NOT LISTED FOR SALE

5690 Newcastle Rd Lafayette, IN 47905

Estimated Value: $528,000 - $579,072

4 Beds
3 Baths
3,648 Sq Ft
$151/Sq Ft Est. Value

Last Sold July 12, 2024

Last sale price $540,000 $148 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $3,298/month

10 Days on Market

Highlights

  • In Ground Pool
  • 2 Car Attached Garage
  • Ceiling Fan
  • Ranch Style House
  • Central Air
  • Level Lot

About This Home

As of July 2024

Welcome to your dream retreat! This exquisite Brick Ranch nestled on 2.2 acres offers the perfect blend of luxury, comfort, and endless entertainment options. Step inside the main floor and be greeted by a spacious layout featuring 4 bedrooms and 2 full bathrooms. The heart of the home is the expansive open floor plan, seamlessly connecting the kitchen, dining room, and living room, making it ideal for gatherings and relaxation alike. Venture downstairs to discover a fully finished basement, boasting two additional guest rooms, a bathroom with a convenient stand-up shower, laundry facilities, and a luxurious infrared sauna—an oasis for unwinding after a long day. Outside, paradise awaits with a 12x24 covered paver patio, leading to a magnificent 16x40 San Juan Fiberglass in-ground pool. Dive into luxury with deck fountains, LED lighting (all new in 2021), and a thrilling water slide. Need more relaxation? Slip into the inviting hot tub and let your worries melt away. Car enthusiasts and hobbyists will rejoice with a 2-car attached garage, a 2-car detached garage, and a spacious pole barn offering ample storage space for all your toys and tools. Updates abound, including a new roof in 2015, a new Bosch Furnace and Heat Pump in 2018, new windows in 2018, and luxurious Brazilian Teak Hardwood flooring throughout.

Last Agent to Sell the Property

Spencer Childers

Keller Williams Lafayette Brokerage Phone: 765-430-4276 Listed on: 05/13/2024

Keller Williams Lafayette

Last Buyer's Agent

Sherri Baird

Keller Williams-Morrison

Keller Williams-Morrison

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,420

Year Built

  • Built in 2000

Lot Details

  • 2.23 Acre Lot
  • Lot Dimensions are 300x300
  • Level Lot
  • Irregular Lot

Parking

  • 2 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • Ceiling Fan
  • Living Room with Fireplace
  • Disposal
  • Electric Dryer Hookup

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan

Basement

  • Basement Fills Entire Space Under The House
  • 1 Bathroom in Basement

Pool

  • In Ground Pool

Schools

  • Cole Elementary School
  • Wainwright Middle School
  • Mc Cutcheon High School

Utilities

  • Central Air
  • Heat Pump System
  • Well
  • Private Sewer

Community Details

  • Community Pool

Listing and Financial Details

  • Assessor Parcel Number 79-12-46-760-014.000-012

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,420

Year Built

Built in 2000

Lot Details

0

Parking

2

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Year Built: 2000
  • Age: 24
  • Style: One Story
  • Architectural Style: Ranch
  • Total Number of Rooms: 13
  • Bedrooms: 4
  • Number Above Grade Bedrooms: 4
  • Total Bathrooms: 3
  • Total Full Bathrooms: 3
  • Legal Description: PT RICH RES TWP 22 R3 1.2916 A BY SURVEY& PT RICH RES TWP 22 R3 0.9338 A
  • Parcel Number ID: 79-12-46-760-014.000-012
  • Platted: Yes
  • Amenities: Ceiling Fan(s), Disposal, Dryer Hook Up Electric, Split Br Floor Plan
  • Sp Lp Percent: 98.2
  • Year Taxes Payable: 2024
  • Special Features: None
  • Stories: 1

Interior Features

  • Total Sq Ft: 3648
  • Total Finished Sq Ft: 3648
  • Above Grade Finished Sq Ft: 1848
  • Below Grade Finished Sq Ft: 1800
  • Price Per Sq Ft: 292.21
  • Basement: Yes
  • Basement Foundation: Full Basement
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 1
  • Fireplace: Living/Great Rm
  • Fireplace: Yes
  • Living Great Room: Dimensions: 19x20, On Level: Main
  • Kitchen: Dimensions: 10x12, On Level: Main
  • Dining Room: Dimensions: 9x12, On Level: Main
  • Bedroom 1: Dimensions: 15x16, On Level: Main
  • Bedroom 2: Dimensions: 12x17, On Level: Main
  • Bedroom 3: Dimensions: 12x13, On Level: Main
  • Bedroom 4: Dimensions: 13x13, On Level: Main
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Full Bathrooms: 2
  • Total Below Grade Sq Ft: 1800

Exterior Features

  • Exterior: Brick
  • Roof Material: Asphalt
  • Outbuilding1: 2nd Detached Garage, Dimensions: 22x24
  • Pool: Below Ground
  • Pool: Yes
  • Outbuilding2: Pole/Post Building, Dimensions: 18x20, 360

Garage/Parking

  • Garage Type: Attached
  • Garage Number Of Cars: 2
  • Garage Size: Dimensions: 23x21
  • Garage Sq Ft: 483
  • Garage: Yes

Utilities

  • Cooling: Central Air, Heat Pump
  • Heating Fuel: Electric
  • Sewer: Private
  • Water Utilities: Well
  • Laundry: Dimensions: Mainx15, On Level: 10
  • Well Type: Unknown

Schools

  • School District: Tippecanoe School Corp.
  • Elementary School: Cole
  • Middle School: Wainwright
  • High School: Mc Cutcheon
  • Elementary School: Cole

Lot Info

  • Lot Description: Irregular, Level, 0-2.9999
  • Lot Dimensions: 300x300
  • Estimated Lot Sq Ft: 96921
  • Estimated Lot Size Acres: 2.225

Tax Info

  • Annual Taxes: 3420.44
  • Exemptions: Homestead

MLS Schools

  • High School: Mc Cutcheon
  • Middle School: Wainwright
  • School District: Tippecanoe School Corp.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 13, 2024
Closed on
Jul 12, 2024
Sold by
Cardwell William
Bought by
Wood-Freeman Megan L and Freeman Devon
Seller's Agent
Spencer Childers
Keller Williams Lafayette
Buyer's Agent
Sherri Baird
Keller Williams-Morrison
List Price
$549,900
Sold Price
$540,000
Premium/Discount to List
-$9,900
-1.8%
Views
42
Current Estimated Value
$549,268

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$9,268
Avg. Annual Appreciation
2.72%
Original Mortgage
$457,875
Outstanding Balance
$454,329
Interest Rate
6.87%
Mortgage Type
FHA
Estimated Equity
$102,000

Purchase Details

Closed on
Apr 3, 2015
Sold by
Pearson Stephanie
Bought by
Cardwell William

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 1, 2009
Sold by
Beeler Francis S
Bought by
Cardwell William and Cardwell Stephanie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$172,000
Interest Rate
4.86%
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
Wood-Freeman Megan L $540,000 Metropolitan Title
Cardwell William -- --
Cardwell William -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Wood-Freeman Megan L $457,875
Previous Owner Cardwell William $250,000
Previous Owner Cardwell William $120,000
Previous Owner Cardwell William $37,500
Previous Owner Cardwell William $177,000
Previous Owner Cardwell Stephanie $50,000
Previous Owner Cardwell William $158,000
Previous Owner Cardwell William $172,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/12/2024 07/12/24 Sold $540,000 -1.8% $148 / Sq Ft
05/23/2024 05/23/24 Pending -- -- --
05/13/2024 05/13/24 For Sale $549,900 -- $151 / Sq Ft
Source: Indiana Regional MLS

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,665 $492,700 $44,900 $447,800
2023 $3,398 $434,000 $44,900 $389,100
2022 $3,303 $386,000 $44,900 $341,100
2021 $2,462 $312,000 $44,900 $267,100
2020 $2,162 $287,600 $44,900 $242,700
2019 $2,056 $281,300 $44,900 $236,400
2018 $1,909 $267,800 $44,900 $222,900
2017 $1,899 $263,700 $44,900 $218,800
2016 $1,872 $262,900 $44,900 $218,000
2014 $1,703 $175,000 $44,900 $130,100
2013 $1,122 $173,300 $44,900 $128,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202416768

Indiana Regional MLS

APN: 79-12-46-760-014.000-012