SELECT *, CASE WHEN `name` LIKE "castaic%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "castaic" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "castaic" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "castaic" 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 ("castaic") 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.
$5,750,00036059 Golden State HwyCastaic CA 91384View Listing
$1,775,00030450 Hidden Valley CtCastaic CA 91384View Listing
$1,650,00029826 Arroyo Oak LnCastaic CA 91384View Listing
$1,575,00030500 Romero Canyon RdCastaic CA 91384View Listing
$1,499,70030007 Sagecrest WayCastaic CA 91384View Listing
$1,299,00028316 Cascade RdCastaic CA 91384View Listing
$1,030,00028826 Saddle CirCastaic CA 91384View Listing
$1,025,00030556 Beryl PlCastaic CA 91384View Listing
$975,00028632 Black Oak LnCastaic CA 91384View Listing
$959,90028410 Orange Park DrCastaic CA 91384View Listing
$949,88831833 The Old RdCastaic CA 91384View Listing
$930,00028026 Forst CtCastaic CA 91384View Listing
$900,00031053 Hasley Canyon RdCastaic CA 91384View Listing
$855,00027764 Villa Canyon RdCastaic CA 91384View Listing
$850,00030438 Barcelona RdCastaic CA 91384View Listing
$848,80030448 Barcelona RdCastaic CA 91384View Listing
$845,00030389 Falls DrCastaic CA 91384View Listing
$843,50031256 Quail Valley RdCastaic CA 91384View Listing
$799,50032509 The Old RdCastaic CA 91384View Listing
$749,00029530 Cambridge AveCastaic CA 91384View Listing
$749,00029046 Sheridan RdCastaic CA 91384View 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-05-2024 3:09:43 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