SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "ME" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 41
Blah
$200,0001090 Mason Bay RdJonesport ME 04649View Listing
$189,000749 Mason Bay RdJonesport ME 04649View Listing
$159,900Yoho Head Rd Lot 15Machiasport ME 04655View Listing
$159,0003 Middle Ground VwJonesport ME 04649View Listing
$158,00011 Collins Cove RdMachiasport ME 04655View Listing
$150,00020 Cottage RdEast Machias ME 04658View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-04-2024 11:05:24 am.