SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IG10 4HY' order by fulladdress
IG10 4HY - 849,000
- Freehold Semi-detached house
IG10 4HY - 804,000
- Freehold Semi-detached house
IG10 4HY - 748,000
- Freehold Semi-detached house
IG10 4HY - 858,000
- Freehold Detached house
IG10 4HY - 938,000
- Freehold Detached house
IG10 4HY - 875,000
- Freehold Semi-detached house
IG10 4HY - 773,000
- Freehold Semi-detached house
IG10 4HY - 607,000
- Freehold Semi-detached house
IG10 4HY - 669,000
- Freehold Mid terrace house
IG10 4HY - 624,000
- Freehold End terrace house
IG10 4HY - 982,000
- Freehold Detached house
IG10 4HY - 833,000
- Freehold Semi-detached property
IG10 4HY - 1,281,000
- Freehold Semi-detached house
IG10 4HY - 989,000
- Freehold Semi-detached house
IG10 4HY - 936,000
- Freehold Semi-detached house
IG10 4HY - 927,000
- Freehold Detached house
IG10 4HY - 1,098,000
- Freehold Semi-detached house
IG10 4HY - 909,000
- Freehold Semi-detached house
IG10 4HY - 883,000
- Freehold Detached house
IG10 4HY - 859,000
- Freehold Semi-detached property
IG10 4HY - 797,000
- Freehold Semi-detached house
IG10 4HY - 960,000
- Freehold Semi-detached house
IG10 4HY - 858,000
- Freehold Semi-detached house
IG10 4HY - 728,000
- Freehold Mid terrace house
IG10 4HY - 880,000
- Freehold End terrace house
IG10 4HY - 735,000
- Freehold Semi-detached house
