SELECT *, CASE WHEN `locality` LIKE "sawpit%" 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 ("sawpit") 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 *, "0" as `rank` FROM `wp_slides` WHERE st = "CO" 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 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.
$28,000,000Fall Creek RdPlacerville CO 81430View Listing
$12,495,000Elk Creek Meadows Rnch Lot 5Placerville CO 81430View Listing
$11,799,99912665 Highway 62Placerville CO 81430View Listing
$7,995,000280 Sage Grouse NPlacerville CO 81430View Listing
$7,700,0008325 County Road M44Placerville CO 81430View Listing
$7,000,000192 Top of the World DrPlacerville CO 81430View Listing
$5,250,0001006 Top of the World DrPlacerville CO 81430View Listing
$4,750,0003400 Peninsula DrPlacerville CO 81430View Listing
$3,500,0002737 Little Cone Ranch RdPlacerville CO 81430View Listing
$2,795,0001036 Harcourt TrlPlacerville CO 81430View Listing
$2,695,00020978 Highway 145Sawpit CO 81430View Listing
$2,400,0001436 Harcourt TrlPlacerville CO 81430View 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