select "b-" as test,l.adid, l.startdate,DATE_ADD(l.enddate,INTERVAL 7 DAY) AS enddate,l.classid,l.text,ll.county,l.classid,substring_index(l.text,' ',50) AS groupText from ads.legals l join ads.legals_location ll on ll.pubid = l.pubid where l.adid like '%%' AND CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) and l.pubid like '%%' and ll.county like '%Snohomish%' group by groupText,l.startdate,l.enddate order by l.text;
Legal Notices
Click on the headline or [Full Notice] link to view the entire notice.
Results: 0 found.
Business News
Latest Snohomish County business news.
Tuesday June 09, 2015 at 02:00 PM
ARLINGTON  While some citizens have expressed concerns about the state of Arlington's downtown, Mike Britt sees a business community that's on the grow, and cites the upcoming Show 'N' Shine car show on Saturday, June 13, as evidence. Read More ›
Tuesday May 19, 2015 at 07:00 AM
TULALIP  Michael Chang retired five years ago, but for the past three years, the Boom City Swap Meet has been his job. Read More ›
Saturday April 25, 2015 at 07:00 AM
OSO  After a tumultuous season last year, in the wake of the Oso slide, the Fruitful Farm & Nursery on Highway 530 aims to have an upgraded facility this season. Read More ›
Sunday April 19, 2015 at 07:00 AM
TULALIP  Jesica Stickles knows the good work that her volunteers are doing through the feedback they get. Read More ›
Sunday April 19, 2015 at 07:00 AM
TULALIP  Jesica Stickles knows the good work that her volunteers are doing through the feedback they get. Read More ›
Saturday April 18, 2015 at 07:00 AM
ARLINGTON  As much as the San Juan Salsa Co. remains committed to serving nothing but handcrafted salsas, they've nonetheless outgrown their facilities and will be expanding into a new building by the end of the year. Read More ›