Title Page Background
DEBUG FN args: Array ( [0] => 1267 [1] => [2] => [3] => agent ) BEFORE: Site: 1267 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1267 Igate: njhud LocID: 1267 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 = 1267 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1267 [1] => [2] => [3] => lender ) BEFORE: Site: 1267 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1267 Igate: njhud LocID: 1267 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 = 1267 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1267 [1] => [2] => [3] => other ) BEFORE: Site: 1267 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1267 Igate: njhud LocID: 1267 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 = 1267 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6031 E Lake Drive
Haslett, MI 48840

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4086 Square Feet
Agency: Coldwell Banker Realty-Okemos
Agency Phone: (517) 349-4406

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Lake Lansing! On the water rare, rare, offering for this amazing 4,086+- square foot sprawling 3 bedroom 2 1/2 bath ranch home including a finished 2nd level bonus room, on 110 feet of direct water frontage! Enjoy year around activity on this all sports lake and close to the sailing club. Amazing curb appeal with metal covered dormer windows. 4-car heated garage including floor drains plus water. Bordered curved driveway. Lovely covered front porch. Custom one owner home was built with amazing quality and design flare throughout. Soaring ceilings, bay windows, tray ceilings and angles in most rooms. Architectural interest and the element of surprise everywhere you glance. The foyer entrance is two stories high with a special eyebrow window. Breathtaking water views in the over-sized great room. Stunning, full wall bank of windows floor to ceiling bringing the outside in! Fireplace, plus French doors to the over the top 4-seasons room offering 3 walls of windows plus access to the maintenance free deck including a gas grill. The kitchen was custom built by "Klein Cabinetry" and offers dovetail drawers, glass cabinets, solid surface countertops, center island with a breakfast counter, walk in pantry and planning desk. Beautiful arched pillared entrance to the dreamy dining area with three walls of windows plus water, water, water views. The library is simply amazing, featuring a fireplace, built-in desk in the window, special ceiling heights, and custom "Klein Cabinetry" unique built-in book shelving. The music room with French doors could easily be a formal dining room, living room, or your choice of use. The primary offers a big window, tray ceilings, generous size corner marble fireplace, plus access to the private bath. Ceramic shower, dressing table, hand painted sink, a walk-in soaking tub and walk-in closet. Convenient first floor laundry with sorting space and beautiful custom built-ins, loads of closets, mud room with a side door to a dog run with an excellent planning center. Note the high-end hardware throughout this special home. Beautiful staircase to the 4-dormer bonus room that includes a split heating system, is the perfect game room or getaway. Two additional bedrooms on the main floor, both are large and offer wonderful water views. Irregular in shape one with a bay window and the other with a barrel vault arch top window. The full bath has a leaded glass picture window, soaking tub, hand painted sink. An amazing accessible crawl area under the whole home is a bonus for storage and extremely well insulated. Enjoy your cottage and home in one with boating, swimming, fishing, ice sports and more. Close to the trails of Lake Lansing, shopping, eateries, schools, and more.
MlsNumber: --
ListingId: 280628


Listing Provided By: Coldwell Banker Realty-Okemos, original listing
Phone: (517) 492-3274
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => ingham-northwest [3] => MI [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: ingham-northwest State: MI Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: ingham-northwest State: MI 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 = 1267 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Elizabeth Fleckenstein
Elizabeth Fleckenstein
ASCIIBHHS Tomie Raines REALTORS
Call Today!: (517) 881-6698

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App