SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP11 1GT' order by fulladdress
HP11 1GT - 418,000
- Freehold Mid terrace house
HP11 1GT - 541,000
- Freehold End terrace house
HP11 1GT - 609,000
- Freehold Semi-detached house
HP11 1GT - 635,000
- Freehold End terrace house
HP11 1GT - 663,000
- Freehold Mid terrace house
HP11 1GT - 605,000
- Freehold Semi-detached house
HP11 1GT - 343,000
- Leasehold Detached house
HP11 1GT - 608,000
- Freehold Mid terrace house
HP11 1GT - 619,000
- Freehold Mid terrace house
HP11 1GT - 415,000
- Freehold Mid terrace house
HP11 1GT - 534,000
- Freehold Terrace property
HP11 1GT - 671,000
- Freehold Mid terrace house
HP11 1GT - 336,000
- Leasehold Purpose built flat
HP11 1GT - 659,000
- Freehold End terrace house
HP11 1GT - 410,000
- Freehold Mid terrace house
HP11 1GT - 599,000
- Freehold Semi-detached house
HP11 1GT - 559,000
- Freehold End terrace house
HP11 1GT - 548,000
- Freehold Mid terrace house
HP11 1GT - 332,000
- Leasehold Flat/Maisonette
HP11 1GT - 509,000
- Freehold Mid terrace house
HP11 1GT - 538,000
- Freehold Mid terrace house
HP11 1GT - 508,000
- Freehold Mid terrace house
HP11 1GT - 328,000
- Leasehold Flat/Maisonette
HP11 1GT - 527,000
- Freehold Mid terrace house
HP11 1GT - 536,000
- Freehold End terrace house
HP11 1GT - 537,000
- Freehold Mid terrace house
HP11 1GT - 523,000
- Freehold Mid terrace house
HP11 1GT - 567,000
- Freehold Mid terrace house
HP11 1GT - 563,000
- Freehold Mid terrace house
HP11 1GT - 345,000
- Leasehold Detached house
HP11 1GT - 434,000
- Freehold Mid terrace house
HP11 1GT - 339,000
- Leasehold Purpose built flat
HP11 1GT - 610,000
- Freehold End terrace house
HP11 1GT - 536,000
- Freehold Mid terrace house
HP11 1GT - 645,000
- Freehold End terrace house
