SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HG5 0TR' order by fulladdress
HG5 0TR - 261,000
- Semi-detached house
HG5 0TR - 638,000
- Freehold Detached house
HG5 0TR - 603,000
- Freehold Detached house
HG5 0TR - 520,000
- Freehold Detached house
HG5 0TR - 382,000
- Freehold Semi-detached house
HG5 0TR - 382,000
- Freehold Semi-detached house
HG5 0TR - 596,000
- Freehold Detached house
HG5 0TR - 642,000
- Freehold Detached house
HG5 0TR - 261,000
- Semi-detached house
HG5 0TR - 198,000
- Semi-detached house
HG5 0TR - 193,000
- Semi-detached house
HG5 0TR - 130,000
- Leasehold Semi-detached house
HG5 0TR - 124,000
- Leasehold End terrace house
HG5 0TR - 126,000
- Leasehold End terrace house
HG5 0TR - 167,000
- Semi-detached house
HG5 0TR - 170,000
- Semi-detached house
HG5 0TR - 359,000
- Freehold Semi-detached house
HG5 0TR - 359,000
- Freehold Semi-detached house
HG5 0TR - 205,000
- Freehold End terrace house
HG5 0TR - 220,000
- Freehold Mid terrace house
HG5 0TR - 229,000
- Freehold End terrace house
HG5 0TR - 363,000
- Semi-detached house
HG5 0TR - 361,000
- Semi-detached house
HG5 0TR - 361,000
- Semi-detached house
HG5 0TR - 382,000
- Freehold Semi-detached house
HG5 0TR - 342,000
- Freehold Semi-detached house
HG5 0TR - 357,000
- Freehold End terrace property
HG5 0TR - 584,000
- Freehold Detached house
HG5 0TR - 377,000
- Freehold Semi-detached house
HG5 0TR - 374,000
- Freehold Semi-detached house
HG5 0TR - 512,000
- Freehold Detached house
HG5 0TR - 557,000
- Freehold Detached house
HG5 0TR - 609,000
- Freehold Detached house
HG5 0TR - 559,000
- Freehold Detached house
HG5 0TR - 640,000
- Freehold Detached house
HG5 0TR - 653,000
- Freehold Detached house
HG5 0TR - 578,000
- Freehold Detached house
HG5 0TR - 605,000
- Freehold Detached property
HG5 0TR - 509,000
- Freehold Detached house
HG5 0TR - 357,000
- Freehold Semi-detached house
HG5 0TR - 382,000
- Freehold Semi-detached house
HG5 0TR - 583,000
- Freehold Detached house
HG5 0TR - 367,000
- Semi-detached house
HG5 0TR - 595,000
- Freehold Detached house
HG5 0TR - 646,000
- Freehold Detached house
HG5 0TR - 585,000
- Freehold Detached house
HG5 0TR - 474,000
- Freehold Detached house
HG5 0TR - 523,000
- Freehold Detached house
HG5 0TR - 620,000
- Freehold Detached house