SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='EN6 4HQ' order by fulladdress
EN6 4HQ - 803,000
- Freehold Detached property
EN6 4HQ - 911,000
- Freehold Detached bungalow
EN6 4HQ - 746,000
- Freehold Detached bungalow
EN6 4HQ - 814,000
- Freehold Detached bungalow
EN6 4HQ - 830,000
- Freehold Semi-detached property
EN6 4HQ - 832,000
- Freehold Detached bungalow
EN6 4HQ - 879,000
- Freehold Detached bungalow
EN6 4HQ - 934,000
- Freehold Detached bungalow
EN6 4HQ - 859,000
- Freehold Detached bungalow
EN6 4HQ - 653,000
- Freehold Detached bungalow
EN6 4HQ - 758,000
- Freehold Detached bungalow
EN6 4HQ - 807,000
- Freehold Detached bungalow
EN6 4HQ - 837,000
- Freehold Detached property
EN6 4HQ - 818,000
- Freehold Detached house
EN6 4HQ - 874,000
- Freehold Detached bungalow
EN6 4HQ - 850,000
- Freehold Detached property
EN6 4HQ - 801,000
- Freehold Detached property
EN6 4HQ - 774,000
- Freehold Detached property
EN6 4HQ - 644,000
- Freehold Detached bungalow
EN6 4HQ - 858,000
- Freehold Detached property
EN6 4HQ - 816,000
- Freehold Detached property
EN6 4HQ - 860,000
- Freehold Detached property
EN6 4HQ - 639,000
- Semi-detached bungalow
EN6 4HQ - 569,000
- Freehold Semi-detached bungalow
EN6 4HQ - 846,000
- Freehold Detached property
EN6 4HQ - 776,000
- Freehold Detached house
EN6 4HQ - 716,000
- Freehold Detached property
EN6 4HQ - 749,000
- Freehold Detached bungalow
EN6 4HQ - 791,000
- Freehold Detached bungalow
EN6 4HQ - 763,000
- Freehold Detached bungalow
