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;

11217 S State Road
Morrice, MI 48857
Donald Dowland with LPT Realty, original listing - (616) 942-2449

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $36,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: LPT Realty
Agency Phone: (650) 543-2753

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Unlock the door to your imagination and embark on the journey of a lifetime with this pristine parcel of land in the coveted Morrice locale. Here, on a canvas of 1.8 partially wooded acres, lies the opportunity to bring your dream home to life amidst the beauty of nature's embrace.<br /> Nestled in the heart of Morrice, this picturesque plot offers the ideal setting for your architectural masterpiece, limited only by the boundaries of your imagination. Whether envisioning a sprawling estate or a cozy retreat, the possibilities are as endless as the horizon stretching before you.<br /> Immerse yourself in the tranquility of your surroundings, where the gentle rustle of leaves and the sweet melody of birdsong provide the soundtrack to your days. With ample space to roam and explore, create your own private oasis, complete with lush gardens, tranquil water features, or whatever your heart desires.<br /> Embrace the freedom to design a home tailored to your unique lifestyle and preference. This prime location offers the perfect balance of privacy and convenience. With Sleepy Hollow State Park, Lansing, and Michigan State Campus just 30 minutes away, enjoy easy access to everyday essentials, while still feeling a world away from the hustle and bustle of city life.<br /> Don't miss your chance to stake your claim in this exceptional opportunity to build the home of your dreams. Let your imagination run wild and seize the opportunity to create a legacy that will be cherished for generations to come. Welcome home to endless possibilities.
MlsNumber: --
ListingId: 24051409


Listing Provided By: LPT Realty, original listing
Phone: (616) 326-5191
Office Phone: (616) 942-2449
Agent Name: Donald Dowland
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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