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','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

6199 N County Road 200 E
Brazil, IN 47834
MOLLY SCHOPMEYER with EMMERT REALTY, original listing - (812) 448-8580

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $645,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5320 Square Feet
Agency: EMMERT REALTY
Agency Phone: (812) 448-8580

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome to your family’s dream home! This spacious 5-bedroom, 3.5-bath gem sits on 5 peaceful acres, set back from the road with wooded backdrop, offering privacy, space, and endless possibilities for family fun. Inside, you’ll love the open-concept main level, perfect for everyday living and making memories together. The heart of the home is a nice, oversized kitchen and living area that looks out onto a fully enclosed indoor gymnasium—a rare and exciting feature for kids and active families alike! Also on the main floor: a relaxing master suite, two additional bedrooms, a cozy sunroom, a dedicated office (great for homework or working from home), dining room, and a large laundry/mudroom to keep everything organized. The finished walk-out basement is ideal for teens, guests, or multigenerational living. It includes two more bedrooms, 1.5 bathrooms, a weight room, and a large family room—plus room to add a kitchenette and second laundry area if you’d like. Outside, the fenced backyard is ready for all kinds of family fun. Roast marshmallows around the firepit, relax in the hot tub, or just enjoy the peace and quiet. And with a 3-car attached garage plus a 2-car detached garage, there’s plenty of space for bikes, toys, and tools. This is more than a house…it’s a place where your family can grow, play, and feel right at home. Don’t miss out on this one-of-a-kind property!
MlsNumber: --
ListingId: 106071


Listing Provided By: EMMERT REALTY, original listing
Phone: (812) 230-8107
Office Phone: (812) 448-8580
Agent Name: MOLLY SCHOPMEYER
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