SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP5 3AY' order by fulladdress
HP5 3AY - 620,000
- Freehold Semi-detached house
HP5 3AY - 496,000
- Freehold Mid terrace house
HP5 3AY - 492,000
- Freehold End terrace house
HP5 3AY - 442,000
- Freehold Semi-detached house
HP5 3AY - 692,000
- Freehold Detached house
HP5 3AY - 403,000
- Freehold Bungalow property
HP5 3AY - 496,000
- Freehold Semi-detached house
HP5 3AY - 394,000
- Freehold Terrace property
HP5 3AY - 573,000
- Freehold Semi-detached house
HP5 3AY - 358,000
- Freehold Mid terrace house
HP5 3AY - 495,000
- Freehold Semi-detached house
HP5 3AY - 398,000
- Freehold Mid terrace house
HP5 3AY - 549,000
- Freehold Semi-detached property
HP5 3AY - 441,000
- Freehold Mid terrace house
HP5 3AY - 652,000
- Freehold Detached house
HP5 3AY - 374,000
- Freehold Mid terrace house
HP5 3AY - 647,000
- Freehold Detached house
HP5 3AY - 404,000
- Freehold Mid terrace house
HP5 3AY - 633,000
- Freehold Detached house
HP5 3AY - 401,000
- Freehold Terrace property
HP5 3AY - 645,000
- Freehold Detached house
HP5 3AY - 391,000
- Freehold Mid terrace house
HP5 3AY - 366,000
- Freehold Mid terrace house
HP5 3AY - 381,000
- Freehold Mid terrace house
HP5 3AY - 833,000
- Freehold Semi-detached house
HP5 3AY - 410,000
- Freehold Mid terrace house
HP5 3AY - 654,000
- Freehold Semi-detached house
HP5 3AY - 404,000
- Freehold Mid terrace house
HP5 3AY - 867,000
- Freehold Semi-detached house
HP5 3AY - 412,000
- Freehold End terrace house
HP5 3AY - 887,000
- Freehold Semi-detached house
HP5 3AY - 807,000
- Freehold Semi-detached house
HP5 3AY - 765,000
- Freehold Semi-detached house
HP5 3AY - 552,000
- Freehold End terrace house
HP5 3AY - 538,000
- Freehold Mid terrace house
HP5 3AY - 500,000
- Freehold Mid terrace house
HP5 3AY - 666,000
- Freehold Semi-detached house
HP5 3AY - 656,000
- Freehold Semi-detached house
HP5 3AY - 606,000
- Freehold Detached property
HP5 3AY - 642,000
- Freehold Semi-detached house
HP5 3AY - 598,000
- Freehold Mid terrace house
HP5 3AY - 583,000
- Freehold Semi-detached house
HP5 3AY - 847,000
- Freehold Detached house
HP5 3AY - 659,000
- Semi-detached house
HP5 3AY - 756,000
- Freehold Semi-detached house
HP5 3AY - 669,000
- Freehold Semi-detached house
HP5 3AY - 265,000
- Leasehold Flat/Maisonette
HP5 3AY - 272,000
- Leasehold Flat/Maisonette
HP5 3AY - 251,000
- Leasehold Purpose built flat
HP5 3AY - 269,000
- Leasehold Flat/Maisonette
HP5 3AY - 273,000
- Leasehold Flat/Maisonette
HP5 3AY - 267,000
- Leasehold Converted flat
HP5 3AY - 270,000
- Leasehold Purpose built flat
HP5 3AY - 270,000
- Leasehold Purpose built flat
