OFF MARKET

Off market jul 2024 for $540K

$578,636

•

3,648

sq ft

5690 Newcastle Rd, Lafayette, IN 47905

About this home

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.

Single-familyProperty Type

2000Year Built

2.23 acresLot Size

$159Est. Price/Sq.Ft.

2 car garageParking

Listed by Spencer Childers • Keller Williams Lafayette

Contact: Agt: 765-430-4276

Bought with Sherri Baird • Keller Williams-Morrison

Redfin checked: 2 minutes ago

•Source:IRMLS #202416768

Redfin Estimate

$578,636

$39K since sold in July 2024$4,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 4.3% higher than the average sale price ($555K) of 6 comparable homes.

SOLD AUG 27, 2026
$715,000
A
4 beds3.5 baths3,387 sq ft
4240 Paulana Pl, Lafayette, IN 47905
SOLD SEP 4, 2026
$527,625
B
4 beds3 baths3,240 sq ft
6556 Wyandotte Rd, Lafayette, IN 47905
SOLD JAN 9, 2026
$485,000
C
4 beds2.5 baths2,535 sq ft
5760 S 800 Rd E, Lafayette, IN 47905
SOLD OCT 19, 2026
$435,000
D
3 beds2 baths2,940 sq ft
752 Shady Ln, Dayton, IN 47941
SOLD SEP 9, 2026
$442,100
E
4 beds2.5 baths2,478 sq ft
4464 Regatta Dr, Lafayette, IN 47909
SOLD DEC 17, 2025
$725,000
F
4 beds3.5 baths5,046 sq ft
5421 Faithful Ln, Lafayette, IN 47905

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Rent

$2,081/mo

Redfin rental estimate

List your home for rent

Market trends in 47905, IN

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

97.8%

0.2% MoM

Median sale price

$290K

$20K MoM

Avg. days on market

24d

1 days MoM

Recently sold homes

114

7 MoM

New listings for sale

OPEN SUN, 1PM TO 3PM
$630,000
4 beds3 baths3,412 sq ft
2524 Mar Ruth Dr, Lafayette, IN 47905
$240,000
3 beds2 baths1,568 sq ft
3480 Union St, Lafayette, IN 47905
$139,900
1 bed1 bath641 sq ft
1402 S 4th St, Lafayette, IN 47904
$290,000
3 beds2.5 baths1,874 sq ft
1306 Sourgum Ln, Lafayette, IN 47905
$265,000
3 beds2 baths1,240 sq ft
5660 Bingham Dr, Lafayette, IN 47905
$359,000
6 beds7 baths2,280 sq ft
525 S 3rd St, Lafayette, IN 47905
FOR SALE BY OWNER
$130,000
3 beds2 baths— sq ft
3910 Harry Ave, Lafayette, IN 47905
$239,500
3 beds2.5 baths2,054 sq ft
1605 Adams St, Lafayette, IN 47905
$319,900
4 beds2.5 baths2,464 sq ft
1820 Beechwood Dr, Lafayette, IN 47905
$495,900
4 beds3.5 baths2,432 sq ft
7321 Combine Dr, Lafayette, IN 47905
See all

Provided by Redfin

Sale history for 5690 Newcastle Rd

Year

Property tax

Land + Additions

Assessment*

2025

$3,689 (+1.3%)

$44,900 + $489,400

$534,300

2024

$3,642 (+7.2%)

$44,900 + $447,800

$492,700

2023

$3,398 (+2.9%)

$44,900 + $389,100

$434,000

2022

$3,303 (+34.2%)

$44,900 + $341,100

$386,000

2021

$2,462 (+13.9%)

$44,900 + $267,100

$312,000

2020

$2,162 (+5.2%)

$44,900 + $242,700

$287,600

2019

$2,056 (+7.7%)

$44,900 + $236,400

$281,300

2018

$1,909 (+0.5%)

$44,900 + $222,900

$267,800

2017

$1,899 (+1.4%)

$44,900 + $218,800

$263,700

2016

$1,872 (+0.9%)

$44,900 + $218,000

$262,900

2015

$1,856 (+48.1%)

$44,900 + $211,500

$256,400

2013

$1,253

$44,900 + $128,400

$173,300

Tax history for 5690 Newcastle Rd

Year

Property tax

Land + Additions

Assessment*

2025

$3,689 (+1.3%)

$44,900 + $489,400

$534,300

2024

$3,642 (+7.2%)

$44,900 + $447,800

$492,700

2023

$3,398 (+2.9%)

$44,900 + $389,100

$434,000

2022

$3,303 (+34.2%)

$44,900 + $341,100

$386,000

2021

$2,462 (+13.9%)

$44,900 + $267,100

$312,000

2020

$2,162 (+5.2%)

$44,900 + $242,700

$287,600

2019

$2,056 (+7.7%)

$44,900 + $236,400

$281,300

2018

$1,909 (+0.5%)

$44,900 + $222,900

$267,800

2017

$1,899 (+1.4%)

$44,900 + $218,800

$263,700

2016

$1,872 (+0.9%)

$44,900 + $218,000

$262,900

2015

$1,856 (+48.1%)

$44,900 + $211,500

$256,400

2013

$1,253

$44,900 + $128,400

$173,300

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

—

Baths

Stories

Lot width

—

Lot depth

—

Lot size

2.23 Acres

Year renovated

2002

Sq. Ft.

3,696

Year built

2000

Style

Single Family Residential

County

Tippecanoe County

APN

791246760014000012

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 16, 2026.

Agricultural Zones

To provide substantial areas for agricultural use and only limited residential development including mobile home parks, where little or no urbanization has occurred or is planned to occur. Zone regulations specific to mobile home parks/manufactured home communities are found in 5-4 below.

Permitted uses

Include but are not limited to:

Agriculture
Greenhouse / nursery
Livestock production
Housing-Single unit
Housing-Multiple units
Housing-Other
Bed & breakfast
Veterinary clinic
Agriculture-Cropland
Housing-Mobile home park

Property details

Parking

Parking/Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking Features: Attached

Interior

Virtual Tour

Bathroom Information
# of Full Bathrooms: 3
# of Main Level Bathrooms: 2

Heating & Cooling
Has Cooling
Cooling: Ceiling Fan(s), Central Air, Heat Pump
Has Heating
Heating: Heat Pump, Electric

Interior Features
Interior Features: Ceiling Fan(s)
Window Features: Window Treatments
Appliances: Disposal, Dishwasher, Microwave, Refrigerator, Water Softener Owned, Gas Range, Dryer
Has Fireplace
# of Fireplaces: 1
Fireplace Features: Living Room

Room Information
# of Rooms Total: 13
Laundry Features: Electric Dryer Hookup, Main Level
Has Basement
Basement Details: Full

Exterior

Exterior Features
Fencing: None
Roof: Asphalt

Pool Information
Has Private Pool
Pool Features: In Ground

Building Information
Above Grade Finished Area: 1,848
Below Grade Finished Area: 1,800
# of Stories Total: 1
Construction Materials: Brick
Foundation Details: Concrete Perimeter

Property Features
Other Structures: Second Garage

Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Site-Built Home

Lot Information
Lot Features: Irregular Lot, Level
Lot Size Dimensions: 300 x 300
Lot Size Acres: 2.225

Financial

Tax Information
Tax Annual Amount: $3,420.44

Utilities

Utility Information
Water Source: Well
Sewer: Private Sewer

Location

Schools Information
School District: Tippecanoe School Corp.
Elementary School: Cole
Middle Or Junior School: Wainwright
High School: Mc Cutcheon

Location Information
Directions: South on 52, left on Wyandotte, right on Newcastle, house is on the right.
Subdivision Name: None

Public facts

Beds: —
Baths: 3.0
Sq. Ft.: 3,696
Stories: 1.0
Lot Size: 2.23 acres
Style: Single Family Residential
Year Built: 2000
Year Renovated: 2002
County: Tippecanoe County
APN: 791246760014000012

Home facts updated by county records on Oct 16, 2026

Other

Listing Information
List AOR: Lafayette Board of REALTORS
AttributionContact: Agt: 765-430-4276

Around this home

Schools

K - 12
Preschool & daycare

James Cole Elementary School

Public K-5 • Assigned • 3.3mi

8/10

Wainwright Middle School

Public 6-8 • Assigned • 1.5mi

8/10

McCutcheon High School

Public 9-12 • Assigned • 7.5mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

3/10 Heat Factor

7 days above 102° expected this year, 18 days in 30 years

2/10 Wind Factor

0% chance of strong winds in next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Lafayette, IN • 47905

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.1 hours in June and 3.3 hours in December, placing it below the U.S. average for solar exposure.

10.1 hrs

3.3 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$550,000 – $666,000

Sell confidently with a local market expert in Lafayette. 3 minutes to get started.

Nearby similar homes

OPEN SUN, 1PM TO 3PM3D WALKTHROUGH

$279,900

3 beds2.5 baths2,516 sq ft

4301 Nauset Ct Ct, Lafayette, IN 47909

Cul-de-sac lot • Open family room • Eat-in kitchen

$279,999

3 beds2.5 baths2,871 sq ft

5515 N Bluegrass Cir, Lafayette, IN 47905

Two story home • Spacious living area • Ample cabinet space

$253,000

3 beds2 baths1,228 sq ft

417 Stanton Dr, Lafayette, IN 47905

Sunroom • Easy access to i-65 • 6,534 sq ft lot

$279,900

3 beds2 baths1,590 sq ft

5117 Stable Dr, Lafayette, IN 47905

Vaulted ceilings • Cozy fireplace • Ceramic backsplash

$789,000

4 beds4.5 baths4,511 sq ft

811 Deerwood Rdg, Lafayette, IN 47905

Gourmet kitchen • Custom cabinetry • Quartz countertops

$319,900

3 beds2 baths1,647 sq ft

207 Folkston Way, Lafayette, IN 47905

Open floor plan • White cabinets • Granite countertops

New listings for sale in 47905

OPEN SUN, 1PM TO 3PM3D WALKTHROUGH

$630,000

4 beds3 baths3,412 sq ft

2524 Mar Ruth Dr, Lafayette, IN 47905

Finished basement • Updated kitchen • Private theater room

$240,000

3 beds2 baths1,568 sq ft

3480 Union St, Lafayette, IN 47905

Modern kitchen • Quartz countertops • Soft close cabinets

$139,900

1 bed1 bath641 sq ft

1402 S 4th St, Lafayette, IN 47904

Investment property • Corner lot • 1 year old roof

$290,000

3 beds2.5 baths1,874 sq ft

1306 Sourgum Ln, Lafayette, IN 47905

Fenced backyard • Quiet neighborhood • 6,229 sq ft lot

$265,000

3 beds2 baths1,240 sq ft

5660 Bingham Dr, Lafayette, IN 47905

One-level living • Walk-in closet • Private bath

$359,000

6 beds7 baths2,280 sq ft

525 S 3rd St, Lafayette, IN 47905

Multifamily property • Recent updates • Solid foundation

FOR SALE BY OWNER

$130,000

3 beds2 baths— sq ft

3910 Harry Ave, Lafayette, IN 47905

Remodeled • Quartz countertops • Wrap around porch

$239,500

3 beds2.5 baths2,054 sq ft

1605 Adams St, Lafayette, IN 47905

Covered front porch • Modern cabinets • Pull-out shelving

$319,900

4 beds2.5 baths2,464 sq ft

1820 Beechwood Dr, Lafayette, IN 47905

Dedicated office • Formal dining • Eat in kitchen

Home values near 5690 Newcastle Rd

Data from public records.

Address	Redfin Estimate
5315 Newcastle Rd, Lafayette, IN - Beds \| 2.5 Baths \| 2556 Sq. Ft.	$369,175
5624 Newcastle Rd, Lafayette, IN 3 Beds \| 1.5 Baths \| 1794 Sq. Ft.	$460,654
5918 Newcastle Rd, Lafayette, IN 3 Beds \| 2.5 Baths \| 2517 Sq. Ft.	$550,782
5525 Newcastle Rd, Lafayette, IN 3 Beds \| 3.5 Baths \| 3621 Sq. Ft.	$769,450
5350 Richardville Rd, Lafayette, IN - Beds \| 2 Baths \| 2102 Sq. Ft.	$396,802
5208 Ruby Ln, Lafayette, IN - Beds \| 2.5 Baths \| 1994 Sq. Ft.	$411,887
5361 Richardville Rd, Lafayette, IN - Beds \| 1 Baths \| 2616 Sq. Ft.	$502,706

Address	Redfin Estimate
5255 Newcastle Rd, Lafayette, IN - Beds \| 2.5 Baths \| 1352 Sq. Ft.	$235,904
5453 Newcastle Rd, Lafayette, IN 3 Beds \| 2.5 Baths \| 1500 Sq. Ft.	$317,740
5355 Newcastle Rd, Lafayette, IN 4 Beds \| 3.5 Baths \| 3300 Sq. Ft.	$585,805
5209 Ruby Ln, Lafayette, IN - Beds \| 2.5 Baths \| 1920 Sq. Ft.	$457,345
5235 Ruby Ln, Lafayette, IN - Beds \| 2.5 Baths \| 2485 Sq. Ft.	$530,427
5380 Richardville Rd, Lafayette, IN - Beds \| 2.5 Baths \| 1959 Sq. Ft.	$331,962

Address	Redfin Estimate
5520 Newcastle Rd, Lafayette, IN - Beds \| 1 Baths \| 1392 Sq. Ft.	$197,339
5435 Newcastle Rd, Lafayette, IN 2 Beds \| 1 Baths \| 1140 Sq. Ft.	$224,055
5701 Newcastle Rd, Lafayette, IN 7 Beds \| 6.5 Baths \| 7860 Sq. Ft.	$704,025
5370 Richardville Rd, Lafayette, IN 4 Beds \| 2 Baths \| 1584 Sq. Ft.	$323,372
5231 Ruby Ln, Lafayette, IN - Beds \| 2.5 Baths \| 2258 Sq. Ft.	$426,904
5360 Richardville Rd, Lafayette, IN - Beds \| 2.5 Baths \| 1728 Sq. Ft.	$331,525

Property information provided by IRMLS when last listed in 2024. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Monon homes for sale
Perrin homes for sale
Downtown Lafayette homes for sale
Highland Park homes for sale
New Chauncey homes for sale

47909 homes for sale
47901 homes for sale
47904 homes for sale
47905 homes for sale
47906 homes for sale

Houses for rent in Lafayette	Agents near me	Munster, IN homes for sale	Lafayette Housing Market
Houses for sale near me	Indianapolis, IN homes for sale	Crown Point, IN homes for sale
Land for sale near me	Carmel, IN homes for sale	Zionsville, IN homes for sale
Open Houses near me	Fishers, IN homes for sale	Lafayette Property Records
Condos for sale near me	Hammond, IN homes for sale	IN New Listings

Delphi homes for sale
Frankfort homes for sale
West Lafayette homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 47905, IN

Sale history for 5690 Newcastle Rd

Tax history for 5690 Newcastle Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 47905

Home values near 5690 Newcastle Rd

More real estate resources