SELECT *, CASE WHEN `name` LIKE "torrance%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "torrance" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "torrance" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "torrance" 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 ("torrance") 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.
$904,9902750 W 182nd St Unit 144Torrance CA 90504View Listing
$900,0003442 Del Amo BlvdTorrance CA 90503View Listing
$899,9902750 W 182nd St Unit 145Torrance CA 90504View Listing
$899,00020802 Brighton AveTorrance CA 90501View Listing
$899,0002511 Monterey StTorrance CA 90503View Listing
$890,0003714 W 181st St Unit SiTorrance CA 90504View Listing
$885,9901336 Plaza Del AmoTorrance CA 90501View Listing
$879,90021410 Halldale AveTorrance CA 90501View Listing
$875,00021135 Hobart BlvdTorrance CA 90501View Listing
$874,9901332 Plaza Del AmoTorrance CA 90501View Listing
$849,0004112 W 173rd PlTorrance CA 90504View Listing
$829,0002118 W 177th StTorrance CA 90504View Listing
$826,0741602 Plaza Del AmoTorrance CA 90501View Listing
$799,99922330 Meyler St Apt 4Torrance CA 90502View Listing
$799,00018031 Falda AveTorrance CA 90504View Listing
$799,00023012 Berendo AveTorrance CA 90502View Listing
$790,0001622 W 220th St Unit 2Torrance CA 90501View Listing
$760,0003536 Redondo Beach BlvdTorrance CA 90504View Listing
$725,0001514 W 207th St Unit BTorrance CA 90501View Listing
$689,0001126 W 228th St Unit 15Torrance CA 90502View Listing
$675,0001250 Engracia AveTorrance CA 90501View 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 10:07:13 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