SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PR8 2JZ' order by fulladdress
PR8 2JZ - 2,665,000
- Leasehold Detached house
PR8 2JZ - 2,297,000
- Leasehold Detached house
PR8 2JZ - 1,680,000
- Leasehold Detached house
PR8 2JZ - 1,207,000
- Leasehold Detached property
PR8 2JZ - 1,768,000
- Leasehold Detached house
PR8 2JZ - 1,198,000
- Freehold Detached property
PR8 2JZ - 1,766,000
- Leasehold Detached house
PR8 2JZ - 982,000
- Leasehold Detached house
PR8 2JZ - 1,329,000
- Freehold Detached house
PR8 2JZ - 2,144,000
- Freehold Detached house
PR8 2JZ - 1,418,000
- Freehold Detached house
PR8 2JZ - 1,384,000
- Freehold Detached house
PR8 2JZ - 1,442,000
- Leasehold Detached house
PR8 2JZ - 1,057,000
- Leasehold Detached house
PR8 2JZ - 1,671,000
- Leasehold Detached house
