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

415 Chippewa Trail
Prudenville, MI 48651

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $212,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1438
Agency: M77 LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1975
Notes: Welcome to your dream Houghton Lake retreat! This charming 3 bed, 1 & 1/2 bath home offers the perfect blend of comfort & convenience, all within walking distance to the beautiful shores of Houghton Lake. As you step inside, you'll be greeted by a warm & inviting atmosphere, with tasteful updates & modern amenities throughout. The spacious living room features a cozy gas fireplace, perfect for chilly evenings or intimate gatherings with loved ones. Prepare to be impressed by the recently renovated kitchen, boasting new countertops, sleek appliances, & ample cabinet space for all your culinary needs. Adjacent to the kitchen is a delightful three seasons room, where you can relax & unwind. The master bedroom boasts a new large walk-in shower, offering a luxurious retreat after a day spent by the lake. Two additional bedrooms provide plenty of space for guests or a growing family. Outside, the fun continues with a generously sized lot spanning approximately half an acre. Take a dip in the hot tub nestled within a charming wood structure, complete with a galvanized roof for added durability and style. The fenced backyard offers privacy & security, perfect for children & pets to play freely. This property is not only a haven for relaxation but also a paradise for outdoor enthusiasts. With public access to Houghton Lake, you can enjoy fishing, boating, & water sports with ease. Plus, with RV hookup on the garage, you can easily accommodate guests or explore the great outdoors on your own adventures. Additional features include central air conditioning, a water softener with RO system in the kitchen, on-demand hot water heater, gutter shields, & central vacuum system for added convenience. The exterior has been freshly painted with a professional spray job & power washing, while new windows installed in 2019 ensure energy efficiency and curb appeal. Don't miss your chance to own this slice of paradise by Houghton Lake, where every day feels like a vacation. Schedule your private showing today!!
MlsNumber: 20240033789


Listing Provided By: M77 LLC, original listing
Name: M77 LLC
Phone: (248) 649-7200
Office Name: Keller Williams Somerset
Office Phone: (248) 649-7200
Agent Name: James T Silver
Disclaimer: Copyright © 2024 Realcomp Limited II. 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