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 July 29, 2014 at 11:00 AM
Christine Daniel resigned her position as executive director of the Port Orchard Chamber of Commerce. Read More ›
Tuesday July 29, 2014 at 01:00 PM
Kitsap Printing, founded in 1982, prints promotional, transactional and published products. Since its acquisition last year, the business has invested in new equipment and new personnel to increase its technological capabilities as well its employee knowledge-base and skill set. Read More ›
Monday July 28, 2014 at 05:00 PM
The Port of Kingston filed an eviction lawsuit against Kingston Adventures owners Beth and Rob Brewster after the Brewsters refused to move their equipment from port property. Notices for the Brewsters to vacate port property by June 30 were not heeded, according to Kitsap County Superior Court documents. Read More ›
Monday July 28, 2014 at 07:00 AM
Sound Publishing Co.s Kitsap newspapers have restructured to improve how the newspapers work together to better serve their communities. Read More ›
Thursday July 17, 2014 at 12:00 PM
Dickeys Barbecue Pit opened its newest location in Port Orchard on July 17 under the leadership of a U.S. Navy veteran. Read More ›
Monday July 21, 2014 at 09:00 AM
Robert Contreras has joined the team at Windermere Real Estate here in Port Orchard as their newest broker. Read More ›