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 4ET' order by fulladdress
SG5 4ET - 589,000
- Freehold End terrace house
SG5 4ET - 463,000
- Freehold Mid terrace house
SG5 4ET - 470,000
- Freehold End terrace house
SG5 4ET - 742,000
- Freehold Detached house
SG5 4ET - 595,000
- Freehold Detached house
SG5 4ET - 545,000
- Freehold Semi-detached house
SG5 4ET - 326,000
- Leasehold Mid terrace house
SG5 4ET - 125,000
- Leasehold Purpose built flat
SG5 4ET - 152,000
- Leasehold Purpose built flat
SG5 4ET - 165,000
- Leasehold Purpose built flat
SG5 4ET - 120,000
- Leasehold Purpose built flat
SG5 4ET - 147,000
- Leasehold Purpose built flat
SG5 4ET - 510,000
- Freehold Semi-detached house
SG5 4ET - 394,000
- Freehold Semi-detached house
SG5 4ET - 585,000
- Freehold Detached house
SG5 4ET - 383,000
- Freehold Semi-detached house
SG5 4ET - 164,000
- Freehold Purpose built flat
SG5 4ET - 473,000
- Freehold Detached house
SG5 4ET - 239,000
- Leasehold Purpose built flat
SG5 4ET - 219,000
- Leasehold Purpose built flat
SG5 4ET - 233,000
- Leasehold Purpose built flat
SG5 4ET - 234,000
- Leasehold Flat/Maisonette
SG5 4ET - 243,000
- Leasehold Purpose built flat
SG5 4ET - 530,000
- Freehold Semi-detached house
SG5 4ET - 407,000
- Freehold Semi-detached house
SG5 4ET - 518,000
- Freehold Mid terrace house
SG5 4ET - 474,000
- Freehold Mid terrace house
SG5 4ET - 195,000
- Leasehold Flat/Maisonette
SG5 4ET - 190,000
- Leasehold Purpose built flat
SG5 4ET - 187,000
- Leasehold Flat/Maisonette
SG5 4ET - 196,000
- Leasehold Flat/Maisonette
SG5 4ET - 207,000
- Leasehold Purpose built flat
SG5 4ET - 453,000
- Freehold Detached house
SG5 4ET - 439,000
- Freehold Mid terrace house
SG5 4ET - 454,000
- Freehold Semi-detached house
SG5 4ET - 429,000
- Freehold Terrace property
SG5 4ET - 451,000
- Freehold End terrace house
SG5 4ET - 0
- Freehold Semi-detached house
SG5 4ET - 436,000
- Freehold End terrace house
SG5 4ET - 269,000
- Freehold Purpose built flat
SG5 4ET - 586,000
- Freehold Detached house
SG5 4ET - 527,000
- Freehold Semi-detached house
SG5 4ET - 435,000
- Freehold Mid terrace house
SG5 4ET - 348,000
- Freehold Mid terrace house
SG5 4ET - 363,000
- Freehold Mid terrace house
SG5 4ET - 285,000
- Freehold Semi-detached house
SG5 4ET - 518,000
- Freehold Mid terrace house
SG5 4ET - 496,000
- Freehold Mid terrace house
SG5 4ET - 546,000
- Freehold Detached house
SG5 4ET - 487,000
- Freehold Terrace property
SG5 4ET - 310,000
- Freehold Purpose built flat
SG5 4ET - 452,000
- Freehold Terrace property
SG5 4ET - 468,000
- Freehold Semi-detached house
SG5 4ET - 500,000
- Freehold Mid terrace house
SG5 4ET - 495,000
- Freehold Mid terrace house
SG5 4ET - 496,000
- Freehold Semi-detached house
SG5 4ET - 393,000
- Freehold Terrace property
SG5 4ET - 393,000
- Freehold Mid terrace house
SG5 4ET - 471,000
- Freehold Mid terrace house