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 0RP' order by fulladdress
SW10 0RP - 898,000
- Leasehold Flat/Maisonette
SW10 0RP - 759,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,479,000
- Leasehold Flat/Maisonette
SW10 0RP - 2,745,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,242,000
- Leasehold Purpose built flat
SW10 0RP - 822,000
- Leasehold Mid terrace house
SW10 0RP - 804,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,495,000
- Leasehold Flat/Maisonette
SW10 0RP - 2,623,000
- Feudal Purpose built flat
SW10 0RP - 1,371,000
- Leasehold Flat/Maisonette
SW10 0RP - 741,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,440,000
- Leasehold Flat/Maisonette
SW10 0RP - 767,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,463,000
- Leasehold Flat/Maisonette
SW10 0RP - 2,797,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,391,000
- Leasehold Purpose built flat
SW10 0RP - 770,000
- Leasehold Flat/Maisonette
SW10 0RP - 758,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,509,000
- Leasehold Flat/Maisonette
SW10 0RP - 2,665,000
- Leasehold Flat/Maisonette
SW10 0RP - 3,068,000
- Leasehold Purpose built flat
SW10 0RP - 708,000
- Leasehold Purpose built flat
SW10 0RP - 585,000
- Leasehold Flat/Maisonette
SW10 0RP - 768,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,444,000
- Leasehold Flat/Maisonette
SW10 0RP - 4,500,000
- Leasehold Flat/Maisonette
SW10 0RP - 3,946,000
- Leasehold Flat/Maisonette
SW10 0RP - 2,986,000
- Leasehold Flat/Maisonette
SW10 0RP - 619,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,471,000
- Leasehold Flat/Maisonette
SW10 0RP - 913,000
- Leasehold Flat/Maisonette
SW10 0RP - 2,735,000
- Leasehold Flat/Maisonette
SW10 0RP - 1,405,000
- Leasehold Flat/Maisonette
SW10 0RP - 697,000
- Leasehold Flat/Maisonette