SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IG7 5DL' order by fulladdress
IG7 5DL - 915,000
- Freehold Semi-detached house
IG7 5DL - 835,000
- Freehold Semi-detached house
IG7 5DL - 865,000
- Freehold Semi-detached house
IG7 5DL - 997,000
- Freehold Semi-detached house
IG7 5DL - 2,741,000
- Freehold Detached house
IG7 5DL - 2,498,000
- Freehold Detached house
IG7 5DL - 2,342,000
- Freehold Detached house
IG7 5DL - 2,389,000
- Freehold Detached property
IG7 5DL - 2,469,000
- Freehold Detached house
IG7 5DL - 2,635,000
- Freehold Detached house
IG7 5DL - 2,641,000
- Freehold Detached property
IG7 5DL - 3,153,000
- Freehold Detached house
IG7 5DL - 2,621,000
- Freehold Detached house
IG7 5DL - 2,800,000
- Freehold Detached house
IG7 5DL - 2,034,000
- Freehold Detached property
IG7 5DL - 2,515,000
- Freehold Detached house
IG7 5DL - 3,882,000
- Freehold Detached property
IG7 5DL - 3,032,000
- Freehold Detached house
IG7 5DL - 2,038,000
- Freehold Detached house
IG7 5DL - 3,065,000
- Freehold Detached house
IG7 5DL - 2,622,000
- Freehold Detached house
IG7 5DL - 2,606,000
- Freehold Detached house
IG7 5DL - 2,919,000
- Freehold Detached house
IG7 5DL - 2,374,000
- Freehold Detached house
IG7 5DL - 2,936,000
- Freehold Detached house
IG7 5DL - 2,569,000
- Freehold Detached house
IG7 5DL - 2,479,000
- Freehold Detached house
IG7 5DL - 3,044,000
- Freehold Detached house
IG7 5DL - 2,548,000
- Freehold Detached house
IG7 5DL - 3,312,000
- Freehold Detached house