SELECT h.hotel_id, hotel_name, star_rating FROM hotels h INNER JOIN hotel_areas_assoc haa ON (h.hotel_id = haa.hotel_id) WHERE haa.area_id = 1338 AND star_rating <= "2.5" AND star_rating > "1.0" ORDER BY RAND() LIMIT 0, 1SELECT h.hotel_id, hotel_name, star_rating FROM hotels h INNER JOIN hotel_areas_assoc haa ON (h.hotel_id = haa.hotel_id) WHERE haa.area_id = 1338 AND star_rating <= "5.0" AND star_rating > "3.5" ORDER BY RAND() LIMIT 0, 1
Overview of VENTAS Madrid Hotels |
In the east of the capital, this middle-class area of red brick residential blocks with green sunshades is dominated by the circular Las Ventas bullring, built in 1929. Surrounded by atmospheric sculptures of horsemen, matadors and bulls, it incorporates Moorish architecture dotted with mosaic patterns and crests executed in sprightly yellows and blues. The bullfights run from March until October. |
| |||||
| |||||
|
![]() ALL VENTAS - MADRID HOTELS
![]() |
|||||||||||||||||||
|
|
|
|