SELECT *, CASE WHEN `locality` LIKE "woodcrest%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "CA" AND (locality IN ("woodcrest") 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
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.
$4,500,00012520 Frederick StreetMoreno Valley CA 92553View Listing
$2,800,00013703 Edgemont StreetMoreno Valley CA 92553View Listing
$1,500,00028070 Bradshaw Cir.Moreno Valley CA 92555View Listing
$800,00024266 Postal AvenueMoreno Valley CA 92553View Listing
$800,00024250 Postal AvenueMoreno Valley CA 92553View Listing
$599,9990 Bradshaw CircleMoreno Valley CA 92555View Listing
$500,0001 Cantarini RoadMoreno Valley CA 92557View Listing
$500,0000 Via BarrancaLake Mathews CA 92570View Listing
$500,0001057 Center StreetHighgrove CA 92507View Listing
$499,00017520 Porter AvenueWoodcrest CA 92504View Listing
$450,00012550 Indian StreetMoreno Valley CA 92553View Listing
$405,00020855 Villa KnollLake Mathews CA 92570View Listing
LENDORS & TITLE COMPANIES
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
Commercial
Land
Ranch