Republic West Remodeling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309119,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://www.republicwestremodeling.com/",
      "title": "Republic West Remodeling",
      "description": "Republic West Remodeling offers the highest quality home remodeling services in Phoenix and the metro area. Kitchens, bathrooms, room additions, whole house remodels, and outdoor living spaces – all projects that add value and function to our clients’ everyday living spaces.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60355,
      "approve_dt": "2015-04-01T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-03-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1759,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1026,
      "ltop": "",
      "facebook": "https://www.facebook.com/RepublicWestRemodeling",
      "tiktok": "",
      "linkedin": "",
      "twitter": "https://twitter.com/rwremodeling",
      "googleplus": "https://plus.google.com/u/0/+Republicwestremodeling/posts",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "https://www.pinterest.com/rwremodeling/",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://instagram.com/republicwestremodeling/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 1737,
      "subcat_id": 5868,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954516f2-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 31, 2015",
      "subcategory": "Kitchen Remodeling",
      "request_types": "",
      "visitcount": 2150
   },
   "visits": {
      "storefront": 2150,
      "articles": 0,
      "videos": 0,
      "reviews": 26,
      "coupons": 0,
      "products": 0,
      "social": 36,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Republic West Remodeling, were proud of the more than 15,000 home remodeling projects weve completed since 1995 \" kitchen and bath remodels, whole house remodels, home additions and outdoor living spaces \" all projects that add value and function to our clients everyday living spaces.\n\nAt Republic West Remodeling, we’re proud of the more than 16,000 Phoenix home remodeling projects we’ve completed since 1995 – kitchen and bath remodels, whole house remodels, room additions, and outdoor living spaces – all projects that added sophistication, style, value and function to our clients’ homes.\n\nAbove all, we’re proud of our loyal customer base. More than half of our projects each year are performed for past clients or for people who have been referred by them – a remarkable achievement in an industry notorious for referral rates in the single digits.\nWelcome to the Home of the Dream Assurance Plan™.\n\nThe Dream Assurance Plan is built on a vision - an idea. The team of professionals at Republic West Remodeling has developed, through their years of experience and a passion for excellence, an exclusive home remodeling process that strives to deliver a pleasant experience and a successful outcome for their customers. Many homeowners have come to expect the nightmare remodeling project that is so prevalent in today's market place. We would like to change that.\n\nWith Republic West Remodeling, you can be assured that your Phoenix home remodeling project will be a dream come true throughout the entire process - from creative design to detailed planning to execution and construction.",
      "service1": "Home Remodeling",
      "service2": " Kitchen Remodeling",
      "service3": " Bathroom Remodeling",
      "service4": " Outdoor Living Spaces",
      "service5": " Phoenix Home Remodeling",
      "service6": " Renovation & Improvement",
      "service7": "",
      "submit_dt": "2015-03-31 19:14:48"
   },
   "location": {
      "uuid": "954516f2-56da-11ed-b77c-b66e99367f32",
      "link_id": 309119,
      "account_id": 60355,
      "company": "Republic West Remodeling",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1026",
      "zip": "85257 ",
      "address": "8101 E. McDowell Rd., Suite 205",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.4653022",
      "lon": "-111.9067761",
      "cityname": "Scottsdale",
      "statename": "Arizona"
   },
   "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": ""
}