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

11749 Bonnett Road
Levering, MI 49755

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $269,900
Beds: 3
Baths:
Status: Active
SqFt: 1424 Square Feet
Agency: Berkshire Hathaway HomeServices-Cheboygan

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Range, Refrigerator, Dryer
Architectural Style: Ranch
Construction Materials: Frame
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Kitchen, Family Room, Living Room, Utility Room

Window Features

Exterior Features: Deck, Shed, Patio/Porch, Paved Driveways
Parking Features: Garage
Other Features: Packing Shed, Shed(s)
Patio and Porch Features: Patio, Porch, Deck

Neighborhood/Schools

Elementary School/District: CHEBOYGAN
Middle/Junior High School/District: Canyon
High School/District: CHEBOYGAN
Subvidision Name: T37N R5W

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1982
Notes: This charming 3-bedroom ranch offers a serene retreat amidst picturesque rolling farm fields. Situated on a large lot, the property boasts a sunroom with a spacious deck at the rear, perfect for soaking in the surrounding natural beauty. With a 2-car attached garage and 2 sheds for storage, you'll have ample space to organize your belongings. Additionally, there's plenty of room for a pole barn and garden, allowing for further customization to suit your needs and interests. The paved drive adds convenience, while the property's proximity to the interstate ensures easy access to nearby amenities and destinations. Despite its peaceful rural setting, the home is not too far from town, offering the perfect balance of tranquility and convenience.
MlsNumber: --


Listing Provided By: Berkshire Hathaway HomeServices-Cheboygan, original listing
Phone: (231) 420-8032
Office Phone: (231) 627-7186
Agent Name: Billy Jewell
Disclaimer: Copyright © 2024 Water Wonderland Board 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