SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SS6 9PP' order by fulladdress
SS6 9PP - 567,000
- Freehold Detached house
SS6 9PP - 623,000
- Freehold Detached house
SS6 9PP - 454,000
- Freehold Semi-detached house
SS6 9PP - 470,000
- Freehold Semi-detached house
SS6 9PP - 499,000
- Freehold Detached house
SS6 9PP - 487,000
- Freehold Detached house
SS6 9PP - 650,000
- Freehold Detached property
SS6 9PP - 592,000
- Freehold Detached house
SS6 9PP - 592,000
- Freehold Detached house
SS6 9PP - 305,000
- Leasehold Terrace property
SS6 9PP - 446,000
- Freehold Semi-detached house
SS6 9PP - 460,000
- Freehold Semi-detached house
SS6 9PP - 636,000
- Freehold Detached property
SS6 9PP - 493,000
- Freehold Detached house
SS6 9PP - 436,000
- Freehold Semi-detached property
SS6 9PP - 496,000
- Freehold Semi-detached house
SS6 9PP - 517,000
- Freehold Semi-detached house
SS6 9PP - 512,000
- Freehold Detached house
SS6 9PP - 502,000
- Freehold Detached house
SS6 9PP - 653,000
- Freehold Detached property
SS6 9PP - 352,000
- Freehold Mid terrace house
SS6 9PP - 517,000
- Freehold Detached house
SS6 9PP - 694,000
- Freehold Detached house
SS6 9PP - 616,000
- Freehold Detached house
SS6 9PP - 654,000
- Freehold Detached house
SS6 9PP - 674,000
- Freehold Detached house
SS6 9PP - 547,000
- Freehold Detached house
SS6 9PP - 256,000
- Leasehold Purpose built flat
SS6 9PP - 439,000
- Leasehold Semi-detached house
SS6 9PP - 360,000
- Freehold Mid terrace house
SS6 9PP - 356,000
- Freehold Mid terrace house
SS6 9PP - 348,000
- Freehold Mid terrace house
SS6 9PP - 360,000
- Freehold End terrace house
SS6 9PP - 671,000
- Freehold Detached house
SS6 9PP - 667,000
- Freehold Detached house
SS6 9PP - 428,000
- Freehold Semi-detached house
SS6 9PP - 393,000
- Freehold Semi-detached house
SS6 9PP - 507,000
- Freehold Semi-detached house
SS6 9PP - 492,000
- Freehold Semi-detached house
SS6 9PP - 683,000
- Freehold Detached house
SS6 9PP - 607,000
- Freehold Detached house
SS6 9PP - 460,000
- Freehold Semi-detached house
SS6 9PP - 416,000
- Freehold Terrace property
SS6 9PP - 475,000
- Freehold Semi-detached house
SS6 9PP - 657,000
- Freehold Detached house
SS6 9PP - 461,000
- Freehold Semi-detached house
SS6 9PP - 458,000
- Freehold Detached property
SS6 9PP - 613,000
- Freehold Detached house
SS6 9PP - 646,000
- Freehold Detached house
SS6 9PP - 663,000
- Freehold Detached property
SS6 9PP - 215,000
- Leasehold Purpose built flat
SS6 9PP - 212,000
- Leasehold Purpose built flat
SS6 9PP - 191,000
- Leasehold Purpose built flat
SS6 9PP - 447,000
- Freehold End terrace house
SS6 9PP - 214,000
- Freehold Purpose built flat
SS6 9PP - 216,000
- Leasehold Purpose built flat
SS6 9PP - 221,000
- Leasehold Purpose built flat
SS6 9PP - 219,000
- Leasehold Purpose built flat
SS6 9PP - 188,000
- Leasehold Flat/Maisonette
SS6 9PP - 193,000
- Leasehold Purpose built flat
SS6 9PP - 591,000
- Freehold Detached house
SS6 9PP - 579,000
- Freehold Detached house
SS6 9PP - 501,000
- Freehold Detached house
SS6 9PP - 514,000
- Freehold Semi-detached house
SS6 9PP - 677,000
- Freehold Detached house
SS6 9PP - 586,000
- Freehold Detached house
SS6 9PP - 622,000
- Freehold Detached property
SS6 9PP - 354,000
- Freehold Semi-detached house
SS6 9PP - 521,000
- Freehold Detached house
SS6 9PP - 641,000
- Freehold Detached property
SS6 9PP - 425,000
- Freehold Semi-detached house
SS6 9PP - 478,000
- Freehold Detached house
SS6 9PP - 605,000
- Freehold Detached house
SS6 9PP - 507,000
- Freehold Detached house
SS6 9PP - 502,000
- Freehold Detached house
SS6 9PP - 656,000
- Freehold Detached house
SS6 9PP - 630,000
- Freehold Detached house
SS6 9PP - 600,000
- Freehold Detached house
SS6 9PP - 619,000
- Freehold Detached house