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

6475 N State Rd. 327 Road
Orland, IN 46776
Chad Marsh with Southern Marsh Realty, original listing - (517) 499-6132

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $179,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1536 Square Feet
Agency: Southern Marsh Realty
Agency Phone: (517) 499-6132

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Nestled in a charming neighborhood, this delightful 3-bedroom, 1.5-bathroom home is a perfect blend of comfort and functionality. As you approach, the first thing you'll notice is the convenience of the attached drive-through garage, measuring a spacious 16x32 feet. This unique feature not only offers ample space for two vehicles but also provides easy access to the backyard – a perfect setup for those who enjoy outdoor activities or gardening. Well-designed mudroom that includes a washer and dryer – a thoughtful touch that adds practicality to your daily routine. This space ensures that muddy shoes and clothes stay contained, leaving the rest of the house pristine. The open kitchen, complete with an inviting eating area. The kitchen has ample counter space, and cabinetry, making it a joy for both cooking enthusiasts and those who appreciate a well-appointed space for meals. The three bedrooms offer cozy retreats, each adorned with hardwood flooring that exudes warmth and timeless charm. The home also features a full unfinished basement, providing a blank canvas for customization or additional storage space, allowing you to tailor the space to your specific needs. During warm summer days, you'll appreciate the comfort of central air conditioning, ensuring a pleasant and cool indoor environment. When it's time to relax and enjoy the outdoors, step onto the back patio overlooking the spacious backyard. This private oasis is perfect for hosting gatherings, barbecues, or simply unwinding after a long day. Adding to the appeal is the home's proximity to Memorial Park, just a short walk away. This provides an excellent opportunity for recreation, picnics, and enjoying the beauty of the outdoors without venturing far from home. This company makes no warranty or representations about the contents of this data. It is the responsibility of the parties looking at the property to satisfy themselves as to accuracy of this information. Taxes were obtained from the local assessor and the taxes could change for the buyer after a closed transaction.
MlsNumber: --
ListingId: 202403491


Listing Provided By: Southern Marsh Realty, original listing
Phone: (517) 499-6132
Office Phone: (517) 499-6132
Agent Name: Chad Marsh
Disclaimer: Copyright © 2024 Northeastern 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