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 = 1317 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 = 1317 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 = 1317 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 Pheasant Drive
Cadillac, MI 49601

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $95,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1512
Agency: Coldwell Banker Schmidt Family Of Companies

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1999
Notes: Welcome to Pheasant Ridge Mobile Home Park in Cadillac, MI, nestled on the serene south end of Cadillac, just a stone's throw away from the vibrant downtown scene. Presenting a stunning 3-bedroom, 2-bathroom doublewide mobile home, boasting a plethora of upgrades and meticulously maintained features. New Upgrades (Within the Last Year): This home has been lavished with recent enhancements including a brand-new roof, window screens, A/C unit, furnace, and a charming front porch, ensuring modern comfort and style. Recent Renovations (Within the Last 5 Years): Enjoy the peace of mind knowing that this residence has been thoughtfully updated with new skylights, skirting, stove, complete interior painting, plush carpet, sleek laminate flooring, water heater, and a beautifully coated deck. The kitchen boasts waterproof flooring, combining durability with elegance. Meticulously Maintained: This home has been lovingly cared for, with meticulous attention to detail evident throughout. Every corner exudes a sense of pride in ownership, promising a comfortable and inviting living experience for its fortunate new owners. $425 water, sewer, trash, road snow removal Nestled within the inviting Pheasant Ridge Mobile Home Park, residents benefit from a sense of community and convenience. Enjoy the tranquil surroundings while still being just moments away from the heart of downtown Cadillac, offering a wealth of dining, shopping, and entertainment options. Don't miss your chance to own this exceptional mobile home in the desirable Pheasant Ridge community. Schedule your showing today and start envisioning the countless memories waiting to be made in this quiet community
MlsNumber: 1919511


Listing Provided By: Coldwell Banker Schmidt Family Of Companies, original listing
Name: Coldwell Banker Schmidt Family Of Companies
Office Name: Schmidt Realtors
Office Phone: (231) 775-1737
Agent Name: Michael McGuire
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt 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