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.
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 ›
Sunday July 20, 2014 at 09:00 AM
The Kitsap Economic Development Alliance (KEDA) is offering Small Business Finance for Government Contractors: Prepping You for Success, a free two-hour seminar for small businesses who are interested in expanding their business through government contracting. Read More ›
Saturday July 12, 2014 at 07:00 AM
Perfect Party has moved from their old location to 1341 Bay St., in the Westbay Center. Read More ›
Friday July 11, 2014 at 02:00 PM
Research indicates soaring median home prices, sinking inventory. Read More ›