SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HA1 1LD' order by fulladdress
HA1 1LD - 844,000
- Freehold Semi-detached house
HA1 1LD - 397,000
- Leasehold Converted flat
HA1 1LD - 812,000
- Freehold Semi-detached house
HA1 1LD - 627,000
- Freehold Terrace property
HA1 1LD - 616,000
- Freehold Semi-detached house
HA1 1LD - 663,000
- Freehold Mid terrace house
HA1 1LD - 652,000
- Freehold Mid terrace house
HA1 1LD - 366,000
- Feudal Converted flat
HA1 1LD - 362,000
- Leasehold Flat/Maisonette
HA1 1LD - 316,000
- Leasehold Flat/Maisonette
HA1 1LD - 531,000
- Semi-detached house
HA1 1LD - 344,000
- Leasehold Purpose built flat
HA1 1LD - 356,000
- Leasehold Converted flat
HA1 1LD - 372,000
- Leasehold Converted flat
HA1 1LD - 372,000
- Leasehold Converted flat
HA1 1LD - 373,000
- Leasehold Converted flat
HA1 1LD - 368,000
- Leasehold Purpose built flat
HA1 1LD - 654,000
- Freehold Mid terrace house
HA1 1LD - 346,000
- Freehold Converted flat
HA1 1LD - 358,000
- Freehold Purpose built flat
HA1 1LD - 366,000
- Leasehold Flat/Maisonette
HA1 1LD - 376,000
- Leasehold Flat/Maisonette
HA1 1LD - 369,000
- Feudal Purpose built flat
HA1 1LD - 658,000
- Freehold Semi-detached house
HA1 1LD - 348,000
- Leasehold Terrace property
HA1 1LD - 345,000
- Leasehold Converted flat
HA1 1LD - 373,000
- Leasehold Converted flat
HA1 1LD - 700,000
- Freehold Semi-detached house
HA1 1LD - 362,000
- Leasehold Converted flat
HA1 1LD - 726,000
- Freehold Semi-detached house
HA1 1LD - 737,000
- Freehold Semi-detached house
HA1 1LD - 352,000
- Leasehold Converted flat
HA1 1LD - 420,000
- Leasehold Flat/Maisonette
HA1 1LD - 388,000
- Leasehold Semi-detached house
HA1 1LD - 0
- Leasehold Flat/Maisonette
HA1 1LD - 401,000
- Leasehold Converted flat
HA1 1LD - 355,000
- Leasehold Converted flat
HA1 1LD - 356,000
- Leasehold Converted flat
HA1 1LD - 345,000
- Leasehold Converted flat
HA1 1LD - 391,000
- Leasehold Converted flat
HA1 1LD - 356,000
- Leasehold Converted flat
HA1 1LD - 423,000
- Leasehold Flat/Maisonette
HA1 1LD - 344,000
- Leasehold Converted flat
HA1 1LD - 371,000
- Feudal Converted flat
HA1 1LD - 304,000
- Leasehold Flat/Maisonette
HA1 1LD - 354,000
- Leasehold Flat/Maisonette
