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 found.
BELLEVUE SCHOOL DISTRICT Bellevue, Washington NOTICE OF A PUBLIC HEARING OF THE BOARD OF DIRECTORS TO AN AMENDING RESOLUTION TO REDIRECT BOND FUNDS Notice is hereby given that the Bellevue School District No. 405 will hold a public meeting on September 16, 2014, at 12241 Main Street, Bellevue, Washington, at... [Full Notice]
Latest King County business news.
Major King County transportation players Metro and Sound Transit face massive cumulative deficits projected into 2015 and rapidly increasing ridership. County Executive Dow Constantine has instructed both agencies to work together to integrate and streamline service and planning. Read More ›
The city has cleared the design for a seven-story AC Marriott Hotel on Northeast Second in downtown Bellevue to offer upscale lodging downtown. Read More ›
Bellevue startup reports massive gains since 2010 | Point Inside improving in-store retail experiences - Bellevue ReporterWednesday September 17, 2014 at 07:00 AM
Bellevue-based tech startup Point Inside today (Wednesday) announced a 1,690 percent growth in revenue since 2010, which CEO Josh Marti says positions the company to focus on new capabilities and products looking 18 months ahead. Read More ›
The Windermere Kirkland-Yarrow Bay office welcomes broker Lynn Sanborn back to their office which is located at 3933 Lake Washington Blvd NE. Read More ›
Membership director and Snoqualmie Valley resident Lizzy Billington is stepping up as new CEO of the Snoqualmie Valley Chamber of Commerce, days after Nate Perea announced his departure for a new role.Perea, who has led the chamber for 16 months, gave notice Thursday, August 28. He is now director of membership experience for the Master Builders Association of King and Snohomish Counties. Perea came to the Snoqualmie Valley chamber April 1, 2013, after serving as the director of membership development for the Issaquah chamber. Read More ›
After nearly two months on the market, Kidder Mathews has confirmed the Red Lion Hotel Bellevue is in contract to be sold. Read More ›