SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IG9 6AS' order by fulladdress
IG9 6AS - 635,000
- Freehold Semi-detached house
IG9 6AS - 360,000
- Leasehold Flat/Maisonette
IG9 6AS - 819,000
- Freehold Semi-detached house
IG9 6AS - 717,000
- Freehold Semi-detached house
IG9 6AS - 822,000
- Freehold Semi-detached house
IG9 6AS - 813,000
- Freehold Semi-detached house
IG9 6AS - 785,000
- Freehold Mid terrace house
IG9 6AS - 823,000
- Freehold Semi-detached property
IG9 6AS - 714,000
- Freehold Semi-detached house
IG9 6AS - 790,000
- Freehold Semi-detached house
IG9 6AS - 771,000
- Freehold Semi-detached house
IG9 6AS - 778,000
- Freehold Semi-detached property
IG9 6AS - 730,000
- Freehold Semi-detached house
IG9 6AS - 785,000
- Freehold Semi-detached house
IG9 6AS - 789,000
- Freehold Semi-detached house
IG9 6AS - 713,000
- Semi-detached house
IG9 6AS - 729,000
- Freehold Semi-detached house
IG9 6AS - 700,000
- Freehold Semi-detached house
IG9 6AS - 796,000
- Freehold Semi-detached house
IG9 6AS - 735,000
- Freehold Detached house
IG9 6AS - 770,000
- Freehold Semi-detached house
IG9 6AS - 742,000
- Freehold Semi-detached house
IG9 6AS - 740,000
- Freehold Semi-detached house
IG9 6AS - 697,000
- Freehold Semi-detached house
IG9 6AS - 660,000
- Freehold Semi-detached house
IG9 6AS - 783,000
- Freehold Semi-detached house
IG9 6AS - 625,000
- Freehold Semi-detached house
IG9 6AS - 760,000
- Freehold Semi-detached house
