OFF MARKET

Off market nov 2025 for $427K

$425,302

•

2,178

sq ft

5935 Houston Rd, West Lafayette, IN 47906

About this home

Welcome to your dream riverfront retreat! This stunning Downham custom built four-bedrooms, three-bath ranch is perfectly perched on a high bank, offering breathtaking views of the river. The walkout basement provides easy access to the river's edge, perfect for enjoying the outdoors and storage for all the toys. Inside you'll find a spacious and open floor plan, custom cabinetry, granite countertops, and ample light. Whether you're relaxing on the deck, fishing from the bank, paddling and simply soaking up the peaceful surroundings, this home is a true sanctuary. Meant to be the forever home for the sellers until the grandchildren called them closer. Nature lovers dream within close proximity to Prophets Town State Park.

Single-familyProperty Type

2017Year Built

0.45 acresLot Size

$195Est. Price/Sq.Ft.

2 car garageParking

Listed by LuAnn Parker • Keller Williams Lafayette

Contact: Agt: 765-490-0520

Bought with Rebecca Rush • BerkshireHathaway HS IN Realty

Redfin checked: a few seconds ago

•Source:IRMLS #202534520

Redfin Estimate

$425,302

$1,698 since sold in November 2025$7,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 15.5% lower than the average sale price ($503K) of 6 comparable homes.

SOLD JUN 18, 2026
$530,000
A
4 beds3.5 baths2,946 sq ft
5144 Greenview Ct, Battle Ground, IN 47920
SOLD OCT 27, 2026
$549,900
B
4 beds2.5 baths3,350 sq ft
5110 Centerview Dr, Battle Ground, IN 47920
SOLD JUN 11, 2026
$380,000
C
3 beds2.5 baths1,984 sq ft
2499 Taino Dr, West Lafayette, IN 47906
SOLD SEP 15, 2026
$647,500
D
4 beds3.5 baths4,114 sq ft
2529 Mar Ruth Dr, Lafayette, IN 47905
SOLD JUL 20, 2026
$518,000
E
4 beds2.5 baths3,271 sq ft
2172 Foxmoor Ln, Lafayette, IN 47905
SOLD AUG 19, 2026
$393,000
F
3 beds2.5 baths2,192 sq ft
2408 Natalie 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,184/mo

Redfin rental estimate

List your home for rent

Market trends in 47906, IN

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

97.7%

0.4% MoM

Median sale price

$405K

$15K MoM

Avg. days on market

50d

10 days MoM

Recently sold homes

133

29 MoM

New listings for sale

NEW 11 HRS AGO
$269,900
3 beds2 baths1,433 sq ft
2415 Fleming Dr, West Lafayette, IN 47906
NEW 33 HRS AGO
$575,000
4 beds2.5 baths4,600 sq ft
4010 Black Forest Ln, West Lafayette, IN 47906
$499,000
3 beds3.5 baths2,260 sq ft
125 Parkerwood Ln, West Lafayette, IN 47906
$499,900
5 beds3.5 baths3,536 sq ft
3290 Secretariat Cir, West Lafayette, IN 47906
$379,000
3 beds2 baths2,050 sq ft
2805 Grosbeak Ln, West Lafayette, IN 47906
OPEN SAT, 1PM TO 3PM
$295,000
2 beds2 baths1,626 sq ft
1755 Sandpiper Dr, West Lafayette, IN 47906
$439,900
3 beds2 baths1,857 sq ft
374 Burnley Dr, West Lafayette, IN 47906
$245,000
3 beds2 baths1,592 sq ft
606 Westview Cir, West Lafayette, IN 47906
VIDEO TOUR
$599,000
5 beds2.5 baths4,686 sq ft
3614 Chancellor Way, West Lafayette, IN 47906
$434,900
3 beds2 baths2,005 sq ft
4356 Foal Dr, West Lafayette, IN 47906
See all

Provided by Redfin

Sale history for 5935 Houston Rd

Year

Property tax

Land + Additions

Assessment*

2025

$1,619 (−9.2%)

$16,300 + $266,600

$282,900

2024

$1,782 (+10.0%)

$16,300 + $257,300

$273,600

2023

$1,619 (+8.4%)

$16,300 + $239,600

$255,900

2022

$1,494 (+5.9%)

$16,300 + $205,300

$221,600

2021

$1,411 (−52.4%)

$16,300 + $194,700

$211,000

2020

$2,963 (+2.0%)

$16,300 + $187,100

$203,400

2019

$2,905 (+82.8%)

$16,300 + $183,000

$199,300

2018

$1,589 (+2,897.9%)

$16,300 + $95,100

$111,400

2017

$53 (−21.2%)

$16,300

2016

$67 (−1.1%)

$16,300 + $3,100

$19,400

2015

$68 (−12.8%)

$16,300 + $3,100

$19,400

2013

$78

$16,300 + $3,000

$19,300

Tax history for 5935 Houston Rd

Year

Property tax

Land + Additions

Assessment*

2025

$1,619 (−9.2%)

$16,300 + $266,600

$282,900

2024

$1,782 (+10.0%)

$16,300 + $257,300

$273,600

2023

$1,619 (+8.4%)

$16,300 + $239,600

$255,900

2022

$1,494 (+5.9%)

$16,300 + $205,300

$221,600

2021

$1,411 (−52.4%)

$16,300 + $194,700

$211,000

2020

$2,963 (+2.0%)

$16,300 + $187,100

$203,400

2019

$2,905 (+82.8%)

$16,300 + $183,000

$199,300

2018

$1,589 (+2,897.9%)

$16,300 + $95,100

$111,400

2017

$53 (−21.2%)

$16,300

2016

$67 (−1.1%)

$16,300 + $3,100

$19,400

2015

$68 (−12.8%)

$16,300 + $3,100

$19,400

2013

$78

$16,300 + $3,000

$19,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

0.45 Acres

Year renovated

2017

Sq. Ft.

2,065

Year built

2017

Style

Single Family Residential

County

Tippecanoe County

APN

790343630042000017

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: Garage Door Opener, Concrete, Off Street, Garage, 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
Has Heating
Heating: Propane

Interior Features
Interior Features: Vaulted Ceiling(s), Walk-In Closet(s), Ceiling Fan(s), Stone Counters, Master Downstairs
Appliances: Disposal, Dishwasher, Microwave, Refrigerator, Washer, Humidifier, Water Softener Owned, Gas Cooktop, Double Oven, Water Purifier, Gas Water Heater, Dryer, Water Heater
Flooring: Hardwood, Vinyl, Brick
Has Fireplace
# of Fireplaces: 1
Fireplace Features: Living Room, Gas Log

Room Information
# of Rooms Total: 10
Laundry Features: Washer Hookup, Electric Dryer Hookup, Main Level
Has Basement
Basement Details: Partially Finished, Walk-Out Access

Exterior

Exterior Features
Patio And Porch Features: Deck
Roof: Shingle

Building Information
Above Grade Finished Area: 1,465
Below Grade Finished Area: 713
# of Stories Total: 1
Construction Materials: Stone, Vinyl Siding
Foundation Details: Concrete Perimeter

Property Features
On Waterfront
Waterfront Features: River Front
Security Features: Smoke Detector(s), Carbon Monoxide Detector(s)
Accessibility Features: Therapeutic Whirlpool

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

Lot Information
Lot Features: Sloped, Waterfront, Landscaped, Wooded
Frontage Type: Waterfront
Water Body Name: Wabash River
Lot Size Dimensions: Slope
Lot Size Acres: 0.45

Financial

Tax Information
Tax Annual Amount: $1,782.02

Utilities

Utility Information
Water Source: Well
Sewer: Septic Tank

Location

HOA Information
Association Amenities: None

Schools Information
School District: Tippecanoe School Corp.
Elementary School: Battle Ground
Middle Or Junior School: Battle Ground
High School: William Henry Harrison

Location Information
Directions: Take 235 out of Battleground turn left right before bridge and follow back to home on the right.
Subdivision Name: None

Community Information
Community Features: None

Public facts

Beds: 4
Baths: 3.0
Sq. Ft.: 2,065
Stories: 1.0
Lot Size: 0.45 acres
Style: Single Family Residential
Year Built: 2017
Year Renovated: 2017
County: Tippecanoe County
APN: 790343630042000017

Home facts updated by county records on Oct 16, 2026

Other

Listing Information
List AOR: Lafayette Board of REALTORS
AttributionContact: Agt: 765-490-0520

Around this home

Schools

K - 12
Preschool & daycare

Battle Ground Elementary School

Public K-5 • Assigned • 1.2mi

7/10

Battle Ground Middle School

Public 6-8 • Assigned • 5.4mi

9/10

William Henry Harrison High School

Public 9-12 • Assigned • 5.2mi

9/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, 17 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

3/10 Air Factor

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

Provided by First Street

Historical weather

West Lafayette, IN • 47906

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.2 hours in June and 3.3 hours in December, placing it below the U.S. average for solar exposure.

10.2 hrs

3.3 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$405,000 – $490,000

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

Nearby similar homes

NEW 33 HRS AGO

$129,900

2 beds1 bath1,271 sq ft

2109 Moore St, Lafayette, IN 47904

Family room • Dining area • Kitchen

3D WALKTHROUGH

$484,000

5 beds3 baths3,034 sq ft

3000 Hamilton St, West Lafayette, IN 47906

Fenced-in corner lot • 9,148 sq ft lot • 2 garage spots

$230,000

2 beds1 bath1,268 sq ft

3303 Old SR 25 N, Lafayette, IN 47905

Spacious dining room • Generous driveway • Detached garage

$419,900

4 beds3.5 baths2,693 sq ft

5772 Galena St, West Lafayette, IN 47906

Finished basement • Large eat-in kitchen • Custom cabinetry

$285,000

3 beds2 baths1,413 sq ft

2487 Matchlock Ct, West Lafayette, IN 47906

Quiet cul-de-sac • Open floor plan • Abundant cabinetry

OPEN SAT, 12PM TO 2PM

$279,900

3 beds2 baths1,726 sq ft

2300 Wigeon Dr, Lafayette, IN 47905

Vaulted ceilings • Pass-through window • Walk-in closet

New listings for sale in 47906

NEW 11 HRS AGO

$269,900

3 beds2 baths1,433 sq ft

2415 Fleming Dr, West Lafayette, IN 47906

Open-concept layout • Walk-in closet • 7,736 sq ft lot

NEW 33 HRS AGO

$575,000

4 beds2.5 baths4,600 sq ft

4010 Black Forest Ln, West Lafayette, IN 47906

4.88 acre lot • 2 garage spots • Built 1978

$499,000

3 beds3.5 baths2,260 sq ft

125 Parkerwood Ln, West Lafayette, IN 47906

Quartz countertops • Tiled backsplash • 2,222 sq ft lot

$499,900

5 beds3.5 baths3,536 sq ft

3290 Secretariat Cir, West Lafayette, IN 47906

Family room • Formal dining room • Breakfast nook

$379,000

3 beds2 baths2,050 sq ft

2805 Grosbeak Ln, West Lafayette, IN 47906

Three car garage • Spacious backyard • One level living

OPEN SAT, 1PM TO 3PM

$295,000

2 beds2 baths1,626 sq ft

1755 Sandpiper Dr, West Lafayette, IN 47906

Prime location • Purdue university • Celery bog

$439,900

3 beds2 baths1,857 sq ft

374 Burnley Dr, West Lafayette, IN 47906

Open floor plan • Stainless appliances • Quartz countertops

$245,000

3 beds2 baths1,592 sq ft

606 Westview Cir, West Lafayette, IN 47906

Open-concept condo • Natural light • Vaulted ceilings

VIDEO TOUR

$599,000

5 beds2.5 baths4,686 sq ft

3614 Chancellor Way, West Lafayette, IN 47906

Finished basement • Updated kitchen • Private home office

Home values near 5935 Houston Rd

Data from public records.

Address	Redfin Estimate
5907 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 560 Sq. Ft.	$130,947
5867 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 1404 Sq. Ft.	$235,186
5911 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 755 Sq. Ft.	$133,554
5933 Huston Rd, West Lafayette, IN - Beds \| 2 Baths \| 1404 Sq. Ft.	$201,832
5831 Huston Rd, West Lafayette, IN 3 Beds \| 2 Baths \| 1488 Sq. Ft.	$304,928
5850 Huston Rd, West Lafayette, IN - Beds \| 2 Baths \| 1658 Sq. Ft.	$289,149
6021 Huston Rd, West Lafayette, IN 3 Beds \| 2 Baths \| 2508 Sq. Ft.	$354,104

Address	Redfin Estimate
6135 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 1482 Sq. Ft.	$174,833
5823 Huston Rd, West Lafayette, IN 2 Beds \| 1 Baths \| 1448 Sq. Ft.	$207,224
5757 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 2233 Sq. Ft.	$295,278
5845 Huston Rd, West Lafayette, IN 3 Beds \| 2.5 Baths \| 2776 Sq. Ft.	$444,408
5903 Huston Rd, West Lafayette, IN 3 Beds \| 2 Baths \| 2210 Sq. Ft.	$361,353
5824 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 1352 Sq. Ft.	$253,430
6029 Huston Rd, West Lafayette, IN 3 Beds \| 1 Baths \| 2156 Sq. Ft.	$386,142

Address	Redfin Estimate
6201 Huston Rd, West Lafayette, IN 3 Beds \| 1 Baths \| 1344 Sq. Ft.	$214,647
5915 Huston Rd, West Lafayette, IN 2 Beds \| 1 Baths \| 936 Sq. Ft.	$266,907
6129 Huston Rd, West Lafayette, IN - Beds \| 1 Baths \| 720 Sq. Ft.	$139,409
5907 Huston Rd, West Lafayette, IN 2 Beds \| 1 Baths \| 1140 Sq. Ft.	$115,982
5861 Huston Rd, West Lafayette, IN - Beds \| 2 Baths \| 1008 Sq. Ft.	$215,992
5760 Huston Rd, West Lafayette, IN - Beds \| 1.5 Baths \| 1394 Sq. Ft.	$231,869

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

More real estate resources

Neighborhoods
Zip Codes
Cities
Popular Searches

Monon homes for sale
Barbarry Heights homes for sale
Downtown Lafayette homes for sale
New Chauncey homes for sale
University Farm homes for sale

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.

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

Houses for rent in West Lafayette	Agents near me	Munster, IN homes for sale	West 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	West Lafayette Property Records
Condos for sale near me	Hammond, IN homes for sale	IN New Listings

Delphi homes for sale
Lafayette homes for sale
Monticello homes for sale