SELECT *, CASE WHEN `locality` LIKE "salida%" 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 = "CO" AND (locality IN ("salida") 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 3
Blah
SELECT *, CASE WHEN `locality` LIKE "salida%" AND `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "city-agent" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "CO" AND (locality IN ("salida") OR locality IS NULL) AND slide_location IN ("city-agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[2] matching rows / [0.00 msec]
Blog ID 3
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.
$9,200,0006600 County Road 176Salida CO 81201View Listing
$4,800,0005011 County Road 212Salida CO 81201View Listing
$2,790,00011355 County Road 251Salida CO 81201View Listing
$2,113,00012740 County Road 195Salida CO 81201View Listing
$1,894,0007380 Heavenly View PkwySalida CO 81201View Listing
$1,795,0007916 Cozart LnSalida CO 81201View Listing
$1,650,00012605 Coyote Valley RdSalida CO 81201View Listing
$1,625,0005105 US Highway 285Salida CO 81201View Listing
$1,595,0006663 County Road 110Salida CO 81201View Listing
$1,498,50012997 Paradise WaySalida CO 81201View Listing
$1,495,00011677 Saddle Ridge CtSalida CO 81201View Listing
$1,470,0001055 County Road 200Poncha Springs CO 81242View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CO" 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 3
Blah
Commercial
Land
Ranch
Single Family
