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 ›
Friday November 21, 2014 at 07:00 AM
Our local shops and stores in Port Orchard are brimming with unique gift ideas. 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 ›
Friday November 14, 2014 at 01:00 PM
The latest addition to Poulsbo's growing number of retail stores will open its doors on Nov. 23. CVS pharmacy has quickly put up four walls and a roof on the corner of Highway 305 and Hostmark Street since the demolition of the former Northwest Design Center in June. The building is now complete and shelves are being stocked. Read More ›
Monday November 17, 2014 at 07:00 AM
Washington activities reach all 39 counties  more than any other U.S. state during worldwide celebration of startups and entrepreneurship. Read More ›