SELECT *, CASE WHEN `name` LIKE "buena vista%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "buena vista" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "buena vista" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "buena vista" 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 ("buena vista") 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.
$4,950,00019000 Mountain View DrBuena Vista CO 81211View Listing
$3,500,0001004 W Main StBuena Vista CO 81211View Listing
$2,740,00022104 Maud LnBuena Vista CO 81211View Listing
$2,100,00017448 Reserve DrBuena Vista CO 81211View Listing
$1,895,00030161 Trails EndBuena Vista CO 81211View Listing
$1,799,00017470 Reserve DrBuena Vista CO 81211View Listing
$1,675,00016689 County Road 363Buena Vista CO 81211View Listing
$1,500,00027581 County Road 301Buena Vista CO 81211View Listing
$1,499,00015611 Paintbrush StBuena Vista CO 81211View Listing
$1,300,00015685 Par LnBuena Vista CO 81211View Listing
$1,295,00016700 County Road 327Buena Vista CO 81211View Listing
$1,295,00030611 Main Range DrBuena Vista CO 81211View Listing
$1,295,00030002 Creek RunBuena Vista CO 81211View Listing
$1,195,00030288 Eagles RdgBuena Vista CO 81211View Listing
$1,150,00030210 Aspen TurnBuena Vista CO 81211View Listing
$1,150,00030477 Valley View DrBuena Vista CO 81211View Listing
$1,098,000462 E Arkansas StBuena Vista CO 81211View Listing
$985,000692 Cedar StBuena Vista CO 81211View Listing
$925,00028885 Fairway DrBuena Vista CO 81211View Listing
$925,00016280 County Road 350Buena Vista CO 81211View Listing
$899,00033469 County Road 373ABuena Vista CO 81211View Listing
$890,00024262 Fishermans Bridge RdBuena Vista CO 81211View Listing
$849,000128 Connie DrBuena Vista CO 81211View Listing
$835,00015662 Cactus LnBuena Vista CO 81211View 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 5:49:28 pm.
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