Century Renovation LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336297,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.century-renovation.com",
      "title": "Century Renovation LLC",
      "description": "Century Renovation LLC provides a comprehensive range of home improvement services designed to increase home value and enhance functionality. We specialize in partial and full home remodels, including kitchen renovations, bathroom remodels, and home additions. Our expertise also extends to custom homes, tiny homes on wheels, and ADUs, providing unique, efficient living spaces. We handle flooring, roofing, and heating systems installations, ensuring every project is built to last. As a licensed general contractor, we coordinate every detail from start to finish, making the process smooth and stress-free. Our services cater to homeowners looking for high-quality home facelifts, fixer-upper transformations, and energy-efficient upgrades, even amidst rising inflation rates. Whether its a plumbing upgrade, painting, or HVAC installation, Century Renovation is your trusted partner for bringing your vision to life.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87032,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18499,
      "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": 5851,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d2092ad6-81d7-11ef-ab46-b66e99367f32",
      "subdate": "Oct 03, 2024",
      "subcategory": "Concrete Contractors",
      "request_types": "",
      "visitcount": 41
   },
   "visits": {
      "storefront": 41,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "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-10-03 22:35:41"
   },
   "location": {
      "uuid": "d2092ad6-81d7-11ef-ab46-b66e99367f32",
      "link_id": 336297,
      "account_id": 87032,
      "company": "Century Renovation LLC",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18499",
      "zip": "97124",
      "address": "4200 NW Leisy Rd, Hillsboro, OR 97124",
      "phone": "",
      "fax": null,
      "email": "sKPTg5Rm.directory@usestyle.ai",
      "name": "Century Renovation LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.551474",
      "lon": "-123.011407",
      "cityname": "Coos Bay",
      "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": ""
}