SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='S66 7LB' order by fulladdress
S66 7LB - 233,000
- Freehold Detached house
S66 7LB - 83,000
- Leasehold Purpose built flat
S66 7LB - 73,000
- Leasehold Flat/Maisonette
S66 7LB - 59,000
- Leasehold Purpose built flat
S66 7LB - 100,000
- Freehold Mid terrace house
S66 7LB - 141,000
- Freehold Semi-detached bungalow
S66 7LB - 56,000
- Leasehold Flat/Maisonette
S66 7LB - 148,000
- Freehold Detached bungalow
S66 7LB - 71,000
- Leasehold Purpose built flat
S66 7LB - 133,000
- Freehold Mid terrace house
S66 7LB - 64,000
- Leasehold Purpose built flat
S66 7LB - 197,000
- Freehold Detached bungalow
S66 7LB - 135,000
- Semi-detached house
S66 7LB - 72,000
- Leasehold Bungalow property
S66 7LB - 136,000
- Freehold Semi-detached house
S66 7LB - 90,000
- Leasehold Semi-detached bungalow
S66 7LB - 148,000
- Freehold Semi-detached property
S66 7LB - 114,000
- Freehold Detached bungalow
S66 7LB - 136,000
- Leasehold Semi-detached house
S66 7LB - 161,000
- Freehold Detached bungalow
S66 7LB - 138,000
- Freehold Semi-detached house
S66 7LB - 113,000
- Freehold Semi-detached house
S66 7LB - 201,000
- Freehold Detached house
S66 7LB - 108,000
- Freehold Semi-detached property
S66 7LB - 115,000
- Freehold Semi-detached house
S66 7LB - 107,000
- Freehold Semi-detached bungalow
S66 7LB - 126,000
- Freehold Terraced bungalow
S66 7LB - 125,000
- Freehold Mid terrace house
S66 7LB - 100,000
- Freehold End terrace house
S66 7LB - 129,000
- Freehold Semi-detached house
S66 7LB - 113,000
- Freehold Bungalow property
S66 7LB - 114,000
- Freehold Mid terrace house
S66 7LB - 130,000
- Freehold End terrace house
S66 7LB - 110,000
- Freehold End terrace house
S66 7LB - 154,000
- Semi-detached house
S66 7LB - 227,000
- Freehold Detached bungalow
S66 7LB - 126,000
- Freehold Semi-detached house
S66 7LB - 66,000
- Leasehold Flat/Maisonette
S66 7LB - 139,000
- Freehold Semi-detached bungalow
S66 7LB - 57,000
- Leasehold Flat/Maisonette
S66 7LB - 69,000
- Leasehold Purpose built flat
S66 7LB - 127,000
- Freehold Semi-detached property
S66 7LB - 66,000
- Leasehold Flat/Maisonette
S66 7LB - 109,000
- Freehold Semi-detached house
S66 7LB - 56,000
- Leasehold Flat/Maisonette
S66 7LB - 107,000
- Freehold Semi-detached house
S66 7LB - 65,000
- Leasehold Flat/Maisonette
S66 7LB - 121,000
- Freehold Semi-detached property
S66 7LB - 67,000
- Leasehold Purpose built flat
S66 7LB - 117,000
- Freehold Semi-detached house
S66 7LB - 117,000
- Freehold Semi-detached bungalow
S66 7LB - 59,000
- Leasehold Flat/Maisonette
S66 7LB - 115,000
- Freehold Semi-detached bungalow
S66 7LB - 67,000
- Leasehold Flat/Maisonette
S66 7LB - 106,000
- Freehold Semi-detached house
S66 7LB - 74,000
- Leasehold Flat/Maisonette
S66 7LB - 89,000
- Leasehold Flat/Maisonette
S66 7LB - 134,000
- Freehold End terrace house
S66 7LB - 105,000
- Freehold Mid terrace house
S66 7LB - 68,000
- Leasehold Purpose built flat
S66 7LB - 78,000
- Leasehold Flat/Maisonette
S66 7LB - 138,000
- Freehold Detached bungalow
S66 7LB - 117,000
- Freehold Semi-detached bungalow
S66 7LB - 120,000
- Freehold Detached house
S66 7LB - 116,000
- Freehold Semi-detached property
S66 7LB - 107,000
- Freehold End terrace house
S66 7LB - 121,000
- Freehold End terrace house
S66 7LB - 78,000
- Leasehold Purpose built flat
S66 7LB - 85,000
- Leasehold Semi-detached property
S66 7LB - 80,000
- Leasehold Purpose built flat
S66 7LB - 81,000
- Leasehold Purpose built flat
S66 7LB - 69,000
- Leasehold Purpose built flat
S66 7LB - 86,000
- Leasehold Flat/Maisonette
S66 7LB - 80,000
- Leasehold Purpose built flat
S66 7LB - 79,000
- Leasehold Purpose built flat
S66 7LB - 80,000
- Leasehold Flat/Maisonette
S66 7LB - 88,000
- Leasehold Purpose built flat
