https://clearchoiceconstruction.com/

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344403,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://clearchoiceconstruction.com/",
      "title": "https://clearchoiceconstruction.com/",
      "description": "Clear Choice Windows & Doors stands as a beacon of quality and reliability in Tigard, Oregon, serving the community as a sterling roofing company. Our team specializes in providing top-notch roofing solutions designed to withstand the ever-changing Oregon weather. We are dedicated to ensuring your home is protected with the best materials and craftsmanship available. From minor repairs to complete roof replacements, our experts handle every project with precision and care. We understand that a sturdy roof is critical to the safety and comfort of your home, which is why we go above and beyond to deliver results that exceed expectations. Each roof we craft or repair reflects our commitment to excellence and attention to detail. When it comes to finding a roofing company in Tigard, homeowners know they can trust Clear Choice Windows & Doors for unparalleled service and lasting results.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95098,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-03-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 6285,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "669db3b3-0aea-11f0-a909-b66e99367f32",
      "subdate": "Mar 27, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 15
   },
   "visits": {
      "storefront": 15,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "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": "2025-03-27 09:03:51"
   },
   "location": {
      "uuid": "669db3b3-0aea-11f0-a909-b66e99367f32",
      "link_id": 344403,
      "account_id": 95098,
      "company": "Clear Choice Windows & Doors",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "97224",
      "address": "7244 SW Durham Rd Suite 900",
      "phone": "9712246797",
      "fax": null,
      "email": "clearchoiceconstructionOR@outlook.com",
      "name": "Clear Choice Windows & Doors",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.399269",
      "lon": "-122.7521511"
   },
   "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": ""
}