Clear Sight Inspections

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 325999,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://csicertified.com/",
      "title": "Clear Sight Inspections",
      "description": "home inspection staten island",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76896,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-10-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 4,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 31,
      "city_id": 25393,
      "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": 1436,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "c392fcc7-6441-11ee-8344-b66e99367f32",
      "subdate": "Oct 06, 2023",
      "subcategory": "Real Estate Listings",
      "request_types": "",
      "visitcount": 20
   },
   "visits": {
      "storefront": 20,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Purchasing a home is arguably the most significant financial decision you'll ever make. Hence, safeguarding that investment with a comprehensive home inspection is paramount. This step not only enlightens you about potential issues but also prepares you for what lies ahead. Yet, not everyone possesses the technical knowledge or emotional detachment to assess properties effectively. Enter Clear Sight Inspections in Staten Island, NY. We stand as your reliable partner, offering unparalleled home inspection services that go beyond superficial checks. Our reports are comprehensive, unbiased, and informative, ensuring you have a crystal-clear understanding of your potential new home. Our seasoned inspectors embody integrity, expertise, and dedication, ensuring peace of mind in your property investment.\r
\r
Email ID : jean@csicertified.com\r
",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-10-06 12:13:31"
   },
   "location": {
      "uuid": "c392fcc7-6441-11ee-8344-b66e99367f32",
      "link_id": 325999,
      "account_id": 76896,
      "company": "Clear Sight Inspections",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 31,
      "city": "25393",
      "zip": "10302",
      "address": "1324 Forest Ave, Unit #460",
      "phone": "(347) 286-8696",
      "fax": null,
      "email": "clearsightinspection12@gmail.com",
      "name": "Clear Sight Inspections",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "",
      "lon": "",
      "cityname": "Staten Island",
      "statename": "New York"
   },
   "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": ""
}