SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SL3 7GU' order by fulladdress
SL3 7GU - 563,000
- Freehold Semi-detached house
SL3 7GU - 552,000
- Freehold Semi-detached house
SL3 7GU - 328,000
- Leasehold Flat/Maisonette
SL3 7GU - 850,000
- Freehold Detached house
SL3 7GU - 944,000
- Freehold Detached house
SL3 7GU - 327,000
- Leasehold Purpose built flat
SL3 7GU - 921,000
- Freehold Detached house
SL3 7GU - 323,000
- Leasehold Purpose built flat
SL3 7GU - 333,000
- Leasehold Flat/Maisonette
SL3 7GU - 564,000
- Freehold Semi-detached house
SL3 7GU - 595,000
- Freehold Semi-detached house
SL3 7GU - 326,000
- Leasehold Flat/Maisonette
SL3 7GU - 591,000
- Freehold Semi-detached property
SL3 7GU - 330,000
- Leasehold Flat/Maisonette
SL3 7GU - 960,000
- Freehold Terrace property
SL3 7GU - 330,000
- Leasehold Flat/Maisonette
SL3 7GU - 952,000
- Freehold Detached house
SL3 7GU - 329,000
- Leasehold Flat/Maisonette
SL3 7GU - 947,000
- Freehold Detached house
SL3 7GU - 329,000
- Freehold Purpose built flat
SL3 7GU - 598,000
- Freehold Terrace property
SL3 7GU - 909,000
- Freehold Detached house
SL3 7GU - 323,000
- Leasehold Purpose built flat
SL3 7GU - 802,000
- Freehold Detached house
SL3 7GU - 335,000
- Leasehold Purpose built flat
SL3 7GU - 931,000
- Freehold Detached property
SL3 7GU - 392,000
- Leasehold Detached house
SL3 7GU - 829,000
- Freehold Detached house
SL3 7GU - 343,000
- Leasehold Purpose built flat
SL3 7GU - 884,000
- Freehold Detached house
SL3 7GU - 469,000
- Freehold End terrace house
SL3 7GU - 568,000
- Freehold Terrace property
SL3 7GU - 476,000
- Freehold Mid terrace house
SL3 7GU - 809,000
- Freehold Detached house
SL3 7GU - 471,000
- Freehold Terrace property
SL3 7GU - 970,000
- Freehold Detached house
SL3 7GU - 475,000
- Freehold End terrace house
SL3 7GU - 961,000
- Freehold Detached house
SL3 7GU - 565,000
- Freehold Terrace property
SL3 7GU - 892,000
- Freehold Detached house
SL3 7GU - 612,000
- Freehold Terrace property
SL3 7GU - 550,000
- Freehold Mid terrace house
SL3 7GU - 835,000
- Freehold Detached house
SL3 7GU - 475,000
- Freehold Semi-detached house
SL3 7GU - 874,000
- Freehold Detached house
SL3 7GU - 473,000
- Freehold Semi-detached house
SL3 7GU - 900,000
- Freehold Detached house
SL3 7GU - 571,000
- Freehold Detached house
SL3 7GU - 946,000
- Freehold Detached property
SL3 7GU - 841,000
- Freehold Detached house
SL3 7GU - 549,000
- Freehold Semi-detached house
SL3 7GU - 499,000
- Freehold End terrace house
SL3 7GU - 509,000
- Freehold Semi-detached house
SL3 7GU - 872,000
- Freehold Detached property
SL3 7GU - 936,000
- Freehold Detached house
SL3 7GU - 977,000
- Freehold Detached property
SL3 7GU - 575,000
- Freehold Semi-detached property
SL3 7GU - 551,000
- Freehold Mid terrace house
SL3 7GU - 982,000
- Freehold Detached house
SL3 7GU - 617,000
- Freehold Semi-detached house
SL3 7GU - 324,000
- Leasehold Purpose built flat
