SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='DA2 6BF' order by fulladdress
DA2 6BF - 701,000
- Freehold Detached house
DA2 6BF - 266,000
- Leasehold Purpose built flat
DA2 6BF - 272,000
- Leasehold Flat/Maisonette
DA2 6BF - 264,000
- Leasehold Flat/Maisonette
DA2 6BF - 275,000
- Leasehold Purpose built flat
DA2 6BF - 511,000
- Freehold Detached house
DA2 6BF - 522,000
- Freehold Semi-detached house
DA2 6BF - 505,000
- Freehold Semi-detached house
DA2 6BF - 621,000
- Freehold Detached house
DA2 6BF - 301,000
- Leasehold Flat/Maisonette
DA2 6BF - 284,000
- Leasehold Purpose built flat
DA2 6BF - 295,000
- Leasehold Purpose built flat
DA2 6BF - 284,000
- Leasehold Purpose built flat
DA2 6BF - 241,000
- Leasehold Purpose built flat
DA2 6BF - 508,000
- Freehold Semi-detached house
DA2 6BF - 650,000
- Freehold Detached house
DA2 6BF - 519,000
- Freehold Semi-detached house
DA2 6BF - 520,000
- Freehold Detached house
DA2 6BF - 344,000
- Leasehold Converted flat
DA2 6BF - 299,000
- Leasehold Converted flat
DA2 6BF - 362,000
- Leasehold Purpose built flat
DA2 6BF - 345,000
- Leasehold Converted flat
DA2 6BF - 413,000
- Leasehold Flat/Maisonette
DA2 6BF - 359,000
- Leasehold Flat/Maisonette
DA2 6BF - 344,000
- Leasehold Flat/Maisonette
DA2 6BF - 332,000
- Leasehold Converted flat
DA2 6BF - 661,000
- Freehold Detached house
DA2 6BF - 371,000
- Leasehold Converted flat
DA2 6BF - 419,000
- Leasehold Flat/Maisonette
DA2 6BF - 522,000
- Freehold Semi-detached house
DA2 6BF - 470,000
- Freehold Semi-detached house
DA2 6BF - 532,000
- Freehold Semi-detached house
DA2 6BF - 496,000
- Freehold Terrace property
DA2 6BF - 530,000
- Freehold Semi-detached house
DA2 6BF - 442,000
- Freehold Semi-detached house
DA2 6BF - 442,000
- Freehold Semi-detached house
DA2 6BF - 523,000
- Freehold Semi-detached house
DA2 6BF - 659,000
- Freehold Detached house
DA2 6BF - 581,000
- Freehold Terrace property
DA2 6BF - 587,000
- Freehold Mid terrace house
DA2 6BF - 599,000
- Freehold Semi-detached house
DA2 6BF - 584,000
- Freehold Mid terrace house
DA2 6BF - 594,000
- Freehold Mid terrace house
DA2 6BF - 596,000
- Freehold Mid terrace house
DA2 6BF - 513,000
- Freehold Semi-detached house
DA2 6BF - 502,000
- Freehold Semi-detached house
DA2 6BF - 517,000
- Freehold Semi-detached house
DA2 6BF - 267,000
- Leasehold Purpose built flat
DA2 6BF - 275,000
- Leasehold Flat/Maisonette