SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='S10 3TP' order by fulladdress
S10 3TP - 1,218,000
- Leasehold Detached property
S10 3TP - 1,302,000
- Leasehold Detached house
S10 3TP - 1,338,000
- Leasehold Detached house
S10 3TP - 1,097,000
- Leasehold Detached house
S10 3TP - 1,490,000
- Leasehold Detached house
S10 3TP - 1,317,000
- Leasehold Detached house
S10 3TP - 1,035,000
- Leasehold Detached house
S10 3TP - 1,093,000
- Leasehold Detached house
S10 3TP - 1,065,000
- Leasehold Detached house
S10 3TP - 281,000
- Leasehold Flat/Maisonette
S10 3TP - 301,000
- Leasehold Mid terrace house
S10 3TP - 285,000
- Leasehold Flat/Maisonette
S10 3TP - 288,000
- Leasehold Flat/Maisonette
S10 3TP - 268,000
- Leasehold Flat/Maisonette
S10 3TP - 293,000
- Leasehold Flat/Maisonette
S10 3TP - 294,000
- Leasehold Flat/Maisonette
S10 3TP - 292,000
- Leasehold Flat/Maisonette
S10 3TP - 279,000
- Leasehold Flat/Maisonette
S10 3TP - 915,000
- Leasehold Detached house
