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

7880 N Red Hill Road
Ellettsville, IN 47429-9761
Alice Chastain with RE/MAX Acclaimed Properties, original listing - (812) 332-3001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2367 Square Feet
Agency: RE/MAX Acclaimed Properties
Agency Phone: (812) 332-3001

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Discover Your Dream Retreat – A 5-Acre Paradise! Welcome to an enchanting 5-acre, park-like sanctuary where nature and comfort blend seamlessly. This meticulously maintained home features 3 spacious bedrooms, 2 full baths, a loft overlooking the living room, and a versatile upstairs studio—perfect for creative spaces, work-from-home needs, or additional relaxation areas. Inside, the rustic charm and warm ambiance create a truly inviting haven. Step outside into your private paradise, where lush, raised irrigated garden beds overflow with strawberries, raspberries, rhubarb, asparagus, horseradish, and herbs. Stroll past flourishing persimmon and pear trees, all thoughtfully labeled, and explore a fenced-in arbor boasting apple, peach, pear, cherry, plum, and additional persimmon trees, along with abundant raspberries. A serene pond, stocked with largemouth bass, bluegill, catfish, and two triploid grass carp, provides the perfect setting for fishing or simply relaxing by the water’s edge. A barn and shed provide ample storage and workspace, while the extended 2.5-car garage ensures convenience. Enjoy the freedom of no homeowners’ association, allowing you to make this retreat truly your own. Recent updates, including a new roof and front gutters, offer peace of mind for years to come. Embrace the beauty and serenity of this incredible country setting—whether you’re gardening, fishing, entertaining, or simply unwinding in nature. This cherished home is waiting for new owners to create lasting memories. Don’t miss your chance to own this slice of paradise!
MlsNumber: --
ListingId: 202506165


Listing Provided By: RE/MAX Acclaimed Properties, original listing
Phone: (812) 322-6256
Office Phone: (812) 332-3001
Agent Name: Alice Chastain
Disclaimer: Copyright © 2025 Bloomington MLS, Inc. 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