SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HP22 6EF' order by fulladdress
HP22 6EF - 389,000
- Freehold Mid terrace house
HP22 6EF - 393,000
- Freehold End terrace house
HP22 6EF - 1,415,000
- Freehold Detached property
HP22 6EF - 763,000
- Freehold Detached house
HP22 6EF - 364,000
- Freehold End terrace house
HP22 6EF - 345,000
- Freehold Mid terrace house
HP22 6EF - 585,000
- Freehold Detached bungalow
HP22 6EF - 374,000
- Freehold End terrace house
HP22 6EF - 537,000
- Freehold Semi-detached house
HP22 6EF - 428,000
- Freehold Terraced bungalow
HP22 6EF - 708,000
- Freehold Bungalow property
HP22 6EF - 362,000
- Leasehold Converted flat
HP22 6EF - 410,000
- Freehold Mid terrace house
HP22 6EF - 459,000
- Freehold End terrace house
HP22 6EF - 0
- Freehold End terrace property
HP22 6EF - 492,000
- Freehold Semi-detached house
HP22 6EF - 505,000
- Freehold Semi-detached house
HP22 6EF - 0
- Freehold End terrace bungalow
HP22 6EF - 976,000
- Freehold Detached house
HP22 6EF - 348,000
- Freehold Detached house
HP22 6EF - 516,000
- Freehold Mid terrace house
HP22 6EF - 311,000
- Freehold Bungalow property
HP22 6EF - 271,000
- Freehold Terrace property
HP22 6EF - 271,000
- Freehold Mid terrace house
HP22 6EF - 348,000
- Freehold Terrace property
HP22 6EF - 622,000
- Freehold Semi-detached house
HP22 6EF - 386,000
- Freehold Mid terrace house
HP22 6EF - 486,000
- Freehold Bungalow property
HP22 6EF - 280,000
- Freehold Terrace property
HP22 6EF - 357,000
- Freehold Terrace property
HP22 6EF - 299,000
- Freehold End terrace house
HP22 6EF - 645,000
- Freehold Semi-detached property
HP22 6EF - 601,000
- Freehold Semi-detached house
HP22 6EF - 358,000
- Freehold Semi-detached property
HP22 6EF - 299,000
- Freehold Mid terrace house
HP22 6EF - 272,000
- Freehold Terrace property
HP22 6EF - 353,000
- Freehold Semi-detached house
HP22 6EF - 839,000
- Freehold Detached bungalow
HP22 6EF - 1,161,000
- Freehold Detached bungalow
HP22 6EF - 485,000
- Freehold Semi-detached house
