SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='IP14 1SS' order by fulladdress
IP14 1SS - 354,000
- Freehold Detached property
IP14 1SS - 255,000
- Freehold Semi-detached bungalow
IP14 1SS - 262,000
- Freehold Semi-detached bungalow
IP14 1SS - 289,000
- Freehold Semi-detached house
IP14 1SS - 250,000
- Freehold Semi-detached bungalow
IP14 1SS - 266,000
- Freehold Semi-detached house
IP14 1SS - 274,000
- Freehold Semi-detached property
IP14 1SS - 295,000
- Freehold Semi-detached house
IP14 1SS - 293,000
- Freehold Semi-detached house
IP14 1SS - 256,000
- Freehold Semi-detached bungalow
IP14 1SS - 347,000
- Freehold Detached house
IP14 1SS - 356,000
- Freehold Detached house
IP14 1SS - 348,000
- Freehold Detached property
IP14 1SS - 441,000
- Freehold Detached house
IP14 1SS - 406,000
- Freehold Detached house
IP14 1SS - 390,000
- Freehold Detached property
IP14 1SS - 467,000
- Freehold Detached house
IP14 1SS - 346,000
- Freehold Detached house
IP14 1SS - 358,000
- Freehold Detached house
IP14 1SS - 421,000
- Freehold Detached house
IP14 1SS - 405,000
- Freehold Detached house
IP14 1SS - 490,000
- Freehold Detached house
IP14 1SS - 453,000
- Freehold Detached house
IP14 1SS - 408,000
- Freehold Detached house
IP14 1SS - 442,000
- Freehold Detached house
IP14 1SS - 455,000
- Freehold Detached property
IP14 1SS - 328,000
- Freehold Semi-detached property
IP14 1SS - 292,000
- Freehold Semi-detached house
IP14 1SS - 359,000
- Freehold Detached house
IP14 1SS - 336,000
- Freehold Detached house
IP14 1SS - 390,000
- Freehold Detached property
IP14 1SS - 161,000
- Leasehold Purpose built flat
IP14 1SS - 456,000
- Freehold Detached house
IP14 1SS - 159,000
- Leasehold Flat/Maisonette
IP14 1SS - 338,000
- Freehold Detached house
IP14 1SS - 356,000
- Freehold Detached house
IP14 1SS - 440,000
- Freehold Detached house
IP14 1SS - 350,000
- Freehold Detached house
IP14 1SS - 157,000
- Leasehold Flat/Maisonette
IP14 1SS - 143,000
- Leasehold Flat/Maisonette
IP14 1SS - 152,000
- Leasehold Flat/Maisonette
IP14 1SS - 271,000
- Freehold Semi-detached house
IP14 1SS - 155,000
- Leasehold Purpose built flat
IP14 1SS - 161,000
- Leasehold Purpose built flat
IP14 1SS - 154,000
- Leasehold Flat/Maisonette
IP14 1SS - 155,000
- Leasehold Flat/Maisonette
IP14 1SS - 154,000
- Leasehold Purpose built flat
IP14 1SS - 154,000
- Leasehold Flat/Maisonette
IP14 1SS - 271,000
- Freehold Semi-detached property
IP14 1SS - 153,000
- Feudal Purpose built flat
