J. R. Door & Window Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340888,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.jrdoorandwindow.net/",
      "title": "J. R. Door & Window Inc",
      "description": "J. R. Door & Window Inc is a family owned and operated business since 1989.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 91585,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 7,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "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": 4183,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "4da2bbfe-d405-11ef-a909-b66e99367f32",
      "subdate": "Jan 16, 2025",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 19
   },
   "visits": {
      "storefront": 19,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Credentials:\r
BBB A+ rating, Energy Star Partner, Lead Safe certified, Licensed Installers, Certified Contractors, Daily Bulletin Readers Choice Award, Inland Valley's Best Window&Best Door Company For 2014\r
\r
Products and Services:\r
window replacement, window installation, vinyl windows, fiberglass windows, wood windows, aluminum windows, energy efficient windows, sliding doors, patio doors, entry doors, french doors, door replacement, door installation, window treatments, window shades, window blinds, window shutters, window coverings, Norman shades, Norman blinds, Norman shutterswindow replacement, window installation, vinyl windows, fiberglass windows, wood windows, aluminum windows, energy efficient windows, sliding doors, patio doors, entry doors, french doors, door replacement, door installation, window treatments, window shades, window blinds, window shutters, window coverings, Norman shades, Norman blinds, Norman shutters\r
\r
Areas Served:\r
Upland, CA\r
(serving the Inland Empire Area)\r
Serving: Chino, Chino Hills, Claremont, Diamond Bar, Fontana, Hacienda Heights, La Verne, Ontario, Rancho Cucamonga,",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-16 12:27:51"
   },
   "location": {
      "uuid": "4da2bbfe-d405-11ef-a909-b66e99367f32",
      "link_id": 340888,
      "account_id": 91585,
      "company": "",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "91786",
      "address": "615 N Benson Ave Unit I Upland, CA ",
      "phone": "(909) 949-9902",
      "fax": null,
      "email": "jrdoorsandwindows@localhoneyblog.com",
      "name": "J. R. Door & Window Inc",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "34.1009648",
      "lon": "-117.6813887"
   },
   "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": ""
}