SELECT *, CASE WHEN `name` LIKE "vallejo%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "vallejo" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "vallejo" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "vallejo" 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 ("vallejo") 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
$799,9991029 Topsail DrVallejo CA 94591View Listing
$799,9004244 Rose Arbor WayVallejo CA 94591View Listing
$799,0004048 Nottingham CtVallejo CA 94591View Listing
$799,000115 Rincon WayVallejo CA 94590View Listing
$778,5001259 Fulton AveVallejo CA 94591View Listing
$775,0009 Sandy Beach RdVallejo CA 94590View Listing
$775,000311 Valle Vista AveVallejo CA 94590View Listing
$760,000435 Goheen CirVallejo CA 94591View Listing
$750,000136 Devonshire CtVallejo CA 94591View Listing
$749,8882824 Olivewood LnVallejo CA 94591View Listing
$749,000117 Farallon DrVallejo CA 94590View Listing
$749,000121 Bella Vista WayVallejo CA 94590View Listing
$739,0001015 Skyline DrVallejo CA 94591View Listing
$735,0002039 Bennington DrVallejo CA 94591View Listing
$729,0001250 Tuolumne StVallejo CA 94590View Listing
$725,0005131 Carisbrooke LnVallejo CA 94591View Listing
$719,00085 Canterbury CirVallejo CA 94591View 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-04-2024 12:56:32 am.
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