SELECT *, CASE WHEN `name` LIKE "lake elsinore%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake elsinore" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake elsinore" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lake elsinore" 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 elsinore") 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.
$2,490,00028067 Highway 74Lake Elsinore CA 92532View Listing
$2,475,00030515 Ortega HwyLake Elsinore CA 92530View Listing
$1,975,00017240 Grand AveLake Elsinore CA 92530View Listing
$1,395,00034550 Hacienda RdLake Elsinore CA 92530View Listing
$1,300,00028750 Pierce AveLake Elsinore CA 92530View Listing
$1,075,00033381 Dreycott WayLake Elsinore CA 92530View Listing
$1,050,00035550 Trabuco DrLake Elsinore CA 92530View Listing
$1,000,00017786 Grand AveLake Elsinore CA 92530View Listing
$975,0002 Ponte RussoLake Elsinore CA 92532View Listing
$929,00016960 Grand AveLake Elsinore CA 92530View Listing
$899,00033161 Marvella LnLake Elsinore CA 92530View Listing
$870,00030962 Via BonicaLake Elsinore CA 92530View Listing
$825,00014923 Via ViolettaLake Elsinore CA 92530View Listing
$820,00026 Via Palmieki CtLake Elsinore CA 92532View Listing
$799,90036589 Obaria WayLake Elsinore CA 92532View Listing
$799,9001 Corte LateuzaLake Elsinore CA 92532View Listing
$799,00010 Vista RipaltiLake Elsinore CA 92532View Listing
$789,000228 S Spring StLake Elsinore CA 92530View Listing
$769,99934317 Otay WayLake Elsinore CA 92532View Listing
$769,00014 Villa RomaLake Elsinore CA 92532View Listing
$759,99930883 Via LakistasLake Elsinore CA 92530View Listing
$751,32616635 Evelyn PlLake Elsinore CA 92530View Listing
$747,00014547 Amorose StLake Elsinore CA 92530View Listing
$745,00033895 Stoneman RdLake Elsinore CA 92530View 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-07-2024 11:48:40 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