United Hydro

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315396,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://unitedhydro.us/hydroponics-store-north-hollywood/",
      "title": "United Hydro",
      "description": "United Hydro is a local hydro store in North Hollywood CA. We offer a wide range of gardening supplies. You will never be disappointed for the lack of any product in our store. Our warehouses always have any kind of equipment and hydroponic systems. Qualified consultants will competently recommend and select hydroponic solutions, as well as the corresponding feeding charts. Individual approach to each buyer allows taking into consideration the peculiarities of a particular plant and creating optimal conditions for it. Find all kinds of hydro products near you. And most importantly: by contacting us, you will save time. You do not have to spend it on looking for goods in other stores. We will provide all your plants!''",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66614,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-06-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 114,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2172,
      "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": 5862,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "94b49561-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 30, 2018",
      "subcategory": "Gardeners",
      "request_types": "",
      "visitcount": 148
   },
   "visits": {
      "storefront": 148,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": " United Hydro is a local hydro store in North Hollywood CA. We offer a wide range of gardening supplies. You will never be disappointed for the lack of any product in our store. Our warehouses always have any kind of equipment and hydroponic systems. Qualified consultants will competently recommend and select hydroponic solutions, as well as the corresponding feeding charts. Individual approach to each buyer allows taking into consideration the peculiarities of a particular plant and creating optimal conditions for it. Find all kinds of hydro products near you. And most importantly: by contacting us, you will save time. You do not have to spend it on looking for goods in other stores. We will provide all your plants!'",
      "service1": "Hydroponics equipment supplier",
      "service2": "Gardening Supply",
      "service3": "Hydroponics Store",
      "service4": "Hydro Store",
      "service5": "",
      "service6": "Hydroponics",
      "service7": "",
      "submit_dt": "2018-06-30 08:08:12"
   },
   "location": {
      "uuid": "94b49561-56da-11ed-b77c-b66e99367f32",
      "link_id": 315396,
      "account_id": 66614,
      "company": "United Hydro",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2172",
      "zip": "91606",
      "address": "6771 Morella Ave",
      "phone": "",
      "fax": null,
      "email": "unitedhydronh@gmail.com",
      "name": "United Hydro",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "34.1936711",
      "lon": "-118.3900315",
      "cityname": "Los Angeles",
      "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": ""
}