SELECT *, CASE WHEN `name` LIKE "san diego%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "san diego" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "san diego" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "san diego" 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 ("san diego") 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
$12,875,0002900 Nichols StSan Diego CA 92106View Listing
$12,750,000579 San Elijo StSan Diego CA 92106View Listing
$10,995,0004592 Rancho Del Mar TrlSan Diego CA 92130View Listing
$8,499,0007563 Montien RdSan Diego CA 92127View Listing
$8,378,0007852 Corte De LuzSan Diego CA 92127View Listing
$7,950,0007837 Lookout DrSan Diego CA 92037View Listing
$7,880,0004532 Rancho Del Mar TrlSan Diego CA 92130View Listing
$7,395,0003470 Bayside WalkSan Diego CA 92109View Listing
$7,000,0005115 Gordon LnSan Diego CA 92109View Listing
$6,995,0004974 Del Mar Mesa RdSan Diego CA 92130View Listing
$6,900,0001053 E Briarfield DrSan Diego CA 92109View Listing
$6,495,0003281 Ocean Front WalkSan Diego CA 92109View Listing
$6,395,0007808 Santaluz InltSan Diego CA 92127View Listing
$5,750,0002408-10 1st AveSan Diego CA 92101View Listing
$5,699,0001605 Plum StSan Diego CA 92106View Listing
$5,550,000952 Cornish DrSan Diego CA 92107View Listing
$5,499,0008195 Run of the Knolls CtSan Diego CA 92127View Listing
$5,495,0008024 Entrada De Luz WSan Diego CA 92127View Listing
$5,380,0004270 Ampudia StSan Diego CA 92103View Listing
$4,900,0004111 Bayard StSan Diego CA 92109View Listing
$4,750,0005190 Rancho Madera BndSan Diego CA 92130View Listing
$4,700,00015445 Artesian Spring RdSan Diego CA 92127View Listing
$4,599,0003446 Buena Vista StSan Diego CA 92109View 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-09-2024 2:25:39 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