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 6LX' order by fulladdress
SG3 6LX - 536,000
- Freehold Semi-detached house
SG3 6LX - 385,000
- Freehold Mid terrace house
SG3 6LX - 491,000
- Freehold End terrace house
SG3 6LX - 282,000
- Freehold End terrace house
SG3 6LX - 361,000
- Freehold Mid terrace house
SG3 6LX - 386,000
- Freehold Mid terrace house
SG3 6LX - 388,000
- Freehold Terrace property
SG3 6LX - 496,000
- Freehold Mid terrace house
SG3 6LX - 543,000
- Freehold Mid terrace house
SG3 6LX - 483,000
- Freehold Mid terrace house
SG3 6LX - 341,000
- Freehold Mid terrace house
SG3 6LX - 466,000
- Freehold End terrace house
SG3 6LX - 386,000
- Freehold Mid terrace house
SG3 6LX - 220,000
- Leasehold Purpose built flat
SG3 6LX - 220,000
- Leasehold Purpose built flat
SG3 6LX - 222,000
- Leasehold Purpose built flat
SG3 6LX - 220,000
- Leasehold Purpose built flat
SG3 6LX - 222,000
- Feudal Purpose built flat
SG3 6LX - 266,000
- Leasehold Purpose built flat
SG3 6LX - 557,000
- Freehold Semi-detached house
SG3 6LX - 223,000
- Leasehold Flat/Maisonette
SG3 6LX - 227,000
- Leasehold Purpose built flat
SG3 6LX - 320,000
- Freehold Semi-detached house
SG3 6LX - 293,000
- Freehold Terrace property
SG3 6LX - 376,000
- Freehold Mid terrace house
SG3 6LX - 388,000
- Freehold Terrace property
SG3 6LX - 383,000
- Freehold Mid terrace house
SG3 6LX - 381,000
- Freehold Mid terrace house
SG3 6LX - 439,000
- Freehold Mid terrace house
SG3 6LX - 433,000
- Freehold Mid terrace house
SG3 6LX - 412,000
- Freehold Terrace property
SG3 6LX - 401,000
- Freehold Mid terrace house
SG3 6LX - 385,000
- Freehold Mid terrace house
SG3 6LX - 305,000
- Freehold Mid terrace house
SG3 6LX - 375,000
- Freehold End terrace house
SG3 6LX - 662,000
- Freehold Detached property
SG3 6LX - 643,000
- Freehold Detached house
SG3 6LX - 700,000
- Freehold Detached property
SG3 6LX - 717,000
- Freehold Detached house
SG3 6LX - 476,000
- Freehold Mid terrace house
SG3 6LX - 705,000
- Freehold Detached house
SG3 6LX - 669,000
- Freehold Detached property
SG3 6LX - 749,000
- Freehold Detached house
SG3 6LX - 627,000
- Freehold Detached house
SG3 6LX - 616,000
- Freehold Detached house
SG3 6LX - 394,000
- Freehold Mid terrace house
SG3 6LX - 390,000
- Freehold Mid terrace house
SG3 6LX - 427,000
- Freehold Mid terrace house
SG3 6LX - 398,000
- Freehold Mid terrace house
SG3 6LX - 376,000
- Freehold Mid terrace house
SG3 6LX - 380,000
- Freehold Mid terrace house
SG3 6LX - 398,000
- Freehold End terrace house
SG3 6LX - 435,000
- Freehold Mid terrace house
SG3 6LX - 384,000
- Freehold Mid terrace house
SG3 6LX - 380,000
- Freehold Mid terrace house
SG3 6LX - 399,000
- Freehold Mid terrace house
SG3 6LX - 287,000
- Freehold End terrace house
SG3 6LX - 401,000
- Freehold Mid terrace house
SG3 6LX - 381,000
- Freehold Mid terrace house
SG3 6LX - 245,000
- Freehold Purpose built flat
SG3 6LX - 469,000
- Freehold Mid terrace house
SG3 6LX - 487,000
- Freehold End terrace house
SG3 6LX - 365,000
- Freehold Terrace property
SG3 6LX - 382,000
- Freehold Terrace property
SG3 6LX - 714,000
- Freehold Detached house
SG3 6LX - 335,000
- Freehold Mid terrace house
SG3 6LX - 697,000
- Freehold Detached house
SG3 6LX - 634,000
- Freehold Detached house
SG3 6LX - 719,000
- Freehold Detached house
SG3 6LX - 642,000
- Freehold Detached house
SG3 6LX - 766,000
- Freehold Detached house
SG3 6LX - 677,000
- Freehold Semi-detached property
SG3 6LX - 671,000
- Freehold Detached property
SG3 6LX - 638,000
- Freehold Detached house
SG3 6LX - 800,000
- Freehold Detached house
SG3 6LX - 727,000
- Freehold Detached house
SG3 6LX - 296,000
- Freehold End terrace house
SG3 6LX - 341,000
- Leasehold Mid terrace house
SG3 6LX - 503,000
- Freehold Mid terrace house
SG3 6LX - 463,000
- Freehold End terrace house
SG3 6LX - 505,000
- Freehold End terrace house
SG3 6LX - 483,000
- Freehold Mid terrace house
SG3 6LX - 558,000
- Freehold End terrace house
SG3 6LX - 398,000
- Freehold Semi-detached house