SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='MK19 6FH' order by fulladdress
MK19 6FH - 752,000
- Leasehold Detached house
MK19 6FH - 424,000
- Leasehold Semi-detached house
MK19 6FH - 446,000
- Freehold Detached house
MK19 6FH - 772,000
- Freehold Detached house
MK19 6FH - 392,000
- Leasehold Semi-detached house
MK19 6FH - 389,000
- Leasehold Semi-detached house
MK19 6FH - 593,000
- Freehold Detached house
MK19 6FH - 180,000
- Leasehold End terrace house
MK19 6FH - 269,000
- Leasehold Semi-detached house
MK19 6FH - 264,000
- Leasehold Semi-detached house
MK19 6FH - 461,000
- Leasehold Detached house
MK19 6FH - 704,000
- Leasehold Detached house
MK19 6FH - 720,000
- Leasehold Detached house
MK19 6FH - 795,000
- Freehold Detached house
MK19 6FH - 778,000
- Freehold Detached house
MK19 6FH - 680,000
- Freehold Detached house
MK19 6FH - 661,000
- Freehold Detached house
MK19 6FH - 604,000
- Freehold Detached house
MK19 6FH - 385,000
- Freehold Semi-detached house
MK19 6FH - 394,000
- Freehold Semi-detached house
MK19 6FH - 615,000
- Freehold Detached house
MK19 6FH - 569,000
- Freehold Detached house
MK19 6FH - 801,000
- Freehold Detached house
MK19 6FH - 735,000
- Freehold Detached house
MK19 6FH - 727,000
- Freehold Detached property
