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.0021320840Dispatcher->dispatch( )../index.php:82
30.07404837312Dispatcher->_invoke( )../dispatcher.php:245
40.08385386584call_user_func_array ( )../dispatcher.php:263
50.08385386880FindaprofessionalController->index( )../dispatcher.php:0
60.08845428192FindaprofessionalController->__office( )../findaprofessional_controller.php:104
70.41645904680Controller->render( )../findaprofessional_controller.php:271
80.41645905248AppController->beforeRender( )../controller.php:534
90.50016156264Zip->getZipNear( )../app_controller.php:280
100.50016157664Model->find( )../zip.php:25
110.50016158264Model->findAll( )../model_php5.php:1146
120.50036160816DboSource->read( )../model_php5.php:1199
130.50216166048DboSource->fetchAll( )../dbo_source.php:564
140.50216166344DboSource->execute( )../dbo_source.php:296
150.50346166632DboSource->showQuery( )../dbo_source.php:165
160.50356167192trigger_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.0021320840Dispatcher->dispatch( )../index.php:82
30.07404837312Dispatcher->_invoke( )../dispatcher.php:245
40.08385386584call_user_func_array ( )../dispatcher.php:263
50.08385386880FindaprofessionalController->index( )../dispatcher.php:0
60.08845428192FindaprofessionalController->__office( )../findaprofessional_controller.php:104
70.41645904680Controller->render( )../findaprofessional_controller.php:271
80.41645905248AppController->beforeRender( )../controller.php:534
90.50016156264Zip->getZipNear( )../app_controller.php:280
100.50716104208Model->find( )../zip.php:37
110.50716104808Model->findAll( )../model_php5.php:1146
120.50726107216DboSource->read( )../model_php5.php:1199
130.50906112448DboSource->fetchAll( )../dbo_source.php:564
140.50906112744DboSource->execute( )../dbo_source.php:296
150.51016113032DboSource->showQuery( )../dbo_source.php:165
160.51026113592trigger_error ( )../dbo_source.php:439

Continental Hearing Aid Center | Hearing Aids in Oakland, CA

Continental Hearing Aid Center

4321 Piedmont Ave
Oakland, California, 94611, US
map
phone 510-652-0405
Fax: 510-652-1764
Website www.continentalhearing.com

Map

Staff

Stone Richard I. Stone




Stone has served his community as businessman, civic leader, active member of the Lion’s Club, and volunteer at Children’s Hospital (where he is Santa each Christmas) for over three decades. He has been one of the cornerstones of the Piedmont Ave Merchant’s Association and had been its president for many years. He has been responsible for the installation of the Christmas lights that cheer Piedmont Avenue during that season.

  • California Hearing Aid Dispenser Lic. No. HA-294
  • NB-HIS, Certified by the National Board of Certification in Hearing Instrument Sciences
  • Member of the International Hearing Society since 1980
  • Member of the American Tinnitus Association (ATA)

Cosgrove Narcissus Cosgrove




Cosgrove has assisted Richard in providing hearing health care to the community for twenty years.


Virtual Hearing Aid Seminar

Driving Directions

Contact Us Now

call510-652-0405

verification image

Tags: Continental Hearing Aid Center, Hearing Aids, Oakland, California, 4321 Piedmont Ave, 94611, 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