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

715 Little Creek Path
Perry, MI 48872
Tracy Snyder with Impact Real Estate, original listing - (517) 402-6544

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $313,800
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1624 Square Feet
Agency: Impact Real Estate
Agency Phone: (517) 402-6544

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2025
Notes: Welcome to The Barcelona, a charming two-story home that combines timeless curb appeal with modern functionality. Boasting three spacious bedrooms, 2.5 baths, and an intelligently designed layout, this home is ideal for families and those who love to entertain. The full front porch adds undeniable charm, offering a peaceful retreat to enjoy the outdoors. Step inside to an entry that welcomes you with a convenient coat closet, leading you into the expansive open-concept living, dining, and kitchen areas. The kitchen is perfect for both cooking and entertaining, featuring a large island and built in pantry. The sliding patio doors in the dining room open to an outdoor haven, ideal for enjoying fresh air. Upstairs, the centrally located laundry room makes life simpler. The primary suite is an inviting sanctuary with its luxurious en-suite bath and ample closet space. Two additional bedrooms and a second full bath provide plenty of room for guests or growing families. With an attached 2-car garage and a full basement, The Barcelona offers endless storage or expansion possibilities. Oak Ridge Homes eliminates the need for a construction loan, making the home-buying process hassle-free. Their high-quality finishes ensure your home is as durable as it is beautiful. Plus, customization options are available to make The Barcelona uniquely yours. Built with expert craftsmanship and attention to detail, The Barcelona is designed to offer comfort, style, and the perfect space for your life. Call today to schedule your tour! **Photos are of a previously built home and may depict upgraes**
MlsNumber: --
ListingId: 11412803


Listing Provided By: Impact Real Estate, original listing
Phone: (517) 402-6544
Office Phone: (517) 402-6544
Agent Name: Tracy Snyder
Disclaimer: Copyright © 2025 My State MLS. 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