SELECT
	property_properties.property_id
FROM
	property_properties
JOIN
	property_attributes as property_attributes_join1
ON
	property_properties.property_id = property_attributes_join1.property_id AND
	property_attributes_join1.attribute_group_id = 14 AND
	property_attributes_join1.attribute_value_id IN (58 )
JOIN
	property_towns
ON
	property_properties.town_id = property_towns.town_id
JOIN
	property_areas
ON
	property_towns.area_id = property_areas.area_id
JOIN
	property_regions
ON
	property_areas.region_id = property_regions.region_id
JOIN
	property_countries
ON
	property_regions.country_id = property_countries.country_id AND
	property_countries.country_id IN ( 1 )
ORDER BY
	property_properties.price ASC