SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW6 1DQ' order by fulladdress
SW6 1DQ - 3,963,000
- Freehold Semi-detached house
SW6 1DQ - 4,203,000
- Leasehold Mid terrace house
SW6 1DQ - 3,494,000
- Leasehold End terrace house
SW6 1DQ - 1,882,000
- Leasehold Detached house
SW6 1DQ - 2,082,000
- Leasehold Terraced
SW6 1DQ - 6,839,000
- Leasehold Semi-detached property
SW6 1DQ - 2,856,000
- Leasehold Detached house
SW6 1DQ - 4,376,000
- Leasehold End terrace house
SW6 1DQ - 4,573,000
- Mid terrace house
SW6 1DQ - 4,448,000
- Leasehold Mid terrace house
SW6 1DQ - 4,337,000
- Leasehold Mid terrace house
SW6 1DQ - 3,865,000
- Leasehold Terraced
SW6 1DQ - 3,567,000
- Leasehold Terraced
SW6 1DQ - 3,421,000
- Mid terrace house
SW6 1DQ - 3,635,000
- Leasehold Detached property
SW6 1DQ - 2,439,000
- Leasehold Terrace property
SW6 1DQ - 3,543,000
- Leasehold End terrace house
SW6 1DQ - 4,196,000
- Leasehold Mid terrace house
SW6 1DQ - 4,199,000
- Leasehold Mid terrace house
SW6 1DQ - 4,644,000
- Leasehold Mid terrace house
SW6 1DQ - 4,297,000
- Mid terrace house
SW6 1DQ - 4,230,000
- Leasehold Mid terrace house
SW6 1DQ - 4,228,000
- Leasehold Mid terrace house
SW6 1DQ - 4,188,000
- Mid terrace house
SW6 1DQ - 3,583,000
- Leasehold Terrace property
SW6 1DQ - 4,132,000
- Leasehold Mid terrace house
SW6 1DQ - 2,221,000
- Leasehold Mid terrace house
SW6 1DQ - 2,656,000
- Leasehold End terrace house
SW6 1DQ - 4,281,000
- Leasehold Mid terrace house
SW6 1DQ - 3,921,000
- Leasehold Terrace property
SW6 1DQ - 4,218,000
- Leasehold Mid terrace house
SW6 1DQ - 4,233,000
- Leasehold Mid terrace house
SW6 1DQ - 4,312,000
- Leasehold Mid terrace house
SW6 1DQ - 4,303,000
- Leasehold Mid terrace house