River Rats Realty

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328711,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "http://riverratsrealty.com/",
      "title": "River Rats Realty",
      "description": "Im an experienced and licensed real estate professional working in the industry since 2005. Ive owned and managed my own brokerage in California and have recently moved with my wife to Bullhead City. Im a hardworking and dedicated realtor and give my best to ensure clients I work with get the best deal possible. If you have any real estate related questions about properties in the city, please feel free to get in touch with me today.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79544,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-02-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 20,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 863,
      "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": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "de8188ff-d5cb-11ee-8344-b66e99367f32",
      "subdate": "Feb 27, 2024",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 59
   },
   "visits": {
      "storefront": 59,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "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-02-27 23:56:48"
   },
   "location": {
      "uuid": "de8188ff-d5cb-11ee-8344-b66e99367f32",
      "link_id": 328711,
      "account_id": 79544,
      "company": "River Rats Realty",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "863",
      "zip": "86429",
      "address": "3031 Rosewood Avenue",
      "phone": "7145141176",
      "fax": null,
      "email": "leecravens@tutanota.com",
      "name": "River Rats Realty",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "19.5345279",
      "lon": "-99.1907364",
      "cityname": "Bullhead City",
      "statename": "Arizona"
   },
   "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": ""
}