SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW10 0RG' order by fulladdress
SW10 0RG - 1,288,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,346,000
- Leasehold Flat/Maisonette
SW10 0RG - 771,000
- Leasehold Flat/Maisonette
SW10 0RG - 795,000
- Leasehold Purpose built flat
SW10 0RG - 1,468,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,218,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,572,000
- Leasehold Flat/Maisonette
SW10 0RG - 753,000
- Leasehold Flat/Maisonette
SW10 0RG - 788,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,575,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,475,000
- Leasehold Flat/Maisonette
SW10 0RG - 798,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,556,000
- Leasehold Flat/Maisonette
SW10 0RG - 779,000
- Leasehold Flat/Maisonette
SW10 0RG - 736,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,551,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,628,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,528,000
- Leasehold Flat/Maisonette
SW10 0RG - 802,000
- Leasehold Purpose built flat
SW10 0RG - 760,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,557,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,557,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,444,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,814,000
- Leasehold Flat/Maisonette
SW10 0RG - 8,002,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,691,000
- Leasehold Flat/Maisonette
SW10 0RG - 2,341,000
- Leasehold Purpose built flat
SW10 0RG - 1,501,000
- Leasehold Flat/Maisonette
SW10 0RG - 700,000
- Leasehold Flat/Maisonette
SW10 0RG - 706,000
- Leasehold Purpose built flat
SW10 0RG - 1,353,000
- Leasehold Flat/Maisonette
SW10 0RG - 1,947,000
- Leasehold Purpose built flat
