Grand Design Construction

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348297,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://granddesign.construction/",
      "title": "Grand Design Construction",
      "description": "At Grand Design Construction, we provide top-quality roofing services in Moore, OK, and surrounding areas. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98992,
      "approve_dt": "2025-07-15T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 35,
      "city_id": 18162,
      "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": 5103,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8593dbac-42c2-11f0-a909-b66e99367f32",
      "subdate": "Jun 06, 2025",
      "subcategory": "Roofers",
      "request_types": "",
      "visitcount": 65
   },
   "visits": {
      "storefront": 65,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 29,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Grand Design Construction is your local Moore, Oklahoma roofing contractor committed to excellence in every shingle and beam we lay. Our dedicated team understands that a sturdy and reliable roof is fundamental to the safety and integrity of your home or business. That's why we take pride in delivering top-notch service with the precision and care our clients deserve. When you're searching for a roofing contractor near me, you can count on us for unparalleled expertise in roofing installation, repair, and maintenance. We ensure each project is completed with high-quality materials and by skilled professionals who are passionate about crafting durable rooftops that stand the test of time. Trust Grand Design Construction to be your partner in fortifying your property against the elements, enhancing its aesthetic appeal, and increasing its value.",
      "service1": "Roof Replacement",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-06 10:39:28"
   },
   "location": {
      "uuid": "8593dbac-42c2-11f0-a909-b66e99367f32",
      "link_id": 348297,
      "account_id": 98992,
      "company": "Grand Design Construction",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 35,
      "city": "18162",
      "zip": "73160",
      "address": "406 N Telephone Rd",
      "phone": "405-963-5318",
      "fax": null,
      "email": "granddesign@businessmailsystem.com",
      "name": "Grand Design Construction",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "35.3417079",
      "lon": "-97.4940591",
      "cityname": "Moore",
      "statename": "Oklahoma"
   },
   "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": ""
}