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;

6195 Nw Aarwood Road
Rapid City, MI 49676-9709
Frank Franco with REMAX Bayshore - Kalkaska, original listing - (231) 258-8046

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $255,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1080 Square Feet
Agency: REMAX Bayshore - Kalkaska
Agency Phone: (231) 258-8046

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: This Beautiful Home sits only 2 miles from Torch Lake and the Public Boat Launch!! A paved driveway will bring you up to the large detached garage/pole barn.(29'x39') Perfectly setup with cement floor, 2 large powered garage doors (10ft & 12ft), heated and cooled, Electric (200 amp), Insulated, with a completely enclosed lean to (29'x12') with its own garage door for access! Built off the other end of the garage/pole barn is an awesome 29'x17' Game/Bar Room that is heated and finished with laminate flooring, Tongue & Groove Walls and Ceiling, and a built in Live Edge Bar Top! Leaving the Garage/Pole Barn, you will see the large 1.3 acre lot with a Sprinkler System, Gardens, and Invisible Fence in place!! Entering the home, you will notice that it has been beautifully remodeled (2018) with Tongue & Groove, Quality Vinyl Lock Flooring, Updated Bathrooms, and Much More!! If you are worried about losing power during the wonderful Northern Michigan winters, then calm your nerves cause this home is set up for you to plug in your own generator to power both the home & garage/pole barn! Further bonuses that this home offers is New Metal Roof (2021) on the house and a New Drain Field (2023)! Come See for Yourself, you Will Not Be Disappointed!!
MlsNumber: --
ListingId: 1927039


Listing Provided By: REMAX Bayshore - Kalkaska, original listing
Phone: (231) 645-3767
Office Phone: (231) 258-8046
Agent Name: Frank Franco
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