SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SL4 3ER' order by fulladdress
SL4 3ER - 910,000
- Freehold Terrace property
SL4 3ER - 980,000
- Freehold Detached house
SL4 3ER - 1,013,000
- Freehold End terrace house
SL4 3ER - 1,044,000
- Freehold End terrace house
SL4 3ER - 996,000
- Freehold Mid terrace house
SL4 3ER - 462,000
- Leasehold Flat/Maisonette
SL4 3ER - 468,000
- Leasehold Flat/Maisonette
SL4 3ER - 870,000
- Leasehold Purpose built flat
SL4 3ER - 674,000
- Leasehold Flat/Maisonette
SL4 3ER - 910,000
- Freehold Mid terrace house
SL4 3ER - 0
- Freehold Terrace property
SL4 3ER - 1,202,000
- Freehold Mid terrace house
SL4 3ER - 1,104,000
- Freehold Semi-detached house
SL4 3ER - 974,000
- Freehold Semi-detached house
SL4 3ER - 932,000
- Freehold Mid terrace house
SL4 3ER - 1,263,000
- Freehold Detached property
SL4 3ER - 1,305,000
- Freehold Detached house
SL4 3ER - 950,000
- Freehold End terrace house
SL4 3ER - 957,000
- Freehold Detached property
SL4 3ER - 968,000
- Freehold End terrace house
SL4 3ER - 930,000
- Freehold End terrace house
SL4 3ER - 877,000
- Freehold Mid terrace house
SL4 3ER - 978,000
- Freehold Semi-detached house
SL4 3ER - 963,000
- Freehold End terrace house
SL4 3ER - 989,000
- Freehold Mid terrace house
SL4 3ER - 987,000
- Freehold End terrace house
SL4 3ER - 1,043,000
- Freehold Semi-detached house
SL4 3ER - 1,009,000
- Freehold Semi-detached house
SL4 3ER - 939,000
- Freehold End terrace house
SL4 3ER - 925,000
- Freehold Mid terrace house
SL4 3ER - 896,000
- Freehold Terrace property
SL4 3ER - 933,000
- Freehold Mid terrace house
SL4 3ER - 493,000
- Leasehold Flat/Maisonette
SL4 3ER - 528,000
- Leasehold Flat/Maisonette
SL4 3ER - 483,000
- Leasehold Flat/Maisonette
SL4 3ER - 976,000
- Leasehold Purpose built flat
SL4 3ER - 893,000
- Leasehold Flat/Maisonette
SL4 3ER - 924,000
- Freehold Terrace property
SL4 3ER - 952,000
- Freehold Mid terrace house
SL4 3ER - 1,258,000
- Freehold End terrace house
SL4 3ER - 432,000
- Leasehold Purpose built flat
SL4 3ER - 494,000
- Leasehold Flat/Maisonette
SL4 3ER - 476,000
- Leasehold Purpose built flat
SL4 3ER - 500,000
- Leasehold Flat/Maisonette
SL4 3ER - 492,000
- Leasehold Flat/Maisonette
