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 '%Kitsap%' 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 Kitsap County business news.
Wednesday November 19, 2014 at 05:00 PM
Creative Office Guru, a graphic design company owned by Shirley Bomgaars of Kingston, is now Empty Nest Graphics. Creative Office Guru opened more than five years ago with the intent of providing remote administrative services for small businesses with an emphasis on publication design. As each year passed, the businesss design services became more in demand and, Bomgaars said, I realized that it was my passion. Read More ›
Friday November 21, 2014 at 06:00 AM
Taste offers traditional Chinese food as well as sushi in an illuminating setting. Read More ›
Sunday November 23, 2014 at 07:00 AM
Olympic Bancorp, the holding company for Kitsap Bank, reported a 22-percent increase in earnings for the first nine months of 2014. Read More ›
Friday November 21, 2014 at 07:00 AM
Our local shops and stores in Port Orchard are brimming with unique gift ideas. Read More ›
Saturday November 22, 2014 at 07:00 AM
Kitsap Bank announced that Sonya Pare has been named Employee of the third Quarter of 2014. Read More ›
Tuesday November 18, 2014 at 11:00 AM
Union Bank has announced that it is closing its Kitsap and North Olympic Peninsula branches as part of a move to shut 20 locations in the state. The bank will close its Port Angeles, Port Townsend, Sequim and Poulsbo branches Feb. 20, followed on Feb. 27 by closures of branches in Bremerton, Silverdale and Gig Harbor, according to Union Bank spokesman Alan Gulick. Read More ›