Rossi Painting & Construction

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350439,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://rossipainting.com/",
      "title": "Rossi Painting & Construction",
      "description": "Rossi Painting %38 Construction is a locally-owned company with 35 years of experience serving the following areas: Belmont, Atherton, Woodside, Burlingame, Daly City, Hillsborough, Foster City, Half Moon Bay, Los Altos, Menlo Park, Millbrae, Mountain View, Pacifica, Palo Alto, Redwood City, San Bruno, San Carlos, San Mateo, and San Francisco. We are trusted and respected, and we offer a 3-year all-inclusive warranty. Our strong reputation is based on the quality of our work and our commitment to client service, as evidenced by our reviews and testimonials.\n
\n
\nWe specialize in a variety of services, including Exterior House Painting, Interior Painting, Residential, Commercial, Lawn Painting, and Kitchen Cabinet Painting.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 101133,
      "approve_dt": "2025-10-27T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-10-27T00: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": 2449,
      "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": 5875,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e36a7748-b2e6-11f0-bb42-b66e99367f32",
      "subdate": "Oct 27, 2025",
      "subcategory": "Painting Contractors",
      "request_types": "",
      "visitcount": 0
   },
   "visits": {
      "storefront": 0,
      "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": "Rossi Painting & Construction is a locally-owned company with 35 years of experience serving the following areas: Belmont, Atherton, Woodside, Burlingame, Daly City, Hillsborough, Foster City, Half Moon Bay, Los Altos, Menlo Park, Millbrae, Mountain View, Pacifica, Palo Alto, Redwood City, San Bruno, San Carlos, San Mateo, and San Francisco. We are trusted and respected, and we offer a 3-year all-inclusive warranty. Our strong reputation is based on the quality of our work and our commitment to client service, as evidenced by our reviews and testimonials.\n
\n
\nWe specialize in a variety of services, including Exterior House Painting, Interior Painting, Residential, Commercial, Lawn Painting, and Kitchen Cabinet Painting.\n",
      "service1": "Painter",
      "service2": " Painting Contractor",
      "service3": " Drywall Repair",
      "service4": " Wallpaper Installer",
      "service5": " Pressure Washing Service.",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-10-27 03:41:57"
   },
   "location": {
      "uuid": "e36a7748-b2e6-11f0-bb42-b66e99367f32",
      "link_id": 350439,
      "account_id": 101133,
      "company": "Wes Dean",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2449",
      "zip": "94070",
      "address": "110 Glenn Way, #17",
      "phone": "650-595-5225",
      "fax": null,
      "email": "rossipaintingca@outlook.com",
      "name": "Rossi Painting & Construction",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "San Carlos",
      "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": ""
}