SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HA0 1QY' order by fulladdress
HA0 1QY - 365,000
- Leasehold Purpose built flat
HA0 1QY - 447,000
- Leasehold Purpose built flat
HA0 1QY - 338,000
- Leasehold Purpose built flat
HA0 1QY - 515,000
- Leasehold Flat/Maisonette
HA0 1QY - 507,000
- Leasehold Flat/Maisonette
HA0 1QY - 389,000
- Leasehold Purpose built flat
HA0 1QY - 349,000
- Leasehold Flat/Maisonette
HA0 1QY - 471,000
- Leasehold Purpose built flat
HA0 1QY - 466,000
- Leasehold Purpose built flat
HA0 1QY - 440,000
- Leasehold Flat/Maisonette
HA0 1QY - 410,000
- Leasehold Purpose built flat
HA0 1QY - 501,000
- Leasehold Purpose built flat
HA0 1QY - 481,000
- Leasehold Flat/Maisonette
HA0 1QY - 492,000
- Leasehold Flat/Maisonette
HA0 1QY - 344,000
- Leasehold Flat/Maisonette
HA0 1QY - 356,000
- Leasehold Flat/Maisonette
HA0 1QY - 477,000
- Leasehold Flat/Maisonette
HA0 1QY - 438,000
- Leasehold Flat/Maisonette
HA0 1QY - 345,000
- Leasehold Flat/Maisonette
HA0 1QY - 456,000
- Leasehold Purpose built flat
HA0 1QY - 475,000
- Leasehold Purpose built flat
HA0 1QY - 339,000
- Leasehold Flat/Maisonette
HA0 1QY - 356,000
- Leasehold Flat/Maisonette
HA0 1QY - 482,000
- Leasehold Flat/Maisonette
HA0 1QY - 451,000
- Leasehold Purpose built flat
HA0 1QY - 439,000
- Leasehold Flat/Maisonette
HA0 1QY - 343,000
- Leasehold Purpose built flat
HA0 1QY - 461,000
- Leasehold Purpose built flat
HA0 1QY - 341,000
- Leasehold Purpose built flat
HA0 1QY - 350,000
- Leasehold Purpose built flat
HA0 1QY - 469,000
- Leasehold Flat/Maisonette
HA0 1QY - 463,000
- Leasehold Flat/Maisonette
HA0 1QY - 461,000
- Leasehold Flat/Maisonette
HA0 1QY - 433,000
- Leasehold Flat/Maisonette
HA0 1QY - 345,000
- Leasehold Flat/Maisonette
HA0 1QY - 473,000
- Leasehold Flat/Maisonette
HA0 1QY - 501,000
- Leasehold Flat/Maisonette
HA0 1QY - 348,000
- Leasehold Purpose built flat
HA0 1QY - 356,000
- Leasehold Flat/Maisonette
HA0 1QY - 495,000
- Leasehold Flat/Maisonette
HA0 1QY - 466,000
- Leasehold Flat/Maisonette
HA0 1QY - 494,000
- Leasehold Flat/Maisonette
HA0 1QY - 438,000
- Leasehold Flat/Maisonette
HA0 1QY - 342,000
- Leasehold Purpose built flat
HA0 1QY - 501,000
- Leasehold Purpose built flat
HA0 1QY - 464,000
- Feudal Purpose built flat
HA0 1QY - 347,000
- Leasehold Purpose built flat
HA0 1QY - 337,000
- Leasehold Flat/Maisonette
HA0 1QY - 475,000
- Leasehold Purpose built flat
HA0 1QY - 467,000
- Leasehold Flat/Maisonette
HA0 1QY - 438,000
- Leasehold Flat/Maisonette
HA0 1QY - 344,000
- Leasehold Purpose built flat
HA0 1QY - 340,000
- Leasehold Purpose built flat
HA0 1QY - 498,000
- Leasehold Purpose built flat
HA0 1QY - 458,000
- Leasehold Purpose built flat
HA0 1QY - 349,000
- Leasehold Purpose built flat
HA0 1QY - 353,000
- Leasehold Flat/Maisonette
HA0 1QY - 487,000
- Feudal Purpose built flat
HA0 1QY - 488,000
- Leasehold Flat/Maisonette
HA0 1QY - 426,000
- Leasehold Flat/Maisonette
HA0 1QY - 349,000
- Leasehold Flat/Maisonette
HA0 1QY - 506,000
- Leasehold Purpose built flat
HA0 1QY - 506,000
- Leasehold Purpose built flat
HA0 1QY - 351,000
- Leasehold Flat/Maisonette
HA0 1QY - 342,000
- Leasehold Flat/Maisonette
HA0 1QY - 368,000
- Leasehold Flat/Maisonette
HA0 1QY - 510,000
- Leasehold Purpose built flat
HA0 1QY - 476,000
- Leasehold Flat/Maisonette
HA0 1QY - 446,000
- Leasehold Flat/Maisonette
HA0 1QY - 347,000
- Leasehold Purpose built flat
HA0 1QY - 471,000
- Leasehold Flat/Maisonette
HA0 1QY - 496,000
- Leasehold Purpose built flat
HA0 1QY - 355,000
- Feudal Purpose built flat
HA0 1QY - 656,000
- Leasehold Purpose built flat
HA0 1QY - 477,000
- Leasehold Flat/Maisonette
HA0 1QY - 662,000
- Leasehold Purpose built flat
HA0 1QY - 640,000
- Feudal Purpose built flat
HA0 1QY - 646,000
- Leasehold Purpose built flat
HA0 1QY - 464,000
- Leasehold Flat/Maisonette
