SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HG5 9DE' order by fulladdress
HG5 9DE - 1,081,000
- Freehold Detached house
HG5 9DE - 1,498,000
- Freehold Detached house
HG5 9DE - 1,273,000
- Freehold Detached house
HG5 9DE - 960,000
- Freehold Detached house
HG5 9DE - 737,000
- Freehold Detached property
HG5 9DE - 1,050,000
- Freehold Detached house
HG5 9DE - 1,324,000
- Freehold Detached house
HG5 9DE - 1,612,000
- Freehold Detached house
HG5 9DE - 1,344,000
- Freehold Detached house
HG5 9DE - 893,000
- Freehold Detached house
HG5 9DE - 920,000
- Freehold Detached property
HG5 9DE - 811,000
- Freehold Detached bungalow
HG5 9DE - 840,000
- Freehold Detached house
HG5 9DE - 1,306,000
- Freehold Detached house
HG5 9DE - 880,000
- Freehold Detached bungalow
HG5 9DE - 1,065,000
- Freehold Detached house
HG5 9DE - 1,175,000
- Freehold Detached house
HG5 9DE - 1,345,000
- Freehold Detached house
HG5 9DE - 1,358,000
- Freehold Detached house
HG5 9DE - 1,215,000
- Freehold Detached house
HG5 9DE - 1,019,000
- Freehold Detached house
HG5 9DE - 2,475,000
- Freehold Detached house
HG5 9DE - 1,724,000
- Freehold Detached house
HG5 9DE - 644,000
- Freehold Detached property
HG5 9DE - 1,006,000
- Freehold Detached house
HG5 9DE - 796,000
- Freehold Detached house
HG5 9DE - 1,704,000
- Freehold Detached property
HG5 9DE - 907,000
- Freehold Detached house
HG5 9DE - 748,000
- Freehold Detached house
HG5 9DE - 1,403,000
- Freehold Detached house
HG5 9DE - 741,000
- Freehold Detached bungalow
