CascoandSonsLLC
{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329429,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://cascoandsons.com/",
      "title": "CascoandSonsLLC",
      "description": "Metal fabrication company with 28 experienced years working with mild steel, stainless steel, aluminum and copper. Specializing in commercial stairs, onsite welding, interior and exterior stairs, railing, structural steel fabrication and erection. Metal/concrete apartment stairs and catwalk reinforcement and replacement. Manufacturing spiral stairs, straight and curved stairways.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80252,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-03-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 15,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 22,
      "city_id": 10477,
      "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": 5707,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "959481ac-ec16-11ee-8344-b66e99367f32",
      "subdate": "Mar 27, 2024",
      "subcategory": "Local Directories",
      "request_types": "",
      "visitcount": 76
   },
   "visits": {
      "storefront": 76,
      "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": "",
      "service1": "Stairs",
      "service2": "Commercial Stairs",
      "service3": "Apartment Stairs",
      "service4": "mobile welding services",
      "service5": "metal fabrication",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-03-27 08:47:03"
   },
   "location": {
      "uuid": "959481ac-ec16-11ee-8344-b66e99367f32",
      "link_id": 329429,
      "account_id": 80252,
      "company": "Casco & Sons LLC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "10477",
      "zip": "48150-1270",
      "address": "13500 Wayne Road",
      "phone": "(248) 579-8979",
      "fax": null,
      "email": "cascoandsonslivonia@mail-burst.com",
      "name": "Casco & Sons LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.3801646",
      "lon": "-83.3879948",
      "cityname": "Livonia",
      "statename": "Michigan"
   },
   "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": ""
}
        Visit To This Page
7
social Media List
     Visit StoreFront 
     
        
            
                
                
Livonia, Michigan 48150-1270 US
                                            
     
    
    
                      Addess:
13500 Wayne RoadLivonia, Michigan 48150-1270 US
Email:
cascoandsonslivonia@mail-burst.comPhone:
(248) 579-8979Visit Our Website
Site Content
Services
- Stairs
 - Commercial Stairs
 - Apartment Stairs
 - mobile welding services
 - metal fabrication