SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SL2 3GW' order by fulladdress
SL2 3GW - 388,000
- Leasehold Purpose built flat
SL2 3GW - 385,000
- Leasehold Purpose built flat
SL2 3GW - 364,000
- Leasehold Purpose built flat
SL2 3GW - 387,000
- Leasehold Purpose built flat
SL2 3GW - 374,000
- Leasehold Flat/Maisonette
SL2 3GW - 323,000
- Leasehold Purpose built flat
SL2 3GW - 347,000
- Leasehold Flat/Maisonette
SL2 3GW - 380,000
- Leasehold Flat/Maisonette
SL2 3GW - 356,000
- Leasehold Flat/Maisonette
SL2 3GW - 374,000
- Leasehold Purpose built flat
SL2 3GW - 345,000
- Leasehold Flat/Maisonette
SL2 3GW - 430,000
- Leasehold Flat/Maisonette
SL2 3GW - 376,000
- Leasehold Purpose built flat
SL2 3GW - 358,000
- Leasehold Purpose built flat
SL2 3GW - 328,000
- Leasehold Purpose built flat
SL2 3GW - 368,000
- Leasehold Flat/Maisonette
SL2 3GW - 368,000
- Leasehold Purpose built flat
SL2 3GW - 342,000
- Leasehold Purpose built flat
SL2 3GW - 336,000
- Leasehold Purpose built flat
SL2 3GW - 893,000
- Leasehold Semi-detached property
SL2 3GW - 583,000
- Leasehold Semi-detached house
SL2 3GW - 674,000
- Freehold End terrace house
SL2 3GW - 373,000
- Leasehold Purpose built flat
SL2 3GW - 846,000
- Freehold Mid terrace house
SL2 3GW - 887,000
- Freehold End terrace house
SL2 3GW - 971,000
- Freehold End terrace house
SL2 3GW - 864,000
- Freehold Mid terrace house
SL2 3GW - 894,000
- Freehold End terrace house
SL2 3GW - 866,000
- Freehold Terrace property
SL2 3GW - 903,000
- Freehold Mid terrace house
SL2 3GW - 905,000
- Freehold End terrace house
SL2 3GW - 855,000
- Freehold End terrace house
SL2 3GW - 856,000
- Freehold Mid terrace house
SL2 3GW - 393,000
- Leasehold Flat/Maisonette
SL2 3GW - 856,000
- Freehold End terrace house
SL2 3GW - 383,000
- Leasehold Flat/Maisonette
SL2 3GW - 373,000
- Leasehold Flat/Maisonette
SL2 3GW - 387,000
- Leasehold Purpose built flat
SL2 3GW - 367,000
- Leasehold Purpose built flat
SL2 3GW - 390,000
- Leasehold Purpose built flat
SL2 3GW - 389,000
- Leasehold Flat/Maisonette
SL2 3GW - 385,000
- Leasehold Flat/Maisonette
SL2 3GW - 372,000
- Leasehold Flat/Maisonette
SL2 3GW - 375,000
- Leasehold Flat/Maisonette
SL2 3GW - 428,000
- Leasehold Purpose built flat
SL2 3GW - 393,000
- Leasehold Flat/Maisonette
SL2 3GW - 392,000
- Leasehold Purpose built flat
SL2 3GW - 385,000
- Leasehold Purpose built flat
SL2 3GW - 414,000
- Leasehold Flat/Maisonette
SL2 3GW - 367,000
- Leasehold Flat/Maisonette
SL2 3GW - 1,041,000
- Freehold Detached property
SL2 3GW - 928,000
- Freehold Semi-detached house
SL2 3GW - 748,000
- Freehold Semi-detached house
SL2 3GW - 962,000
- Freehold Semi-detached house
SL2 3GW - 414,000
- Leasehold Purpose built flat
SL2 3GW - 893,000
- Freehold Semi-detached house
SL2 3GW - 871,000
- Freehold Terrace property
SL2 3GW - 886,000
- Freehold Semi-detached house