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;

212 Arrowhead Drive
Prudenville, MI 48651

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $317,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1470
Agency: COLDWELL BANKER MT. PLEASANT REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1989
Notes: Beautiful Houghton Lake area home offers 3 bedrooms 2 baths, and sits on a quiet hill with a babbling creek! Home offers an open floor plan overlooking a wall of windows to the multi-level deck, creek, and spacious yard! Stunning maple kitchen is open to beautiful vaulted ceilings over the living room. Entertain friends at the Granite island bar and a walk-in kitchen pantry with shelving so your have everything nice and organized for your cooking needs. This nicely updated home features new flooring throughout, new Whirlpool fingerprint-free stainless appliances, including side by side ice maker fridge, built in microwave, dishwasher with stainless interior, a 5 burner stove, as well as a washer/dryer. Other updates include new central air and condenser. Seller says he loves the views from the Great room and Loft, as his home offers amazing views (every season), of Denton Creek and its beautiful landscape. You can count on seeing ducks, turtles, fish and more! Own the land on both sides of the Creek as the land across the creek is a pie shape lot which is part this offering. Fish off your dock or have a fire out on the spacious lawn with your besties! Love to kayak? Enjoy 'effortless kayaking' into Houghton Lake (the current is never difficult). Just off M55, this home is close to shopping, and Houghton Lake amenities (access to Houghton Lake is 800 feet away) and best of all, its move in ready to boot! Home is freshly painted with neutral colors throughout and has quality wood blinds in kitchen, baths, and bedrooms. Master on-suite is up the open staircase to the private 2nd level with loft sitting area, walk in closet and private full bath. Houghton Lk is Michigans largest inland lake; famous for summer water sports and winter ice fishing, ATV and snowmobile trails. An 8x10 garden shed can store those supplies! Are you ready to buy your new home and get settled? Measurements are M/L and buyer must verify.
MlsNumber: 1920049


Listing Provided By: COLDWELL BANKER MT. PLEASANT REALTY, original listing
Name: COLDWELL BANKER MT. PLEASANT REALTY
Phone: (989) 773-5972
Office Name: COLDWELL BANKER MT. PLEASANT REALTY
Office Phone: (989) 773-5972
Agent Name: Deb Morris
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