SELECT *, CASE WHEN `name` LIKE "oak bluffs%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "oak bluffs" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "oak bluffs" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "oak bluffs" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "MA" AND (locality IN ("oak bluffs") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 27
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MA" 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 27
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$11,000,00047 E Chop DrOak Bluffs MA 02557View Listing
$6,800,000400 Barnes RdOak Bluffs MA 02568View Listing
$5,850,000267 Barnes RdOak Bluffs MA 02557View Listing
$4,295,0009 Weston AveOak Bluffs MA 02557View Listing
$3,250,000311 E Chop DrOak Bluffs MA 02557View Listing
$2,950,00034 Windemere RdOak Bluffs MA 02557View Listing
$2,900,0003 Mayhew WayOak Bluffs MA 02557View Listing
$2,800,0002 E Side RdOak Bluffs MA 02557View Listing
$2,800,00032 Harthaven RdOak Bluffs MA 02557View Listing
$2,675,000107 Barnes RdOak Bluffs MA 02557View Listing
$2,650,0004 High Meadow LnOak Bluffs MA 02557View Listing
$2,495,0003 Canonicus AveOak Bluffs MA 02557View Listing
$2,289,00019 Wendall AveOak Bluffs MA 02568View Listing
$2,250,0002 Farm PathOak Bluffs MA 02557View Listing
$2,200,00016 Franklin AveOak Bluffs MA 02557View Listing
$2,100,00028 Rogers WayOak Bluffs MA 02557View Listing
$1,849,9004 Hopes WayOak Bluffs MA 02557View Listing
$1,849,00011 John Wesley AveOak Bluffs MA 02557View Listing
$1,799,0003 Poplar LnOak Bluffs MA 02557View Listing
$1,650,00056 Deer Run RdOak Bluffs MA 02568View Listing
$1,600,00011 Canonicus AveOak Bluffs MA 02557View Listing
$1,475,00054 Cannahoot StOak Bluffs MA 02557View Listing
$1,295,0007 Fairway DrOak Bluffs MA 02557View Listing
$1,150,000179 County RdOak Bluffs MA 02557View 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-12-2024 12:04:43 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MA" AND (cat = "lenders" OR 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 27
Blah