Lighthouse® Outdoor Lighting of Columbus

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318743,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://lighthouse-lights.com/location/columbus",
      "title": "Lighthouse® Outdoor Lighting of Columbus",
      "description": "Monday - Friday 8:00 am to 8:00 pm",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69937,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-03-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 138,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 16903,
      "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": 288,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9576f9bf-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 18, 2020",
      "subcategory": "Home And Garden",
      "request_types": "",
      "visitcount": 200
   },
   "visits": {
      "storefront": 200,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Our mission is to reveal the natural beauty, elegance and texture typically concealed in darkness through designing optimal landscape lighting solutions that will perpetually transform the way our clients perceive their Lighthouse Outdoor Living space.\r
Lighthouse Outdoor Lighting of Columbus is the premiere landscape and architectural lighting design and installation company in the Columbus area. We specialize in high-end residential and commercial lighting design, installation, troubleshooting/repair and routine service of outdoor lighting systems.",
      "service1": "Outdoor lights",
      "service2": "Lighting",
      "service3": "Electricals",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-03-18 04:25:12"
   },
   "location": {
      "uuid": "9576f9bf-56da-11ed-b77c-b66e99367f32",
      "link_id": 318743,
      "account_id": 69937,
      "company": "Lighthouse® Outdoor Lighting of Columbus",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16903",
      "zip": "43035",
      "address": "8595 Columbus Pike ",
      "phone": "(614) 300-2943 ",
      "fax": null,
      "email": "joelighthouse72@gmail.com",
      "name": "Lighthouse® Outdoor Lighting of Columbus",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.1380814",
      "lon": "-83.0177518",
      "cityname": "Columbus",
      "statename": "Ohio"
   },
   "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": ""
}