SELECT  prop_properties.property_id  , prop_properties.city_id, geo_cities.department_id, property_activity_type, property_price, property_accomodation_type
							         FROM prop_properties, geo_countries, geo_departments, geo_cities, geo_cities, geo_departments
								     WHERE 1 = 1 AND property_delete = 0
								      AND geo_departments.department_activated = 1 AND geo_cities.city_activated = 1 AND 32 = geo_departments.country_id AND geo_cities.department_id = geo_departments.department_id AND prop_properties.city_id = geo_cities.city_id  AND property_state <> 'D' AND property_num_images > 0  AND country_activated = 1 AND department_activated = 1 AND city_activated = 1 AND geo_countries.country_id = geo_departments.country_id AND geo_cities.department_id = geo_departments.department_id AND prop_properties.city_id = geo_cities.city_id AND property_price >= "300000" AND property_price <= "600000" AND geo_departments.department_id = 70 AND geo_departments.country_id	=	32

SELECT  prop_properties.property_id  
							         FROM prop_properties, geo_countries, geo_departments, geo_cities, geo_cities, geo_departments
								     WHERE 1 = 1 AND property_delete = 0
								      AND geo_departments.department_activated = 1 AND geo_cities.city_activated = 1 AND 32 = geo_departments.country_id AND geo_cities.department_id = geo_departments.department_id AND prop_properties.city_id = geo_cities.city_id  AND property_state <> 'D' AND property_num_images > 0  AND country_activated = 1 AND department_activated = 1 AND city_activated = 1 AND geo_countries.country_id = geo_departments.country_id AND geo_cities.department_id = geo_departments.department_id AND prop_properties.city_id = geo_cities.city_id AND property_price >= "300000" AND property_price <= "600000" AND geo_departments.department_id = 70 AND geo_departments.country_id	=	32 LIMIT 0,0

• Departamento
• Ciudad
• Precio
• Actividad
• Tipo de Alojamiento

Propiedades Destacadas

resultados para esta búsqueda

Número de registros por página: 10 | 20 | 30 | 50 |

1

Escoge tu pa�s Argentina Bolivia Brazil Canada Chile Colombia Costa Rica Ecuador El Salvador España EE. UU. Guatemala Honduras Jamaica México Nicaragua Panamá Paraguay Perú Portugal Puerto Rico R. Dominicana Uruguay Venezuela

Ir a Quevacaciones.com Acerca de Quevacaciones Contáctenos © Quevacaciones - Todos los derechos reservados

Diseñado y desarrollado por Magdalena Medio