Atlantic Hardscape and Concrete

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 334488,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://atlantichardscape.ca/",
      "title": "Atlantic Hardscape and Concrete",
      "description": "Atlantic Hardscape and Concrete in Fredericton, NB, is your trusted partner in transforming outdoor areas through expert hardscaping and landscaping. Our services include custom patios, paver driveways, walkways, retaining walls, and outdoor kitchens, as well as landscape design, lighting, drainage, and light excavation.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 85243,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-08-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 99,
      "countrycode": "CA",
      "loc_id": 99,
      "state_id": 0,
      "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": 5178,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "30ecc377-617c-11ef-ab46-b66e99367f32",
      "subdate": "Aug 23, 2024",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 8
   },
   "visits": {
      "storefront": 8,
      "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": "At Atlantic Hardscape and Concrete, based in Fredericton, NB, we are passionate about transforming outdoor spaces into stunning, functional environments. With years of experience in the industry, we specialize in offering top-tier hardscaping and landscaping services that bring your outdoor vision to life. Our team of skilled professionals is committed to delivering exceptional craftsmanship and personalized service, ensuring that each project reflects the unique needs and style of our clients.\r
\r
Why Choose Us?\r
\r
Expert Craftsmanship: Our team of highly skilled professionals is dedicated to delivering superior quality in every project we undertake. Whether it's custom patios, paver driveways, walkways, retaining walls, or outdoor kitchens, our attention to detail ensures that your outdoor space is built to last and look beautiful.\r
\r
Comprehensive Services: We offer a wide range of services to meet all your outdoor needs. From landscape design and installation to lighting, drainage solutions, and light excavation, we provide everything you need to create a cohesive and functional outdoor environment.\r
\r
Customized Solutions: We understand that every client has a unique vision for their outdoor space. That's why we offer customized solutions tailored to your specific needs and preferences, ensuring that your project is a true reflection of your style.\r
\r
Client-Focused Approach: Your satisfaction is our top priority. We work closely with you throughout the entire process, from initial consultation to project completion, to ensure that your vision is realized to the fullest. Our transparent communication and commitment to excellence make us a trusted partner in your outdoor transformation.\r
\r
Local Expertise: As a proud Fredericton-based company, we have a deep understanding of the local landscape and climate. This knowledge allows us to recommend the best materials and designs for your specific environment, ensuring that your outdoor space remains beautiful and functional for years to come.\r
\r
Choose Atlantic Hardscape and Concrete for your next outdoor project and experience the difference that expertise, dedication, and a client-centered approach can make. Let us help you create the outdoor space you've always dreamed of.\r
\r
",
      "service1": "Landscaping",
      "service2": "Hardscaping",
      "service3": "paver driveway installation",
      "service4": "patio and walkway installation",
      "service5": "light excavating services",
      "service6": "Landscape drainage system installation",
      "service7": "landscape lighting ",
      "submit_dt": "2024-08-23 18:19:09"
   },
   "location": {
      "uuid": "30ecc377-617c-11ef-ab46-b66e99367f32",
      "link_id": 334488,
      "account_id": 85243,
      "company": "Atlantic Hardscape and Concrete",
      "sid": 69,
      "country": 99,
      "countrycode": "CA",
      "state": 0,
      "city": "0",
      "zip": "E3B 0L3",
      "address": "34 Jackstraw Ct, Fredericton, NB",
      "phone": "5062610771",
      "fax": null,
      "email": "info@atlantichardscape.ca",
      "name": "Atlantic Hardscape and Concrete",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.9513572",
      "lon": "-66.700833",
      "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": ""
}