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

14600 W Diane Drive
Camden, MI 49232
Tracy Fitch with CENTURY 21 Affiliated, original listing - (517) 254-4442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $639,900
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3036 Square Feet
Agency: CENTURY 21 Affiliated
Agency Phone: (517) 254-4442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: Lake Diane Distinctive Lake Front Home with 150 ft water front provides fantastic lake views from road side porch perfect for morning sunrise coffee & lake side wrap around deck for evening sunsets. 4 poss. 5 BR+/3 Bath provides plenty of room for all to enjoy! Open floor plan connects living room, dining area with built in cabinets & kitchen with a great lake view upon entry. Sliding door exits to a fabulous 4 season room that also leads to multi level deck perfect for relaxing or entertaining. Main floor amenities are stainless steel appliances, endless granite counter tops, warming gas log fireplace with lighted surrounding shelves, butler pantry & convenient main floor Laundry. Main BR boast dual walk in closets plus 2 additional closets amazing bath and slider to 4 season room. Guest BR has lake view & slider to deck. 3rd BR on main level has large area for an office, crafting, additional seating area or convert to a walk in closet or additional private sleeping quarters. Premium built in cupboards, closets & storage areas through out main floor. Lower level has 1 poss. 2 BR & recreational area. Should you need additional sleeping the recreational room is a plus and the 2 trundle beds are included. Full bathroom serves guests well. Large Mechanical room has range, refrigerator & loads of storage shelving. R.O system serves Kitchen sink & Ref. and furnace humidifier. Radon mitigation system installed 2022. Concrete drive affords parking for approx. 14 vehicles, leads to over sized garage with immense amounts of cabinets & crushed stone polyurethane floor coating. Lets exit to a manicured, lush lawn with sprinkler system that draws from the lake & view the beautiful flower gardens & shrubs. Venture to the 2 tier wrap around deck with adjustable separate awning cover to take in views of the lake with shade or with out. The fire pit is located off deck lake side for gathering & watching the flames dance. Super Sandy BEACH perfect for swimming, includes dock, water bubbler to leave dock in year round & 'boat house' with porch area for entertaining, store your water accessories for easy access. Additions completed by Architectural Engineer. 4 TV mounts, 1 portable humidifier included and magic beach towel rack included. Personalized metal FP surround excluded.
MlsNumber: --
ListingId: 24061192


Listing Provided By: CENTURY 21 Affiliated, original listing
Phone: (517) 254-4442
Office Phone: (517) 254-4442
Agent Name: Tracy Fitch
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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