SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SM6 8AA' order by fulladdress
SM6 8AA - 1,009,000
- Freehold Detached house
SM6 8AA - 524,000
- Freehold Mid terrace house
SM6 8AA - 779,000
- Freehold Semi-detached bungalow
SM6 8AA - 560,000
- Freehold Semi-detached house
SM6 8AA - 541,000
- Freehold Semi-detached house
SM6 8AA - 737,000
- Freehold Semi-detached house
SM6 8AA - 723,000
- Freehold Semi-detached house
SM6 8AA - 783,000
- Freehold Semi-detached house
SM6 8AA - 853,000
- Freehold Semi-detached house
SM6 8AA - 659,000
- Freehold Semi-detached house
SM6 8AA - 669,000
- Freehold Semi-detached house
SM6 8AA - 575,000
- Freehold End terrace house
SM6 8AA - 587,000
- Freehold Terrace property
SM6 8AA - 576,000
- Freehold Mid terrace house
SM6 8AA - 589,000
- Freehold Mid terrace house
SM6 8AA - 604,000
- Freehold End terrace house
SM6 8AA - 1,032,000
- Freehold Detached house
SM6 8AA - 336,000
- Leasehold Flat/Maisonette
SM6 8AA - 334,000
- Leasehold Converted flat
SM6 8AA - 688,000
- Freehold Semi-detached house
SM6 8AA - 706,000
- Freehold Semi-detached house
SM6 8AA - 592,000
- Freehold Semi-detached house
SM6 8AA - 782,000
- Freehold Detached house
SM6 8AA - 247,000
- Leasehold Purpose built flat
SM6 8AA - 237,000
- Leasehold Flat/Maisonette
SM6 8AA - 219,000
- Leasehold Purpose built flat
SM6 8AA - 250,000
- Leasehold Flat/Maisonette
SM6 8AA - 231,000
- Leasehold Purpose built flat
SM6 8AA - 304,000
- Leasehold Flat/Maisonette
SM6 8AA - 228,000
- Leasehold Flat/Maisonette
SM6 8AA - 301,000
- Leasehold Purpose built flat
SM6 8AA - 252,000
- Leasehold Flat/Maisonette
SM6 8AA - 248,000
- Leasehold Purpose built flat
SM6 8AA - 226,000
- Leasehold Converted flat
SM6 8AA - 301,000
- Leasehold Purpose built flat
SM6 8AA - 246,000
- Leasehold Flat/Maisonette
SM6 8AA - 231,000
- Leasehold Flat/Maisonette
SM6 8AA - 206,000
- Leasehold Purpose built flat
SM6 8AA - 227,000
- Leasehold Flat/Maisonette
SM6 8AA - 246,000
- Leasehold Flat/Maisonette
SM6 8AA - 589,000
- Freehold Semi-detached house
