SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='S17 3SB' order by fulladdress
S17 3SB - 645,000
- Leasehold Semi-detached house
S17 3SB - 900,000
- Leasehold Detached house
S17 3SB - 628,000
- Semi-detached house
S17 3SB - 821,000
- Leasehold Detached house
S17 3SB - 635,000
- Leasehold Semi-detached house
S17 3SB - 812,000
- Leasehold Detached house
S17 3SB - 677,000
- Leasehold Semi-detached house
S17 3SB - 810,000
- Leasehold Detached house
S17 3SB - 664,000
- Leasehold Semi-detached house
S17 3SB - 663,000
- Leasehold Detached house
S17 3SB - 635,000
- Leasehold Semi-detached house
S17 3SB - 850,000
- Leasehold Detached house
S17 3SB - 709,000
- Leasehold Semi-detached house
S17 3SB - 847,000
- Leasehold Detached house
S17 3SB - 665,000
- Leasehold Semi-detached house
S17 3SB - 897,000
- Leasehold Detached house
S17 3SB - 675,000
- Leasehold Semi-detached house
S17 3SB - 657,000
- Leasehold Semi-detached house
S17 3SB - 668,000
- Leasehold Semi-detached house
S17 3SB - 632,000
- Leasehold Semi-detached house
S17 3SB - 678,000
- Leasehold Semi-detached house
S17 3SB - 663,000
- Leasehold Semi-detached house
S17 3SB - 665,000
- Leasehold Semi-detached house
S17 3SB - 632,000
- Freehold Semi-detached house
S17 3SB - 588,000
- Leasehold Semi-detached house
S17 3SB - 646,000
- Leasehold Semi-detached house
S17 3SB - 673,000
- Leasehold Semi-detached house
S17 3SB - 557,000
- Leasehold Semi-detached house
S17 3SB - 656,000
- Leasehold Semi-detached house
S17 3SB - 1,184,000
- Leasehold Detached house
S17 3SB - 887,000
- Leasehold Detached house
S17 3SB - 633,000
- Leasehold Semi-detached house
S17 3SB - 900,000
- Leasehold Detached house
S17 3SB - 906,000
- Leasehold Detached house
S17 3SB - 908,000
- Leasehold Detached house
S17 3SB - 629,000
- Leasehold Semi-detached house
S17 3SB - 645,000
- Leasehold Semi-detached house
S17 3SB - 627,000
- Leasehold Semi-detached house
S17 3SB - 924,000
- Leasehold Detached house