SELECT *, CASE WHEN `name` LIKE "ewa beach%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ewa beach" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ewa beach" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ewa beach" 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 = "HI" AND (locality IN ("ewa beach") 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
$1,670,00091-1164 Waikapoo StEwa Beach HI 96706View Listing
$1,650,00091-1074 Waikai StEwa Beach HI 96706View Listing
$1,650,00091-1452 Noelo StEwa Beach HI 96706View Listing
$1,525,00091-1277 Kuanoo StEwa Beach HI 96706View Listing
$1,450,00091-1081 Kai Weke StEwa Beach HI 96706View Listing
$1,425,00091-1099 Waiemi StEwa Beach HI 96706View Listing
$1,399,88891-701A Oneula PlEwa Beach HI 96706View Listing
$1,398,88891-1041 Kai Oio StEwa Beach HI 96706View Listing
$1,350,00091-1011 Waikoihi StEwa Beach HI 96706View Listing
$1,349,00091-211 Kuanoo PlEwa Beach HI 96706View Listing
$1,340,67091-1948 Hikupau St Lot 11Ewa Beach HI 96706View Listing
$1,338,00091-1040 Niolo StEwa Beach HI 96706View Listing
$1,326,73591-1920 Hikupau St Lot 4Ewa Beach HI 96706View Listing
$1,326,73591-1910 Hikupau St Lot 2Ewa Beach HI 96706View Listing
$1,325,00091-1085 Waiemi StEwa Beach HI 96706View Listing
$1,317,00091-1143 Waikapoo StEwa Beach HI 96706View Listing
$1,316,73591-1868 Hikupau St Lot 51Ewa Beach HI 96706View Listing
$1,315,69591-1880 Hikupau St Lot 54Ewa Beach HI 96706View 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-14-2024 8:37:17 pm.
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
Ranch
Single Family
