SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW16 5BD' order by fulladdress
SW16 5BD - 634,000
- Freehold End terrace house
SW16 5BD - 577,000
- Freehold End terrace house
SW16 5BD - 569,000
- Freehold Terrace property
SW16 5BD - 627,000
- Freehold Mid terrace house
SW16 5BD - 597,000
- Freehold Mid terrace house
SW16 5BD - 578,000
- Freehold Terrace property
SW16 5BD - 588,000
- Freehold Terrace property
SW16 5BD - 583,000
- Freehold Terrace property
SW16 5BD - 581,000
- Freehold Mid terrace house
SW16 5BD - 595,000
- Freehold Mid terrace house
SW16 5BD - 562,000
- Freehold Mid terrace house
SW16 5BD - 621,000
- Freehold Mid terrace house
SW16 5BD - 598,000
- Freehold Mid terrace house
SW16 5BD - 612,000
- Freehold Mid terrace house
SW16 5BD - 590,000
- Freehold Mid terrace house
SW16 5BD - 591,000
- Freehold Mid terrace house
SW16 5BD - 574,000
- Freehold Flat/Maisonette
SW16 5BD - 589,000
- Freehold Mid terrace house
SW16 5BD - 614,000
- Freehold Terrace property
SW16 5BD - 671,000
- Freehold Mid terrace house
SW16 5BD - 647,000
- Freehold Semi-detached house
SW16 5BD - 590,000
- Freehold End terrace house
SW16 5BD - 797,000
- Freehold End terrace house
SW16 5BD - 774,000
- Freehold Mid terrace house
SW16 5BD - 768,000
- Freehold Mid terrace house
SW16 5BD - 761,000
- Freehold Mid terrace house
SW16 5BD - 770,000
- Freehold Mid terrace house
SW16 5BD - 785,000
- Freehold Mid terrace house
SW16 5BD - 783,000
- Freehold End terrace house
