SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SG5 4FB' order by fulladdress
SG5 4FB - 913,000
- Freehold Detached house
SG5 4FB - 547,000
- Freehold Semi-detached house
SG5 4FB - 492,000
- Freehold Terrace property
SG5 4FB - 574,000
- Freehold End terrace house
SG5 4FB - 473,000
- Freehold Semi-detached house
SG5 4FB - 488,000
- Freehold Semi-detached house
SG5 4FB - 464,000
- Freehold Semi-detached house
SG5 4FB - 874,000
- Freehold Detached house
SG5 4FB - 477,000
- Freehold Semi-detached house
SG5 4FB - 984,000
- Freehold Detached house
SG5 4FB - 570,000
- Freehold Semi-detached property
SG5 4FB - 1,026,000
- Freehold Detached property
SG5 4FB - 453,000
- Freehold Mid terrace house
SG5 4FB - 849,000
- Freehold Detached house
SG5 4FB - 456,000
- Freehold Terrace property
SG5 4FB - 502,000
- Freehold Semi-detached house
SG5 4FB - 452,000
- Freehold End terrace house
SG5 4FB - 489,000
- Freehold Semi-detached house
SG5 4FB - 461,000
- Freehold Mid terrace house
SG5 4FB - 581,000
- Freehold Terrace property
SG5 4FB - 492,000
- Freehold Mid terrace house
SG5 4FB - 556,000
- Freehold End terrace property
SG5 4FB - 565,000
- Freehold End terrace house
SG5 4FB - 544,000
- Freehold End terrace house
SG5 4FB - 530,000
- Freehold Semi-detached property
SG5 4FB - 538,000
- Freehold Detached house
SG5 4FB - 529,000
- Freehold Terrace property
SG5 4FB - 523,000
- Freehold Mid terrace house
SG5 4FB - 575,000
- Freehold Terrace property
SG5 4FB - 418,000
- Freehold Mid terrace house
SG5 4FB - 531,000
- Freehold Mid terrace house
SG5 4FB - 440,000
- Freehold Terrace property
SG5 4FB - 537,000
- Freehold End terrace house
SG5 4FB - 542,000
- Freehold End terrace house
SG5 4FB - 779,000
- Freehold Detached house
SG5 4FB - 510,000
- Freehold Semi-detached house
SG5 4FB - 883,000
- Freehold Detached house
SG5 4FB - 495,000
- Freehold Terrace property
SG5 4FB - 828,000
- Freehold Detached house
SG5 4FB - 421,000
- Freehold Terrace property
SG5 4FB - 896,000
- Freehold Detached house
SG5 4FB - 532,000
- Freehold Mid terrace house
SG5 4FB - 537,000
- Freehold Semi-detached house
SG5 4FB - 519,000
- Freehold Semi-detached house
SG5 4FB - 587,000
- Freehold Semi-detached property
SG5 4FB - 533,000
- Freehold Semi-detached house
SG5 4FB - 525,000
- Freehold Semi-detached house
SG5 4FB - 520,000
- Freehold Mid terrace house
SG5 4FB - 536,000
- Freehold End terrace house
SG5 4FB - 852,000
- Freehold Detached house
SG5 4FB - 923,000
- Freehold Terrace property
SG5 4FB - 977,000
- Freehold Detached house
SG5 4FB - 802,000
- Freehold Detached house
SG5 4FB - 950,000
- Freehold Detached house
SG5 4FB - 803,000
- Freehold Detached house
SG5 4FB - 529,000
- Freehold Semi-detached house
SG5 4FB - 973,000
- Freehold Detached house
SG5 4FB - 1,116,000
- Freehold Detached house
SG5 4FB - 1,138,000
- Freehold Detached property
SG5 4FB - 536,000
- Freehold Semi-detached house
SG5 4FB - 546,000
- Freehold Semi-detached house
SG5 4FB - 573,000
- Freehold Semi-detached house
SG5 4FB - 1,005,000
- Freehold Detached house
SG5 4FB - 545,000
- Freehold Semi-detached house
SG5 4FB - 526,000
- Freehold Semi-detached house
SG5 4FB - 676,000
- Freehold Detached house
SG5 4FB - 1,053,000
- Freehold Detached house
SG5 4FB - 560,000
- Freehold Semi-detached property
SG5 4FB - 582,000
- Freehold Semi-detached house
SG5 4FB - 599,000
- Freehold Mid terrace house
SG5 4FB - 595,000
- Freehold Mid terrace house
SG5 4FB - 311,000
- Freehold Detached house
SG5 4FB - 482,000
- Freehold Terrace property
SG5 4FB - 491,000
- Semi-detached house