Query: SELECT `Zip`.`zip`, `Zip`.`lat`, `Zip`.`lon`, `Zip`.`city`, `Zip`.`state`, `Zip`.`county`, `Zip`.`is_primary`, `Zip`.`population`, `Zip`.`cityaliasname`, `Zip`.`areacode`, `Zip`.`has_location` FROM `zipcodes` AS `Zip` WHERE `Zip`.`lat` BETWEEN '38' AND '38' AND `Zip`.`lon` BETWEEN '-97' AND '-97' AND `Zip`.`state` LIKE LIMIT 1
( ! ) Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 in /var/www/websites-local/prod/wdp/cake/libs/model/datasources/dbo_source.php on line 439
Call Stack
#TimeMemoryFunctionLocation
10.000075232{main}( )../index.php:0
20.0020320552Dispatcher->dispatch( )../index.php:82
30.37304642080Dispatcher->_invoke( )../dispatcher.php:245
40.38545111104call_user_func_array ( )../dispatcher.php:263
50.38545111392HhcontentController->show( )../dispatcher.php:0
60.53955240584Controller->render( )../hhcontent_controller.php:259
70.53955241152HhcontentController->beforeRender( )../controller.php:534
80.53955243960AppController->beforeRender( )../hhcontent_controller.php:28
90.65315544120Zip->getZipNear( )../app_controller.php:280
100.65325545520Model->find( )../zip.php:25
110.65325546120Model->findAll( )../model_php5.php:1146
120.65335548672DboSource->read( )../model_php5.php:1199
130.65535553904DboSource->fetchAll( )../dbo_source.php:564
140.65535554200DboSource->execute( )../dbo_source.php:296
150.67425554488DboSource->showQuery( )../dbo_source.php:165
160.67425555048trigger_error ( )../dbo_source.php:439

Query: SELECT `Zip`.`zip`, `Zip`.`lat`, `Zip`.`lon`, `Zip`.`city`, `Zip`.`state`, `Zip`.`county`, `Zip`.`is_primary`, `Zip`.`population`, `Zip`.`cityaliasname`, `Zip`.`areacode`, `Zip`.`has_location` FROM `zipcodes` AS `Zip` WHERE `Zip`.`lat` BETWEEN '37' AND '39' AND `Zip`.`lon` BETWEEN '-98' AND '-96' AND `Zip`.`state` LIKE LIMIT 1
( ! ) Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 in /var/www/websites-local/prod/wdp/cake/libs/model/datasources/dbo_source.php on line 439
Call Stack
#TimeMemoryFunctionLocation
10.000075232{main}( )../index.php:0
20.0020320552Dispatcher->dispatch( )../index.php:82
30.37304642080Dispatcher->_invoke( )../dispatcher.php:245
40.38545111104call_user_func_array ( )../dispatcher.php:263
50.38545111392HhcontentController->show( )../dispatcher.php:0
60.53955240584Controller->render( )../hhcontent_controller.php:259
70.53955241152HhcontentController->beforeRender( )../controller.php:534
80.53955243960AppController->beforeRender( )../hhcontent_controller.php:28
90.65315544120Zip->getZipNear( )../app_controller.php:280
100.69595551592Model->find( )../zip.php:37
110.69605552192Model->findAll( )../model_php5.php:1146
120.69605554600DboSource->read( )../model_php5.php:1199
130.69805559832DboSource->fetchAll( )../dbo_source.php:564
140.69805560128DboSource->execute( )../dbo_source.php:296
150.70145560416DboSource->showQuery( )../dbo_source.php:165
160.70145560976trigger_error ( )../dbo_source.php:439

HLA- Florida Offers Chance to Win... | Healthy Hearing

HLA- Florida Offers Chance to Win October Cruise for Two

Sunday, February 7th 2010
Font Size S M L

The Assocation is offering raffle tickets for a "Cruise for Two" on the newer Royal Caribbean ruise ship, Freedom of the Seas, sailing October 17, 2010 to the Western Caribbean.

The cruise sails out of Port Canaveral and will be full of extras for hard of hearing passengers. Assistive devices in the cabins, captioning of the live entertainment and floor shows, a section of the dining area for the group, and a private welcome aboard party.

Ticket donations are $10.00 each and includes – for two – all meals on board, noncarbonated drinks and non-alcoholic beverages, entrance to all ship's hot spots, casino, ice shows, art galleries,floor shows, piano lounge. Port charges, government fees and taxes are included in the in the prize.

Open to all USA residents, one does not have to have a hearing loss to join us. It is not a deaf cruise, just a group cruise of interested passengers who may or may not have a hearing loss.

Please contact Lynn Rousseau at HLAFlorida@aol.com  if interested in taking a chance for the winning ticket.

Reservations are still open if anyone wishes to book this cruise to join us. Contact Barbara Maher at barbaram@gotravelorlando.com while pricing is low.

More details and the itinerary can be found on www.HLA-FL.com

Font Size S M L
About Healthy Hearing
Healthy Hearing

As Your Homepage for Hearing Healthcare, Healthy Heaing provides opportunities to customize our information for you or a loved one with hearing loss.  When you Get HAPPYTM! you are sent, for free, some of the most comprehensive information found on hearing aids and cochlear implants available to consumer patients today.  We encourage you to take the next step and share this information with a licensed professional. Your local hearing healthcare provider is the key in connecting all of this information into the best rehabilitation plan for your specific lifestyle and hearing needs.  If you would like, you can also research the latest in digital hearing aid and cochlear implant technology  from some of the largest and most respected companies in the world.  If you want to keep up with the latest, view our news articles and releases on our home page, or simply tap into our RSS feeds.  Finally, our eNewsletters also allow for our updates in your inbox.

For more information, visit www.healthyhearing.com/happy/

Local Hearing Professionals
Audiology Clinic
Emporia, KS 66801
620 343-1100 more »
Audiology Clinic
Junction City, KS 66441
(785) 238-6633 more »

more listings near Emporia, KS »



Local Hearing Professionals
Audiology Clinic
Emporia, KS 66801
620 343-1100 more »
Audiology Clinic
Junction City, KS 66441
(785) 238-6633 more »
Audiology Associates - Manhattan Medical Center
Manhattan, KS 66502
785 539 7361 more »
Advanced Hearing Solutions
Olathe, KS 66061
(913) 764-5355 more »
Hearing Specialists of Tulsa
Tulsa, OK 74104
918-592-3737 more »
Hometown Hearing & Audiology
Overland Park, KS 66212
816-313-2800 more »

more listings near Emporia, KS »

Questions?  Give us a call today at 800-567-1692
Sign up for our eNewsletter

Text Size:

S M L