SELECT *, CASE WHEN `name` LIKE "waipahu%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "waipahu" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "waipahu" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "waipahu" 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 ("waipahu") 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.
$1,649,00094-1090 Kuhaulua StWaipahu HI 96797View Listing
$1,478,00094-341 Kahuahele StWaipahu HI 96797View Listing
$1,250,00094-1201 Kaniau PlWaipahu HI 96797View Listing
$1,200,00094-264 Kipou StWaipahu HI 96797View Listing
$1,200,00094-618 Hiahia PlWaipahu HI 96797View Listing
$1,198,00094-1084 Kukula StWaipahu HI 96797View Listing
$1,175,00094-441 Hene StWaipahu HI 96797View Listing
$1,170,00094-1131 Kaloli LoopWaipahu HI 96797View Listing
$1,150,00094-1061 Alelo StWaipahu HI 96797View Listing
$1,140,00094-1009A Maiau St Unit 161Waipahu HI 96797View Listing
$1,140,00094-1018 Waiopae StWaipahu HI 96797View Listing
$1,100,00094-975 Nalii StWaipahu HI 96797View Listing
$1,045,00094-1089 Kapukawai StWaipahu HI 96797View Listing
$998,00094-1152 Hoohele St Unit 9Waipahu HI 96797View Listing
$989,00094-1015 Waiopae StWaipahu HI 96797View Listing
$985,00094-679 Noheaiki PlWaipahu HI 96797View Listing
$980,00094-1015 Lalama LoopWaipahu HI 96797View Listing
$975,00094-1037 Koliana StWaipahu HI 96797View Listing
$970,00094-378 Kahuawai StWaipahu HI 96797View Listing
$959,00094-1028 Mawaho StWaipahu HI 96797View Listing
$950,00094-404 Kipou StWaipahu HI 96797View Listing
$949,99994-1051 Lumikula StWaipahu HI 96797View Listing
$939,00094-1009 Hanauna StWaipahu HI 96797View Listing
$915,00094-1044 Kahimoe PlWaipahu HI 96797View 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-06-2024 9:17:43 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
