SELECT *, CASE WHEN `name` LIKE "mission viejo%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "mission viejo" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "mission viejo" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "mission 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 ("mission 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,200,00021221 San MiguelMission Viejo CA 92692View Listing
$1,198,00026391 Cortina DrMission Viejo CA 92691View Listing
$1,195,00023961 Warsaw StMission Viejo CA 92691View Listing
$1,195,00021373 MiramarMission Viejo CA 92692View Listing
$1,170,00023892 Lindley StMission Viejo CA 92691View Listing
$1,128,50021121 Peppertree LnMission Viejo CA 92691View Listing
$1,100,00023681 Via ChiripaMission Viejo CA 92691View Listing
$1,099,00022731 LA Vina DrMission Viejo CA 92691View Listing
$1,075,00021282 BristleconeMission Viejo CA 92692View Listing
$1,069,00021951 TobarraMission Viejo CA 92692View Listing
$1,050,00026201 Avenida BonachonMission Viejo CA 92691View Listing
$999,90024126 CalendulaMission Viejo CA 92692View Listing
$998,00027451 TossamarMission Viejo CA 92692View Listing
$950,00027820 Via SarasateMission Viejo CA 92692View Listing
$949,90026281 Papagayo DrMission Viejo CA 92691View Listing
$940,00023541 Via VenturaMission Viejo CA 92692View Listing
$910,00023691 Via BenaventeMission Viejo CA 92692View Listing
$899,99528182 AlavaMission Viejo CA 92692View Listing
$898,00027622 Via GranadosMission Viejo CA 92692View Listing
$880,00023622 Via GarfiasMission Viejo CA 92692View Listing
$868,00027868 Via SarasateMission Viejo CA 92692View Listing
$829,00027651 Via RodrigoMission Viejo CA 92692View Listing
$819,99928137 AlavaMission Viejo CA 92692View Listing
$814,90021121 CancunMission Viejo CA 92692View 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-03-2024 7:53:28 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