BGB Painting, LLC Gilbert,AZ Exterior Painting Interior Painting HOA Painting Stucco Repair

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314087,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://bgbpainting.com",
      "title": "BGB Painting, LLC Gilbert,AZ Exterior Painting Interior Painting HOA Painting Stucco Repair ",
      "description": "Need a paint contractor? Contact us for a free estimate on your residential or commercial painting project. No job is finished until you''re satisfied. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65314,
      "approve_dt": "2020-08-28T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-12-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 459,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 921,
      "ltop": "",
      "facebook": "https://www.facebook.com/pages/BGB-Painting/1511882295778300",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "https://plus.google.com/102057473948723676203?hl=en",
      "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": 5875,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "955e4959-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 26, 2017",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 615
   },
   "visits": {
      "storefront": 615,
      "articles": 0,
      "videos": 0,
      "reviews": 23,
      "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": "At BGB Painting, our team of professional painters bring incredible value and experienced services to homeowners and business owners throughout the East Valley, to include Gilbert, Chandler, Mesa, Queen Creek, Gold Canyon, and of course, Phoenix.\n\nWe are your one stop shop for making the most impressive upgrades to your property.",
      "service1": "Residential painters",
      "service2": " Commercial Painters",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2017-12-26 05:54:21"
   },
   "location": {
      "uuid": "955e4959-56da-11ed-b77c-b66e99367f32",
      "link_id": 314087,
      "account_id": 65314,
      "company": "BGB Painting, LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "921",
      "zip": "85296",
      "address": "67 S. Higley Ave., Suite 103-308",
      "phone": "(480) 570-7592",
      "fax": null,
      "email": "bgbpaintingllc@emailsu.com",
      "name": "BGB Painting, LLC",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.3485491",
      "lon": "-111.7196221",
      "cityname": "Gilbert",
      "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": ""
}