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.
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 ›
Friday July 11, 2014 at 07:00 AM
Sonia Tosunian moved in November to Port Orchard from Orange County, Calif., and decided to open her own business, Brighten Your Day. Her motto is Your personal assistant for every need. Read More ›