SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SM5 2NU' order by fulladdress
SM5 2NU - 685,000
- Freehold Semi-detached house
SM5 2NU - 660,000
- Freehold Semi-detached house
SM5 2NU - 673,000
- Freehold Semi-detached house
SM5 2NU - 634,000
- Freehold Mid terrace house
SM5 2NU - 625,000
- Freehold Semi-detached house
SM5 2NU - 655,000
- Freehold Semi-detached house
SM5 2NU - 608,000
- Freehold Semi-detached house
SM5 2NU - 627,000
- Freehold Detached house
SM5 2NU - 606,000
- Freehold Semi-detached house
SM5 2NU - 656,000
- Freehold Semi-detached house
SM5 2NU - 663,000
- Freehold Semi-detached house
SM5 2NU - 627,000
- Freehold Semi-detached house
SM5 2NU - 616,000
- Freehold Semi-detached property
SM5 2NU - 663,000
- Freehold Detached house
SM5 2NU - 774,000
- Freehold Detached house
SM5 2NU - 869,000
- Freehold Detached house
SM5 2NU - 640,000
- Freehold Semi-detached house
SM5 2NU - 605,000
- Freehold Semi-detached house
SM5 2NU - 296,000
- Leasehold Converted flat
SM5 2NU - 293,000
- Leasehold Flat/Maisonette
SM5 2NU - 871,000
- Freehold Detached house
SM5 2NU - 806,000
- Freehold Semi-detached house
SM5 2NU - 599,000
- Freehold Semi-detached house
SM5 2NU - 651,000
- Freehold Detached house
SM5 2NU - 318,000
- Leasehold Flat/Maisonette
SM5 2NU - 334,000
- Leasehold Purpose built flat
SM5 2NU - 335,000
- Leasehold Purpose built flat
SM5 2NU - 338,000
- Leasehold Flat/Maisonette
SM5 2NU - 341,000
- Leasehold Flat/Maisonette
SM5 2NU - 331,000
- Leasehold Flat/Maisonette
SM5 2NU - 323,000
- Leasehold Converted flat
SM5 2NU - 724,000
- Freehold Semi-detached house
