SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='GU33 7BW' order by fulladdress
GU33 7BW - 237,000
- Freehold Mid terrace house
GU33 7BW - 238,000
- Freehold End terrace house
GU33 7BW - 265,000
- Freehold End terrace house
GU33 7BW - 186,000
- Leasehold Purpose built flat
GU33 7BW - 253,000
- Leasehold Purpose built flat
GU33 7BW - 237,000
- Freehold Mid terrace house
GU33 7BW - 632,000
- Freehold Detached house
GU33 7BW - 261,000
- Freehold Mid terrace house
GU33 7BW - 461,000
- Freehold End terrace house
GU33 7BW - 348,000
- Freehold Mid terrace house
GU33 7BW - 392,000
- Freehold Mid terrace house
GU33 7BW - 248,000
- Freehold Purpose built flat
GU33 7BW - 404,000
- Freehold End terrace house
GU33 7BW - 333,000
- Freehold Mid terrace house
GU33 7BW - 250,000
- Freehold End terrace house
GU33 7BW - 399,000
- Freehold End terrace house
GU33 7BW - 336,000
- Freehold Mid terrace house
GU33 7BW - 399,000
- Freehold Mid terrace house
GU33 7BW - 451,000
- Freehold Semi-detached house
GU33 7BW - 462,000
- Freehold Semi-detached house
GU33 7BW - 547,000
- Freehold Semi-detached house
GU33 7BW - 389,000
- Freehold Mid terrace house
GU33 7BW - 405,000
- Freehold Terrace property
GU33 7BW - 404,000
- Freehold Mid terrace house
GU33 7BW - 785,000
- Freehold Detached bungalow
GU33 7BW - 398,000
- Freehold Terrace property
GU33 7BW - 767,000
- Freehold Detached house
GU33 7BW - 541,000
- Freehold Semi-detached house
GU33 7BW - 545,000
- Freehold Semi-detached house
GU33 7BW - 446,000
- Freehold End terrace house
GU33 7BW - 492,000
- Freehold Semi-detached house
GU33 7BW - 241,000
- Freehold Terrace property
GU33 7BW - 383,000
- Freehold End terrace house
GU33 7BW - 408,000
- Freehold Semi-detached house
GU33 7BW - 657,000
- Freehold Detached bungalow
GU33 7BW - 522,000
- Freehold Detached house
GU33 7BW - 737,000
- Freehold Detached house
GU33 7BW - 657,000
- Freehold Detached bungalow
GU33 7BW - 201,000
- Freehold Mid terrace house
GU33 7BW - 395,000
- Freehold Mid terrace house
GU33 7BW - 615,000
- Freehold Detached bungalow
GU33 7BW - 685,000
- Freehold Detached house
GU33 7BW - 264,000
- Freehold Terrace property
GU33 7BW - 813,000
- Freehold Detached house
GU33 7BW - 628,000
- Freehold Detached house
GU33 7BW - 241,000
- Freehold Mid terrace house
GU33 7BW - 563,000
- Freehold Detached bungalow
GU33 7BW - 754,000
- Freehold Detached bungalow
GU33 7BW - 866,000
- Freehold Detached house
GU33 7BW - 273,000
- Freehold End terrace house
GU33 7BW - 416,000
- Freehold End terrace house