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

9266 Kenyon Trail
Frederic, MI 49733
Gordon Hodges with REO-TCFront-233021, original listing - (231) 947-9800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $330,000
Beds: 3
Baths: Full: 2
Status: Pending
SqFt: 1800 Square Feet
Agency: REO-TCFront-233021
Agency Phone: (231) 947-9800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Perfect Up North Getaway or Primary Sanctuary! Nestled on 6.22 wooded acres of beautiful hardwoods, this charming retreat offers the ideal blend of rustic comfort and modern convenience. The main floor boasts a bright and open layout with cathedral ceilings and stunning log accents throughout the bannisters and ceiling beams. The spacious kitchen features an island bar—perfect for entertaining—while full patio doors open to a large backyard, bringing the outdoors in. Stay cozy in the winter months with a large wood stove as the focal point of the living area. The main floor includes a generously sized bedroom, a full bathroom, and a convenient laundry/mudroom with access to the back deck. Upstairs, the loft bedroom is fully enclosed for privacy and features warm wood ceilings, brand-new carpet, and classic Up North log railings overlooking the living space below. The lower level is a suite like no other, offering a spacious family room ideal for gatherings or relaxation. The connected primary suite features a large bathroom with a walk-in shower, a natural daylight egress window, and a sizable walk-in closet. A unique 11.5' x 4' bonus room—currently used as a craft room—would also make a perfect office. When it is time to relax or get a work out on, you will find the most unique workout space located just off the front. Perfect for meditation or full on gym. Additional highlights include a high-speed fiber optic internet connection, multiple heating and cooling sources, and a 42' x 36' pole barn with two 10-foot doors—perfect for storing all your toys and gear securely. Located just minutes from lakes, downtown Gaylord, and Highway access, this property offers privacy, peace, and convenience all in one.
MlsNumber: --
ListingId: 1933891


Listing Provided By: REO-TCFront-233021, original listing
Phone: (231) 499-4448
Office Phone: (231) 947-9800
Agent Name: Gordon Hodges
Disclaimer: Copyright © 2025 Northern Great Lakes Realtors MLS. 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