San Diego''s Best Window Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314401,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.sandiegobestwindows.com",
      "title": "San Diego''s Best Window Company",
      "description": "We are the preferred choice in San Diego County for replacement windows, patio doors, and entry doors. Our windows are durable, high quality, energy efficient and at affordable prices. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65628,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-02-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 130,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2452,
      "ltop": "",
      "facebook": "https://www.facebook.com/sandiegosbestwindow",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://www.twitter.com/sdbw",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "https://www.yelp.com/biz/san-diegos-best-window-company-san-diego-8",
      "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": null,
      "logo_ext": null,
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "956027d5-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 06, 2018",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 142
   },
   "visits": {
      "storefront": 142,
      "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": "We have installed over thousands of replacement windows and door in San Diego County. Our mission is for all of our customer to be happy an satisfied with our work. ",
      "service1": "window blinds",
      "service2": "window shades",
      "service3": "window shutters",
      "service4": "window coverings",
      "service5": "patio doors",
      "service6": "entry doors",
      "service7": "replacement windows",
      "submit_dt": "2018-02-06 19:25:26"
   },
   "location": {
      "uuid": "956027d5-56da-11ed-b77c-b66e99367f32",
      "link_id": 314401,
      "account_id": 65628,
      "company": "San Diego''s Best Window Company",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2452",
      "zip": "92126",
      "address": "8888 Miramar Rd",
      "phone": "",
      "fax": null,
      "email": "sandiegosbestwindow@gmail.com",
      "name": "San Diego''s Best Window Company",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "32.8940047",
      "lon": "-117.1342192",
      "cityname": "San Diego",
      "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": ""
}