Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 712 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 712 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 712 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

10999 N State Road 59
Brazil, IN 47834

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $584,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1800 Square Feet
Agency: Berkshire Hathaway HomeServices Newlin-Miller REALTORS®
Agency Phone: (812) 478-1900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Picturesque homestead located in rural Clay County just north of Brazil! Situated on just under 40 acres, this wooded paradise is a nature lovers dream! As you enter the front door, the hardwood floors flow throughout the open concept design perfect for entertaining or relaxing with the family! The kitchen features an abundance of cabinets/countertop space, breakfast bar seating, and tile backsplash. The primary suite has great closet space and private bath that also accesses the laundry room. Bedrooms #2 and #3 are both spacious with large closets and share a full bathroom. The oversized laundry room has a laundry sink and room for additional appliances. Outside, there is a covered front porch and covered rear deck to relax and enjoy the views. There are two large pole barns also included! The first, a 32' x 40' with electric, is perfect for car storage and plenty of additional room. The 2nd pole barn (32' x 54') is currently set up as a shop/additional storage. This barn is insulated (walls and attic), has 220 electric, has water line stubbed in, and pre-plumbed for a future bathroom/wet bar/etc! The rolling wooded ground is home to tons of wildlife with regular trail cam sitings of deer, turkey, bobcats, and beavers! There is a hunting blind already on the property and will stay. Call/text a local agent to find out more or schedule a tour of this amazing property!
MlsNumber: --
ListingId: 105997


Listing Provided By: Berkshire Hathaway HomeServices Newlin-Miller REALTORS®, original listing
Phone: (812) 249-6955
Office Phone: (812) 478-1900
Agent Name: ERIC MILLER
Disclaimer: Copyright © 2025 Terre Haute Area Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App