MCS Power Wash and Junk Removal

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 323088,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://mcscontractingservices.com",
      "title": "MCS Power Wash and Junk Removal",
      "description": "MCS Power Wash & Junk Removal is your friendly, family-owned company. We are one of the leading power wash companies in Peoria, Arizona. We provide pressure washing services for residential & commercial customers with top-quality service and equipment. Junk Removal, who has junk? Let our top professional services help you remove your unwanted junk or debris! We can cut overhead costs and provide our customers with competitive pricing. Our quality and principles are committed to continual improvement and ensure that we can deliver the best results for our customers.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 74186,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2022-09-27T00: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": 3,
      "city_id": 988,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "958e75b5-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 27, 2022",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 5
   },
   "visits": {
      "storefront": 5,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "MCS Power Wash&Junk Removal is your friendly, family-owned company. We are one of the leading power wash companies in Peoria, Arizona. We provide pressure washing services for residential&commercial customers with top-quality service and equipment. Junk Removal, who has junk? Let our top professional services help you remove your unwanted junk or debris! We can cut overhead costs and provide our customers with competitive pricing. Our quality and principles are committed to continual improvement and ensure that we can deliver the best results for our customers.\r
\r
Address - 8609 W Columbine Dr, Peoria, Arizona, 85381",
      "service1": "Power-Washing",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2022-09-27 11:54:04"
   },
   "location": {
      "uuid": "958e75b5-56da-11ed-b77c-b66e99367f32",
      "link_id": 323088,
      "account_id": 74186,
      "company": "MCS Power Wash and Junk Removal",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "988",
      "zip": "85381",
      "address": "8609 W Columbine Dr",
      "phone": "(623) 986-5321",
      "fax": null,
      "email": "mcscontracting.listings@gmail.com",
      "name": "MCS Power Wash and Junk Removal",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Peoria",
      "statename": "Arizona"
   },
   "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": ""
}