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;

6403 Woodcliffe Lane
East Lansing, MI 48823

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,198,000
Beds: 4
Baths: Full: 4, ½: 3
Status: Active
SqFt: 7096 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: 1996
Notes: Live the dream! Whitehills Woods newest offering with this magnificent, one of a kind, over 7000 square foot one owner home, nestled on a beautiful mature wooded one-acre parcel in a prime location in the neighborhood. Amazing high-end quality with special details and appointments throughout. Enjoy the deluxe main floor primary suite, plus 3-4 additional bedrooms and 7 baths. The dramatic foyer entry is truly captivating with breathtaking views at every glance. The stunning oversized great room is enhanced with a large bank of two-story windows that bring the outside in and is adorned with a gorgeous travertine marble and sandstone fireplace. The great room includes views of both the front and back staircases, plus the upper catwalk crafted in a spectacular metal and glass banister and railings. A beautiful adjoining dining room and sit-up wet bar, complete with serving space, sink and refrigerator makes this the perfect living space for family use and entertainment. The heart of the home gourmet kitchen includes custom made solid maple cabinets, solid red oak hardwood flooring, gleaming granite countertops, generous walk-in pantry, a Sub-Zero extra-large refrigerator, 4 burner gas range cook top with a convertible down draft grill, two built-in ovens, eating bar, and island with prep sink and offers an abundance of work space, including a planning desk, plus a charming informal eating area nestled in a bay of windows! The hearth room, adjacent to the kitchen and open to the living areas, is enhanced with a special tray ceiling and includes a striking media center with decorative wall notches and surround sound. Two patio doors allow easy access to the large wrap around deck, perfect for relaxing while sipping your morning coffee, enjoying the birds and nature, grilling and entertaining. The open back staircase to the lower level makes this home function so comfortably. The efficient back hall includes a family 1/2 bath, a walk-in closet plus a great laundry center with access to the ample three car garage! A special guest bath is conveniently located off the front entrance. The gracious main floor primary suite is captivating with special ceiling heights and beautiful door windows to a private deck. A wonderful built-in dressing table and an abundance of storage with extensive built-ins in the walk-in closet are located off the hall to the private bath. Stacked windows add architectural interest with a walk-in marble shower and euro door, whirlpool corner tub, extra-long double sink vanity and separate stool area, rounding out the suite. Take in the second floor overlook for amazing views of the living areas below. The en-suite is quietly nestled off the hallway and includes its own full bath, walk-in closet, 2 linen closets and tree filled view of the back yard. Two additional bedrooms have a generous shared bath (one bedroom lacks a closet, but there is space to add one) and has a pretty arched window. The other is oversized with a walk-in closet. If this is not enough, brace yourselves for the over-the-top, outstanding, out of a magazine, high ceiling walkout finished lower level! Game space, sitting area, full kitchen/ bar, captivating media center accented with magnificent slabs of granite and custom cherry built-ins (truly a picture of art) is simply magnificent and breathtaking, and simply WOWs the entire home. The adjoining see through bar makes the living area function beautifully and was designed with loads of custom cherry cabinets, quartz countertops, stunning accent tiles with contemporary artistry and imagination and functions as a full kitchen with dining space too. The dramatic custom double doors to the flex room, exercise room or 5th bedroom has its own private bath plus a large walk-in closet. An additional 1/2 bath is in a great location off the living space. Pamper yourselves in luxury with this unique and well-designed masterpiece of a home! Close to MSU, shopping, eateries, highway access, parks, neighborhood lake for fishing and tennis court. Newer Bosch dishwasher (2020), Newer roof (2015), A/C (2019), furnace (2021). See attached floor plan (some rooms may vary). Master window treatments, Master hallway mirror, and TVs are reserved.
MlsNumber: --
ListingId: 282929


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