Koehler Homes, Inc.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318847,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://koehlerhomesinc.com/",
      "title": "Koehler Homes, Inc.",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70041,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-04-02T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 141,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3606,
      "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": 4183,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957786f5-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 02, 2020",
      "subcategory": "Windows",
      "request_types": "",
      "visitcount": 198
   },
   "visits": {
      "storefront": 198,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Koehler Homes, Inc. has been locally owned and operated for over 35 years. Our business model is built on referrals from satisfied customers, who have realized that we focus on building long term relationships. We approach every homeowner's needs with the same core principles that guide our business: Honesty, Integrity, Service, and a promise to never leave the job until the homeowner is completely satisfied. Koehler Homes, Inc. warranties our workmanship and promises 100% satisfaction on the installation of our products. We are also A+ rated and accredited with the BBB. ",
      "service1": "Jacksonville Replacement Windows",
      "service2": "Jacksonville Window Company",
      "service3": "Jacksonville Window Replacement",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-04-02 06:49:18"
   },
   "location": {
      "uuid": "957786f5-56da-11ed-b77c-b66e99367f32",
      "link_id": 318847,
      "account_id": 70041,
      "company": "Koehler Homes, Inc.",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3606",
      "zip": "32217",
      "address": "5971 Powers Ave Suite 6",
      "phone": "(904) 580-3777",
      "fax": null,
      "email": "koehlerhomesinc@outlook.com",
      "name": "Koehler Homes, Inc.",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "30.2626895",
      "lon": "-81.620719",
      "cityname": "Jacksonville",
      "statename": "Florida"
   },
   "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": ""
}