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 = 1312 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 = 1312 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 = 1312 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;

9397 W Scenic Lake Drive
Laingsburg, MI 48848

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $869,900
Beds: 4
Baths: 4
Status: Active
SqFt: 4189
Agency: Coldwell Banker Hubbell BriarWood

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1972
Notes: All-Sports Scenic Lake, Craftsman style walkout ranch on a lush 1.12 acres with 180 ft of lake frontage, absolutely breathtaking views! One of the most prominent properties on Scenic Lake! Stylishly redesigned throughout - offering 4 Bedrooms, 3.5 Baths, and over 4,100 square feet of living space! New expansive covered front porch with stacked stone & vinyl shakes enhances the curb appeal. Striking lake views the moment you walk into the inviting foyer, open to the spacious great room boasting hardwood floors; two-sided brick fireplace; beamed cathedral ceiling; and custom transom windows allowing plenty of natural light! Maintenance free decking spans the entire lakeside of home - a perfect space for entertaining friends & family - overlooking tranquil landscape below w/ paver patios and stone step pathways following along a pond & waterfall encompassed by perennials. Kitchen overlooks the lake, offering ample Aristokraft cabinets with pantry, island prep space, granite counters, tile backsplash, appliance garage, built-in trash drawer, stainless steel appliances, reverse osmosis system, custom built-in desk, and door to the deck. Just off the kitchen, 1st floor laundry room doubles as mudroom with additional cabinetry & counter space set up for a beverage station along with a half bath and access to the deck and garage. Plenty of storage space in the oversized tandem garage with separate back overhead door for storing your sports car, atv, or water toys. Formal dining room and flex space recently updated with new lighting, windows, custom trim, & more. 4 bedrooms have all been completely updated including craftsman style doors and offer ample closet space. Oversized primary suite has sitting area and deck access to enjoy your morning coffee while relishing the sunrise. En suite with new tile, soaking tub with a lake view window, walk in ceramic shower with a euro door & pebbled tiled floor, and separate vanities. Walkout lower level includes game area with two-sided gas log masonry fireplace, exercise space, full bathroom, media room w/ French doors leading out to the new covered concrete patio, wet bar with built-in microwave and space for a refrigerator & range - perfect for entertaining! Also, 2 storage areas, 2 furnaces & A/C units, 2 hot water heaters, & 200 AMP service. Enjoy year-round water activities from your private sandy beach with fire pit and lakefront deck. Unbelievable landscape with irrigation. The perfect oasis! The Scenic Lake Association, includes a private park with sandy beach, volleyball court, play structure, & boat launch. Enjoy annual activities including 4th of July fireworks, end of summer glow party, and more! Minutes to I-69, Okemos, & East Lansing. Discover Lansing's best kept secret!
MlsNumber: 279490


Listing Provided By: Coldwell Banker Hubbell BriarWood, original listing
Name: Coldwell Banker Hubbell BriarWood
Phone: (517) 492-3398
Office Name: Coldwell Banker Realty-East Lansing
Office Phone: (517) 332-5100
Agent Name: Carrie Peters
Disclaimer: Copyright © 2024 Greater Lansing Association 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