SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HU9 1PS' order by fulladdress
HU9 1PS - 343,000
- Freehold Detached house
HU9 1PS - 173,000
- Freehold Semi-detached house
HU9 1PS - 439,000
- Freehold Detached house
HU9 1PS - 183,000
- Freehold Semi-detached house
HU9 1PS - 183,000
- Freehold Semi-detached house
HU9 1PS - 183,000
- Freehold Semi-detached house
HU9 1PS - 285,000
- Freehold Detached house
HU9 1PS - 186,000
- Freehold Semi-detached house
HU9 1PS - 284,000
- Freehold Detached house
HU9 1PS - 196,000
- Freehold Semi-detached house
HU9 1PS - 187,000
- Freehold Semi-detached property
HU9 1PS - 186,000
- Freehold Semi-detached house
HU9 1PS - 285,000
- Freehold Detached house
HU9 1PS - 277,000
- Freehold Detached property
HU9 1PS - 353,000
- Freehold Detached property
HU9 1PS - 378,000
- Freehold Detached house
HU9 1PS - 184,000
- Freehold Semi-detached property
HU9 1PS - 360,000
- Freehold Detached property
HU9 1PS - 361,000
- Freehold Detached house
HU9 1PS - 343,000
- Freehold Detached house
HU9 1PS - 331,000
- Freehold Detached house
HU9 1PS - 428,000
- Freehold Detached house
HU9 1PS - 313,000
- Freehold Detached house
HU9 1PS - 407,000
- Freehold Detached house
HU9 1PS - 186,000
- Freehold Semi-detached house
HU9 1PS - 321,000
- Freehold Detached house
HU9 1PS - 313,000
- Freehold Detached house
HU9 1PS - 377,000
- Freehold Detached house
HU9 1PS - 342,000
- Freehold Detached house
HU9 1PS - 421,000
- Freehold Detached house
HU9 1PS - 296,000
- Freehold Detached property
HU9 1PS - 190,000
- Freehold Semi-detached house
HU9 1PS - 325,000
- Freehold Detached house
HU9 1PS - 360,000
- Freehold Detached house
HU9 1PS - 402,000
- Freehold Detached house
HU9 1PS - 408,000
- Freehold Detached house
HU9 1PS - 255,000
- Freehold Semi-detached house
HU9 1PS - 346,000
- Freehold Detached house
HU9 1PS - 361,000
- Freehold Detached house
HU9 1PS - 431,000
- Freehold Detached house
HU9 1PS - 206,000
- Freehold Semi-detached house
HU9 1PS - 453,000
- Freehold Detached house
HU9 1PS - 419,000
- Freehold Detached house
HU9 1PS - 460,000
- Freehold Detached house
HU9 1PS - 471,000
- Freehold Detached house
HU9 1PS - 199,000
- Freehold Semi-detached house