SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HA4 8RY' order by fulladdress
HA4 8RY - 881,000
- Freehold Bungalow property
HA4 8RY - 844,000
- Freehold Detached bungalow
HA4 8RY - 903,000
- Freehold Semi-detached house
HA4 8RY - 840,000
- Freehold Semi-detached house
HA4 8RY - 812,000
- Freehold Detached house
HA4 8RY - 358,000
- Leasehold Purpose built flat
HA4 8RY - 353,000
- Leasehold Purpose built flat
HA4 8RY - 401,000
- Leasehold Purpose built flat
HA4 8RY - 448,000
- Leasehold Purpose built flat
HA4 8RY - 714,000
- Freehold Detached bungalow
HA4 8RY - 835,000
- Freehold Detached bungalow
HA4 8RY - 1,025,000
- Freehold Detached house
HA4 8RY - 787,000
- Freehold Detached house
HA4 8RY - 795,000
- Freehold Semi-detached property
HA4 8RY - 721,000
- Freehold Bungalow property
HA4 8RY - 785,000
- Freehold Detached house
HA4 8RY - 821,000
- Freehold Semi-detached house
HA4 8RY - 991,000
- Freehold Detached house
HA4 8RY - 888,000
- Freehold Detached property
HA4 8RY - 360,000
- Freehold Flat/Maisonette
HA4 8RY - 723,000
- Freehold Detached bungalow
HA4 8RY - 675,000
- Freehold Detached house
HA4 8RY - 1,112,000
- Freehold Detached house
HA4 8RY - 739,000
- Freehold Detached bungalow
HA4 8RY - 779,000
- Freehold Detached house
HA4 8RY - 1,159,000
- Freehold Detached house
HA4 8RY - 1,307,000
- Freehold Detached house
HA4 8RY - 791,000
- Freehold Semi-detached house
HA4 8RY - 827,000
- Freehold Semi-detached house
HA4 8RY - 963,000
- Freehold Detached house
HA4 8RY - 816,000
- Freehold Semi-detached house
