Palms Garage Doors and Products

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335599,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://palmsgaragedoorsandproducts.com/",
      "title": "Palms Garage Doors and Products",
      "description": "Why Choose Palms Garage Doors\r\nAre you searching for garage door repair services for your home or business? Then look no further.\r\nPalms Garage Doors offers professional garage door installation, maintenance, and repair services to homeowners and businesses in the San Francisco Bay Area. With years of experience, you can count on us for prompt and professional service.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86342,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-19T00: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": 5,
      "city_id": 2213,
      "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": 4176,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "513d0e19-7653-11ef-ab46-b66e99367f32",
      "subdate": "Sep 19, 2024",
      "subcategory": "Garage",
      "request_types": "",
      "visitcount": 23
   },
   "visits": {
      "storefront": 23,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Why Choose Palms Garage Doors\r
Are you searching for garage door repair services for your home or business? Then look no further.\r
Palms Garage Doors offers professional garage door installation, maintenance, and repair services to homeowners and businesses in the San Francisco Bay Area. With years of experience, you can count on us for prompt and professional service.",
      "service1": "Garage Door Repair",
      "service2": "Garage Door Maintenance",
      "service3": "Garage Door Installation",
      "service4": "Spring Replacement",
      "service5": "Garage Door Opener",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-19 06:49:28"
   },
   "location": {
      "uuid": "513d0e19-7653-11ef-ab46-b66e99367f32",
      "link_id": 335599,
      "account_id": 86342,
      "company": "Palms Garage Doors and Products",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2213",
      "zip": "94025",
      "address": "3523 Haven Avenue, Unit F",
      "phone": "+1 650-677-1114",
      "fax": null,
      "email": "palmsgaragedoors@burst-email.com",
      "name": "Palms Garage Doors and Products",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.4880344",
      "lon": "-122.1890167",
      "cityname": "Menlo Park",
      "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": ""
}