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.
Closed
$427,000
5935 Houston Rd, West Lafayette, IN 47906
4beds
2,178sqft
Single Family Residence
Built in 2017
0.45 Acres Lot
$434,400 Zestimate®
$--/sqft
$2,566 Estimated rent
Home value
$434,400
$404,000 - $465,000
$2,566/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$2,566/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$2,566/mo
Rent Zestimate®
Refinance and save
$2,454/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$2,454/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: November 07, 2025 at 06:53am
Listed by:
LuAnn Parker Agt:765-490-0520,
Keller Williams Lafayette
Bought with:
Rebecca Rush, RB17001695
BerkshireHathaway HS IN Realty
Source: IRMLS,MLS#: 202534520
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
- Main level bedrooms: 2
Bedroom 1
- Level: Main
Bedroom 2
- Level: Main
Dining room
- Level: Main
- Area: 121
- Dimensions: 11 x 11
Kitchen
- Level: Main
- Area: 169
- Dimensions: 13 x 13
Living room
- Level: Main
- Area: 169
- Dimensions: 13 x 13
Heating
- Propane
Cooling
- Central Air
Appliances
- Included: Disposal, Dishwasher, Microwave, Refrigerator, Washer, Gas Cooktop, Dryer-Electric, Humidifier, Iron Filter-Well Water, Double Oven, Water Filtration System, Gas Water Heater, Water Softener Owned
- Laundry: Electric Dryer Hookup, Main Level, Washer Hookup
Features
- Ceiling Fan(s), Vaulted Ceiling(s), Walk-In Closet(s), Stone Counters, Double Vanity, Stand Up Shower, Tub and Separate Shower, Tub/Shower Combination, Main Level Bedroom Suite, Custom Cabinetry
- Flooring: Hardwood, Vinyl, Brick
- Windows: Double Pane Windows
- Basement: Walk-Out Access,Partially Finished,Concrete
- Number of fireplaces: 1
- Fireplace features: Living Room, Gas Log
Interior area
- Total structure area: 2,786
- Total interior livable area: 2,178 sqft
- Finished area above ground: 1,465
- Finished area below ground: 713
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage Door Opener, Concrete
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck
- Has spa: Yes
- Spa features: Jet Tub
- Has view: Yes
- Waterfront features: Waterfront, Waterfront-High Bank, River Front, River
- Body of water: Wabash River
- Frontage length: Water Frontage(77.8)
Lot
- Size: 0.45 Acres
- Features: Few Trees, Sloped, Rural, Landscaped
Details
- Parcel number: 790343360042.000017
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Stone, Vinyl Siding
- Roof: Shingle
Condition
- New construction: No
- Year built: 2017
Utilities & green energy
- Electric: REMC
- Sewer: Septic Tank
- Water: Well
Community & neighborhood
Security
- Security features: Carbon Monoxide Detector(s), Smoke Detector(s)
Community
- Community features: None
Location
- Region: West Lafayette
- Subdivision: None
Other
Other facts
- Listing terms: Conventional,VA Loan
Price history
| Date | Event | Price |
|---|---|---|
| 11/6/2025 | Sold | $427,000-1.8% |
Source:  IRMLS #202534520 Report a problem | ||
| 9/24/2025 | Pending sale | $435,000 |
Source: IRMLS #202534520 Report a problem | ||
| 8/28/2025 | Listed for sale | $435,000+3525% |
Source: IRMLS #202534520 Report a problem | ||
| 11/21/2016 | Listing removed | $12,000$6/sqft |
Source: F C Tucker/Lafayette Inc #201651033 Report a problem | ||
| 11/8/2016 | Listed for sale | $12,000$6/sqft |
Source: F C Tucker/Lafayette Inc #201651033 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $1,619 +8.4% | $273,600 +6.9% |
| 2023 | $1,494 +5.9% | $255,900 +15.5% |
| 2022 | $1,411 -52.4% | $221,600 +5% |
Find assessor info on the county website
Neighborhood: 47906
Nearby schools
GreatSchools rating
- 7/10Battle Ground Elementary SchoolGrades: K-5Distance: 1.2 mi
- 7/10Battle Ground Middle SchoolGrades: 6-8Distance: 5.5 mi
- 10/10William Henry Harrison High SchoolGrades: 9-12Distance: 5.3 mi
Schools provided by the listing agent
- Elementary: Battle Ground
- Middle: Battle Ground
- High: William Henry Harrison
- District: Tippecanoe School Corp.
Source: IRMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$434,400
2% more
+$8,688
With Zillow Showcase(estimated)
$443,088
- Indiana
- Tippecanoe County
- West Lafayette
- 47906
- 5935 Houston Rd