SELECT *, CASE WHEN `name` LIKE "aliso viejo%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "aliso viejo" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "aliso viejo" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "aliso viejo" 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 ("aliso viejo") 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.
$1,949,00028 Wild Rose PlAliso Viejo CA 92656View Listing
$1,750,00016 RidgecrestAliso Viejo CA 92656View Listing
$1,699,9004 Oak View DrAliso Viejo CA 92656View Listing
$1,350,00013 HeatherwoodAliso Viejo CA 92656View Listing
$1,280,00032 Cameo DrAliso Viejo CA 92656View Listing
$1,200,00010 White Pelican LnAliso Viejo CA 92656View Listing
$1,150,00047 Bluebird LnAliso Viejo CA 92656View Listing
$1,149,00024 Deerborn DrAliso Viejo CA 92656View Listing
$1,139,00022 Robin RdgAliso Viejo CA 92656View Listing
$1,099,0007 Cayman BracAliso Viejo CA 92656View Listing
$969,0001 Bluff Cove DrAliso Viejo CA 92656View Listing
$855,00037 Sandalwood Unit 91Aliso Viejo CA 92656View Listing
$815,00023 Fulmar LnAliso Viejo CA 92656View Listing
$775,00050 Trillium PlAliso Viejo CA 92656View Listing
$749,00023495 Via JacintoAliso Viejo CA 92656View Listing
$720,00023466 Los AdornosAliso Viejo CA 92656View Listing
$699,00024792 Via San RafaelAliso Viejo CA 92656View Listing
$675,00023431 El ReposaAliso Viejo CA 92656View 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:59:19 pm.
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
Ranch
Single Family
