R&S Erection of Richmond Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334602,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.rs4doorsandgates.com/",
      "title": "R&S Erection of Richmond Inc",
      "description": "If your commercial or residential garage door requires service, rest assured that our IDEA-certified technicians are on standby for you 24-hours a day. We offer world-class garage door service on virtually every make or model of door and opener. Our door service rates are competitive and we are committed to resolving your garage door problems quickly and efficiently. If you have an emergency, please call us directly.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85355,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 11,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2404,
      "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": 5860,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f396520b-6481-11ef-ab46-b66e99367f32",
      "subdate": "Aug 27, 2024",
      "subcategory": "Garage Door",
      "request_types": "",
      "visitcount": 17
   },
   "visits": {
      "storefront": 17,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-08-27 14:37:57"
   },
   "location": {
      "uuid": "f396520b-6481-11ef-ab46-b66e99367f32",
      "link_id": 334602,
      "account_id": 85355,
      "company": "R&S Erection of Richmond Inc",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2404",
      "zip": "94801",
      "address": "1826 7th St\t",
      "phone": "(510) 232- 2062",
      "fax": null,
      "email": "rserectionofrichmondinc@gmail.com",
      "name": "R&S Erection of Richmond Inc",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.9592023",
      "lon": "-122.3612593",
      "cityname": "Richmond",
      "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": ""
}