SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='MK7 6DU' order by fulladdress
MK7 6DU - 404,000
- Freehold Detached house
MK7 6DU - 66,000
- Leasehold Purpose built flat
MK7 6DU - 107,000
- Leasehold End terrace house
MK7 6DU - 133,000
- Leasehold End terrace house
MK7 6DU - 112,000
- Leasehold Mid terrace house
MK7 6DU - 113,000
- Leasehold Mid terrace house
MK7 6DU - 118,000
- Leasehold Mid terrace house
MK7 6DU - 111,000
- Leasehold Mid terrace house
MK7 6DU - 401,000
- Freehold Detached house
MK7 6DU - 99,000
- Leasehold Mid terrace house
MK7 6DU - 119,000
- Leasehold Mid terrace house
MK7 6DU - 123,000
- Leasehold End terrace house
MK7 6DU - 255,000
- Freehold Semi-detached house
MK7 6DU - 282,000
- Freehold Semi-detached house
MK7 6DU - 274,000
- Freehold Semi-detached house
MK7 6DU - 136,000
- Leasehold End terrace house
MK7 6DU - 287,000
- Freehold End terrace house
MK7 6DU - 247,000
- Freehold Terrace property
MK7 6DU - 256,000
- Freehold Mid terrace house
MK7 6DU - 221,000
- Freehold Mid terrace house
MK7 6DU - 211,000
- Freehold Mid terrace house
MK7 6DU - 266,000
- Freehold Semi-detached house
MK7 6DU - 344,000
- Freehold Semi-detached house
MK7 6DU - 361,000
- Freehold Semi-detached house
MK7 6DU - 294,000
- Freehold Semi-detached house
MK7 6DU - 296,000
- Freehold Semi-detached house
MK7 6DU - 121,000
- Leasehold Semi-detached house
MK7 6DU - 293,000
- Freehold Semi-detached house
MK7 6DU - 394,000
- Freehold Detached house
MK7 6DU - 411,000
- Freehold Semi-detached house
MK7 6DU - 350,000
- Freehold Semi-detached house
MK7 6DU - 438,000
- Freehold Detached house
MK7 6DU - 472,000
- Freehold Detached house
MK7 6DU - 405,000
- Freehold Detached house
MK7 6DU - 90,000
- Leasehold Mid terrace house
MK7 6DU - 90,000
- Leasehold Mid terrace house
MK7 6DU - 104,000
- Leasehold Mid terrace house
MK7 6DU - 133,000
- Leasehold Mid terrace house
MK7 6DU - 68,000
- Leasehold Purpose built flat