SELECT *, CASE WHEN `name` LIKE "monterey park%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "monterey park" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "monterey park" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "monterey park" 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 ("monterey park") 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,600,000508 Brightwood StMonterey Park CA 91754View Listing
$1,498,000308 S Alhambra AveMonterey Park CA 91755View Listing
$1,419,8001469 Abajo DrMonterey Park CA 91754View Listing
$1,399,888720 Cadiz StMonterey Park CA 91754View Listing
$1,350,000745 Metro DrMonterey Park CA 91755View Listing
$1,220,0001395 Lightview StMonterey Park CA 91754View Listing
$1,100,000512 Everett AveMonterey Park CA 91755View Listing
$1,068,0001751 Verde Vista DrMonterey Park CA 91754View Listing
$988,000329 W Gleason StMonterey Park CA 91754View Listing
$950,000228 E Floral DrMonterey Park CA 91755View Listing
$949,000316 Elizabeth AveMonterey Park CA 91755View Listing
$878,999740 Divina Vista StMonterey Park CA 91754View Listing
$870,000331 E Newmark AveMonterey Park CA 91755View Listing
$860,0001798 Polk WayMonterey Park CA 91755View Listing
$845,000936 Coriolanus DrMonterey Park CA 91755View Listing
$829,999325 W Hammel StMonterey Park CA 91754View Listing
$829,900228 S Ynez AveMonterey Park CA 91754View Listing
$799,9992315 Hillview AveMonterey Park CA 91754View Listing
$799,000424 S Moore AveMonterey Park CA 91754View Listing
$788,000522 N Ynez Ave Apt CMonterey Park CA 91754View Listing
$760,000844 S Garfield AveMonterey Park CA 91754View Listing
$750,000604 S Ynez AveMonterey Park CA 91754View Listing
$728,000858 S Garfield AveMonterey Park CA 91754View Listing
$699,0002410 Gladmar StMonterey Park CA 91754View 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-16-2024 6:16:03 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