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

4245 E Y Avenue
Vicksburg, MI 49097

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $765,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 4236 Square Feet
Agency: Jaqua, REALTORS
Agency Phone: (269) 341-4300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1974
Notes: Experience the ultimate up north resort lifestyle without the travel. Spectacular updated walk-out ranch home w/ 86ft of frontage on the breathtaking & peaceful Kimble lake, plus 10.4 serene/wooded acreage. This luxurious home boasts 4,236 sqft, 5 bdr, 4 full bth, 2 car att. garage & a 24X40 pole building for all your extra lake toys. Inviting entry into a great room w/ luxurious wood flooring, FP, formal DR, spacious open kitchen featuring custom cabinets, granite counters, center island/snack bar, tiled back splash, newer SS appliances , trash compactor, separate vegetable sink & pantry. Newer Pella windows provides a fantastic view of the lake. 3 spacious bdr on main floor including the primary w/ updated tiled steam shower w/ heated floors. 2 additional updated full bths on the ma Experience the ultimate up north resort lifestyle without the travel. Spectacular updated walk-out ranch home w/ 86ft of frontage on the breathtaking & peaceful Kimble lake, plus 10.4 serene/wooded acreage. This luxurious home boasts 4,236 sqft, 5 bdr, 4 full bth, 2 car att. garage & a 24X40 pole building for all your extra lake toys. Inviting entry into a great room w/ luxurious wood flooring, FP, formal DR, spacious open kitchen featuring custom cabinets, granite counters, center island/snack bar, tiled back splash, newer SS appliances , trash compactor, separate vegetable sink & pantry. Newer Pella windows provides a fantastic view of the lake. 3 spacious bdr on main floor including the primary w/ updated tiled steam shower w/ heated floors. 2 additional updated full bths on the main<br /> <br /> & laundry. Walk-out level features new luxury vinyl plank flooring, 2 additional bdr, work out room, theater room & rec room w/ FP. Roof (2023), furnace/ A/C (2021), RO system, negotiable home warranty and TV's are included along with Mesh WIFI.<br /> Kimble Lake is an all sports lake great for fishing, boating, kayaking, tubing and jet skiing. Lake connects to 3 other lakes Howard and Barton. 10.4 acres provide a real peaceful setting to connect with nature. Vicksburg is an award winning school system with a vibrant downtown full of local Mom and Pop establishments. Dock comes with the house, 24x20 Pole building with Concrete flooring perfect to store all your lake toys. 220 power out to the lake and the large patio is the perfect area for entertaining. Home has 3 bladder tanks for the well so water pressure will not be an problem. RO system to ensure water quality. High speed internet is available which is perfect for working at home. Theater Room complete with Dolby 7.1 sound system . Whole house sound system with built-in speaker which also goes out to the patio for entertaining and a ring a ring security system.
MlsNumber: --
ListingId: 24048542


Listing Provided By: Jaqua, REALTORS, original listing
Phone: (269) 217-6250
Office Phone: (269) 341-4300
Agent Name: Paul Valentin
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.


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 = 1273 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 C David Howard
C David Howard
ASCIICentury 21
Call Today!: (269) 207-4228

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App