SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HG1 3DN' order by fulladdress
HG1 3DN - 564,000
- Freehold Detached house
HG1 3DN - 521,000
- Freehold Detached house
HG1 3DN - 626,000
- Freehold Detached house
HG1 3DN - 670,000
- Freehold Detached house
HG1 3DN - 597,000
- Freehold Detached house
HG1 3DN - 567,000
- Freehold Detached property
HG1 3DN - 531,000
- Freehold Detached house
HG1 3DN - 629,000
- Freehold Detached house
HG1 3DN - 749,000
- Freehold Detached house
HG1 3DN - 770,000
- Freehold Detached house
HG1 3DN - 655,000
- Freehold Detached house
HG1 3DN - 596,000
- Freehold Detached house
HG1 3DN - 563,000
- Freehold Detached house
HG1 3DN - 662,000
- Freehold Detached house
HG1 3DN - 524,000
- Freehold Detached house
HG1 3DN - 588,000
- Freehold Detached house
HG1 3DN - 747,000
- Freehold Detached house
HG1 3DN - 518,000
- Freehold Detached house
HG1 3DN - 494,000
- Freehold Detached house
HG1 3DN - 646,000
- Freehold Detached house
HG1 3DN - 705,000
- Freehold Detached house
HG1 3DN - 697,000
- Freehold Detached property
HG1 3DN - 606,000
- Freehold Detached house
HG1 3DN - 600,000
- Freehold Detached house
HG1 3DN - 630,000
- Freehold Detached house
HG1 3DN - 719,000
- Freehold Detached property
HG1 3DN - 567,000
- Freehold Detached property
HG1 3DN - 685,000
- Freehold Detached property
HG1 3DN - 634,000
- Freehold Detached house
HG1 3DN - 662,000
- Freehold Detached property
HG1 3DN - 517,000
- Freehold Detached house
HG1 3DN - 582,000
- Freehold Detached house