California Custom Creations

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346162,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://www.ca-custom.com/",
      "title": "California Custom Creations",
      "description": "California Custom Creations is a family-owned and operated business with over 30 years of experience in window and door installation throughout the Bay Area, primarily serving San Mateo County including Mountain View, San Mateo, and Palo Alto. They pride themselves on quality in-house service without subcontracting, competitive pricing, and making home improvement projects easy and stress-free for homeowners.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96857,
      "approve_dt": "2025-08-17T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-30T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1906,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "97938828-25ad-11f0-a909-b66e99367f32",
      "subdate": "Apr 30, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 13
   },
   "visits": {
      "storefront": 13,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Products and Services : window replacement, window installation, vinyl windows, wood windows, aluminum windows, sliding doors, patio doors, entry doors, french doors, door replacement, door installation, skylights, vinyl siding, dry rot repair\n
\n
Brands: Milgard, Amerimax, Marvin, Atrium\n
\n
Professional Associations: Hero Registered Contractor\n
\n
Credentials: AAMA-certified, Service Magic Screened&Approved, Family-owned and operated\n
\n
Areas Served: Belmont, Burlingame, Foster City, Half Moon Bay, Menlo Park, Millbrae, Montara, Moss Beach, Mountain View, Pacifica, Palo Alto, Portola Valley, Redwood City, San Bruno, San Mateo, Stanford\n
",
      "service1": "window installation and replacement",
      "service2": " door installation services",
      "service3": " free estimate consultations",
      "service4": " custom home improvement solutions",
      "service5": " in-house project management",
      "service6": " personalized customer service",
      "service7": " Bay Area residential installation services",
      "submit_dt": "2025-04-30 10:26:35"
   },
   "location": {
      "uuid": "97938828-25ad-11f0-a909-b66e99367f32",
      "link_id": 346162,
      "account_id": 96857,
      "company": "California Custom Creations",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1906",
      "zip": "94018",
      "address": "715 Valencia Ave",
      "phone": "(408) 316-6293",
      "fax": null,
      "email": "cacustomcreations@wehaveprepared.com",
      "name": "California Custom Creations",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.5083204",
      "lon": "-122.4781892",
      "cityname": "El Granada",
      "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": ""
}