Sebastian Francese General Contractor

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350477,
      "site_id": 6,
      "cat_id": 39,
      "priority": 0,
      "url": "https://www.sfgc.biz/",
      "title": "Sebastian Francese General Contractor",
      "description": "Sebastian Francese brings 17 years of maritime craftsmanship to residential construction. After building and restoring boats—including 11 years running his own yacht service business—he became a California licensed general contractor in 2010. His marine construction background provides exceptional attention to detail and proven expertise in solving complex structural and weatherproofing challenges, elevating every project beyond industry standards.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 101171,
      "approve_dt": "2025-10-30T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-10-30T00: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": 5,
      "city_id": 2404,
      "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": 6646,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e57824fc-b566-11f0-bb42-b66e99367f32",
      "subdate": "Oct 30, 2025",
      "subcategory": "Construction",
      "request_types": "",
      "visitcount": 1
   },
   "visits": {
      "storefront": 1,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Sebastian Francese General Contractor is a California based construction company known for its precision, craftsmanship, and attention to detail, led by Sebastian Francese, a former yacht builder with over 17 years of experience in high performance restoration. Since becoming a licensed general contractor in 2010, Sebastian has brought the same skill and structural expertise from the marine world to land based projects, specializing in whole house renovations, remodels, additions, custom kitchens, elegant bathrooms, durable decks, and outdoor living spaces. Whether you're updating a single room or transforming your entire home, every project is guided by a commitment to lasting quality, clear communication, and expert craftsmanship that sets this contractor apart.",
      "service1": "Whole House Renovations",
      "service2": " Home Remodels & Additions",
      "service3": " Kitchen Remodeling",
      "service4": " Bathroom Remodeling",
      "service5": " Decks & Outdoor Spaces",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-10-30 08:03:18"
   },
   "location": {
      "uuid": "e57824fc-b566-11f0-bb42-b66e99367f32",
      "link_id": 350477,
      "account_id": 101171,
      "company": "Sebastian Francese General Contractor",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2404",
      "zip": "94805",
      "address": "450 36th St",
      "phone": "5102906455",
      "fax": null,
      "email": "sfgc.bizca@gmail.com",
      "name": "Sebastian Francese General Contractor",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Richmond",
      "statename": "California"
   },
   "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": ""
}