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.
Tuesday January 27, 2015 at 03:00 PM
Barrecor, a new exercise studio, will open this week in the Hildebrand Village. Read More ›
Friday January 23, 2015 at 06:00 AM
Port Orchard Chamber of Commerce Executive Director Matt Murphy delivered his State of the Chamber address at the Jan. 15 monthly luncheon at the Port Orchard Pavilion. Read More ›
Monday January 26, 2015 at 10:00 AM
Washington State Department of Revenue is offering some tips to help businesses file their taxes on time. Read More ›
Friday January 23, 2015 at 09:00 AM
Christine Wringren, of Poulsbo's former Sugar & Spice Tea Company, has taken over Mrs. Muir's House of Ghosts and Magic in Port Gamble and will open the shop full time. Read More ›
Thursday January 22, 2015 at 10:00 AM
The state Department of Health has taken disciplinary actions or withdrawn charges against the following health care providers in Kitsap. Read More ›
Thursday January 22, 2015 at 09:00 AM
The Greater Poulsbo Chamber of Commerces annual Presidents Gala and Community Awards Banquet is Jan. 24, 6-9 p.m., at Kiana Lodge. Call 360-779-4999. The chamber will install its leadership for 2015. Awards will be presented to the Young Leader of the Year, Emerging Business of the Year, Organization of the Year, Volunteer of the Year, Business of the Year, Person of the Year Read More ›