SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU51 1HL' order by fulladdress
GU51 1HL - 851,000
- Freehold Detached house
GU51 1HL - 476,000
- Freehold Mid terrace house
GU51 1HL - 432,000
- Freehold Terrace property
GU51 1HL - 531,000
- Freehold End terrace house
GU51 1HL - 834,000
- Freehold Detached house
GU51 1HL - 578,000
- Freehold Detached house
GU51 1HL - 475,000
- Freehold End terrace house
GU51 1HL - 520,000
- Freehold Semi-detached house
GU51 1HL - 428,000
- Freehold Terrace property
GU51 1HL - 572,000
- Freehold Mid terrace house
GU51 1HL - 490,000
- Freehold Semi-detached house
GU51 1HL - 465,000
- Freehold End terrace house
GU51 1HL - 507,000
- Freehold Semi-detached house
GU51 1HL - 375,000
- Freehold End terrace house
GU51 1HL - 487,000
- Freehold Detached house
GU51 1HL - 480,000
- Freehold Semi-detached house
GU51 1HL - 463,000
- Freehold Semi-detached house
GU51 1HL - 449,000
- Freehold Terrace property
GU51 1HL - 366,000
- Freehold Terrace property
GU51 1HL - 583,000
- Freehold Detached house
GU51 1HL - 374,000
- Freehold End terrace house
GU51 1HL - 475,000
- Freehold Semi-detached house
GU51 1HL - 463,000
- Freehold Semi-detached house
GU51 1HL - 782,000
- Freehold Detached house
GU51 1HL - 386,000
- Freehold End terrace house
GU51 1HL - 482,000
- Freehold Semi-detached house
GU51 1HL - 365,000
- Freehold Mid terrace house
GU51 1HL - 382,000
- Freehold Terrace property
GU51 1HL - 382,000
- Freehold Terrace property
GU51 1HL - 724,000
- Freehold Detached property
GU51 1HL - 510,000
- Freehold Semi-detached house
GU51 1HL - 559,000
- Freehold Terrace property
GU51 1HL - 464,000
- Freehold End terrace house
GU51 1HL - 530,000
- Freehold Mid terrace house
GU51 1HL - 540,000
- Freehold Terrace property
GU51 1HL - 542,000
- Freehold Semi-detached house
GU51 1HL - 481,000
- Freehold Semi-detached house
GU51 1HL - 449,000
- Freehold End terrace house
GU51 1HL - 466,000
- Freehold Semi-detached house
GU51 1HL - 478,000
- Freehold Mid terrace house
GU51 1HL - 483,000
- Freehold Terrace property
GU51 1HL - 580,000
- Freehold Terrace property
GU51 1HL - 480,000
- Freehold Semi-detached house
GU51 1HL - 522,000
- Freehold Semi-detached house
GU51 1HL - 436,000
- Freehold End terrace house
