SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='WD6 2AB' order by fulladdress
WD6 2AB - 659,000
- Freehold Semi-detached house
WD6 2AB - 649,000
- Freehold Semi-detached house
WD6 2AB - 625,000
- Freehold End terrace house
WD6 2AB - 615,000
- Freehold Mid terrace house
WD6 2AB - 643,000
- Freehold End terrace house
WD6 2AB - 663,000
- Freehold Semi-detached house
WD6 2AB - 652,000
- Freehold Mid terrace house
WD6 2AB - 649,000
- Freehold End terrace house
WD6 2AB - 655,000
- Freehold Semi-detached house
WD6 2AB - 539,000
- Freehold End terrace house
WD6 2AB - 583,000
- Freehold Mid terrace house
WD6 2AB - 604,000
- Freehold Semi-detached house
WD6 2AB - 640,000
- Freehold Semi-detached house
WD6 2AB - 659,000
- Freehold Semi-detached house
WD6 2AB - 688,000
- Freehold Detached house
WD6 2AB - 644,000
- Freehold Semi-detached house
WD6 2AB - 664,000
- Freehold Semi-detached house
WD6 2AB - 688,000
- Freehold Semi-detached house
WD6 2AB - 654,000
- Freehold Semi-detached house
WD6 2AB - 656,000
- Freehold Semi-detached house
WD6 2AB - 674,000
- Freehold Semi-detached house
WD6 2AB - 610,000
- Freehold Semi-detached house
WD6 2AB - 649,000
- Freehold Semi-detached house
WD6 2AB - 656,000
- Semi-detached house
WD6 2AB - 651,000
- Freehold Semi-detached house
WD6 2AB - 653,000
- Freehold Semi-detached house
WD6 2AB - 678,000
- Freehold Semi-detached house
WD6 2AB - 610,000
- Freehold Semi-detached house
WD6 2AB - 661,000
- Freehold Semi-detached house
WD6 2AB - 652,000
- Freehold Semi-detached house
WD6 2AB - 681,000
- Freehold Detached house
WD6 2AB - 577,000
- Freehold End terrace house
WD6 2AB - 602,000
- Freehold Mid terrace property
WD6 2AB - 618,000
- Freehold Mid terrace house
WD6 2AB - 575,000
- Freehold Semi-detached house
WD6 2AB - 588,000
- Freehold End terrace house
WD6 2AB - 627,000
- Freehold Semi-detached house
WD6 2AB - 639,000
- Freehold Semi-detached house
WD6 2AB - 650,000
- Freehold Mid terrace house
WD6 2AB - 654,000
- Freehold Semi-detached house