SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW3 4DY' order by fulladdress
SW3 4DY - 2,142,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,619,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,490,000
- Leasehold Detached house
SW3 4DY - 2,809,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,293,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,373,000
- Leasehold Purpose built flat
SW3 4DY - 2,569,000
- Leasehold Purpose built flat
SW3 4DY - 1,611,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,371,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,880,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,924,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,276,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,788,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,290,000
- Leasehold Purpose built flat
SW3 4DY - 1,259,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,031,000
- Leasehold Purpose built flat
SW3 4DY - 2,864,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,956,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,866,000
- Feudal Purpose built flat
SW3 4DY - 1,971,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,563,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,897,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,245,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,510,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,809,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,262,000
- Leasehold Purpose built flat
SW3 4DY - 3,837,000
- Share of freehold Flat/Maisonette
SW3 4DY - 4,426,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,857,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,764,000
- Leasehold Flat/Maisonette
SW3 4DY - 1,360,000
- Leasehold Flat/Maisonette
SW3 4DY - 2,790,000
- Leasehold Purpose built flat
SW3 4DY - 2,834,000
- Leasehold Purpose built flat
SW3 4DY - 2,801,000
- Leasehold Flat/Maisonette
SW3 4DY - 579,000
- Leasehold Flat/Maisonette