SELECT *, CASE WHEN `name` LIKE "hayward%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hayward" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hayward" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hayward" 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 ("hayward") 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.
$3,995,00025530 Dario TerHayward CA 94541View Listing
$2,500,000187 Arundel PlHayward CA 94542View Listing
$2,290,0002822 Breaker CirHayward CA 94545View Listing
$1,799,000118 Sonas DrHayward CA 94542View Listing
$1,798,00026233 Clover RdHayward CA 94542View Listing
$1,788,000371 Drummond DrHayward CA 94542View Listing
$1,680,00021833 Meekland AveHayward CA 94541View Listing
$1,598,00025732 West CtHayward CA 94541View Listing
$1,588,000255 Bridgewater RdHayward CA 94544View Listing
$1,488,00029020 Tern PlHayward CA 94545View Listing
$1,375,00022941 Ashwin CtHayward CA 94541View Listing
$1,240,0001030 Highland BlvdHayward CA 94542View Listing
$1,190,00022488 Bayview AveHayward CA 94541View Listing
$1,175,00025705 Westview WayHayward CA 94542View Listing
$1,149,00022173 Main StHayward CA 94541View Listing
$1,120,000426 Mackenzie PlHayward CA 94544View Listing
$1,115,00029710 Hansen StHayward CA 94544View Listing
$1,100,00021132 Garden AveHayward CA 94541View Listing
$1,100,00021164 Garden AveHayward CA 94541View Listing
$1,098,00024375 Chandler RdHayward CA 94545View Listing
$1,050,00029712 Hansen StHayward CA 94544View Listing
$1,019,999531 Ellery PlHayward CA 94544View Listing
$1,000,000402 Saint Andrews StHayward CA 94544View Listing
$1,000,0002017 Parkhurst StHayward CA 94541View 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 12:17:48 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