Russell's American Mechanical

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335681,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://americanmechanicalva.com/",
      "title": "Russell's American Mechanical",
      "description": "Welcome to Russell's and American Mechanical where WE CAN FIX THAT! We offer residential plumbing, HVAC, electrical, generator, and gas line service throughout Virginia Beach, Norfolk, Chesapeake and the surrounding cities in Hampton Roads. Same day emergency services, priority membership service and the best customer service! Our mission is to provide the highest quality workmanship from professionals you can trust, and our motto is if you have a problem: \"We can fix that for you!\"\r\n \r\n Popular Services:\r\n\r\n - Heating Repair/Installs\r\n - A/C Repair/Installs\r\n - Drain Unclogging (Clearing)\r\n - Water Heater Repairs/Installation\r\n - Electrician Repair/Install\r\n - Generator Installs",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86424,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 10,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 45,
      "city_id": 23209,
      "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": 6601,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c39c20f2-78f7-11ef-ab46-b66e99367f32",
      "subdate": "Sep 22, 2024",
      "subcategory": "HVAC",
      "request_types": "",
      "visitcount": 48
   },
   "visits": {
      "storefront": 48,
      "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": "Welcome to Russell's and American Mechanical where WE CAN FIX THAT! We offer residential plumbing, HVAC, electrical, generator, and gas line service throughout Virginia Beach, Norfolk, Chesapeake and the surrounding cities in Hampton Roads. Same day emergency services, priority membership service and the best customer service! Our mission is to provide the highest quality workmanship from professionals you can trust, and our motto is if you have a problem: \"We can fix that for you!\"\r
 \r
 Popular Services:\r
\r
 - Heating Repair/Installs\r
 - A/C Repair/Installs\r
 - Drain Unclogging (Clearing)\r
 - Water Heater Repairs/Installation\r
 - Electrician Repair/Install\r
 - Generator Installs",
      "service1": "HVAC",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-22 15:31:40"
   },
   "location": {
      "uuid": "c39c20f2-78f7-11ef-ab46-b66e99367f32",
      "link_id": 335681,
      "account_id": 86424,
      "company": "Russell's American Mechanical",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 45,
      "city": "23209",
      "zip": "23320",
      "address": "1100 Executive Blvd",
      "phone": "(757) 571-9386",
      "fax": null,
      "email": "russellsamrcnmchncl@brite-post.com",
      "name": "Russell''s American Mechanical",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "36.7587616",
      "lon": "-76.2319744",
      "cityname": "Chesapeake",
      "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": ""
}