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 26, 2014 at 10:00 AM
Rep. Derek Kilmer, D-Bremerton, released the following statement on Nov. 25 after the Puget Sound Naval Shipyard and Intermediate Maintenance Facility announced it will hire 850 entry-level workers. Read More ›
Tuesday November 25, 2014 at 12:00 PM
Rep. Derek Kilmer, D-Bremerton, released the following statement on Nov. 25 after the Puget Sound Naval Shipyard and Intermediate Maintenance Facility announced it will hire 850 entry-level workers. Read More ›
Monday November 24, 2014 at 04:00 PM
Dragonfly Farms has provided nursery and landscaping services for nearly 15 years at its Kingston-area location. Now the business has aims to become a draw for weddings and other events, and is using online crowdfunding to seek support so it can do so. Read More ›
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 ›
Monday November 24, 2014 at 07:00 AM
According to the National Retail Federation, shoppers spent an average of $407 last year and more than 100 million consumers shopped on Thanksgiving Day and Black Friday. 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 ›