SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SS9 1DG' order by fulladdress
SS9 1DG - 657,000
- Freehold Semi-detached property
SS9 1DG - 595,000
- Freehold Mid terrace house
SS9 1DG - 300,000
- Leasehold Flat/Maisonette
SS9 1DG - 300,000
- Leasehold Flat/Maisonette
SS9 1DG - 252,000
- Leasehold Flat/Maisonette
SS9 1DG - 900,000
- Freehold Detached house
SS9 1DG - 345,000
- Leasehold Converted flat
SS9 1DG - 331,000
- Leasehold Flat/Maisonette
SS9 1DG - 625,000
- Freehold Semi-detached house
SS9 1DG - 315,000
- Leasehold Converted flat
SS9 1DG - 947,000
- Freehold Detached house
SS9 1DG - 715,000
- Freehold Semi-detached house
SS9 1DG - 339,000
- Leasehold Flat/Maisonette
SS9 1DG - 759,000
- Freehold Detached house
SS9 1DG - 725,000
- Freehold Semi-detached property
SS9 1DG - 596,000
- Freehold Mid terrace house
SS9 1DG - 669,000
- Freehold End terrace house
SS9 1DG - 735,000
- Freehold End terrace house
SS9 1DG - 367,000
- Leasehold Flat/Maisonette
SS9 1DG - 281,000
- Leasehold Flat/Maisonette
SS9 1DG - 285,000
- Leasehold Purpose built flat
SS9 1DG - 342,000
- Leasehold Purpose built flat
SS9 1DG - 293,000
- Leasehold Converted flat
SS9 1DG - 317,000
- Leasehold Converted flat
SS9 1DG - 739,000
- Freehold Mid terrace house
SS9 1DG - 605,000
- Freehold Mid terrace house
SS9 1DG - 731,000
- Freehold Semi-detached house
SS9 1DG - 924,000
- Freehold Detached house
SS9 1DG - 318,000
- Leasehold Flat/Maisonette
SS9 1DG - 1,093,000
- Freehold Detached house
SS9 1DG - 903,000
- Freehold Detached property
