SELECT *, CASE WHEN `locality` LIKE "garden city%" 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 ("garden city") 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.
$1,787,58016890 Cattlemans WayGreeley CO 80631View Listing
$1,750,000Highway 34 BypGreeley CO 80634View Listing
$1,720,00032795 Eagleview DrGreeley CO 80631View Listing
$1,717,07516886 Cattlemans WayGreeley CO 80631View Listing
$1,650,0008772 County Road 54Milliken CO 80543View Listing
$1,599,00035494 County Road 43Eaton CO 80615View Listing
$1,577,00020664 Niobrara BlvdLa Salle CO 80645View Listing
$1,570,965Kohler Farms RdKersey CO 80644View Listing
$1,563,00010829 Highway 257 SpurGreeley CO 80634View Listing
$1,299,90025596 County Road 54 1/4Kersey CO 80644View Listing
$1,299,00028127 County Road 60 1/2Greeley CO 80631View Listing
$1,299,00011248 Hillcrest DrGreeley CO 80631View 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