Holt Plumbing Company LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317403,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.holtplumbing.com/",
      "title": "Holt Plumbing Company LLC",
      "description": "Holt Plumbing has been providing top-quality plumbing services in Middle Tennessee since 1988. We strive to ensure each customer''s satisfaction. Call us today to request a quote.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68601,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-07-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 182,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 41,
      "city_id": 21145,
      "ltop": "",
      "facebook": "https://www.facebook.com/HoltPlumbingCo/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/in/gina-holt-b7bba744",
      "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": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956f9416-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 17, 2019",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 275
   },
   "visits": {
      "storefront": 275,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "If you are planning to remodel your home or business, you have come to the right place. Holt Plumbing can handle all your plumbing remodeling and repair needs. Our experienced plumbers will ensure that your job is done just the way you want. We offer 5% senior citizen and military discounts. Call our licensed, bonded, and insured company to schedule an appointment!\r\n",
      "service1": "Plumps and Pipe Thawing",
      "service2": "Electronic Leak Detection",
      "service3": "Remodeling and Repair",
      "service4": "Backflow Preventers",
      "service5": "Water and Sewer Lines",
      "service6": "Drain Cleaning",
      "service7": "Water Heater",
      "submit_dt": "2019-07-17 06:23:14"
   },
   "location": {
      "uuid": "956f9416-56da-11ed-b77c-b66e99367f32",
      "link_id": 317403,
      "account_id": 68601,
      "company": "Holt Plumbing Company LLC",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 41,
      "city": "21145",
      "zip": "37217",
      "address": "2608 Murfreesboro Rd, Suite 100",
      "phone": "615-361-6001",
      "fax": null,
      "email": "holtplumbing01@gmail.com",
      "name": "Holt Plumbing Company LLC",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "36.0740364",
      "lon": "-86.637487",
      "cityname": "Nashville-Davidson",
      "statename": "Tennessee"
   },
   "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": ""
}