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;

11366 Orchard Drive
Rapid City, MI 49676

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2714
Agency: ER Up North Properties LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1990
Notes: Orchard Hills Living with shared Torch Lake beach front park is offered with this updated 3-bedroom, 2.5-bathroom home. Greeted with the newly updated and remodeled open-concept layout, perfect for both relaxation and entertaining. The spacious kitchen, boasting elegant granite countertops, ample storage with pull-out cabinets and a pantry, complemented by stainless steel appliances including a stove and dishwasher. The kitchen shares the open space with the dining and living room, all adorned with newly remodeled windows, flooring, and doors, creating a great space for gatherings with friends and family. The main floor owner's bedroom, complete with an attached private bathroom featuring a shower. Two additional well-appointed guest bedrooms share a full guest bathroom. Step outside through the sliding glass door off the dining room onto the back deck, where outdoor living awaits. Inside the fenced backyard, you'll find a patio, an outdoor gas fireplace, and a wood-burning fire pit, perfect for cozy evenings under the stars. For those who love the convenience of RVs or extra toys, an additional stone driveway complements the paved driveway and heated, drywalled attached garage. The second garage offers drive-through access to the backyard, making maneuvering a breeze. An storage shed in the backyard for gardening tools. Residents can join the Beach Club for access to a shared beach for a nominal yearly fee. Surrounded by lush greenery near the end of a peaceful cul-de-sac on a paved county-maintained road. Elk Rapids School District. Conveniently located near Torch River, Kewadin and Elk Rapids. Ready for immediate possession, this home presents an opportunity to experience the best of Orchard Hills living.
MlsNumber: 1921297


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