SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HA2 6HD' order by fulladdress
HA2 6HD - 760,000
- Freehold Detached house
HA2 6HD - 358,000
- Leasehold Purpose built flat
HA2 6HD - 323,000
- Leasehold Flat/Maisonette
HA2 6HD - 355,000
- Leasehold Flat/Maisonette
HA2 6HD - 301,000
- Leasehold Flat/Maisonette
HA2 6HD - 289,000
- Leasehold Converted flat
HA2 6HD - 351,000
- Leasehold Purpose built flat
HA2 6HD - 373,000
- Leasehold Flat/Maisonette
HA2 6HD - 728,000
- Freehold Detached house
HA2 6HD - 581,000
- Freehold Semi-detached house
HA2 6HD - 341,000
- Leasehold Purpose built flat
HA2 6HD - 510,000
- Freehold Semi-detached house
HA2 6HD - 752,000
- Freehold Semi-detached property
HA2 6HD - 660,000
- Freehold Semi-detached house
HA2 6HD - 656,000
- Freehold Semi-detached house
HA2 6HD - 659,000
- Freehold Semi-detached house
HA2 6HD - 673,000
- Freehold Semi-detached house
HA2 6HD - 509,000
- Freehold Semi-detached house
HA2 6HD - 536,000
- Freehold Semi-detached house
HA2 6HD - 521,000
- Semi-detached house
HA2 6HD - 546,000
- Freehold Semi-detached house
HA2 6HD - 338,000
- Leasehold Purpose built flat
HA2 6HD - 669,000
- Freehold Semi-detached house
HA2 6HD - 938,000
- Freehold Detached house
HA2 6HD - 904,000
- Freehold Detached property
HA2 6HD - 900,000
- Freehold Detached house
HA2 6HD - 836,000
- Freehold Detached house
HA2 6HD - 667,000
- Freehold Semi-detached house
HA2 6HD - 614,000
- Freehold Semi-detached property
HA2 6HD - 678,000
- Freehold End terrace property
HA2 6HD - 331,000
- Leasehold Purpose built flat
HA2 6HD - 397,000
- Leasehold Semi-detached house
HA2 6HD - 350,000
- Leasehold Purpose built flat
HA2 6HD - 341,000
- Leasehold Purpose built flat
HA2 6HD - 300,000
- Leasehold Flat/Maisonette
HA2 6HD - 292,000
- Leasehold Purpose built flat
