SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PE19 6TG' order by fulladdress
PE19 6TG - 339,000
- Freehold Mid terrace house
PE19 6TG - 354,000
- Freehold Mid terrace house
PE19 6TG - 344,000
- Freehold Mid terrace house
PE19 6TG - 341,000
- Freehold End terrace house
PE19 6TG - 544,000
- Freehold Semi-detached house
PE19 6TG - 964,000
- Freehold Detached house
PE19 6TG - 300,000
- Freehold Terrace property
PE19 6TG - 423,000
- Freehold Detached house
PE19 6TG - 292,000
- Freehold End terrace house
PE19 6TG - 1,091,000
- Freehold Detached house
PE19 6TG - 760,000
- Freehold Detached house
PE19 6TG - 536,000
- Freehold Semi-detached house
PE19 6TG - 679,000
- Freehold Detached property
PE19 6TG - 910,000
- Freehold Detached house
PE19 6TG - 755,000
- Freehold Detached property
PE19 6TG - 759,000
- Freehold Detached house
PE19 6TG - 783,000
- Freehold Detached property
PE19 6TG - 826,000
- Freehold Detached house
PE19 6TG - 1,233,000
- Freehold Detached house
PE19 6TG - 466,000
- Freehold Detached house
PE19 6TG - 398,000
- Freehold Mid terrace house
PE19 6TG - 473,000
- Freehold Semi-detached house
PE19 6TG - 489,000
- Freehold Semi-detached bungalow
PE19 6TG - 829,000
- Freehold Detached house
PE19 6TG - 1,482,000
- Freehold Detached property
PE19 6TG - 647,000
- Freehold Detached bungalow
PE19 6TG - 792,000
- Freehold Detached property
PE19 6TG - 908,000
- Freehold Detached house
PE19 6TG - 475,000
- Freehold Detached property
