The Schueler Group

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349924,
      "site_id": 24,
      "cat_id": 80,
      "priority": 0,
      "url": "https://schuelergroup.com/",
      "title": "The Schueler Group",
      "description": "The Schueler Group is a trusted commercial real estate developer serving Southwest Ohio since the 1930s. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100619,
      "approve_dt": "2025-09-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 17174,
      "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": 1433,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "670be562-872b-11f0-bb42-b66e99367f32",
      "subdate": "Sep 01, 2025",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 29
   },
   "visits": {
      "storefront": 29,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 12,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "The Schueler Group is a trusted commercial real estate developer serving Southwest Ohio since the 1930s. We provide comprehensive services including land development, commercial construction, property management, and brokerage. Our diverse portfolio ranges from empty acreage and prime industrial parcels to retail, medical, and office spaces. Backed by decades of experience, we help businesses buy, lease, or build the right properties to achieve long-term growth and success.",
      "service1": "Commercial Real Estate Development Cincinnati OH",
      "service2": "Commercial Real Estate Services Firm Cincinnati OH",
      "service3": "Commercial Real Estate Services Firm Cincinnati OH",
      "service4": "Commercial Real Estate Broker Services Cincinnati OH",
      "service5": "Commercial Property Real Estate Agents Cincinnati OH",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-09-01 12:01:33"
   },
   "location": {
      "uuid": "670be562-872b-11f0-bb42-b66e99367f32",
      "link_id": 349924,
      "account_id": 100619,
      "company": "The Schueler Group",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "17174",
      "zip": "45036",
      "address": "3000 Henkle Dr G",
      "phone": "513-932-6010",
      "fax": null,
      "email": "schuelergrouplebanon@gmail.com",
      "name": "The Schueler Group",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Lebanon",
      "statename": "Ohio"
   },
   "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": ""
}