Location Object
(
[id] => 1038939
[parent_id] => 1167
[name] => Sanur
[slug] => Asia-Indonesia-Sanur.html
[type] => 5
)
SELECT hotels.id AS id, provider_number, hotels.slug AS slug, hotels.name AS name, address1, address2, location_id, description, internet_connect,
gym, onsite_parking, pet_friendly, pool, restaurant, handicap_access, childsitting_services, bar, cable_tv,
wireless_internet_access, has_fax, iron, drycleaning, coffee_maker, airconditioning, safe, elevators, golf,
tennis, price, rating, travel_site_count.count AS travel_site_count
FROM hotels
LEFT JOIN travel_site_count ON travel_site_count.hotel_id = hotels.id
JOIN locations_hotelslogue ON hotels.location_id = locations_hotelslogue.id
WHERE locations_hotelslogue.name = 'Sanur' AND locations_hotelslogue.type=5 AND status = 1 ORDER BY travel_site_count DESC, rating
Cheap Hotels in Sanur, Bali. Compare prices on Discount Sanur Hotels
Sanur Hotels, Bali
Jl. Hang Tuah 46
Average Daily Price (USD): $48
Rating: 



Jl By Pass Ngurah Rai No 36
Rating: 



Jl D Tamblingan 128
Rating: 



05 Jl Hang Tuah Iii
Rating: 



Jl Danau Tamblingan 64X
Rating: 



Jalan Kesuma Sari No4, Semawang
Rating: 



Jl Duyung No 99 Sanur
Rating: 



Tirta Akasa Street, No 28 Sanur Bali
Rating: 



Danau Tamblingan Street No 35, Street No 35
Rating: 



Jalan ByPass Ngurah Rai 83
Rating: 



Jalan Danau Tamblingan 87, Sanur
Rating: 



Jl. Danau Tamblingan No.27
Rating: 



Danau Tamblingan Street No 80, Sanur Bali
Rating: 



Tanjung Street No. 41, Sanur - Denpasar, Bali, Sanur Denpasar Bali-Indonesia
Rating: 



Danau Tamblingan Street No. 60 Sanur-Bali-Ind, Sanur-Bali-Indonesia
Rating: 



Danau Tamblingan Street No. 51 Sanur-Bali, Sanur Bali
Rating: 



Danau Tamblingan Street No Bali
Danau Tamblingan Street No -Bali-Indonesia
Jl Hang Tuah Iii No 05
Rating: 



23rd Hang Tuah Street
Rating: 



Kesari Street
Average Daily Price (USD): $231.94
Rating: 



22 Cernara Street
Rating: 



Danau Tamblingan Street No Bali
Rating: 



Jl. Danau Tamblingan 89
Rating: 



Jl. Danau Tamblingan P.O. Box 3306 Sanur
Rating: 



Hang Tuah 49 Street, Sanur-Bali
Rating: 



Jl. Danau Posos 102 Sanur 80228
Rating: 



Jalan Karangsari No 5 Sanur, Bali
Rating: 



More BootsnAll Travel Network Sites