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 1AS' order by fulladdress
S66 1AS - 357,000
- Freehold Bungalow property
S66 1AS - 582,000
- Freehold Detached house
S66 1AS - 609,000
- Freehold Detached property
S66 1AS - 565,000
- Freehold Detached house
S66 1AS - 334,000
- Freehold Bungalow property
S66 1AS - 331,000
- Freehold Semi-detached bungalow
S66 1AS - 378,000
- Freehold Detached bungalow
S66 1AS - 549,000
- Freehold Detached house
S66 1AS - 540,000
- Freehold Detached house
S66 1AS - 653,000
- Freehold Detached property
S66 1AS - 438,000
- Freehold Detached house
S66 1AS - 613,000
- Freehold Detached house
S66 1AS - 491,000
- Freehold Detached bungalow
S66 1AS - 468,000
- Freehold Detached bungalow
S66 1AS - 474,000
- Freehold Detached house
S66 1AS - 440,000
- Freehold Detached house
S66 1AS - 380,000
- Freehold Bungalow property
S66 1AS - 414,000
- Freehold Detached bungalow
S66 1AS - 424,000
- Freehold Detached property
S66 1AS - 358,000
- Freehold Detached bungalow
S66 1AS - 605,000
- Freehold Detached house
S66 1AS - 555,000
- Freehold Detached house
S66 1AS - 529,000
- Freehold Detached property
S66 1AS - 428,000
- Freehold Detached property
