Dream Boat Docks

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 347755,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://dreamboatdocks.com",
      "title": "Dream Boat Docks",
      "description": "Looking for pile driving contractors near me? Our skilled team at Dream Boat Docks ensures every pile is driven to perfection. Build with confidencestart your project with us today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98450,
      "approve_dt": "2025-07-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0dc80c4b-3b96-11f0-a909-b66e99367f32",
      "subdate": "May 28, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 12
   },
   "visits": {
      "storefront": 12,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Dream Boat Docks has been providing quality marine construction to families and businesses throughout Texas since 1987, built on uncompromising quality and the philosophy of treating every project as if it were part of our own home. With over 25 years of experience as your premier Texas Gulf Coast dock and boat lift experts, our close-knit team of master carpenters and installers operates like an extended family, ensuring every \"Dream Project\" exceeds expectations through superior service, world-class products, and the belief that with us on your construction team, the only limitation is your imagination.",
      "service1": "Custom Dock Construction",
      "service2": " Boat Lift Installation",
      "service3": " Marine Construction Services",
      "service4": " Waterfront System Design",
      "service5": " Dock Renovation and Refresh",
      "service6": " Master Carpentry and Installation",
      "service7": " Texas Gulf Coast Marine Projects",
      "submit_dt": "2025-05-28 07:33:31"
   },
   "location": {
      "uuid": "0dc80c4b-3b96-11f0-a909-b66e99367f32",
      "link_id": 347755,
      "account_id": 98450,
      "company": "Dream Boat Docks",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77049",
      "address": "19302 Rio Villa Dr",
      "phone": "346-450-8966",
      "fax": null,
      "email": "dreamboatdockshouston@finmail.com",
      "name": "Dream Boat Docks",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.828088",
      "lon": "-95.0819226",
      "cityname": "Houston",
      "statename": "Texas"
   },
   "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": ""
}