Brilon Iron Works

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335702,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.brilonllc.com",
      "title": "Brilon Iron Works",
      "description": "Brilon Iron Works is a family-owned business located in Mesa, AZ, specializing in crafting high-quality iron doors and gates. With an extensive inventory of over 200 doors, we offer a wide range of options including single doors, double doors, pivot doors, and custom designs. Our products are designed to enhance security, curb appeal, and are maintenance-free. We provide Arizona delivery and installation services, as well as nationwide shipping. Our showroom in Mesa, Arizona features over 50 door designs, and we offer free home consultations and quotes. Committed to unparalleled craftsmanship and customer satisfaction, every door is pre-hung and tested to ensure top-notch quality and functionality. Interior doors, exterior doors, gates, fencing: we can do it all!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86445,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-22T00: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": 3,
      "city_id": 961,
      "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": 5864,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f3e50d7d-791e-11ef-ab46-b66e99367f32",
      "subdate": "Sep 22, 2024",
      "subcategory": "Home Cleaners",
      "request_types": "",
      "visitcount": 28
   },
   "visits": {
      "storefront": 28,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-22 20:12:11"
   },
   "location": {
      "uuid": "f3e50d7d-791e-11ef-ab46-b66e99367f32",
      "link_id": 335702,
      "account_id": 86445,
      "company": "Brilon Iron Works",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "961",
      "zip": "85212",
      "address": "8150 E Germann Rd , Bldg 2 Ste 114, Mesa, AZ 85212",
      "phone": "4805679772",
      "fax": null,
      "email": "kOpIyoVR.directory@usestyle.ai",
      "name": "Brilon Iron Works",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.279779",
      "lon": "-111.657075",
      "cityname": "Mesa",
      "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": ""
}