Southgate Glass

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336803,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.southgateglass.com",
      "title": "Southgate Glass",
      "description": "Window Replacement in Sacramento, CA",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87536,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "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": "d56172e6-8af3-11ef-ab46-b66e99367f32",
      "subdate": "Oct 15, 2024",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 7
   },
   "visits": {
      "storefront": 7,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "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, Storefront Windows, Moving Glass Walls, Moveable Glass Wall Systems, Residential window replacement, Residential Door Replacement, Commercial Window Replacement, Commercial Door Replacement, Residential Windows, Residential Doors, Commercial Windows, Commercial Doors, Shower Doors, Screens, Glass, Shower Enclosures, Mirrors\r
\r
Serving Cities: West Sacramento, Rosemont, La Riviera, Florin, Rio Linda, Carmichael, North Highlands, Rancho Cordova, Foothill Farms, Fair Oaks, Davis, Elk Grove, Citrus Heights, Orangevale, Roseville\r
\r
Brands:\r
Milgard, Andersen, Simonton, Cascade, Ply GEM, Marvin, AG Millworks, Cardinal, Therma Tru, All Weather",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-15 12:48:53"
   },
   "location": {
      "uuid": "d56172e6-8af3-11ef-ab46-b66e99367f32",
      "link_id": 336803,
      "account_id": 87536,
      "company": "",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "95823",
      "address": "6852 Franklin Blvd ",
      "phone": "(916) 421-1723",
      "fax": null,
      "email": "southgateglasssac@localhoneyblog.com",
      "name": "Southgate Glass",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.5019362",
      "lon": "-121.4632799"
   },
   "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": ""
}