SELECT *, CASE WHEN `name` LIKE "lake arrowhead%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake arrowhead" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake arrowhead" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake arrowhead" 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 = "CA" AND (locality IN ("lake arrowhead") 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 2
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" 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 2
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.
$12,550,0001000 Robinhood DrLake Arrowhead CA 92352View Listing
$9,500,000365 Mittry LnLake Arrowhead CA 92352View Listing
$6,750,00027913 S Peninsula DrLake Arrowhead CA 92352View Listing
$5,995,00027615 Meadow Bay DrLake Arrowhead CA 92352View Listing
$5,450,00027423 N Bay RdLake Arrowhead CA 92352View Listing
$5,249,000496 N State Highway 173Lake Arrowhead CA 92352View Listing
$4,950,000458 State Highway 173Lake Arrowhead CA 92352View Listing
$3,800,000839 Ridge RdLake Arrowhead CA 92352View Listing
$3,700,000165 Rocky Point RdLake Arrowhead CA 92352View Listing
$3,499,000354 State Highway 173Lake Arrowhead CA 92352View Listing
$3,400,00027459 N BayLake Arrowhead CA 92352View Listing
$3,250,000293 N Fairway DrLake Arrowhead CA 92352View Listing
$3,200,000222 John Muir RdLake Arrowhead CA 92352View Listing
$2,999,50029223 Pigeon Hawk LnLake Arrowhead CA 92352View Listing
$2,995,000942 Lake Edge WayLake Arrowhead CA 92352View Listing
$2,895,00027771 Hamiltair DrLake Arrowhead CA 92352View Listing
$2,750,00027452 Alpen DrLake Arrowhead CA 92352View Listing
$2,749,00027961 N Shore RdLake Arrowhead CA 92352View Listing
$2,695,00028315 Somerset DrLake Arrowhead CA 92352View Listing
$2,690,00027589 W Shore RdLake Arrowhead CA 92352View Listing
$2,650,000374 Golf Course RdLake Arrowhead CA 92352View Listing
$2,499,000250 Brentwood DrLake Arrowhead CA 92352View Listing
$2,499,00029231 Pigeon Hawk LnLake Arrowhead CA 92352View Listing
$2,400,00029082 Bald Eagle Ridge RdLake Arrowhead CA 92352View 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-13-2024 1:24:12 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "CA" 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 2
Blah