SELECT * FROM `liquer_restaurent` WHERE `city` = 'Gurgaon' AND `location` != 'Sector38' GROUP BY `id` ORDER BY CASE WHEN type = '%Farmhouse%' THEN 1 ELSE 2 END ASC LIMIT 176, 16
Venue Name | Address | Prices |
---|---|---|
Terrace 212 | DLF Phase 3.Gurgaon | ₹10,000/night |
Primeland Party Hall | Sector 43.Gurgaon | ₹7,000/night |
Farmhouse 423 | Aravali Retreat.Gurgaon | ₹15,000/night |
Terrace 7800 | Sector 38.Gurgaon | ₹7,000/night |
Farmhouse 233 | Baliawas.Gurgaon | ₹15,000/night |
Farmhouse 101 | Manesar.Gurgaon | ₹20,000/night |
Farmhouse 100 | Sohna Road.Gurgaon | ₹20,000/night |
Farmhouse 3131 | Badshahpur.Gurgaon | ₹20,000/night |
Farmhouse 298 | Aravali Retreat.Gurgaon | ₹18,000/night |
Farmhouse 934 | Manesar.Gurgaon | ₹18,000/night |
Farmhouse 103 | Sadhrana.Gurgaon | ₹27,000/night |