SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SG13 7WN' order by fulladdress
SG13 7WN - 327,000
- Leasehold Flat/Maisonette
SG13 7WN - 323,000
- Leasehold Purpose built flat
SG13 7WN - 343,000
- Leasehold Converted flat
SG13 7WN - 678,000
- Freehold End terrace house
SG13 7WN - 529,000
- Leasehold Mid terrace house
SG13 7WN - 498,000
- Leasehold Mid terrace house
SG13 7WN - 489,000
- Leasehold Mid terrace house
SG13 7WN - 562,000
- Leasehold End terrace house
SG13 7WN - 334,000
- Leasehold Purpose built flat
SG13 7WN - 340,000
- Leasehold Flat/Maisonette
SG13 7WN - 319,000
- Leasehold Purpose built flat
SG13 7WN - 334,000
- Leasehold Purpose built flat
SG13 7WN - 334,000
- Leasehold Flat/Maisonette
SG13 7WN - 336,000
- Leasehold Flat/Maisonette
SG13 7WN - 512,000
- Leasehold Flat/Maisonette
SG13 7WN - 343,000
- Leasehold Purpose built flat
SG13 7WN - 339,000
- Leasehold Purpose built flat
SG13 7WN - 326,000
- Leasehold Flat/Maisonette
SG13 7WN - 335,000
- Leasehold Flat/Maisonette
SG13 7WN - 330,000
- Leasehold Purpose built flat
SG13 7WN - 328,000
- Leasehold Flat/Maisonette
SG13 7WN - 660,000
- Freehold End terrace house
SG13 7WN - 658,000
- Freehold Terrace property
SG13 7WN - 692,000
- Freehold Mid terrace house
SG13 7WN - 692,000
- Freehold Mid terrace house
SG13 7WN - 656,000
- Freehold Mid terrace house
SG13 7WN - 696,000
- Freehold Terrace property
SG13 7WN - 688,000
- Freehold End terrace house
SG13 7WN - 662,000
- Freehold End terrace house
SG13 7WN - 673,000
- Freehold Mid terrace house
SG13 7WN - 334,000
- Leasehold Flat/Maisonette
SG13 7WN - 634,000
- Freehold Terrace property
SG13 7WN - 656,000
- Freehold Mid terrace house
SG13 7WN - 639,000
- Freehold Mid terrace house
SG13 7WN - 642,000
- Freehold Terrace property
SG13 7WN - 706,000
- Freehold Mid terrace house
SG13 7WN - 663,000
- Freehold Terrace property
SG13 7WN - 600,000
- Freehold Mid terrace house
SG13 7WN - 578,000
- Freehold Mid terrace house
SG13 7WN - 609,000
- Freehold Mid terrace house
SG13 7WN - 319,000
- Leasehold Purpose built flat
SG13 7WN - 606,000
- Freehold Terrace property
SG13 7WN - 699,000
- Freehold Semi-detached house
SG13 7WN - 684,000
- Freehold End terrace house
SG13 7WN - 713,000
- Freehold Mid terrace house
SG13 7WN - 653,000
- Freehold End terrace house
SG13 7WN - 353,000
- Leasehold Purpose built flat
SG13 7WN - 316,000
- Leasehold Converted flat
SG13 7WN - 324,000
- Leasehold Flat/Maisonette
SG13 7WN - 396,000
- Leasehold Converted flat