Hartford Fence Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333298,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.hartfordfence.com/",
      "title": "Hartford Fence Company",
      "description": "Hartford Fence Co offers a complete range of residential and commercial fence construction services. From new fence installation to fence repair for both residential and commercial applications. Service is provided by multiple crews headed by experienced foreman with handpicked crews. Our office is professionally managed by an administrative professional and our estimating/ sales/ and consulting services are provided by an experienced project manager.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84075,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 26,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 7,
      "city_id": 3158,
      "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": 5855,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "13e9c9db-47f2-11ef-8344-b66e99367f32",
      "subdate": "Jul 22, 2024",
      "subcategory": "Fence Contractors",
      "request_types": "",
      "visitcount": 93
   },
   "visits": {
      "storefront": 93,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Hartford Fence Co offers a complete range of residential and commercial fence construction services. From new fence installation to fence repair for both residential and commercial applications. Service is provided by multiple crews headed by experienced foreman with handpicked crews. Our office is professionally managed by an administrative professional and our estimating/ sales/ and consulting services are provided by an experienced project manager.",
      "service1": "Vinyl Fence",
      "service2": "Wood Fence",
      "service3": "Chainlink Fence",
      "service4": "Metal Fence",
      "service5": "Residential/Commercial",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-22 06:17:31"
   },
   "location": {
      "uuid": "13e9c9db-47f2-11ef-8344-b66e99367f32",
      "link_id": 333298,
      "account_id": 84075,
      "company": "Hartford Fence Company",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 7,
      "city": "3158",
      "zip": "06110",
      "address": "559 New Park Avenue",
      "phone": "+1 860-952-9646",
      "fax": null,
      "email": "jordanconover87@brite-mail.com",
      "name": "Hartford Fence Company",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.7365203",
      "lon": "-72.7217504",
      "cityname": "West Hartford",
      "statename": "Connecticut"
   },
   "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": ""
}