SELECT *, CASE WHEN `name` LIKE "rancho palos verdes%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "rancho palos verdes" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "rancho palos verdes" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "rancho palos verdes" 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 ("rancho palos verdes") 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.
$7,990,0002950 Twin Harbors View DrRancho Palos Verdes CA 90275View Listing
$7,499,99945 Oceanaire DrRancho Palos Verdes CA 90275View Listing
$3,995,0003234 Parkhurst DrRancho Palos Verdes CA 90275View Listing
$3,499,00042 Santa Barbara DrRancho Palos Verdes CA 90275View Listing
$3,400,000122 Spindrift LnRancho Palos Verdes CA 90275View Listing
$2,895,0002720 Colt RdRancho Palos Verdes CA 90275View Listing
$2,850,00030538 Rhone DrRancho Palos Verdes CA 90275View Listing
$2,795,00029711 Grandpoint LnRancho Palos Verdes CA 90275View Listing
$2,790,0006966 Crest RdRancho Palos Verdes CA 90275View Listing
$2,688,00027772 Palos Verdes Dr ERancho Palos Verdes CA 90275View Listing
$2,590,00021 Sweetbay RdRancho Palos Verdes CA 90275View Listing
$2,395,00030203 Rhone DrRancho Palos Verdes CA 90275View Listing
$2,350,00030332 Via BoricaRancho Palos Verdes CA 90275View Listing
$2,350,0006636 Locklenna LnRancho Palos Verdes CA 90275View Listing
$2,349,0002256 Rue Le CharleneRancho Palos Verdes CA 90275View Listing
$2,295,0006338 Sattes DrRancho Palos Verdes CA 90275View Listing
$2,275,0006055 Montemalaga DrRancho Palos Verdes CA 90275View Listing
$2,249,0006504 Via LorenzoRancho Palos Verdes CA 90275View Listing
$2,200,00030707 Cartier DrRancho Palos Verdes CA 90275View Listing
$2,150,0003158 Crownview DrRancho Palos Verdes CA 90275View Listing
$2,100,00030326 Ganado DrRancho Palos Verdes CA 90275View Listing
$2,000,0004276 Admirable DrRancho Palos Verdes CA 90275View Listing
$1,950,0005413 Diversey DrRancho Palos Verdes CA 90275View Listing
$1,899,0003139 Dianora DrRancho Palos Verdes CA 90275View 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-12-2024 9:43:10 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
