SELECT *, CASE WHEN `name` LIKE "danville%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "danville" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "danville" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "danville" 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 ("danville") 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,899,000308 Verona AveDanville CA 94526View Listing
$1,898,000235 Laurelglen CtDanville CA 94506View Listing
$1,895,000970 El Cajon DrDanville CA 94526View Listing
$1,824,900215 Heather PlDanville CA 94526View Listing
$1,800,000224 Walnut Creek CtDanville CA 94506View Listing
$1,799,0001237 Greenbrook DrDanville CA 94526View Listing
$1,799,000216 Stetson DrDanville CA 94506View Listing
$1,798,000963 Redwood DrDanville CA 94506View Listing
$1,789,9501138 Greenbrook DrDanville CA 94526View Listing
$1,679,88831 Saint Joan CtDanville CA 94526View Listing
$1,650,000404 Antelope Ridge WayDanville CA 94506View Listing
$1,599,900300 Jacaranda DrDanville CA 94506View Listing
$1,599,000225 Gil Blas RdDanville CA 94526View Listing
$1,499,000124 Gerbera StDanville CA 94506View Listing
$1,399,946720 Senca CtDanville CA 94526View Listing
$1,375,000262 Cameo DrDanville CA 94526View Listing
$1,278,0002145 Myrtle Beach LnDanville CA 94526View Listing
$1,275,0002158 Myrtle Beach LnDanville CA 94526View Listing
$1,250,0001644 Fountain Springs CirDanville CA 94526View Listing
$1,098,0001517 Mission DrDanville CA 94526View Listing
$875,0001837 Ridgeland CirDanville CA 94526View 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 6:44:32 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