SELECT *, CASE WHEN `name` LIKE "anchorage%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "anchorage" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "anchorage" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "anchorage" 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 = "AK" AND (locality IN ("anchorage") 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 22
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AK" 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 22
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,800,00015051 Echo Canyon RdAnchorage AK 99516View Listing
$2,399,00010554 Whitby CirAnchorage AK 99515View Listing
$2,250,00019430 Villages Scenic PkwyAnchorage AK 99516View Listing
$2,025,0004014 North Point DrAnchorage AK 99502View Listing
$1,973,734L11 Red Sky CirAnchorage AK 99516View Listing
$1,950,0005120 Bainbridge CirAnchorage AK 99516View Listing
$1,775,00011741 Barr RdAnchorage AK 99516View Listing
$1,650,0006701 Paula PlAnchorage AK 99507View Listing
$1,500,0006911 Catine CirAnchorage AK 99507View Listing
$1,475,00010040 Schuss DrAnchorage AK 99507View Listing
$1,472,96616310 Mountain Breeze DrAnchorage AK 99516View Listing
$1,380,0003115 Susitna View CtAnchorage AK 99517View Listing
$1,350,00015640 Wind Song DrAnchorage AK 99516View Listing
$1,295,000L1 Huffman RdAnchorage AK 99516View Listing
$1,250,00016074 Mountain Air DrAnchorage AK 99516View Listing
$1,250,000360 Oceanview DrAnchorage AK 99515View Listing
$1,246,1005912 Potter Valley RdAnchorage AK 99516View Listing
$1,214,00019055 Potter Highlands DrAnchorage AK 99516View Listing
$1,199,900L2 Depalatis CirAnchorage AK 99516View Listing
$1,198,0003530 DE Armoun RdAnchorage AK 99516View Listing
$1,195,500L4 Avalanche CirAnchorage AK 99516View Listing
$1,175,00011136 Red Sky CirAnchorage AK 99516View Listing
$1,150,00013868 Canyon RdAnchorage AK 99516View Listing
$1,150,00016847 Woods Pointe CirAnchorage AK 99516View 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-05-2024 4:00:01 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "AK" 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 22
Blah