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

2832 Kittansett Drive
Okemos, MI 48864

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $737,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4478 Square Feet
Agency: Berkshire Hathaway HomeServices Tomie Raines
Agency Phone: (517) 351-3617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Make your next move to an exciting and unique home. ''Spartan Lodge'' is a craftsman-style 4 BR, 4.5 bath countryside ranch with nearly 4500 sf of finished living space. It is an extraordinarily distinctive home with impeccable workmanship and a design unique to the Greater Lansing Area. It will surprise and delight you at every turn with its voluminous wood ceilings and open spaces beaming sunlight through the windows of your world overlooking the bluffs of College Fields Golf Club. A brilliant use of elements and space including soaring wood and coffered ceilings, custom knotty Alderwood trim, cabinetry, and solid 9ft doors, authentic stone, and breathtaking arrangement of glass invite you to live luxuriously yet comfortable in what you find in a traditional northern Michigan cottage. The front porch, an expansive 52 ft. deck, and a lower patio are all places for relaxation and fun! A wonderful home for all lifestyles including a multi-generational home with two generous bedrooms with private ensuite baths on the main floor. The primary suite offers tremendous view and access to the deck. It has a 9.10x6 walk-in closet, a dressing area, 2 private lavs, one includes a bidet, jetted tub and tiled shower enclosure. There are two additional bedrooms, with 2 full baths, 2nd laundry, and full kitchen on the lower walkout level. The main floor features 10 ft + ceilings, 9-foot doors, a multi-use room with double-solid Alderwood half-light doors that can serve as an office, studio, music room, or room of choice. The warmth and expansiveness of the great room, dining and kitchen makes this the perfect gathering space for friends and family. The authentic stone fireplace, built-in cabinetry, wet bar, wine fridge, and beverage center open to the dining and kitchen space all of which access the 52 ft deck and amazing views of the course. An upgraded cook's kitchen features Jenn-air stainless steel appliances, a raised granite bar and counters, main and prep sink areas, a double oven, and a gas cooktop. The back hall features a walk-in pantry, laundry room/sorting/storage area, and half bath. The garage is 21x25, an extra-long space for storage or longer vehicles. Downstairs has a pub style décor featuring a full kitchen/bar/kegerator, pool table, and theater area perfect for game and movie night! Walk out to the patio for BBQ, refreshments, and more fun. The two additional bedrooms are handy for family or overnight guests. There are 2 full baths, a second laundry with stackable washer/dryer, exercise room, and storage area. Enjoy site condominium amenities including a low monthly fee of $85/mo. covering lawn and snow maintenance. Minutes away to Okemos schools, less than 2 miles to MSU, nearby shopping, dining and more, meaning you will be delighted and proud to come home to 2832 Kittansett Dr., Okemos MI.
MlsNumber: --
ListingId: 284587


Listing Provided By: Berkshire Hathaway HomeServices Tomie Raines, original listing
Phone: (517) 449-6100
Office Phone: (517) 351-3617
Agent Name: Lisa Fletcher
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 = 3328 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;
Real Estate Expert Photo for Rebecca Dunne
Rebecca Dunne
ASCIIHoward Hanna Real Estate Executives Lansing Office
Call Today!: (517) 416-8663

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App