Title Page Background
DEBUG FN args: Array ( [0] => 1294 [1] => [2] => [3] => agent ) BEFORE: Site: 1294 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1294 Igate: njhud LocID: 1294 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1294 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1294 [1] => [2] => [3] => lender ) BEFORE: Site: 1294 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1294 Igate: njhud LocID: 1294 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1294 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1294 [1] => [2] => [3] => other ) BEFORE: Site: 1294 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1294 Igate: njhud LocID: 1294 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1294 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

14150 Pointe Road
Atlanta, MI 49709
Debbie Rolfsen with United Country Great Lakes Realty & Auction, original listing - (989) 785-3661

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $410,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2160 Square Feet
Agency: United Country Great Lakes Realty & Auction
Agency Phone: (989) 785-3661

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: --
Notes: The completely upgraded and remodeled home on Beautiful Rush Lake features an open kitchen, dining, and living room area where you can enjoy the views of the lake. Enjoy your morning coffee on the patio watching the beautiful sunrise, wildlife, and peace and quiet of the lake, or entertain family and friends grilling steaks and enjoying the sunsets of Rush Lake. Home offers 3 bedrooms, 2 full baths, Upper level features entry, main bedroom, laundry/utility room. The main level is spacious and offers open views of the lake, with a walkout to patio and outdoor entertaining and relaxation. Additional room on the lower level could be completed as another bedroom, office, exercise room, or your vision. Kitchen was completely renovated. Other upgrades include a two zone furnace for heating upstairs and main level, Air conditioning, all newer Anderson windows, newer appliances throughout, alarm system. Two single car garages plus an additional storage space have been updated plus a permanent carport for keeping your boat or pontoon. Rush Lake is a 224 acre All Sports Lake for Northern Pike, Lg & Small Mouth Bass, Bluegill and Perch. Large 2 car garage for all your tools /4 wheelers and winter gear. Amazing kayaking and viewing wildlife. Close to ORV trails in Elk Capital of MI
MlsNumber: --
ListingId: 201834184


Listing Provided By: United Country Great Lakes Realty & Auction, original listing
Phone: (317) 507-5985
Office Phone: (989) 785-3661
Agent Name: Debbie Rolfsen
Disclaimer: Copyright © 2025 Water Wonderland Board of Realtors®. 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