Sunbridge Solar

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317641,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://sunbridgesolar.com/",
      "title": "Sunbridge Solar",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68839,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-08-22T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 215,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 24007,
      "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": "gif",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9570d4d9-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 22, 2019",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 282
   },
   "visits": {
      "storefront": 282,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Sunbridge Solar provides high-quality residential and commercial solar energy installations. We specialize in both the Portland-Vancouver urban areas and rural farmlands. Along with providing you the right information needed to make an informed buying decision, we provide comfort and security by helping our customers save time, money, and our environment at their own pace. Request your free, no-obligation, solar consultation today.",
      "service1": "washington solar",
      "service2": "portland solar",
      "service3": "washington solar company",
      "service4": "oregon solar company",
      "service5": "portland solar company",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-08-22 09:08:57"
   },
   "location": {
      "uuid": "9570d4d9-56da-11ed-b77c-b66e99367f32",
      "link_id": 317641,
      "account_id": 68839,
      "company": "Sunbridge Solar",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "24007",
      "zip": "98671",
      "address": "421 C Street, Unit 5A",
      "phone": "(360) 313-7190",
      "fax": null,
      "email": "sunbridgesolarwa@gmail.com",
      "name": "Sunbridge Solar",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.5810209",
      "lon": "-122.3734944",
      "cityname": "Washougal",
      "statename": "Washington"
   },
   "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": ""
}