Silvernail Realty

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350020,
      "site_id": 24,
      "cat_id": 80,
      "priority": 0,
      "url": "https://silvernailrealty.com",
      "title": "Silvernail Realty",
      "description": "Silvernail Realty is a full-service real estate company specializing in home sales and property management across Mecosta County, Osceola County, Newaygo, and Montcalm County regions. With extensive local knowledge and a proven track record, the team at Silvernail Realty listens carefully to understand each client's unique real estate goals and creates tailored solutions to meet their needs. Whether you're a first-time buyer, experienced investor, or looking for rental opportunities, Silvernail Realty provides the expertise and resources necessary to achieve your real estate objectives.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100715,
      "approve_dt": "2025-09-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-10T00: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": 22,
      "city_id": 10198,
      "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": 1416,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8dc4c9c1-8e08-11f0-bb42-b66e99367f32",
      "subdate": "Sep 10, 2025",
      "subcategory": "Property Management Agent",
      "request_types": "",
      "visitcount": 49
   },
   "visits": {
      "storefront": 49,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 22,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Silvernail Realty, we offer home sales, consultations and property management.\n
\n
\nWe listen carefully to understand your real estate goals and work hard to create solutions that make sense for you. Whether you are new to the market, an experienced investor or looking to rent, we have the expertise, proven track record, and resources to help you achieve your real estate goals.\n",
      "service1": "Homes for Sale",
      "service2": "",
      "service3": "Rental Properties",
      "service4": "Residential Real Estate",
      "service5": "Real Estate",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-09-10 05:39:43"
   },
   "location": {
      "uuid": "8dc4c9c1-8e08-11f0-bb42-b66e99367f32",
      "link_id": 350020,
      "account_id": 100715,
      "company": "Silvernail Realty ",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10198",
      "zip": "49307",
      "address": "17810 205th Ave, #1",
      "phone": "231-796-6329",
      "fax": null,
      "email": "silvernailrealty@inboxbear.com",
      "name": "Silvernail Realty",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Big Rapids",
      "statename": "Michigan"
   },
   "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": ""
}