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 '00100'' at line 1
select * from hotels where left(hotel_address,10)='OFF NGONG\' and postal_code='00100'
select * from hotels where left(hotel_address,10)='OFF NGONG\' and postal_code='00100'
Radisson Blu Hotel And Residence Nairobi
NAIROBI, ,
- AD - BED - BREAKFAST
- AD - BEST AVAILABLE RATE
- PREPAID RATE WITH BREAKFAST
- PREPAID RATE
- BEST AVAILABLE RATE
- BED - BREAKFAST
- ROMANCE EXPERIENCE
from $ 409USD
PALACINA THE RESIDENCE & THE SUITES
NAIROBI, , 00100
- Penthouse 02 Bedroom Residence - Extra-person charges may apply
from $ 2528USD
Movenpick Hotel & Residences Nairobi
NAIROBI, , 100
- Hotel Supersale-Prepay No Refund
- MRate avail STAY LONGER AND SAVE MORE - BB-BB/Bed+Brkfast
- MRate avail FLEXIBLE RATE - BB-BB/Bed+Brkfast
- MRate avail FLEXIBLE RATE
from $ 182USD
Doubletree By Hilton Nairobi Hurlingham
NAIROBI, , 00400
- DREAM AWAY
- FLEXIBLE RATE
- BED AND BREAKFAST
- AAA STAY AND SAVE
from $ 189USD
The Zehneria Portico Nairobi
NAIROBI, , 00800
- Book and Stay
- Length of Stay
- Carlson Wagonlit Travel Global Programme
from $ 184USD
Executive Residency Best Western Nairobi
NAIROBI, , 00100
- FLEXIBLE RATE*BEST LEAST RESTRICTIVE RATE
- AAA CAA RATE
- GOVT MILITARY RATE
from $ 1107USD
Hilton Garden Inn Jomo Kenyatta Int Apt
NAIROBI, , 00603
- FLEXIBLE RATE
- 2X POINTS
- BED AND BREAKFAST
- EARLY BREAKFAST RATE
from $ 290USD
Lake Naivasha Country Club Con
KARAGITE, , 102124-001
- I PREFER MEMBER RATE -BREAKFAST INCLUDED
- BEST AVAILABLE RATE
- PREFERRED FAMILY PACKAGE
- AMEX PREFERRED FAMILY
from $ 165USD
Lake Elmenteita Serena Camp
NAKURU, ,
- Best Available Rate-Fullboard amp; excl. entry fee
