SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IG8 8RZ' order by fulladdress
IG8 8RZ - 1,133,000
- Freehold Terraced
IG8 8RZ - 2,022,000
- Freehold Detached house
IG8 8RZ - 2,033,000
- Freehold Detached property
IG8 8RZ - 2,029,000
- Freehold Detached house
IG8 8RZ - 2,054,000
- Freehold Detached house
IG8 8RZ - 1,982,000
- Freehold Detached property
IG8 8RZ - 1,879,000
- Freehold Detached house
IG8 8RZ - 2,000,000
- Freehold Detached property
IG8 8RZ - 2,226,000
- Freehold Detached house
IG8 8RZ - 1,055,000
- Freehold End terrace house
IG8 8RZ - 1,023,000
- Freehold Terrace property
IG8 8RZ - 2,066,000
- Freehold Detached property
IG8 8RZ - 1,339,000
- Freehold Mid terrace house
IG8 8RZ - 1,246,000
- Freehold End terrace house
IG8 8RZ - 1,920,000
- Freehold Detached house
IG8 8RZ - 2,206,000
- Freehold Detached house
IG8 8RZ - 2,145,000
- Freehold Detached house
IG8 8RZ - 2,060,000
- Freehold Detached house
IG8 8RZ - 2,029,000
- Freehold Detached house
IG8 8RZ - 2,058,000
- Freehold Detached house
IG8 8RZ - 2,046,000
- Freehold Detached house
IG8 8RZ - 1,028,000
- Freehold Mid terrace house
IG8 8RZ - 2,394,000
- Freehold Detached house
IG8 8RZ - 2,078,000
- Freehold Detached house
IG8 8RZ - 2,113,000
- Freehold Detached house
IG8 8RZ - 2,230,000
- Freehold Detached property
IG8 8RZ - 2,226,000
- Freehold Detached property
IG8 8RZ - 1,117,000
- Freehold End terrace house
IG8 8RZ - 2,056,000
- Freehold Detached house
IG8 8RZ - 2,135,000
- Freehold Detached property
IG8 8RZ - 2,233,000
- Freehold Detached house
IG8 8RZ - 2,099,000
- Freehold Detached property
IG8 8RZ - 2,099,000
- Freehold Detached house
