SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HG4 5HA' order by fulladdress
HG4 5HA - 248,000
- Freehold Bungalow property
HG4 5HA - 300,000
- Semi-detached bungalow
HG4 5HA - 208,000
- Freehold Mid terrace bungalow
HG4 5HA - 304,000
- Semi-detached bungalow
HG4 5HA - 219,000
- Freehold End terrace bungalow
HG4 5HA - 131,000
- Share of freehold Terrace property
HG4 5HA - 184,000
- Freehold Mid terrace house
HG4 5HA - 191,000
- Freehold Terrace property
HG4 5HA - 124,000
- Freehold Converted flat
HG4 5HA - 452,000
- Freehold Detached bungalow
HG4 5HA - 483,000
- Freehold Semi-detached property
HG4 5HA - 397,000
- Freehold Semi-detached house
HG4 5HA - 448,000
- Freehold Semi-detached house
HG4 5HA - 402,000
- Freehold Semi-detached property
HG4 5HA - 569,000
- Freehold Detached house
HG4 5HA - 545,000
- Freehold Detached house
HG4 5HA - 558,000
- Freehold Detached house
HG4 5HA - 247,000
- Freehold End terrace house
HG4 5HA - 210,000
- Freehold End terrace house
HG4 5HA - 566,000
- Freehold Mid terrace house
HG4 5HA - 388,000
- Freehold Detached house
HG4 5HA - 468,000
- Freehold Semi-detached house
HG4 5HA - 350,000
- Freehold Detached house
HG4 5HA - 410,000
- Freehold Detached property
HG4 5HA - 530,000
- Freehold Detached bungalow
HG4 5HA - 265,000
- Freehold Detached bungalow
HG4 5HA - 744,000
- Freehold Semi-detached property
HG4 5HA - 353,000
- Freehold Mid terrace house
HG4 5HA - 494,000
- Freehold Detached bungalow
