SELECT *, CASE WHEN `name` LIKE "culver city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "culver city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "culver city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "culver city" 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 ("culver city") 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.
$4,388,0004406 Motor AveCulver City CA 90232View Listing
$3,250,00011120 Braddock DrCulver City CA 90230View Listing
$2,995,0005195 Dobson WayCulver City CA 90230View Listing
$2,500,0004339 Motor AveCulver City CA 90232View Listing
$2,400,0004338 Huntley AveCulver City CA 90230View Listing
$2,399,00011947 Beatrice StCulver City CA 90230View Listing
$2,350,0004225 LA Salle AveCulver City CA 90232View Listing
$1,995,00011853 Weir StCulver City CA 90230View Listing
$1,899,0004016 Astaire AveCulver City CA 90232View Listing
$1,850,0004393 Motor AveCulver City CA 90232View Listing
$1,725,00012059 Juniette StCulver City CA 90230View Listing
$1,699,0004369 Huntley AveCulver City CA 90230View Listing
$1,695,0003950 Huron AveCulver City CA 90232View Listing
$1,600,0004244 Mildred AveCulver City CA 90066View Listing
$1,585,0004054 Coolidge AveCulver City CA 90066View Listing
$1,499,00011906 Weir StCulver City CA 90230View Listing
$1,499,00011946 Aneta StCulver City CA 90230View Listing
$1,489,0003832 Bentley Ave Unit 4Culver City CA 90232View Listing
$1,450,0005422 Selmaraine DrCulver City CA 90230View Listing
$1,429,0004611 Coolidge AveCulver City CA 90230View Listing
$1,395,0003341 McManus AveCulver City CA 90232View Listing
$1,395,0004061 Minerva AveCulver City CA 90066View Listing
$1,299,00011838 Marshall StCulver City CA 90230View Listing
$1,275,00011226 Culver Park DrCulver City CA 90230View 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-04-2024 4:09:00 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