Seattle Custom Remodels

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308493,
      "site_id": 58,
      "cat_id": 53,
      "priority": 0,
      "url": "http://www.seattlecustomremodels.com",
      "title": "Seattle Custom Remodels",
      "description": "At Seattle Custom Remodels we enjoy the fact that we get to improve our customers homes in both aesthetics and structure. Since 1995 we have layed our fingertips over dozens of projects in the Greater Seattle Area.\r\nKitchens - This part of the home is generally the most popular, and their is always potential to improve it, which makes it our favorite room! We can add new granite countertops, cabin",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59718,
      "approve_dt": "2015-01-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-01-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1089,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23922,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 4186,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "9542c3a9-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 07, 2015",
      "subcategory": "Bathroom Remodeling",
      "request_types": "",
      "visitcount": 1367
   },
   "visits": {
      "storefront": 1367,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Seattle Custom Remodels we enjoy the fact that we get to improve our customers homes in both aesthetics and structure. Since 1995 we have layed our fingertips over dozens of projects in the Greater Seattle Area.\r
Kitchens - This part of the home is generally the most popular, and their is always potential to improve it, which makes it our favorite room! We can add new granite countertops, cabinets and backsplashes to bring the kitchen area together.\r
Bathrooms - We can get in there and take out your old bath/shower and get something a little cleaner and more visually pleasing. A full demo can be done and new tile can be layed as well as new toilet and sink\r
We have many ideas for your home, feel free to reach out so that we can come together and figure out a gameplan for your new home remodeling project!",
      "service1": "Kitchen Remodeling",
      "service2": "Bathroom Remodeling",
      "service3": "Home Additions",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2015-01-08 04:57:54"
   },
   "location": {
      "uuid": "9542c3a9-56da-11ed-b77c-b66e99367f32",
      "link_id": 308493,
      "account_id": 59718,
      "company": "Seattle Custom Remodels",
      "sid": 0,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23922",
      "zip": "98104",
      "address": "815 1st Ave #61",
      "phone": "",
      "fax": "",
      "email": "seattlecustomremodels@gmail.com",
      "name": "http://www.seattlecustomremodels.com",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "41.559675",
      "lon": "-90.412682",
      "cityname": "Seattle",
      "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": ""
}