J&S Construction

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338598,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://remodelspokane.com/",
      "title": "J&S Construction",
      "description": "Transform your home with J&S Construction your trusted partner for quality home renovations and remodeling services. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 89311,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-02T00: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": 46,
      "city_id": 23946,
      "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": 5844,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f5270627-b098-11ef-a909-b66e99367f32",
      "subdate": "Dec 02, 2024",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 42
   },
   "visits": {
      "storefront": 42,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Transform your home with J&S Construction your trusted partner for quality home renovations and remodeling services. Serving Spokane, WA, and the surrounding areas, we specialize in kitchen and bathroom remodels, custom cabinetry, flooring, and complete home makeovers. Our skilled team combines craftsmanship with attention to detail to bring your vision to life, whether you're upgrading for comfort, style, or functionality. At J&S Construction, we prioritize customer satisfaction, offering personalized solutions tailored to your needs. Ready to turn your dream home into reality? Contact us today to schedule your consultation and discover how we can elevate your living spaces!",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-02 10:34:06"
   },
   "location": {
      "uuid": "f5270627-b098-11ef-a909-b66e99367f32",
      "link_id": 338598,
      "account_id": 89311,
      "company": "J&S Construction",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23946",
      "zip": "99223",
      "address": "N/A",
      "phone": "509-351-0400",
      "fax": null,
      "email": "remodelspokanewa@gmail.com",
      "name": "J&S Construction",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "47.6795206",
      "lon": "-117.3857847",
      "cityname": "Spokane",
      "statename": "Washington"
   },
   "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": ""
}