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

3641 Beech Tree Lane
Okemos, MI 48864
Shirley Boucha with Coldwell Banker Realty-East Lansing, original listing - (517) 332-5100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $915,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5676 Square Feet
Agency: Coldwell Banker Realty-East Lansing
Agency Phone: (517) 332-5100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Impressive executive brick home in sought-after Spring Lake boasts $90k+ in updates on a private, fenced half-acre backing to a trail. Grand foyer with spiral staircase leads to a chic updated office with built-ins and spacious living/dining areas. The updated kitchen features quartz counters and a breakfast nook, flowing into a bright four-seasons room and large deck overlooking the landscaped yard. Upstairs, the master suite offers French doors, a private loft/sitting area, and a master bath with skylights and jetted tub. Three more bedrooms feature walk-in closets. The expansive lower level includes a built-in bar room, billiard and game areas, a gym/dance studio, and a workshop, plus ample storage. If you're looking for an impressive executive custom built brick home that boasts over $90k in updates, this is it! Located in the highly sought after Spring Lake neighborhood, this 4 bedroom, 3.5 bath home is absolutely stunning sitting on a fully fenced, half-acre private lot that backs up to a walking trail. Step inside the home and be welcomed by the expansive foyer and glamorous spiral staircase. Off the foyer, you have French doors that open into your chic designer updated office with many built-ins. There is also a spacious living room with cathedral ceilings that flows into the formal dining room. <br /> Step into the heart of the home - a beautifully updated kitchen with new quartz countertops, designed for both culinary adventures and casual gatherings. Start your day with a cup of coffee in the charming breakfast nook that offers a sun-drenched spot to enjoy your morning meal. Seamlessly connected, a light-filled 4-seasons room extends your living space, providing a tranquil haven. From the 4-seasons room, step out onto a large deck that overlooks a picturesque landscaped backyard. This outdoor oasis is perfect for al fresco dining, entertaining guests, or simply relaxing. <br /> Imagine ascending the staircase to your own private sanctuary. This isn't just a bedroom; it's a master suite thoughtfully designed for relaxation. Stepping through elegant French doors, you immediately sense spaciousness in the main sleeping area. Tucked away within the suite is a private loft/ sitting area, a versatile space as your personal retreat. Imagine unwinding here with a good book, enjoying a morning coffee, or simply savoring a quiet moment before the day begins or after it concludes.<br /> The master bath is an oasis of calm. Skylights invite the beauty of the outdoors in, casting a soft, natural glow throughout the space. Indulge in the therapeutic embrace of a jetted tub, letting the day's stresses melt away. Additionally, there are three more bedrooms that have their own walk in closets. <br /> Descend to the expansive lower level, a versatile space designed for both recreation and practicality. Imagine entertaining friends in your very own built-in bar room. Discover the dedicated space for a gym/ dance studio, perfect for maintaining an active lifestyle. Plus there is a workshop! This level also boasts an abundance of storage space, ensuring a clutter-free home.
MlsNumber: --
ListingId: 287837


Listing Provided By: Coldwell Banker Realty-East Lansing, original listing
Phone: (517) 214-4185
Office Phone: (517) 332-5100
Agent Name: Shirley Boucha
Disclaimer: Copyright © 2025 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