SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SM1 4QT' order by fulladdress
SM1 4QT - 532,000
- Freehold Detached house
SM1 4QT - 516,000
- Freehold Mid terrace house
SM1 4QT - 484,000
- Freehold Semi-detached house
SM1 4QT - 476,000
- Freehold Semi-detached house
SM1 4QT - 566,000
- Freehold End terrace house
SM1 4QT - 534,000
- Freehold Terrace property
SM1 4QT - 524,000
- Freehold Mid terrace house
SM1 4QT - 517,000
- Freehold Mid terrace house
SM1 4QT - 484,000
- Freehold Mid terrace house
SM1 4QT - 527,000
- Freehold Terrace property
SM1 4QT - 537,000
- Freehold Terrace property
SM1 4QT - 558,000
- Freehold End terrace house
SM1 4QT - 555,000
- Freehold Mid terrace house
SM1 4QT - 499,000
- Freehold Terrace property
SM1 4QT - 504,000
- Freehold Mid terrace house
SM1 4QT - 556,000
- Freehold Mid terrace house
SM1 4QT - 560,000
- Freehold Mid terrace house
SM1 4QT - 521,000
- Freehold Terrace property
SM1 4QT - 564,000
- Freehold Mid terrace house
SM1 4QT - 487,000
- Freehold Mid terrace house
SM1 4QT - 482,000
- Freehold Mid terrace house
SM1 4QT - 555,000
- Freehold End terrace house
SM1 4QT - 354,000
- Freehold Flat/Maisonette
SM1 4QT - 262,000
- Leasehold Converted flat
SM1 4QT - 592,000
- Freehold Mid terrace house
SM1 4QT - 313,000
- Leasehold Converted flat
SM1 4QT - 316,000
- Leasehold Converted flat
SM1 4QT - 585,000
- Freehold End terrace house
SM1 4QT - 562,000
- Freehold Mid terrace house
SM1 4QT - 562,000
- Freehold Mid terrace house
SM1 4QT - 566,000
- Freehold Mid terrace house
SM1 4QT - 487,000
- Freehold Terrace property
SM1 4QT - 315,000
- Share of freehold Converted flat
SM1 4QT - 280,000
- Leasehold Converted flat
SM1 4QT - 478,000
- Freehold End terrace house
SM1 4QT - 571,000
- Freehold Mid terrace house
SM1 4QT - 0
- Freehold Mid terrace house
SM1 4QT - 468,000
- Freehold Mid terrace house
SM1 4QT - 440,000
- Freehold End terrace house
SM1 4QT - 441,000
- Freehold Terrace property
SM1 4QT - 512,000
- Freehold End terrace house
SM1 4QT - 398,000
- Freehold Semi-detached house
SM1 4QT - 410,000
- Freehold End terrace house
SM1 4QT - 375,000
- Freehold Mid terrace house
SM1 4QT - 393,000
- Freehold Mid terrace house
SM1 4QT - 428,000
- Freehold End terrace house
SM1 4QT - 483,000
- Freehold Terrace property
SM1 4QT - 532,000
- Freehold Terrace property
SM1 4QT - 256,000
- Leasehold Purpose built flat
SM1 4QT - 230,000
- Leasehold Purpose built flat
SM1 4QT - 248,000
- Leasehold Purpose built flat
