SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GL5 5HE' order by fulladdress
GL5 5HE - 468,000
- Leasehold End terrace house
GL5 5HE - 538,000
- Leasehold Mid terrace house
GL5 5HE - 465,000
- Leasehold Terraced bungalow
GL5 5HE - 635,000
- Leasehold Bungalow property
GL5 5HE - 485,000
- Leasehold End terrace bungalow
GL5 5HE - 424,000
- Leasehold Mid terrace house
GL5 5HE - 403,000
- Leasehold Terrace property
GL5 5HE - 404,000
- Leasehold Terraced bungalow
GL5 5HE - 497,000
- Leasehold End terrace house
GL5 5HE - 322,000
- Leasehold Flat/Maisonette
GL5 5HE - 504,000
- Leasehold Terraced bungalow
GL5 5HE - 360,000
- Leasehold End terrace house
GL5 5HE - 379,000
- Leasehold Mid terrace house
GL5 5HE - 459,000
- Leasehold Mid terrace house
GL5 5HE - 434,000
- Leasehold Terraced bungalow
GL5 5HE - 481,000
- Leasehold Detached house
GL5 5HE - 689,000
- Leasehold Detached house
GL5 5HE - 384,000
- Leasehold Mid terrace house
GL5 5HE - 382,000
- Leasehold Mid terrace house
GL5 5HE - 453,000
- Leasehold Terrace property
GL5 5HE - 565,000
- Leasehold Bungalow property
GL5 5HE - 524,000
- Leasehold Mid terrace house
GL5 5HE - 404,000
- Leasehold End terrace house
GL5 5HE - 429,000
- Leasehold Flat/Maisonette
GL5 5HE - 499,000
- Leasehold Semi-detached property
GL5 5HE - 537,000
- Leasehold Semi-detached bungalow
GL5 5HE - 448,000
- Leasehold Semi-detached bungalow
GL5 5HE - 444,000
- Leasehold End terrace house
