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

C Sw Jesses Trail
South Boardman, MI 49680
Kelly Clark with The Mitten Real Estate Group, original listing - (231) 421-1970

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $59,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: The Mitten Real Estate Group
Agency Phone: (231) 421-1970

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Parcels A & B combined at a discount. I could do the typical vacant land remarks & tell you about the 2 lots that are zoned AG, one with 2.69 acres & the other 3.46 acres just 25 minutes from Traverse City. You can buy them both for a total of just over 6 acres. I could write about the surrounding state land, the abundance of wildlife and trails. Instead, I ask you to put on the '80s hit Jessie's Girl by Rick Springfield and sing along... Jesse's Trail's a find. Jesse's Trails a good find of mine. But Lately something's changed in my sellers mind Jesse's Trl needs a buyer just look at this sign. Just come see it with your own eyes Yeah you'll love it in the back woods I just know it And you'll build your dream home with great, great design You know you'll wish that you had Jesse's Trail You'll wish that you had Jesse's Trail Where can you find some acreage like that? There's lots of trees to give you shade There's wildlife at night to softly serenade You know you've got acreage options 3.4 or 2.4 Or buy em both together for a little bit more Just come see it with your own eyes Yeah you'll love it in the backwoods I just know it . And you'll build your dream home With great, great design You know you'll wish that you had Jesse's Trail You'll wish that you had Jesse's Trail Where can you find some acreage like that? Like Jesse's Trail You'll wish that you had Jesse's Trail Where can you find some acreage Where can you find some acreage like that? I know you look on Zillow all the time Wondering where you can find a deal I've got 6 acres, peace & quiet At this price it's a helluva steal I'll tell you where you can find a parcel like that. Like Jesse's Trail You know you'll wish that you had Jesse's Trail You'll wish that you had Jesse's Trail It's where you'll find a parcel like that You'll want Jesse's Trl It's where you'll find some acreage like that.
MlsNumber: --
ListingId: 1929060


Listing Provided By: The Mitten Real Estate Group, original listing
Phone: (231) 392-3444
Office Phone: (231) 421-1970
Agent Name: Kelly Clark
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors 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