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

1541 Stanlake Drive
East Lansing, MI 48823

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 5
Baths: 4
Status: Active
SqFt: 3904
Agency: Coldwell Banker Hubbell BriarWood

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1969
Notes: Oh my! Stunning 4600 (+/-) square foot Al White built livable family home. Deceiving from outside with 5 bedrooms and 3 1/2 baths above grade! Lovely curb appeal with a pretty welcoming front porch. 9 ft ceiling heights on the main floor. The gleaming tiled floor foyer leads to the spacious living area anchored by an eye catching fireplace and the adjoining formal dining room with extensive crown molding, wainscoting and beamed ceilings. A dream gourmet brand new kitchen with gleaming quartz countertops, subway tile backsplash, loads of cabinetry, wonderful new appliances such as induction range, 2 door refrigerator plus two micro dual refrigerator drawers, double ovens, two drawer dishwasher, large eating bar, shiplap accent wall with a tv mount, and amazing built in China display with butcher block countertop! Easy access to the backyard for outdoor enjoyment. The comfortable hearth room/family room includes hardwood floors, beamed ceilings, built ins and a gorgeous fireplace. A first floor laundry including a window, sink, appliances and extra cabinetry plus a drop zone. Enjoy the wonderful updated half bath! Fabulous main floor primary suite with cathedral beamed ceilings, French door access to the new deck and rear yard. Wonderful primary bath with heated tiled floors, spacious shower with seat, euro door and yummy tile work, 2 separate vanities plus dressing table space, pretty chrome hardware plus separate stool area. Two additional main floor bedrooms with a full bath plus a back hall staircase to the second floor with two oversized charming bedrooms, one with a large walk in closet plus an updated full bath complete with subway tile, double vanity, granite countertops and black and white period styled tiled floor! Each of the upstairs bedroom have charming dormer windows! The full bath also has access through one of the bedrooms with a convenient door to the hallway. Walk in linen closet and adorable loft too! Spacious 2.5 garage. The finished lower level has an egress window, large media room, fireplace and wet bar with seating area, sink, oven and beautiful cabinetry! A home to be cherished to be sure! See list of some of the exciting upgrades. All fireplaces converted to gas with a new meter. Generac Generator. Newer vinyl windows. Furnace 2020 and air 2016. Keyless entry to garage. Quiet wonderful street in sought after Whitehills Subdivision. Walking distance to the neighborhood park and Whitehills Elementary School with sidewalk and street lights. Close to MSU, eateries, shopping, highway access and more! Seller reserves beverage refrigerator in basement, deep freezer in basement, basement refrigerator, light fixture in playroom, mounted televisions in kitchen and primary bedroom.
MlsNumber: 278398


Listing Provided By: Coldwell Banker Hubbell BriarWood, original listing
Name: Coldwell Banker Hubbell BriarWood
Phone: (517) 492-3398
Office Name: Coldwell Banker Realty-Okemos
Office Phone: (517) 349-4406
Agent Name: Lynne VanDeventer
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.


Local Real Estate Expert

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 = 1267 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;
Angela Averill
ASCIICentury 21 Affiliated
Call Today!: (517) 712-5949

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App