General Contractor

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350385,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://www.frametofinishllc.net",
      "title": "General Contractor",
      "description": "Frame to Finish, LLC. is a trusted general contractor serving Bend, Tetherow, Powell Butte, and nearby areas. We specialize in residential and commercial construction, offering expert craftsmanship in carpentry, remodeling, flooring, countertops, siding, and timber framing. Committed to quality, integrity, and precision, we ensure every project runs smoothly, stays on budget, and exceeds expectations while building lasting value and trust.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 101079,
      "approve_dt": "2025-10-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-10-17T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18467,
      "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": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "6f1bd697-ab73-11f0-bb42-b66e99367f32",
      "subdate": "Oct 17, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 2
   },
   "visits": {
      "storefront": 2,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Frame to Finish, LLC. is a trusted general contractor serving Bend, Tetherow, Powell Butte, and nearby areas. We specialize in residential and commercial construction, offering expert craftsmanship in carpentry, remodeling, flooring, countertops, siding, and timber framing. Committed to quality, integrity, and precision, we ensure every project runs smoothly, stays on budget, and exceeds expectations while building lasting value and trust.",
      "service1": "Timber Framing",
      "service2": "Countertop Installation",
      "service3": "Remodeling",
      "service4": "Carpentry",
      "service5": "General Contracting",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-10-17 16:07:52"
   },
   "location": {
      "uuid": "6f1bd697-ab73-11f0-bb42-b66e99367f32",
      "link_id": 350385,
      "account_id": 101079,
      "company": "Frame to Finish, LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18467",
      "zip": "97701",
      "address": "Service Area",
      "phone": "541-280-0973",
      "fax": null,
      "email": "frametofinishllcor@outlook.com",
      "name": "Frame to Finish, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Bend",
      "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": ""
}