Rich''s Hauling & Yard Clean-Up

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 311739,
      "site_id": 6,
      "cat_id": 39,
      "priority": 0,
      "url": "http://www.richsjunkhauling.com",
      "title": "Rich''s Hauling & Yard Clean-Up",
      "description": "Got junk? Want space? Rich''s Hauling and Yard Clean-up are junk hauling and solid waste pick up specialists based in Citrus Heights serving Roseville, \nWe are dedicated to fitting in with your schedule as much as we can to provide you with the excellent service that you want and deserve, so we are proud to offer same day removal and hauling services.\nIf your home or garage is suffering from lack of space from too much junk and garbage, or your yard is threatening to overrun your house, call Rich''s Hauling for prompt and courteous attention to your dilemma. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 62974,
      "approve_dt": "2016-04-01T00:00:00.000Z",
      "source": null,
      "submit_dt": "2016-03-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1012,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1761,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/114305869947657598726/about",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5732,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95541327-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 16, 2016",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 1104
   },
   "visits": {
      "storefront": 1104,
      "articles": 0,
      "videos": 0,
      "reviews": 9,
      "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": "Rich’s Hauling and Yard Clean-up are junk hauling and solid waste pick up specialists based in Lincoln, Citrus Heights, Roseville, Fair Oaks, Sacramento Valley, Rocklin, and Natomas.\n\nOur company has many years of experience in cleaning up messy yards, picking up solid waste, and hauling away junk.\n\nIf your home, garage, or private property is suffering from lack of space from too much junk and garbage, or your yard is threatening to overrun your house with overgrown plants, call Rich’s Hauling for prompt and courteous attention to your dilemma.\n",
      "service1": "Junk hauling",
      "service2": " Shed tear-down",
      "service3": " Deck removal",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2016-03-16 04:53:30"
   },
   "location": {
      "uuid": "95541327-56da-11ed-b77c-b66e99367f32",
      "link_id": 311739,
      "account_id": 62974,
      "company": "Rich''s Hauling & Yard Clean-Up",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1761",
      "zip": "95608",
      "address": "",
      "phone": "916-519-0668",
      "fax": "",
      "email": "richhauling24@gmail.com",
      "name": "Rich''s Hauling & Yard Clean-Up",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "Carmichael",
      "statename": "California"
   },
   "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": ""
}