SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SS2 6SN' order by fulladdress
SS2 6SN - 183,000
- Leasehold Purpose built flat
SS2 6SN - 297,000
- Freehold Semi-detached house
SS2 6SN - 192,000
- Leasehold Purpose built flat
SS2 6SN - 194,000
- Leasehold Flat/Maisonette
SS2 6SN - 336,000
- Freehold Semi-detached property
SS2 6SN - 357,000
- Freehold Semi-detached house
SS2 6SN - 422,000
- Freehold Semi-detached house
SS2 6SN - 407,000
- Freehold Detached house
SS2 6SN - 256,000
- Freehold End terrace house
SS2 6SN - 248,000
- Freehold Semi-detached house
SS2 6SN - 225,000
- Freehold Semi-detached house
SS2 6SN - 237,000
- Semi-detached house
SS2 6SN - 352,000
- Freehold Semi-detached house
SS2 6SN - 375,000
- Freehold Semi-detached house
SS2 6SN - 367,000
- Freehold Semi-detached property
SS2 6SN - 303,000
- Freehold End terrace house
SS2 6SN - 337,000
- Freehold End terrace house
SS2 6SN - 118,000
- Leasehold Flat/Maisonette
SS2 6SN - 140,000
- Leasehold Purpose built flat
SS2 6SN - 141,000
- Leasehold Flat/Maisonette
SS2 6SN - 387,000
- Freehold Semi-detached house
SS2 6SN - 119,000
- Leasehold Flat/Maisonette
SS2 6SN - 151,000
- Leasehold Flat/Maisonette
SS2 6SN - 129,000
- Leasehold Flat/Maisonette
SS2 6SN - 141,000
- Leasehold Purpose built flat
SS2 6SN - 141,000
- Leasehold Flat/Maisonette
SS2 6SN - 176,000
- Leasehold Purpose built flat
SS2 6SN - 182,000
- Leasehold Flat/Maisonette
SS2 6SN - 192,000
- Leasehold Purpose built flat
SS2 6SN - 324,000
- Freehold Semi-detached house
SS2 6SN - 339,000
- Freehold Semi-detached house
SS2 6SN - 329,000
- Freehold Semi-detached house
SS2 6SN - 293,000
- Freehold End terrace house
SS2 6SN - 187,000
- Leasehold Purpose built flat
SS2 6SN - 186,000
- Leasehold Purpose built flat
SS2 6SN - 291,000
- Leasehold Semi-detached property
SS2 6SN - 342,000
- Freehold Semi-detached house
