SELECT *, CASE WHEN `name` LIKE "elizabeth%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "elizabeth" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "elizabeth" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "elizabeth" 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 = "CO" AND (locality IN ("elizabeth") 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.
$2,375,00032961 County Road 25Elizabeth CO 80107View Listing
$2,200,0005101 Blue Bell TrlElizabeth CO 80107View Listing
$2,195,00036200 County Road 1Elizabeth CO 80107View Listing
$2,140,000121 County Road 146Elizabeth CO 80107View Listing
$2,000,00037910 Winook CirElizabeth CO 80107View Listing
$1,250,00037695 Tarie TrlElizabeth CO 80107View Listing
$1,200,000270 High Meadows LoopElizabeth CO 80107View Listing
$1,200,0004155 County Road 114Elizabeth CO 80107View Listing
$1,200,00083 Rocky Cliff RdElizabeth CO 80107View Listing
$1,200,0002972 Rock CirElizabeth CO 80107View Listing
$1,170,00039441 Stockton CirElizabeth CO 80107View Listing
$1,160,00035055 County Road 17Elizabeth CO 80107View Listing
$1,120,00039417 Stockton CirElizabeth CO 80107View Listing
$1,098,00039412 Stockton CirElizabeth CO 80107View Listing
$1,050,000218 High Meadows LoopElizabeth CO 80107View Listing
$1,000,00010852 Rolling Vista TrlElizabeth CO 80107View Listing
$935,00042061 N Pinehurst CirElizabeth CO 80107View Listing
$899,90047800 Private Road 39Elizabeth CO 80107View Listing
$899,9004576 Park LnElizabeth CO 80107View Listing
$874,9991377 Stage Run TrlElizabeth CO 80107View Listing
$848,950895 W Witherspoon DrElizabeth CO 80107View Listing
$832,581740 Tubman DrElizabeth CO 80107View Listing
$825,0001089 E Witherspoon DrElizabeth CO 80107View Listing
$799,950904 W Witherspoon DrElizabeth CO 80107View 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-06-2024 7:33:21 am.
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