Appleton Campbell

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 339304,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://appletoncampbell.com/",
      "title": "Appleton Campbell",
      "description": "Appleton Campbell is proud to be Northern Virginia's leading Plumbing, Heating, Cooling and Electrical service providers since 1976. Based in Warrenton, VA, our locally owned and operated company strives to deliver the best home services to our customers throughout the region. Whether you need routine service on your Northern Virginia HVAC, plumbing, or electrical system; or you need emergency assistance, our team is here and ready for your call.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90013,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23495,
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "de00d230-bba5-11ef-a909-b66e99367f32",
      "subdate": "Dec 16, 2024",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 31
   },
   "visits": {
      "storefront": 31,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Furnaces, boilers, heat pumps, repair, installs",
      "service2": "Ductless AC, repair, maintenance, installation",
      "service3": "Generators, lighting, rewiring, electric panels",
      "service4": "Heating, cooling, indoor air quality",
      "service5": "Drain cleaning, sewer repair, sewer replacement",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-16 12:04:14"
   },
   "location": {
      "uuid": "de00d230-bba5-11ef-a909-b66e99367f32",
      "link_id": 339304,
      "account_id": 90013,
      "company": "Appleton Campbell",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23495",
      "zip": "20186",
      "address": "285 Alwington Blvd",
      "phone": "(540) 347-0765",
      "fax": null,
      "email": "appletoncampbell@brite-mail.com",
      "name": "Appleton Campbell",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.6982862",
      "lon": "-77.7926777",
      "cityname": "Warrenton",
      "statename": "Virginia"
   },
   "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": ""
}