{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 339633,
"site_id": 24,
"cat_id": 80,
"priority": 2,
"url": "https://www.haart.co.uk/branch-finder/colindale-estate-agents/",
"title": " ",
"description": " ",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 90340,
"approve_dt": null,
"source": null,
"submit_dt": "2024-12-23T00:00:00.000Z",
"filler": null,
"points": null,
"ppc_remain": null,
"ppc_points": null,
"link_points": null,
"clickcount": 2,
"referrals": null,
"country": 265,
"countrycode": "GB",
"loc_id": 265,
"state_id": 0,
"city_id": 476,
"ltop": "",
"facebook": "",
"tiktok": null,
"linkedin": "",
"twitter": "",
"googleplus": "",
"youtube_channel": null,
"youtube": "",
"youtube_title": null,
"pinterest": "",
"yelp": "",
"foursquare": "",
"instagram": "",
"tripadvisor": null,
"trustpilot": null,
"blog_link": null,
"ss_exchange": 0,
"googlebot": null,
"yahoobot": null,
"msnbot": null,
"author_id": null,
"subcat_id": 1435,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "6752f7b0-c11b-11ef-a909-b66e99367f32",
"subdate": "Dec 23, 2024",
"subcategory": "Real Estate Companies",
"request_types": "",
"visitcount": 34
},
"visits": {
"storefront": 34,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 18,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "At haart Estate Agents Colindale, as part of the UK's largest independent estate agents, we help thousands of people buy or sell their homes through our network of over 100 branches. We offer a range of services, including financial & legal support, valuations, and more. We're committed to providing top-quality customer service. haart is here to help meet all your property needs, whatever stage you are at in your journey. Contact us today - we're available for a call until 10pm.",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2024-12-23 10:48:11"
},
"location": {
"uuid": "6752f7b0-c11b-11ef-a909-b66e99367f32",
"link_id": 339633,
"account_id": 90340,
"company": "haart Estate Agents Colindale",
"sid": 24,
"country": 265,
"countrycode": "GB",
"state": 0,
"city": "476",
"zip": "NW9 6RR",
"address": "12 Varley Parade, Edgware Road, Colindale, Greater London",
"phone": "02082 059797",
"fax": null,
"email": "haarteacolindale@mail-burst.com",
"name": "haart Estate Agents Colindale",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "51.587353",
"lon": "-0.2508933",
"cityname": "London",
"statename": ""
},
"socialmedia": [
{
"title": "Facebook",
"ptype_id": 29,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Instagram",
"ptype_id": 30,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Youtube",
"ptype_id": 31,
"dbtable": "links_socialmedia",
"item": "Youtube Video",
"cnt": null
},
{
"title": "LinkedIn",
"ptype_id": 32,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "TikTok",
"ptype_id": 33,
"dbtable": "links_socialmedia",
"item": "Videos",
"cnt": null
},
{
"title": "Twitter",
"ptype_id": 34,
"dbtable": "links_socialmedia",
"item": "Page",
"cnt": null
},
{
"title": "Reddit",
"ptype_id": 37,
"dbtable": "links_socialmedia",
"item": "Reddit",
"cnt": null
},
{
"title": "SnapChat",
"ptype_id": 38,
"dbtable": "links_socialmedia",
"item": "SnapChat",
"cnt": null
}
],
"promos": [
{
"item": "article",
"cnt": 0
},
{
"item": "video",
"cnt": 0
},
{
"item": "product",
"cnt": 0
},
{
"item": "coupon",
"cnt": 0
},
{
"item": "service",
"cnt": 0
},
{
"item": "article_external",
"cnt": 0
},
{
"item": "video_external",
"cnt": 0
},
{
"item": "product_external",
"cnt": 0
},
{
"item": "coupon_external",
"cnt": 0
},
{
"item": "service_external",
"cnt": 0
}
],
"featuredproduct": ""
}
all our featured social media
