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

6925 W County Road 325 S
Greencastle, IN 46135
Rachael Phillips with In-Site Real Estate Services, original listing - (765) 676-6000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $435,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2956 Square Feet
Agency: In-Site Real Estate Services
Agency Phone: (765) 676-6000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Nestled in complete privacy on a stunning 5-acre wooded lot, this custom-built ranch with 4 bedrooms, 2.5 baths, and a walk-out basement is a rare find. Words like "pristine" hardly capture the true essence of this home-every detail showcases exceptional quality and craftsmanship. The kitchen boasts brand-new custom cabinetry, quartz countertops, a stylish tile backsplash, and new appliances. Throughout the home, fresh paint, updated lighting, new baseboards, and laminate flooring create a modern and inviting atmosphere. The main-level bathrooms have been beautifully renovated with custom vanities, upgraded cabinets, new toilets, and walk-in showers. The walk-out basement features a spacious multipurpose room, a newly added half bath, gas log fireplace and extra storage space. Beyond the stunning cosmetic upgrades, significant mechanical improvements ensure lasting comfort and efficiency. These include a brand-new furnace and A/C system, a new roof on both the house and 24x30 detached garage, A generator hookup provides added security, offering peace of mind in any weather. Outdoor enthusiasts will appreciate the natural beauty and functionality of the property. The partially fenced backyard (with 5-foot fencing), a spacious patio, and a large covered front porch offer ideal spaces for relaxation, pets, and family gatherings. Abundant mature trees and frequent wildlife sightings enhance the property's serene and picturesque setting. Located in the Greencastle School District, this exceptional home offers privacy, modern updates, and an unbeatable outdoor experience. Don't miss the opportunity to make it yours!
MlsNumber: --
ListingId: 22026657


Listing Provided By: In-Site Real Estate Services, original listing
Phone: (317) 679-1226
Office Phone: (765) 676-6000
Agent Name: Rachael Phillips
Disclaimer: Copyright © 2025 MIBOR Service Corporation. 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