264 Fresco is a modern Italian restaurant in Carlsbad

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346291,
      "site_id": 38,
      "cat_id": 60,
      "priority": 2,
      "url": "https://www.264fresco.com",
      "title": "264 Fresco is a modern Italian restaurant in Carlsbad",
      "description": "264 Fresco is a modern Italian restaurant in Carlsbad featuring a delicious menu, a lively atmosphere, and experienced, attentive staff.  We use only fresh, local ingredients, and offer a tempting variety of steak, chicken, seafood, and pasta dishes, as well as wood-fired pizzas and made-to-order paninis.  With our vibrant decor and open floor plan, we are the ideal spot for romantic dinners, private parties, and casual lunches. Visit us during happy hour for special prices on quality wine, beers, and cocktails. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96986,
      "approve_dt": "2025-08-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-02T00: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": 1758,
      "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": 2114,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9b4c5199-271a-11f0-a909-b66e99367f32",
      "subdate": "May 02, 2025",
      "subcategory": "Italian Food Catering",
      "request_types": "",
      "visitcount": 42
   },
   "visits": {
      "storefront": 42,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "264 Fresco is a vibrant Carlsbad restaurant dedicated to creating delightful dining experiences through exceptional cuisine made from the finest ingredients, outstanding service, and a warm, welcoming atmosphere. Located in the heart of Carlsbad Village, we cater to every occasion—from casual drinks and intimate meals to special celebrations and private parties. Our commitment to excellence ensures that every guest leaves completely satisfied, whether dining in our main restaurant or enjoying our 21+ deck area.",
      "service1": "fine dining restaurant",
      "service2": " private party hosting",
      "service3": " takeout orders",
      "service4": " gift card sales",
      "service5": " reservations",
      "service6": " happy hour specials",
      "service7": " deck dining (21+)",
      "submit_dt": "2025-05-02 05:59:27"
   },
   "location": {
      "uuid": "9b4c5199-271a-11f0-a909-b66e99367f32",
      "link_id": 346291,
      "account_id": 96986,
      "company": "264 Fresco",
      "sid": 38,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1758",
      "zip": "92008",
      "address": "264 Carlsbad Village Dr, Carlsbad, CA 92008, USA",
      "phone": "7607203737",
      "fax": null,
      "email": "264fresco@gmail.com",
      "name": "Restaurant",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "33.1581337",
      "lon": "-117.3516677",
      "cityname": "Carlsbad",
      "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": ""
}