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

9750 Amidon Drive
Traverse City, MI 49685

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,900
Beds: 4
Baths:
Status: Active
SqFt: 3024 Square Feet
Agency: Schmidt Realtors

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Interior Features: Pantry, Mud Room, Cathedral Ceilings, Drywall, Dishwasher, Refrigerator, Microwave, Formal Dining Room, Dryer, Washer, OVEN/RANGE, FOYER ENTRANCE, SOLARIUM/SUN ROOM, CEILING FAN SKYLIGHTS
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4

Window Features

Exterior Features: Wood
Roof: Asphalt

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 19 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1983
Notes: Privacy abounds on this one-of-a-kind estate parcel with a well-maintained home, reflective of its surroundings, and two outbuildings in desirable Long Lake Township! Set on 19 acres with two deeded access points, the land is beautifully wooded and level. Highlights of the main level of the home include a lovely and spacious living room with a fireplace, a formal dining room off the expansive kitchen, a sunroom with a gas stove that invites you to linger with a good book, a laundry room off the garage and convenient foyer entrance. Upstairs you'll find the bedrooms and a full bath, including the primary suite with a half-bath, dramatic ceilings with a skylight, and plenty of built-in storage. The lower level is finished with a family room and multi-purpose room, suitable for crafts, hobbies, play, work - the possibilities are endless! Speaking of endless possibilities, in addition to the two-car attached garage there are two additional 40x24 buildings - one with pole construction with added aesthetic wood siding, currently used for storage, one with stick-built construction used as a heated workshop. With the layout and size of this parcel, combined with the two access points, it would also be suitable for a small development.
MlsNumber: --


Listing Provided By: Schmidt Realtors, original listing
Phone: (231) 590-2198
Office Phone: (231) 929-2300
Agent Name: Ben Street
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt 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