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: 1 found.
Kitsap County Online 08/15/2014 thru 09/12/2014
IN THE SUPERIOR COURT OF WASHINGTON FOR KITSAP COUNTY KITSAP CREDIT UNION, Plaintiff, v. RSR PROPERTIES, LLC; A WASHINGTON CORPORATION; R.S.R. PROPERTIES, LLC, A WASHINGTON CORPORATION; RICKY D. ROACH AND JANE DOE ROACH, AND THE MARITAL COMMUNITY COMPOSED THEREOF; RAYMOND T. HAYNES AND JANE DOE HAYNES, AND THE MARITAL COMMUNITY... [Full Notice]
Business News
Latest Kitsap County business news.
Friday August 22, 2014 at 08:00 AM
Students in the culinary arts program at Bates Technical College had two options: a day trip to Wild Waves Theme Park or a visit from Bay Street Meat Company butcher and co-owner Brian Brozovic. Read More ›
Friday August 15, 2014 at 10:00 AM
The Goller Gallery made its place on Front Street official with a ribbon cutting on Aug. 7, after four months on the block. Read More ›
Friday August 15, 2014 at 06:00 AM
Educational, and collectable shop moves to Poulsbo Read More ›
Thursday August 14, 2014 at 01:00 PM
A martial art new to the region is being introduced. Read More ›
Friday August 15, 2014 at 12:00 PM
Kitsap Bank promoted Lael Alecci to Branch Manager of the Kitsap Bank of Kingston. Alecci is moving from her position as a Senior Financial Service Specialist, which she began three years ago. Read More ›
Thursday August 14, 2014 at 01:00 PM
Sweet Life Cakery is expanding its business by opening a retail storefront for dine in and pick-up in Kingston. Read More ›