Notice: MYSQL ERROR QUERY_SINGLE: SELECT count(*) FROM mls.listings_index li LEFT JOIN mls.listings_taar_com ltc ON ltc.L_ListingID=li.search_id AND li.type="com" LEFT JOIN mls.listings_taar_res ltr ON ltr.L_ListingID=li.search_id AND li.type="res" LEFT JOIN mls.listings_taar_vac ltv ON ltv.L_ListingID=li.search_id AND li.type="vac" LEFT JOIN mls.listings_taar_inc lti ON lti.L_ListingID=li.search_id AND li.type="inc" WHERE li.source="TAAR" SELECT command denied to user 'reonorth'@'localhost' for table 'listings_index' in /var/www/vhosts/reonorth.com/httpdocs/manager/obj/database/mysql.php on line 675

Notice: MYSQL ERROR QUERY_ARRAY: SELECT DISTINCT li.area FROM mls.listings_index li ORDER BY li.area SELECT command denied to user 'reonorth'@'localhost' for table 'listings_index' in /var/www/vhosts/reonorth.com/httpdocs/manager/obj/database/mysql.php on line 675

Notice: MYSQL ERROR QUERY_ASSOC: SELECT li.*, COALESCE(ltc.LA1_PhoneNumber1Area, ltv.LA1_PhoneNumber1Area, ltr.LA1_PhoneNumber1Area, lti.LA1_PhoneNumber1Area) AS LA1_PhoneNumber1Area, COALESCE(ltc.LA1_PhoneNumber1, ltv.LA1_PhoneNumber1, ltr.LA1_PhoneNumber1, lti.LA1_PhoneNumber1) AS LA1_PhoneNumber1, COALESCE(ltc.LA1_Email, ltv.LA1_Email, ltr.LA1_Email, lti.LA1_Email) AS LA1_Email FROM mls.listings_index li LEFT JOIN mls.listings_taar_com ltc ON ltc.L_ListingID=li.search_id AND li.type="com" LEFT JOIN mls.listings_taar_res ltr ON ltr.L_ListingID=li.search_id AND li.type="res" LEFT JOIN mls.listings_taar_vac ltv ON ltv.L_ListingID=li.search_id AND li.type="vac" LEFT JOIN mls.listings_taar_inc lti ON lti.L_ListingID=li.search_id AND li.type="inc" WHERE li.source="TAAR" ORDER BY price LIMIT 0,10 SELECT command denied to user 'reonorth'@'localhost' for table 'listings_index' in /var/www/vhosts/reonorth.com/httpdocs/manager/obj/database/mysql.php on line 675
Northern Michigan Properties: Waterfront Homes, Vacant Land, Luxury Homes & Commercial Property: by Real Estate One
  • Results 1- of
  • |
  • View
  • results per page
  • |
  • Sort by

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/reonorth.com/httpdocs/properties/index.php on line 213
  • Results 1- of

Search by Category

Search by Category:

Search by Map Search by Map

Use this helpful tool to search for homes in a specific area, and refine your search by type of property, price range and amenities that are important to you.

Listing Alerts

Find your home faster! With our free home finder service you automatically receive new listing alerts and updates by email as soon as properties that meet your specifications become available. More ยป

What's my home worth?

Search by Category