SELECT *, CASE WHEN `name` LIKE "bass lake%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bass lake" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bass lake" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "bass lake" 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 = "CA" AND (locality IN ("bass lake") 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 2
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" 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 2
Blah
$878,70054801 Willow Cove LnBass Lake CA 93604View Listing
$825,00039768 S Cedar Vista CirBass Lake CA 93604View Listing
$825,00039768 Cedar Vista Cir SBass Lake CA 93604View Listing
$795,00054680 Blue GillBass Lake CA 93604View Listing
$790,00040444 Road 222Bass Lake CA 93604View 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-08-2024 4:47:30 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" 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 2
Blah