SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NW3 2NQ' order by fulladdress
NW3 2NQ - 1,683,000
- Freehold Mid terrace house
NW3 2NQ - 1,024,000
- Leasehold Flat/Maisonette
NW3 2NQ - 937,000
- Leasehold Flat/Maisonette
NW3 2NQ - 953,000
- Leasehold Converted flat
NW3 2NQ - 1,315,000
- Leasehold Terrace property
NW3 2NQ - 957,000
- Leasehold Purpose built flat
NW3 2NQ - 2,139,000
- Freehold Terraced
NW3 2NQ - 1,851,000
- Freehold Mid terrace house
NW3 2NQ - 1,826,000
- Freehold Mid terrace house
NW3 2NQ - 1,737,000
- Freehold Terrace property
NW3 2NQ - 1,779,000
- Freehold Mid terrace house
NW3 2NQ - 1,829,000
- Freehold Mid terrace house
NW3 2NQ - 1,719,000
- Freehold Terrace property
NW3 2NQ - 1,866,000
- Freehold Terraced
NW3 2NQ - 1,685,000
- Freehold Mid terrace house
NW3 2NQ - 2,042,000
- Freehold End terrace house
NW3 2NQ - 806,000
- Leasehold Converted flat
NW3 2NQ - 602,000
- Leasehold Purpose built flat
NW3 2NQ - 876,000
- Leasehold Flat/Maisonette
NW3 2NQ - 659,000
- Leasehold Purpose built flat
NW3 2NQ - 764,000
- Leasehold Flat/Maisonette
NW3 2NQ - 1,575,000
- Freehold Mid terrace house
NW3 2NQ - 1,787,000
- Freehold Mid terrace house
NW3 2NQ - 2,014,000
- Freehold Mid terrace house
NW3 2NQ - 796,000
- Leasehold Purpose built flat
NW3 2NQ - 816,000
- Leasehold Flat/Maisonette
NW3 2NQ - 684,000
- Leasehold Purpose built flat
NW3 2NQ - 661,000
- Leasehold Flat/Maisonette
NW3 2NQ - 549,000
- Leasehold Purpose built flat
NW3 2NQ - 2,149,000
- Freehold Terraced
NW3 2NQ - 2,065,000
- Freehold Mid terrace house
NW3 2NQ - 1,776,000
- Freehold Mid terrace house
NW3 2NQ - 1,973,000
- Freehold Mid terrace house
NW3 2NQ - 1,725,000
- Freehold Mid terrace house
NW3 2NQ - 873,000
- Leasehold Purpose built flat
NW3 2NQ - 862,000
- Leasehold Flat/Maisonette
NW3 2NQ - 857,000
- Leasehold Flat/Maisonette
NW3 2NQ - 950,000
- Leasehold Flat/Maisonette
NW3 2NQ - 762,000
- Leasehold Flat/Maisonette
NW3 2NQ - 533,000
- Leasehold Purpose built flat
NW3 2NQ - 523,000
- Leasehold Flat/Maisonette
NW3 2NQ - 569,000
- Leasehold Purpose built flat
NW3 2NQ - 516,000
- Leasehold Purpose built flat
NW3 2NQ - 1,825,000
- Freehold Terraced
NW3 2NQ - 521,000
- Leasehold Purpose built flat
NW3 2NQ - 570,000
- Leasehold Purpose built flat
NW3 2NQ - 544,000
- Leasehold Purpose built flat
NW3 2NQ - 533,000
- Leasehold End terrace house
NW3 2NQ - 520,000
- Leasehold Flat/Maisonette
NW3 2NQ - 552,000
- Freehold Purpose built flat
NW3 2NQ - 558,000
- Leasehold Purpose built flat
NW3 2NQ - 506,000
- Leasehold Flat/Maisonette
NW3 2NQ - 558,000
- Leasehold Purpose built flat
NW3 2NQ - 1,871,000
- Freehold Mid terrace house
NW3 2NQ - 581,000
- Leasehold Purpose built flat
NW3 2NQ - 2,069,000
- Freehold Mid terrace house
NW3 2NQ - 1,780,000
- Freehold End terrace house
NW3 2NQ - 902,000
- Leasehold Purpose built flat