SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PO7 7RX' order by fulladdress
PO7 7RX - 698,000
- Freehold Detached property
PO7 7RX - 651,000
- Freehold Detached house
PO7 7RX - 655,000
- Freehold Detached house
PO7 7RX - 854,000
- Freehold Detached house
PO7 7RX - 875,000
- Freehold Detached property
PO7 7RX - 562,000
- Freehold Semi-detached house
PO7 7RX - 574,000
- Freehold Semi-detached house
PO7 7RX - 688,000
- Freehold Detached house
PO7 7RX - 734,000
- Freehold Detached house
PO7 7RX - 611,000
- Freehold Detached house
PO7 7RX - 658,000
- Freehold Detached house
PO7 7RX - 707,000
- Freehold Detached house
PO7 7RX - 969,000
- Freehold Detached property
PO7 7RX - 597,000
- Semi-detached house
PO7 7RX - 906,000
- Freehold Detached house
PO7 7RX - 498,000
- Freehold Semi-detached house
PO7 7RX - 558,000
- Freehold Semi-detached house
PO7 7RX - 656,000
- Freehold Detached house
PO7 7RX - 599,000
- Freehold Detached house
PO7 7RX - 768,000
- Freehold Detached house
PO7 7RX - 691,000
- Freehold Detached house
PO7 7RX - 653,000
- Freehold Detached house
PO7 7RX - 794,000
- Freehold Detached house
PO7 7RX - 645,000
- Freehold Detached house
PO7 7RX - 704,000
- Freehold Detached house
PO7 7RX - 587,000
- Freehold Detached house
PO7 7RX - 550,000
- Freehold Detached house
PO7 7RX - 967,000
- Freehold Detached house
PO7 7RX - 652,000
- Freehold Detached house
PO7 7RX - 686,000
- Freehold Detached property
PO7 7RX - 525,000
- Freehold Detached bungalow
PO7 7RX - 659,000
- Freehold Semi-detached property
PO7 7RX - 498,000
- Semi-detached house
PO7 7RX - 683,000
- Freehold Semi-detached house
PO7 7RX - 543,000
- Freehold Semi-detached property