SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='FY8 3FP' order by fulladdress
FY8 3FP - 267,000
- Freehold Semi-detached house
FY8 3FP - 327,000
- Leasehold Detached house
FY8 3FP - 337,000
- Leasehold Detached property
FY8 3FP - 398,000
- Leasehold Detached house
FY8 3FP - 411,000
- Leasehold Detached house
FY8 3FP - 157,000
- Leasehold End terrace house
FY8 3FP - 445,000
- Leasehold Detached house
FY8 3FP - 158,000
- Leasehold Mid terrace house
FY8 3FP - 318,000
- Freehold Detached house
FY8 3FP - 419,000
- Leasehold Detached house
FY8 3FP - 155,000
- Leasehold Mid terrace house
FY8 3FP - 412,000
- Leasehold Detached house
FY8 3FP - 168,000
- Leasehold End terrace house
FY8 3FP - 335,000
- Leasehold Detached property
FY8 3FP - 214,000
- Leasehold End terrace property
FY8 3FP - 396,000
- Leasehold Detached house
FY8 3FP - 204,000
- Leasehold Terrace property
FY8 3FP - 245,000
- Leasehold End terrace house
FY8 3FP - 192,000
- Leasehold End terrace house
FY8 3FP - 245,000
- Leasehold Mid terrace house
FY8 3FP - 431,000
- Leasehold Detached property
FY8 3FP - 240,000
- Leasehold Mid terrace house
FY8 3FP - 333,000
- Leasehold Detached house
FY8 3FP - 245,000
- Leasehold End terrace house
FY8 3FP - 389,000
- Leasehold Detached house
FY8 3FP - 428,000
- Freehold Detached house
FY8 3FP - 428,000
- Leasehold Detached house
FY8 3FP - 350,000
- Leasehold Detached property
FY8 3FP - 378,000
- Leasehold Detached property
FY8 3FP - 334,000
- Leasehold Detached property
FY8 3FP - 359,000
- Leasehold Detached house
FY8 3FP - 268,000
- Leasehold Semi-detached house
FY8 3FP - 243,000
- Leasehold Mid terrace house
FY8 3FP - 256,000
- Freehold End terrace house
FY8 3FP - 261,000
- Leasehold Semi-detached house
FY8 3FP - 250,000
- Leasehold End terrace house
FY8 3FP - 280,000
- Leasehold Semi-detached house
FY8 3FP - 282,000
- Leasehold Semi-detached house
