Urban Refurbishment, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338743,
      "site_id": 8,
      "cat_id": 67,
      "priority": 2,
      "url": "https://www.urbanrefurbishment.com/ ",
      "title": "Urban Refurbishment, LLC",
      "description": "Urban Refurbishment LLC is a residential remodeling contractor based in Minneapolis, Minnesota. The company specializes in high-quality, custom home renovations, focusing on transforming older homes while preserving their historical integrity. With over 12 years in business and a combined 40 years of experience among its team, Urban Refurbishment offers services ranging from structural modifications to intricate design solutions. The company emphasizes personalized service, exceptional craftsmanship, and transparent communication, utilizing BuilderTrend project management software for efficient project tracking. Urban Refurbishment is a member of the National Association of the Remodeling Industry (NARI) and is BBB-accredited with an A+ rating",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 89454,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11296,
      "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": 68,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "be0b6bce-b225-11ef-a909-b66e99367f32",
      "subdate": "Dec 04, 2024",
      "subcategory": "Kitchen Remodeling",
      "request_types": "",
      "visitcount": 39
   },
   "visits": {
      "storefront": 39,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-04 09:54:24"
   },
   "location": {
      "uuid": "be0b6bce-b225-11ef-a909-b66e99367f32",
      "link_id": 338743,
      "account_id": 89454,
      "company": "Urban Refurbishment, LLC",
      "sid": 8,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11296",
      "zip": "55407",
      "address": "4133 20th Ave S",
      "phone": "612-315-9139 ",
      "fax": null,
      "email": "urbanrefurbishments@gmail.com",
      "name": "Urban Refurbishment, LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "44.9277265",
      "lon": "-93.243283",
      "cityname": "Minneapolis",
      "statename": "Minnesota"
   },
   "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": ""
}