Pearl Painters

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329679,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://pearlpainters.com/",
      "title": "Pearl Painters",
      "description": "Pearl Painters is a residential painting contractor in the Portland metro area. Services include interior, exterior, and cabinet painting. We are residential repainting specialists, meaning that we fully protect every surface in your home, including brand new flooring of any kind. Expect nothing but the best in our work, from the very first consultation to when we wrap up your project. Hundreds of 5-star reviews from customers in Tigard, Lake Oswego, Beaverton, and all surrounding areas.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80494,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 14,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18715,
      "ltop": "",
      "facebook": "https://www.facebook.com/pearlpainters/",
      "tiktok": null,
      "linkedin": "https://www.instagram.com/pearl.painters/",
      "twitter": "https://twitter.com/pearlpainters",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/pearlpainters/",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/pearl.painters/",
      "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": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d2c7c9af-f312-11ee-8344-b66e99367f32",
      "subdate": "Apr 05, 2024",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 98
   },
   "visits": {
      "storefront": 98,
      "articles": 0,
      "videos": 0,
      "reviews": 15,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-05 06:07:46"
   },
   "location": {
      "uuid": "d2c7c9af-f312-11ee-8344-b66e99367f32",
      "link_id": 329679,
      "account_id": 80494,
      "company": "Pearl Painters",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18715",
      "zip": "97223",
      "address": "13458 SW Hillshire Dr",
      "phone": "(503) 579-3765",
      "fax": null,
      "email": "pearlpainters@brite-mail.com",
      "name": "Pearl Painters",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.422354",
      "lon": "-122.8162165",
      "cityname": "Tigard",
      "statename": "Oregon"
   },
   "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": ""
}