This home's estimate is 7.8% higher than the average sale price ($315K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate

























5251 N Substation Rd, Attica, IN 47918
About this home
Country living at its finest. 3 bedroom, 2 bath split ranch with 1736 square feet has been updated with new flooring and new carpet coming in 2 bedrooms. One bedroom used as workout room, new french doors to back deck and brand new 3 car detached garage. This one of a kind gem is nestled upon 5 wooded acres with 2 creeks, apple, peach and pear orchard, 2 outbuildings, and strawberry patch. Beautiful views from the spacious front porch. 2 living areas, wood burner saves tremendously on heating bills. MUST SEE! Contingent upon seller finding suitable housing. 20 Minutes to Lafayette, schools and shopping!
Redfin Estimate
Earn from this home
Get cash now or lower your monthly rate
List your home for rent
Market trends in 47918, IN
Last updated August 2026
Buyer's Market
Seller's Market
Balanced market
+0.0% MoM
See all
Provided by Redfin
Sale history for 5251 N Substation Rd
$101/sq ft
$104/sq ft
$74/sq ft
Tax history for 5251 N Substation Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Parking/Garage Information
- Has Garage
- # of Garage Spaces: 3
- Parking Features: Off Street, Detached
Interior
- Virtual Tour
- Bathroom Information
- # of Full Bathrooms: 2
- # of Main Level Bathrooms: 2
- Heating & Cooling
- Has Cooling
- Cooling: Central Air
- Has Heating
- Heating: Propane, Wood
- Interior Features
- Appliances: Dishwasher, Microwave, Refrigerator, Electric Cooktop, Electric Oven, Electric Range
- Room Information
- # of Rooms Total: 7
- Laundry Features: Main Level
- Basement Details: Crawl Space
Exterior
- Building Information
- Above Grade Finished Area: 1,736
- # of Stories Total: 1
- Construction Materials: Vinyl Siding
- Property Features
- Other Structures: Outbuilding
- Property Information
- Property Type: Residential
- Property Sub Type: Single Family Residence
- Raw Mls Property Sub Type: Site-Built Home
- Lot Information
- Lot Features: Level, Wooded
- Lot Size Dimensions: 5
- Lot Size Acres: 5
Financial
- Tax Information
- Tax Annual Amount: $1,139.58
Utilities
- Utility Information
- Water Source: Well
- Sewer: Septic Tank
Location
- Schools Information
- School District: Attica Cons.
- Elementary School: Attica
- Middle Or Junior School: Attica
- High School: Attica
- Location Information
- Directions: SR 25 W, R on 510 S, L on 900 W, R on 600 S, L on Substation Rd. Home on L.
- Subdivision Name: None
Public facts
- Beds: —
- Baths: 2.0
- Sq. Ft.: 1,736
- Stories: 1.0
- Lot Size: 5 acres
- Style: Single Family Residential
- Year Built: 2002
- Year Renovated: 2002
- County: Fountain County
- APN: 230228132001000003
Other
- Listing Information
- List AOR: Lafayette Board of REALTORS
- AttributionContact: Agt: 765-479-3773
Around this home
Schools
Public PreK-5 • Assigned • 7.3mi
Public 6-12 • Assigned • 8.0mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 101° expected this year, 17 days in 30 years
0% chance of strong winds in next 30 years
0 unhealthy days expected this year, 0 days in 30 years
Sun exposure
In this area, properties receive around 10.1 hours in June and 3.4 hours in December, placing it below the U.S. average for solar exposure.
Is this your home?
Track this home’s value and nearby sales activity
Nearby similar homes
New listings for sale in 47918
Home values near 5251 N Substation Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 3 Baths | 2091 Sq. Ft. | $437,023 |
3 Beds | 1 Baths | 2016 Sq. Ft. | $298,778 |
| Address | Redfin Estimate |
|---|---|
- Beds | 2 Baths | 1928 Sq. Ft. | $308,070 |
3 Beds | 2 Baths | 1152 Sq. Ft. | — |
| Address | Redfin Estimate |
|---|---|
3 Beds | 3 Baths | 2348 Sq. Ft. | $402,936 |
4 Beds | 2.5 Baths | 4752 Sq. Ft. | $680,765 |
More real estate resources
- Cities
- Zip Codes
- Popular Searches
| Danville homes for sale | |||
| Lafayette homes for sale | |||
| West Lafayette homes for sale |
| 47993 homes for sale | |||
| 47918 homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
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.
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.
























United States
Canada