SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SG3 6DE' order by fulladdress
SG3 6DE - 495,000
- Freehold Semi-detached house
SG3 6DE - 493,000
- Freehold Semi-detached house
SG3 6DE - 864,000
- Freehold Detached house
SG3 6DE - 886,000
- Freehold Detached property
SG3 6DE - 576,000
- Freehold Semi-detached house
SG3 6DE - 637,000
- Freehold Semi-detached house
SG3 6DE - 881,000
- Freehold Detached house
SG3 6DE - 708,000
- Freehold Semi-detached house
SG3 6DE - 492,000
- Freehold Semi-detached house
SG3 6DE - 564,000
- Freehold Semi-detached house
SG3 6DE - 581,000
- Freehold Semi-detached house
SG3 6DE - 766,000
- Freehold Semi-detached house
SG3 6DE - 631,000
- Freehold Detached bungalow
SG3 6DE - 731,000
- Freehold Detached house
SG3 6DE - 561,000
- Freehold Semi-detached house
SG3 6DE - 607,000
- Freehold Semi-detached house
SG3 6DE - 632,000
- Freehold Detached bungalow
SG3 6DE - 782,000
- Freehold Detached house
SG3 6DE - 522,000
- Freehold Semi-detached house
SG3 6DE - 499,000
- Freehold Semi-detached house
SG3 6DE - 538,000
- Freehold Semi-detached bungalow
SG3 6DE - 444,000
- Freehold Semi-detached bungalow
SG3 6DE - 725,000
- Freehold Detached house
SG3 6DE - 772,000
- Freehold Terrace property
SG3 6DE - 694,000
- Freehold Detached house
SG3 6DE - 522,000
- Freehold Semi-detached house
SG3 6DE - 544,000
- Freehold Semi-detached house
SG3 6DE - 527,000
- Freehold Semi-detached house
SG3 6DE - 592,000
- Freehold Semi-detached house
SG3 6DE - 787,000
- Freehold Detached house
SG3 6DE - 506,000
- Freehold Semi-detached house
SG3 6DE - 619,000
- Freehold Semi-detached house
SG3 6DE - 597,000
- Freehold Semi-detached house
SG3 6DE - 777,000
- Freehold Detached house
SG3 6DE - 563,000
- Freehold Semi-detached house
SG3 6DE - 797,000
- Freehold Detached house
SG3 6DE - 564,000
- Freehold Semi-detached house
SG3 6DE - 551,000
- Freehold Semi-detached property
SG3 6DE - 750,000
- Freehold Semi-detached house
SG3 6DE - 588,000
- Freehold Semi-detached property
SG3 6DE - 732,000
- Freehold Semi-detached house
SG3 6DE - 580,000
- Freehold Semi-detached house
SG3 6DE - 578,000
- Freehold Semi-detached house
SG3 6DE - 614,000
- Freehold Semi-detached house
SG3 6DE - 561,000
- Freehold Semi-detached house
SG3 6DE - 584,000
- Freehold Semi-detached house
SG3 6DE - 772,000
- Freehold Detached house
SG3 6DE - 571,000
- Freehold Semi-detached house
SG3 6DE - 721,000
- Freehold Detached house
SG3 6DE - 515,000
- Freehold Semi-detached house
SG3 6DE - 1,070,000
- Freehold Detached house
SG3 6DE - 580,000
- Freehold Semi-detached house
SG3 6DE - 696,000
- Freehold Detached house
SG3 6DE - 511,000
- Freehold Semi-detached house
SG3 6DE - 700,000
- Leasehold Detached house
SG3 6DE - 768,000
- Freehold Semi-detached house
SG3 6DE - 780,000
- Freehold Semi-detached house
