select "a-" as test,l.pubid,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_location ll join ads.legals l on l.pubid = ll.pubid and CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) where ll.county like '%king%' and l.adid like '%%' AND CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) and l.pubid like '%bel%' group by groupText,l.startdate,l.enddate order by l.text;
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 - 2
GOLDBERG & OSBORNE Stephanie M. Ireland, Esq. 4423 E. Thomas Road, Suite 3 Phoenix, Arizona 85018 State BarNo. 018108 (602) 808-6200. sireland@ goldbergandosborne.com Attorneys for Plaintiff In the Superior Court of the State of Arizona in and for the County of Marjcopa DAVID E. RAU, a single individual, Plaintiff, vs.... [Full Notice]
Superior Court of Washington County of King YOLANDA VONDIESSL LINT Petitioner, And CHRISTIAN LEE LINT Respondent No. 15-3-01731-8SEA Summons by Publication To the Respondent CHRISTIAN LEE LINT The petitioner has started an action in the above court requesting that your marriage or domestic partnership be dissolved. The petition also requests... [Full Notice]
Latest King County business news.
Founder Institute brings early-stage startup program to Eastside | Director warns not all will graduate - Bellevue ReporterTuesday March 24, 2015 at 01:00 PM
Founder Institute Seattle director Maria Dykstra says the early-stage startup accelerator is focusing on drawing in Eastside entrepreneurs for its next 14-week program, but cautions not everyone admitted will make it to the end. Read More ›
Kemper Freeman used Lincoln Square's new studio showcase room Monday to announce a W Hotel will be a significant feature of the Lincoln Square expansion when it opens in 2017. Read More ›
Every young child has a dream. Adults have dreams, too; but as we grow up, they often get lost along the way. Read More ›
Balls and Whistles Music Bar will open in Kirkland at 7 p.m. on March 28. Read More ›
Local signs and visual graphics provider FASTSIGNS of Kirkland was named one of the top centers out of more than 570 locations worldwide at the 2015 FASTSIGNS International Convention, which was recently held in Dallas, Texas. Read More ›
Chick-fil-A opening with a camp out' | First 100' customers to stay night in parking lot - Bellevue ReporterTuesday March 17, 2015 at 05:00 PM
The first Chick-fil-A in Washington will open April 9 in Bellevue, but those wanting a first taste of the action should consider bringing a sleeping bag. Read More ›