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.000075296{main}( )../index.php:0
20.0018320840Dispatcher->dispatch( )../index.php:82
30.07614837312Dispatcher->_invoke( )../dispatcher.php:245
40.08655386216call_user_func_array ( )../dispatcher.php:263
50.08655386512FindaprofessionalController->index( )../dispatcher.php:0
60.09145427824FindaprofessionalController->__office( )../findaprofessional_controller.php:104
70.71685972128Controller->render( )../findaprofessional_controller.php:271
80.71685972696AppController->beforeRender( )../controller.php:534
90.78776223472Zip->getZipNear( )../app_controller.php:280
100.78776224872Model->find( )../zip.php:25
110.78776225472Model->findAll( )../model_php5.php:1146
120.78786228024DboSource->read( )../model_php5.php:1199
130.78956233256DboSource->fetchAll( )../dbo_source.php:564
140.78956233552DboSource->execute( )../dbo_source.php:296
150.79126233840DboSource->showQuery( )../dbo_source.php:165
160.79136234400trigger_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.000075296{main}( )../index.php:0
20.0018320840Dispatcher->dispatch( )../index.php:82
30.07614837312Dispatcher->_invoke( )../dispatcher.php:245
40.08655386216call_user_func_array ( )../dispatcher.php:263
50.08655386512FindaprofessionalController->index( )../dispatcher.php:0
60.09145427824FindaprofessionalController->__office( )../findaprofessional_controller.php:104
70.71685972128Controller->render( )../findaprofessional_controller.php:271
80.71685972696AppController->beforeRender( )../controller.php:534
90.78776223472Zip->getZipNear( )../app_controller.php:280
100.79576171416Model->find( )../zip.php:37
110.79576172016Model->findAll( )../model_php5.php:1146
120.79586174424DboSource->read( )../model_php5.php:1199
130.79736179656DboSource->fetchAll( )../dbo_source.php:564
140.79736179952DboSource->execute( )../dbo_source.php:296
150.79836180240DboSource->showQuery( )../dbo_source.php:165
160.79836180800trigger_error ( )../dbo_source.php:439

Advanced Affordable Hearing Solutions | Hearing Aids in N...

Advanced Affordable Hearing Solutions

747 Farmington Ave
New Britain, Connecticut, 06053, US
map
phone (860) 224-1617
Website www.affordablehearing.us

Map

Staff

Rioux Henry Rioux
BC-HIS, Owner




Rioux-Wade Judy Rioux-Wade
Controller




Brown Lynne Brown
Customer Service Representative




Lapenna Charles Lapenna
CT HIS



After being in the health care field as an administrator for a nursing home, I wanted to do more in the way of helping people. After I became a Hearing Instrument Specialist I felt even more rewarded in my work. My favorite part of my job is being able to help my patients in their home. As you age a lot of things are taking away from you, your ability to see, which impairs your ability to drive, one of the biggest freedoms we have. For me to be able to service and test my patients in the home, means that they no longer have to search for the ride, pay for a cab or wait for family to get out of work, I still enable them to have a sense of independence.

Vescera Gary C. Vescera
HIS




M. Stan M.
Customer Service Representative



I came to Affordable Hearing Solutions after retiring from a 45 year position in the banking industry. This background has suited me well in my public contact with the hearing impaired on a personal basis, as I am also a senior citizen which is our usual age of our patient. I feel that this better helps me relate with them.

W. Janice W.
Customer Service Representative



I came to the company with the faith of making patients happier. I enjoy the patients putting their trust in me, I strive to make them feel as comfortable as possible and show lots of care for their needs.

Virtual Hearing Aid Seminar

Driving Directions

Contact Us Now

call(860) 224-1617

verification image

Tags: Advanced Affordable Hearing Solutions, Hearing Aids, New Britain, Connecticut, 747 Farmington Ave, 06053, Hearing Aids & Assistive Devices, Hearing Aids & Assistive Devices Service & Repair, Hearing Aid Specialists, Hearing Tests

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