SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE3 8BZ' order by fulladdress
SE3 8BZ - 639,000
- Freehold Semi-detached house
SE3 8BZ - 679,000
- Freehold Semi-detached house
SE3 8BZ - 667,000
- Freehold Semi-detached house
SE3 8BZ - 662,000
- Freehold Semi-detached house
SE3 8BZ - 613,000
- Freehold Semi-detached house
SE3 8BZ - 617,000
- Freehold Semi-detached house
SE3 8BZ - 686,000
- Freehold Semi-detached property
SE3 8BZ - 644,000
- Freehold Semi-detached house
SE3 8BZ - 719,000
- Freehold Semi-detached house
SE3 8BZ - 610,000
- Freehold Semi-detached house
SE3 8BZ - 727,000
- Freehold Semi-detached house
SE3 8BZ - 648,000
- Freehold Semi-detached house
SE3 8BZ - 632,000
- Freehold Semi-detached house
SE3 8BZ - 631,000
- Freehold Semi-detached house
SE3 8BZ - 694,000
- Freehold Semi-detached house
SE3 8BZ - 589,000
- Freehold Semi-detached house
SE3 8BZ - 682,000
- Freehold Semi-detached house
SE3 8BZ - 612,000
- Semi-detached house
SE3 8BZ - 705,000
- Freehold Semi-detached house
SE3 8BZ - 606,000
- Freehold Semi-detached house
SE3 8BZ - 593,000
- Freehold Semi-detached property
SE3 8BZ - 636,000
- Freehold Semi-detached house
SE3 8BZ - 637,000
- Freehold Semi-detached house
SE3 8BZ - 717,000
- Freehold Semi-detached house
SE3 8BZ - 760,000
- Freehold Semi-detached house
SE3 8BZ - 607,000
- Semi-detached house
SE3 8BZ - 620,000
- Freehold Semi-detached house
SE3 8BZ - 607,000
- Freehold Semi-detached house
SE3 8BZ - 621,000
- Semi-detached house
SE3 8BZ - 605,000
- Freehold Semi-detached house
SE3 8BZ - 600,000
- Freehold Semi-detached house
SE3 8BZ - 617,000
- Freehold Semi-detached house
SE3 8BZ - 660,000
- Freehold Semi-detached house
SE3 8BZ - 707,000
- Freehold Semi-detached house
SE3 8BZ - 639,000
- Freehold Semi-detached house
SE3 8BZ - 739,000
- Freehold Semi-detached house
SE3 8BZ - 715,000
- Freehold Semi-detached house