SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='W12 8BG' order by fulladdress
W12 8BG - 2,082,000
- Freehold Semi-detached house
W12 8BG - 2,007,000
- Freehold End terrace house
W12 8BG - 2,096,000
- Freehold Mid terrace house
W12 8BG - 2,053,000
- Freehold End terrace house
W12 8BG - 2,134,000
- Freehold Mid terrace house
W12 8BG - 1,989,000
- Freehold Terrace property
W12 8BG - 2,104,000
- Freehold Mid terrace house
W12 8BG - 2,097,000
- Freehold Flat/Maisonette
W12 8BG - 2,099,000
- Freehold Terrace property
W12 8BG - 2,102,000
- Mid terrace house
W12 8BG - 798,000
- Freehold Terrace property
W12 8BG - 2,146,000
- Freehold End terrace house
W12 8BG - 609,000
- Leasehold Flat/Maisonette
W12 8BG - 374,000
- Leasehold Purpose built flat
W12 8BG - 444,000
- Leasehold Flat/Maisonette
W12 8BG - 580,000
- Leasehold Flat/Maisonette
W12 8BG - 562,000
- Leasehold Flat/Maisonette
W12 8BG - 544,000
- Leasehold Flat/Maisonette
W12 8BG - 583,000
- Leasehold Flat/Maisonette
W12 8BG - 383,000
- Leasehold Purpose built flat
W12 8BG - 2,120,000
- Freehold Mid terrace house
W12 8BG - 342,000
- Leasehold Flat/Maisonette
W12 8BG - 374,000
- Leasehold Purpose built flat
W12 8BG - 400,000
- Leasehold Purpose built flat
W12 8BG - 382,000
- Leasehold Flat/Maisonette
W12 8BG - 408,000
- Leasehold Purpose built flat
W12 8BG - 415,000
- Leasehold Purpose built flat
W12 8BG - 304,000
- Leasehold Converted flat
W12 8BG - 622,000
- Leasehold Flat/Maisonette
W12 8BG - 377,000
- Leasehold Purpose built flat
W12 8BG - 424,000
- Leasehold Purpose built flat
W12 8BG - 1,988,000
- Mid terrace house
W12 8BG - 608,000
- Leasehold Flat/Maisonette
W12 8BG - 558,000
- Leasehold Flat/Maisonette
W12 8BG - 470,000
- Leasehold Flat/Maisonette
W12 8BG - 344,000
- Leasehold Flat/Maisonette
W12 8BG - 371,000
- Leasehold Purpose built flat
W12 8BG - 518,000
- Leasehold Purpose built flat
W12 8BG - 411,000
- Leasehold Flat/Maisonette
W12 8BG - 436,000
- Leasehold Purpose built flat
W12 8BG - 347,000
- Leasehold Flat/Maisonette
W12 8BG - 2,078,000
- Freehold Mid terrace house
W12 8BG - 400,000
- Leasehold Flat/Maisonette
W12 8BG - 412,000
- Leasehold Purpose built flat
W12 8BG - 591,000
- Leasehold Purpose built flat
W12 8BG - 619,000
- Leasehold Flat/Maisonette
W12 8BG - 408,000
- Leasehold Purpose built flat
W12 8BG - 447,000
- Leasehold Flat/Maisonette
W12 8BG - 614,000
- Leasehold Flat/Maisonette
W12 8BG - 559,000
- Leasehold Flat/Maisonette
W12 8BG - 305,000
- Leasehold Purpose built flat
W12 8BG - 326,000
- Leasehold Purpose built flat
W12 8BG - 1,843,000
- Freehold Detached house
W12 8BG - 344,000
- Leasehold Purpose built flat
W12 8BG - 373,000
- Leasehold Purpose built flat
W12 8BG - 348,000
- Leasehold Purpose built flat
W12 8BG - 452,000
- Feudal Purpose built flat
W12 8BG - 433,000
- Leasehold Flat/Maisonette
W12 8BG - 446,000
- Leasehold Flat/Maisonette
W12 8BG - 310,000
- Leasehold Purpose built flat
W12 8BG - 451,000
- Leasehold Flat/Maisonette
W12 8BG - 434,000
- Leasehold Flat/Maisonette
W12 8BG - 612,000
- Leasehold Flat/Maisonette
W12 8BG - 1,995,000
- Freehold Terrace property
W12 8BG - 1,880,000
- Freehold Semi-detached property
