SELECT *, CASE WHEN `name` LIKE "long beach%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "long beach" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "long beach" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "long beach" 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 ("long beach") 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,359,0002412 Palo Verde AveLong Beach CA 90815View Listing
$1,325,0001309 E 2nd StLong Beach CA 90802View Listing
$1,310,0004989 E Ferro StLong Beach CA 90815View Listing
$1,300,000600 Terraine AveLong Beach CA 90814View Listing
$1,299,0003805 Linden AveLong Beach CA 90807View Listing
$1,299,000388 E Ocean Blvd Unit P8Long Beach CA 90802View Listing
$1,299,000340 Ultimo AveLong Beach CA 90814View Listing
$1,289,8884264 Pepperwood AveLong Beach CA 90808View Listing
$1,270,0006140 Orange AveLong Beach CA 90805View Listing
$1,250,0003260 Val Verde AveLong Beach CA 90808View Listing
$1,250,0003659 Woodruff AveLong Beach CA 90808View Listing
$1,200,0002715 E 3rd StLong Beach CA 90814View Listing
$1,199,0002410 Clark AveLong Beach CA 90815View Listing
$1,199,0002180 Snowden AveLong Beach CA 90815View Listing
$1,199,0005135 E Eagle StLong Beach CA 90815View Listing
$1,199,0001819 Vuelta Grande AveLong Beach CA 90815View Listing
$1,195,0005366 Pine AveLong Beach CA 90805View Listing
$1,150,000307 Roswell AveLong Beach CA 90814View Listing
$1,150,0003666 N Pioneer BlvdLong Beach CA 90808View Listing
$1,150,0003310 E Vista StLong Beach CA 90803View Listing
$1,150,0006815 E Monlaco RdLong Beach CA 90808View Listing
$1,149,000850 Lees AveLong Beach CA 90815View Listing
$1,125,000274 Ximeno AveLong Beach CA 90803View Listing
$1,100,0006516 E Harco StLong Beach CA 90808View 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-09-2024 7:45:24 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