SELECT *, CASE WHEN `name` LIKE "sunnyvale%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sunnyvale" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sunnyvale" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sunnyvale" 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 ("sunnyvale") 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
$3,170,000669 Spruce DrSunnyvale CA 94086View Listing
$2,750,0001079 The Dalles AveSunnyvale CA 94087View Listing
$2,688,000633 Carlisle WaySunnyvale CA 94087View Listing
$2,488,0001112 The Dalles AveSunnyvale CA 94087View Listing
$2,399,0001040 Gloucester CtSunnyvale CA 94087View Listing
$2,398,000864 Orange AveSunnyvale CA 94087View Listing
$2,388,0001574 Vireo AveSunnyvale CA 94087View Listing
$2,290,000750 Calla DrSunnyvale CA 94086View Listing
$2,200,0001381 Hampton DrSunnyvale CA 94087View Listing
$2,190,000438 Joshua WaySunnyvale CA 94086View Listing
$2,188,888645 Nashua CtSunnyvale CA 94087View Listing
$2,188,800475 Molino AveSunnyvale CA 94086View Listing
$2,188,0001477 Yukon DrSunnyvale CA 94087View Listing
$2,188,000838 Devonshire WaySunnyvale CA 94087View Listing
$2,050,0001078 S Bernardo AveSunnyvale CA 94087View Listing
$1,990,000306 Bartlett AveSunnyvale CA 94086View Listing
$1,799,000918 Mockingbird LnSunnyvale CA 94087View Listing
$1,690,000524 E Washington AveSunnyvale CA 94086View Listing
$1,648,888491 Isla Vista TerSunnyvale CA 94085View Listing
$1,588,000541 San Marcos Ter Unit 3Sunnyvale CA 94085View Listing
$1,555,000713 Lakebird DrSunnyvale CA 94089View Listing
$1,488,8881084 Doheny TerSunnyvale CA 94085View Listing
$1,389,000123 Maidenhair TerSunnyvale CA 94086View 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-12-2024 2:02:00 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