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;

8615+ Rapid City Road
Rapid City, MI 49676

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $559,000
Beds: 3
Baths: 1
Status: Active
SqFt: 1878
Agency: ER Up North Properties LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1930
Notes: Welcome to a truly exceptional opportunity! TWO HOMES ON ONE PARCEL! A delightful 3-BR, 1-BA ranch-style home, sharing a spacious 1.26-acre lot with an adorable 2-BR, 1.5-BA home. Main house showcases LP Smart Diamond siding, a new shingle roof in 2022, accented black-trimmed windows and house. Inside, main floor living where the open kitchen, dining room take center stage. Updated backsplash, countertops, appliances, and an island. The dining room features a natural fireplace crafted with local stone, wood floors, and a sliding door. The cozy living room boasts tile floors, a brick wall, and a convenient sliding door opening to the fenced-in backyard. A versatile multi-use room, currently a workout space, offers porcelain plank tile, in-floor heating, new drywall, paint, and windows and doors from Paradigm. Fully remodeled bathroom, featuring a stunning walk-in shower with a glass door, wood ceiling, and a new vanity and sink. The fenced-in backyard and sun screen-covered back patio. Also included a 24X48 pole barn w/ new metal roof, new siding, electric, and cement floor. The second, a custom, stick-built home offers 2-BR and 1.5 BA, overlooking the scenic Rapid River. Built in 2007, featuring a one-car attached garage, large windows, a covered deck made from reclaimed redwood, and tall ceilings create an open and spacious feel. The kitchen, complete with a movable island, cooktop, and microwave/wall convection oven. The master bedroom includes a master bath with laundry. The additional bedroom/office shares a half bath. Electric baseboard heat ensures cost efficiency, and all rooms are insulated for zone heating. A new front porch enhances the charm of this riverside retreat. Situated in Clearwater Township, these residences are just a stone's throw from Rapid River, Torch Lake, public accesses, boat launches, and the Famous Sandbar. Rapid City amenities, including a post office, school, and shopping, are easily accessible. Centrally located.
MlsNumber: 1918161


Listing Provided By: ER Up North Properties LLC, original listing
Name: ER Up North Properties LLC
Phone: (231) 883-4509
Office Name: Up North Properties
Office Phone: (231) 498-2498
Agent Name: Sarah Burlingame
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