Imperial Contracting, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350192,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://imperialconstructionservices.com/",
      "title": "Imperial Contracting, LLC",
      "description": "Imperial Contracting is a privately owned general contracting company headquartered in Scottsdale, Arizona, and specializing since 1999 in the painting and renovation of multi-family residences throughout the western United States.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100887,
      "approve_dt": "2025-09-29T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 990,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "344a3538-9d0f-11f0-bb42-b66e99367f32",
      "subdate": "Sep 29, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 26
   },
   "visits": {
      "storefront": 26,
      "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": "Imperial Contracting is a privately owned general contracting company headquartered in Scottsdale, Arizona, and specializing since 1999 in the painting and renovation of multi-family residences throughout the western United States. We have completed projects – at a rate of well over 200 per year and with contract values in excess of $25 million — for over 100 real estate investment trusts, property management companies, and home owner associations. This customer base has been built on our commitment to quality on every project and on our customers’ understanding that Imperial Contracting can be trusted to provide prompt and personal attention to their needs.",
      "service1": "Affordable Housing",
      "service2": "Renovation",
      "service3": "Multi-family Housing Rehabilitation",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-09-29 08:35:07"
   },
   "location": {
      "uuid": "344a3538-9d0f-11f0-bb42-b66e99367f32",
      "link_id": 350192,
      "account_id": 100887,
      "company": "Kyle  Anderson",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85027",
      "address": "2020 West Lone Cactus Drive",
      "phone": "480-892-9157",
      "fax": null,
      "email": "imperialcontractingaz@gmail.com",
      "name": "Imperial Contracting, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Phoenix",
      "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": ""
}