SELECT *, CASE WHEN `locality` LIKE "southampton%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "MA" AND (locality IN ("southampton") 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.
$1,750,00024 Ward AveNorthampton MA 01060View Listing
$1,200,000668 N Farms RdNorthampton MA 01062View Listing
$614,99926 Pheasants XingWest Springfield MA 01089View Listing
$595,0001251 E Mountain RdWestfield MA 01085View Listing
$575,000135 Glendale RdHampden MA 01036View Listing
$550,0001342 E Mountain RdWestfield MA 01085View Listing
$524,9007 Courtney LnSouthampton MA 01073View Listing
$475,000400 North RdWestfield MA 01085View Listing
$449,000116 County RdSouthampton MA 01073View Listing
$440,000Reservoir Rd Lot AWesthampton MA 01027View Listing
$439,0001010 Ryan RdNorthampton MA 01061View Listing
$399,000210 Pine Hill RdRussell MA 01071View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
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
Commercial
Land
Ranch
Single Family
