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

87 44th Street
Bloomingdale, MI 49026
Pamela Lombard with Chuck Jaqua, REALTOR, original listing - (269) 381-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1382 Square Feet
Agency: Chuck Jaqua, REALTOR
Agency Phone: (269) 381-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 58 acre(s)
Property Type: Residential-Farm
Year Built: 1930
Notes: Almost 60 acres of incredible farm land and woods. The farmhouse and barns sit high on a hill with panoramic views of the fields and woods. Located on a quiet country road you will love listening to nature not highways.<br /> Watch the sunrise, sunset, and star gaze in the night. This property offers incredible views. The home is in the process of a major renovation and the owner spared no expense on the electrical, windows, insulation, and finished spaces. The spacious kitchen features hickory cabinets, granite counters, a huge center island. Open dining and living room offers great entertaining space. The home features 3 bedrooms and currently 1.5 baths, but there is room to make a spa quality primary ensuite bath. The kitchen, dining, living room and bedroom have been updated with new vinyl plank floors, fresh drywall, paint, fixtures. Many new Anderson windows. The main bath, primary suite and ensuite are a work in process ready for new owners ideas. Unfortunately the seller is relocating out of state and is having to give up his slice of heaven.<br /> 32 acres of this working farm is tillable and leased to produce $7000 of income from renting the land. The woods are excellent for hunting and there are a few spots that would make excellent areas for a pond, seller has approval. Even though this property feels like it is a thousand miles from no where, it is less than 15 minutes to South Haven and Lake Michigan, less than 30 minutes to Kalamazoo and Allegan. This property is perfect to expand your farming, possible venue or airbnb, or just a great place to call home and get away from the hustle and bustle of city living. Come see this majestic property before it's too late.
MlsNumber: --
ListingId: 24058465


Listing Provided By: Chuck Jaqua, REALTOR, original listing
Phone: (269) 806-8035
Office Phone: (269) 381-7653
Agent Name: Pamela Lombard
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