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 = 788 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 = 788 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 = 788 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;

11499 W Nobles Chapel Road
Elberfeld, IN 47613
Tim Mason with RE/MAX REVOLUTION, original listing - (812) 664-0845

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,795,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3600 Square Feet
Agency: RE/MAX REVOLUTION
Agency Phone: (812) 664-0845

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Custom Modern Farmhouse on 27.98 Acres with Luxury Amenities and Endless Possibilities Step into timeless elegance with this stunning custom modern farmhouse, built in 2021 and offering 3,600 square feet of thoughtfully designed living space. Nestled on nearly 28 acres of serene countryside, this property blends luxury living with functional versatility, ideal for those seeking a dream home with income-producing or creative potential. Inside, you'll find 4 spacious bedrooms, 3 full bathrooms, and expansive 9-10 foot ceilings that amplify the natural light flooding through large windows. Exotic hardwood floors run throughout the main living areas, leading you to a grand entryway featuring a show-stopping chandelier. The great room boasts coffered ceilings, a ventless gas fireplace, and an open layout perfect for entertaining. The gourmet chef’s kitchen is a culinary dream with granite countertops, a huge walk-in pantry, high-end appliances, and both a water softener and reverse osmosis filtration system. The private owner’s suite offers a peaceful retreat, complete with his and hers walk-in closets, a custom marble walk-in shower, and double vanity. Upstairs, an oversized bonus room provides an ideal space for a home office or creative studio. Stay connected with fiber optic high-speed internet, perfect for remote work or streaming. Outdoors, enjoy the 8-foot deep saltwater pool for resort-style relaxation. A large 3-car attached garage offers ample storage, while the 40x80 pole frame building provides endless utility for hobbies, vehicles, or storage. Also included is a second, expansive structure that can easily be transformed into an event center, large daycare, recording studio, or creative venue. Featuring a 30x60 entertainment stage, kitchen facilities, and several flexible-use rooms, the possibilities are limited only by your imagination. Whether you're looking for a private estate, business opportunity, or creative haven, this rare gem delivers on every level.
MlsNumber: --
ListingId: 202516074


Listing Provided By: RE/MAX REVOLUTION, original listing
Phone: (812) 664-0845
Office Phone: (812) 664-0845
Agent Name: Tim Mason
Disclaimer: Copyright © 2025 Southwest Indiana 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