- Home
- View Directory
- Advertising
- Pick of the Week
- Competitions
- December 2014/January 2015
- May/June 2014
- April/May 2014
- February/March 2014
- December 13/January 14
- October/November 2013
- August/September 2013
- June/July 2013
- March 2013
- February 2013
- January 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- Health & More
- Useful Info
- Sign up
- Contact Us
Expression #1 of ORDER BY clause is not in SELECT list, references column 'kosherp_main.Advert.Type of Advert' which is not in SELECT list; this is incompatible with DISTINCT(3065) executing query: SELECT DISTINCT `Category`.`ID`,`Category`.`Name` FROM `Category` JOIN `Advert Category` ON `Advert Category`.`Category`=`Category`.`ID` JOIN `Advert` ON `Advert`.`ID`=`Advert Category`.`Advert` JOIN `Advert Modification` ON `Advert Modification`.`Advert`=`Advert`.`ID` JOIN `Advert City` ON `Advert`.`ID`=`Advert City`.`AdvertID` WHERE `Category`.`Parent` IN (308) AND `Advert Modification`.`Authoriser`<>0 AND `Advert Modification`.`Rejected`='0' AND `Advert`.`Cancellor`=0 AND `Advert Modification`.`NoShow`='0' ORDER BY `Advert`.`Type of Advert` DESC, `Advert Modification`.`Name` ASC
Tel: 020 8880 1075
Tel: 0161 773 0069
Fax: 0161 773 0170
[email protected]
Visit this website
Health & Beauty > Optician and Accessories
There are 3 listings in Health & Beauty > Optician and Accessories
Eyesight Optician
Free NHS and Private Eye Tests
Huge Range of Gents & Ladies Glasses
Large Range of Half Frame Childrens Glasses
Metal and Plastic Frames
Open 9.30am - 5.30pm
Huge Range of Gents & Ladies Glasses
Large Range of Half Frame Childrens Glasses
Metal and Plastic Frames
Open 9.30am - 5.30pm
Free NHS and Private Eye Tests
Huge Range of Gents & Ladies Glasses
Large Range of Half Fra...
Huge Range of Gents & Ladies Glasses
Large Range of Half Fra...
Stamford Hill
Stamford Hill
3a Regent Court
Amhurst park
London
N16 5LP
3a Regent Court
Amhurst park
London
N16 5LP
Tel: 020 8880 1075
The Village Optician Ltd
* Eye Examinations
* Frames
* Contact Lenses
* Diagnosis
* Laser Surgery
* Conditions & Diseases
Opening Hours
Mon-Thurs: 9:00am-6:00pm
Fri: 9:00am-2:00pm
Sat: Closed
Sun: 10:00am-2:00pm
THE OCT EYE SCAN: The Zeiss Cirrus HD-OCT is our latest acquisition. It gives us more information about eye conditons such as macular degeneration and glaucoma by scanning the retina. The process is quick and absolutely painless and highly recommmended for that extra peace of mind.
IRLENS SYNDROME: A description of when patients (usually children) have difficulty processing what they are reading. Such conditions include dyslexia and Irlens has shown that coloured overlays or special filtered spectacles can assist in reading ability in some individuals.
Now at The Village Optician Ltd we have invested in the Intuituitive Colorimeter which can be even more specific in determining the precise colour required.
* Frames
* Contact Lenses
* Diagnosis
* Laser Surgery
* Conditions & Diseases
Opening Hours
Mon-Thurs: 9:00am-6:00pm
Fri: 9:00am-2:00pm
Sat: Closed
Sun: 10:00am-2:00pm
THE OCT EYE SCAN: The Zeiss Cirrus HD-OCT is our latest acquisition. It gives us more information about eye conditons such as macular degeneration and glaucoma by scanning the retina. The process is quick and absolutely painless and highly recommmended for that extra peace of mind.
IRLENS SYNDROME: A description of when patients (usually children) have difficulty processing what they are reading. Such conditions include dyslexia and Irlens has shown that coloured overlays or special filtered spectacles can assist in reading ability in some individuals.
Now at The Village Optician Ltd we have invested in the Intuituitive Colorimeter which can be even more specific in determining the precise colour required.
* Eye Examinations
* Frames
* Contact Lenses
* Diagnosis
* Laser Surgery
* Conditions & Dise...
* Frames
* Contact Lenses
* Diagnosis
* Laser Surgery
* Conditions & Dise...
Manchester
Manchester
470 Bury New Road
Prestwich
Manchester
M25 1AX
470 Bury New Road
Prestwich
Manchester
M25 1AX
Tel: 0161 773 0069
Fax: 0161 773 0170
[email protected]
Visit this website