SELECT *, CASE WHEN `locality` LIKE "honolulu%" 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 = "HI" AND (locality IN ("honolulu") 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 23
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "HI" 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 23
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.
$2,450,00046-464 Haiku Plantations DrKaneohe HI 96744View Listing
$2,335,0002550 Waiomao RdHonolulu HI 96816View Listing
$1,900,00047-730 Ahilama PlKaneohe HI 96744View Listing
$1,780,00047-720 Lamalama PlKaneohe HI 96744View Listing
$1,575,000355 Opihikao Pl Unit 355Honolulu HI 96825View Listing
$1,297,5001521 Kalaniwai Pl Unit 57Honolulu HI 96821View Listing
$1,295,000123D Maunalua Ave Unit 18Honolulu HI 96821View Listing
$1,250,0004308 Sierra Dr Unit BHonolulu HI 96816View Listing
$1,149,0007007 Hawaii Kai Dr Apt F21Honolulu HI 96825View Listing
$1,100,0001459 Kalanikai Pl Unit 42Honolulu HI 96821View Listing
$1,099,0004730 Halehoola PlHonolulu HI 96816View Listing
$979,00045-995 Wailele Rd Apt 33Kaneohe HI 96744View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "HI" 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 23
Blah