The Geller Firm

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348705,
      "site_id": 37,
      "cat_id": 57,
      "priority": 2,
      "url": "https://rickgeller.com/",
      "title": "The Geller Firm",
      "description": " With over 37 years experience and more than 7,000 satisfied clients, The Geller Firm is your trusted partner in navigating the complexities of personal injury claims. We're here to make sure that you receive the maximum compensation for your pain, suffering, and losses.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99399,
      "approve_dt": "2025-07-10T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 14951,
      "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": 2239,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d6ef6706-4a57-11f0-a909-b66e99367f32",
      "subdate": "Jun 16, 2025",
      "subcategory": "Legal Services",
      "request_types": "",
      "visitcount": 47
   },
   "visits": {
      "storefront": 47,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The Geller Firm is a trusted law firm in New York serving as your advocate in personal injury litigation with a steadfast commitment to justice and a passion for standing up for those harmed by others' negligence. With Rick Geller and his team serving as a beacon of hope for over 7,000 clients across more than 37 years of personal injury litigation, we ensure you get the justice you deserve through experienced legal representation and unwavering dedication to our clients' rights.",
      "service1": "Personal injury litigation",
      "service2": " Negligence case representation",
      "service3": " Justice advocacy services",
      "service4": " Legal consultation and evaluation",
      "service5": " Client rights protection",
      "service6": " Experienced trial representation",
      "service7": " Comprehensive case management",
      "submit_dt": "2025-06-16 02:15:57"
   },
   "location": {
      "uuid": "d6ef6706-4a57-11f0-a909-b66e99367f32",
      "link_id": 348705,
      "account_id": 99399,
      "company": "The Geller Firm",
      "sid": 37,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "14951",
      "zip": "11530",
      "address": "1122 Franklin Avenue",
      "phone": "5164944601",
      "fax": null,
      "email": "rickgeller@mail-burst.com",
      "name": "The Geller Firm",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "40.7317143",
      "lon": "-73.6368079",
      "cityname": "Garden City",
      "statename": "New York"
   },
   "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": ""
}