American Construction & Remodeling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317258,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.americanconstructionremodeling.com",
      "title": "American Construction & Remodeling",
      "description": "We''re a locally owned and operated business that has 30 years of experience, providing variety of remodeling services for your home and office needs at affordable prices. Call us at 503-265-9793.\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68456,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 129,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 36,
      "city_id": 18555,
      "ltop": "",
      "facebook": "https://www.facebook.com/American-Construction-And-Remodeling-1452527631725788/",
      "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": 4186,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956eca45-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 14, 2019",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 193
   },
   "visits": {
      "storefront": 193,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We're a locally owned and operated business that has 30 years of experience, providing variety of remodeling services for the homeowners and business owner at affordable prices. We have a dedicated team that performs custom remodeling services in spaces of all sizes. Whether you're ready to remodel your kitchen, basement, or outdoor space, rely on us to meet and exceed your expectations. Contact us today to request FREE in-home consultation for your next remodeling project. Call us at 503-265-9793 today!\r\n",
      "service1": "exterior",
      "service2": "interior",
      "service3": "bathroom-remodeling",
      "service4": "kitchen-remodeling",
      "service5": "remodeling",
      "service6": "renovate",
      "service7": "renovation",
      "submit_dt": "2019-06-14 12:03:15"
   },
   "location": {
      "uuid": "956eca45-56da-11ed-b77c-b66e99367f32",
      "link_id": 317258,
      "account_id": 68456,
      "company": "American Construction & Remodeling",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 36,
      "city": "18555",
      "zip": "97086",
      "address": "13349 SE Tumbleweed Ct",
      "phone": "503-265-9793",
      "fax": null,
      "email": "constructionremodeling12@hotmail.com",
      "name": "American Construction & Remodeling",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.4288283",
      "lon": "-122.5262697",
      "cityname": "Happy Valley",
      "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": ""
}