Pinestraw America of Fairhope

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349727,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "https://pinestrawamerica.com/location/fairhope-al/",
      "title": "Pinestraw America of Fairhope",
      "description": "To provide exceptional quality long leaf pine straw products and services nationwide. We are committed to sustainable practices, customer satisfaction, and enhancing the natural beauty of landscapes across America with our eco-friendly and reliable solutions",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100422,
      "approve_dt": "2025-08-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-14T00: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": 1,
      "city_id": 0,
      "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": 5190,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c34c6651-790e-11f0-bb42-b66e99367f32",
      "subdate": "Aug 14, 2025",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 54
   },
   "visits": {
      "storefront": 54,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 245,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Pinestraw America of Fairhope offers premium pine straw installation services for residential and commercial landscapes in Fairhope, AL. We specialize in delivering and professionally installing fresh, long-leaf pine straw to enhance curb appeal, control weeds, and prevent erosion. Our experienced team ensures clean edges, even coverage, and efficient service with every installation. Whether you're refreshing flower beds, garden borders, or large commercial spaces, we provide dependable and high-quality results tailored to your needs. Trust Pinestraw America of Fairhope to keep your outdoor spaces looking polished and well-maintained all year round. Call us today for expert pine straw solutions",
      "service1": "Pine Starw",
      "service2": "Landscape",
      "service3": "Care",
      "service4": "Lawn",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-08-14 13:01:16"
   },
   "location": {
      "uuid": "c34c6651-790e-11f0-bb42-b66e99367f32",
      "link_id": 349727,
      "account_id": 100422,
      "company": "Pinestraw America of  Fairhope",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 1,
      "city": "0",
      "zip": "36580",
      "address": "14581 Co Rd 49 Suite #C17",
      "phone": "(251) 270 5117",
      "fax": null,
      "email": "pinestrawamericaoffairhope@proton.me",
      "name": "Pinestraw America of Fairhope",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "",
      "statename": ""
   },
   "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": ""
}