Mr. Window Cleaner Window Cleaning Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 34023,
      "site_id": 58,
      "cat_id": 11,
      "priority": 0,
      "url": "http://www.mrwindowcleaner.com",
      "title": "Mr. Window Cleaner Window Cleaning Service",
      "description": "Window Cleaning for Southern California. Specializing in residential and commercial window cleaning. Free estimates: 714-719-9114.",
      "keywords": "window cleaning, window washing, window cleaner, window washers, residential window cleaning",
      "status": "",
      "affiliate_id": 0,
      "cust_id": 28473,
      "approve_dt": "2008-02-14T00:00:00.000Z",
      "source": "editor",
      "submit_dt": "2008-02-14T00:00:00.000Z",
      "filler": null,
      "points": 750,
      "ppc_remain": 0,
      "ppc_points": 0,
      "link_points": 0,
      "clickcount": 1695,
      "referrals": 0,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2172,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 5887,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "94936fbc-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 14, 2008",
      "subcategory": "Window Cleaning",
      "request_types": "",
      "visitcount": 1808
   },
   "visits": {
      "storefront": 1808,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mr. Window Cleaner Window Washing Service is owned by Joe Bulik, an entrepreneurial business owner who relocated from Queens, New York to California in the early seventies. With years of experience in identifying and filling market needs, Joe has built a loyal customer base by providing high-quality residential window cleaning services with exceptional customer care and attention to detail.",
      "service1": "residential window cleaning",
      "service2": " glass care and maintenance",
      "service3": " exterior window washing",
      "service4": " interior window cleaning",
      "service5": " screen cleaning",
      "service6": " window frame cleaning",
      "service7": " customer-focused window services",
      "submit_dt": "2008-02-14 00:00:00"
   },
   "location": {
      "uuid": "94936fbc-56da-11ed-b77c-b66e99367f32",
      "link_id": 34023,
      "account_id": 28473,
      "company": "Mr. Window Cleaner",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2172",
      "zip": "",
      "address": "",
      "phone": "714-869-1800",
      "fax": null,
      "email": null,
      "name": null,
      "status": "hide",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Los Angeles",
      "statename": "California"
   },
   "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": ""
}