SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='PE19 6AD' order by fulladdress
PE19 6AD - 491,000
- Freehold Detached house
PE19 6AD - 333,000
- Freehold Mid terrace house
PE19 6AD - 508,000
- Freehold End terrace house
PE19 6AD - 355,000
- Freehold End terrace house
PE19 6AD - 368,000
- Freehold Detached house
PE19 6AD - 500,000
- Freehold Detached house
PE19 6AD - 504,000
- Freehold Detached house
PE19 6AD - 490,000
- Freehold Detached house
PE19 6AD - 339,000
- Freehold End terrace house
PE19 6AD - 569,000
- Freehold Detached house
PE19 6AD - 245,000
- Leasehold Mid terrace house
PE19 6AD - 443,000
- Freehold Detached house
PE19 6AD - 546,000
- Freehold Detached house
PE19 6AD - 329,000
- Freehold End terrace house
PE19 6AD - 502,000
- Freehold Detached house
PE19 6AD - 270,000
- Freehold Mid terrace house
PE19 6AD - 420,000
- Freehold Detached house
PE19 6AD - 374,000
- Freehold Terrace property
PE19 6AD - 549,000
- Freehold Detached house
PE19 6AD - 468,000
- Freehold Detached house
PE19 6AD - 556,000
- Freehold Detached house
PE19 6AD - 363,000
- Freehold Semi-detached house
PE19 6AD - 484,000
- Freehold Semi-detached house
PE19 6AD - 362,000
- Freehold Semi-detached house
PE19 6AD - 447,000
- Freehold Mid terrace house
PE19 6AD - 451,000
- Freehold Detached house
PE19 6AD - 409,000
- Freehold Detached house
PE19 6AD - 454,000
- Freehold Detached house
PE19 6AD - 335,000
- Freehold Mid terrace house
PE19 6AD - 590,000
- Freehold Detached house
PE19 6AD - 493,000
- Freehold Detached house
PE19 6AD - 288,000
- Freehold Terrace property
PE19 6AD - 367,000
- Freehold Semi-detached house
PE19 6AD - 523,000
- Freehold Detached house
PE19 6AD - 493,000
- Freehold Detached house
PE19 6AD - 325,000
- Leasehold Semi-detached house
PE19 6AD - 426,000
- Freehold Semi-detached house
PE19 6AD - 462,000
- Freehold Detached property
PE19 6AD - 274,000
- Freehold End terrace house
PE19 6AD - 458,000
- Freehold Detached house
PE19 6AD - 271,000
- Leasehold Mid terrace house
PE19 6AD - 373,000
- Freehold Semi-detached house
PE19 6AD - 271,000
- Leasehold Mid terrace house
PE19 6AD - 283,000
- Leasehold Semi-detached house
PE19 6AD - 380,000
- Freehold Semi-detached house
PE19 6AD - 508,000
- Freehold Detached house
PE19 6AD - 332,000
- Freehold Terrace property
PE19 6AD - 373,000
- Freehold Semi-detached house
PE19 6AD - 405,000
- Freehold Detached house
PE19 6AD - 474,000
- Freehold Detached house
PE19 6AD - 496,000
- Freehold Detached house
PE19 6AD - 468,000
- Freehold Detached house
PE19 6AD - 468,000
- Freehold Detached house
PE19 6AD - 429,000
- Freehold Semi-detached house
PE19 6AD - 477,000
- Freehold Detached house
PE19 6AD - 488,000
- Freehold Semi-detached house
PE19 6AD - 549,000
- Freehold Detached house
PE19 6AD - 378,000
- Freehold Detached house
PE19 6AD - 357,000
- Freehold Terrace property
PE19 6AD - 478,000
- Freehold Detached house
