Sequoia Plaza Flowers

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 344805,
      "site_id": 56,
      "cat_id": 41,
      "priority": 2,
      "url": "https://www.sequoiaplazaflowers.com/",
      "title": "Sequoia Plaza Flowers",
      "description": "FULL SERVICE FLORIST SERVING VISALLIA, CA AND SURROUNDING AREA SINCE 1950 WITH ALL YOUR FLORAL NEEDS!!!! VISALIA'S FLORIST OF CHOICE! Visalia FLORIST - Sequoia Plaza Flowers SHOP FLOWERS FOR DELIVERY in Visalia, CA and Surrounding Areas",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 95500,
      "approve_dt": "2025-10-27T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-04T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2627,
      "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": 3985,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "b0991904-116e-11f0-a909-b66e99367f32",
      "subdate": "Apr 04, 2025",
      "subcategory": "Floral Shop",
      "request_types": "",
      "visitcount": 30
   },
   "visits": {
      "storefront": 30,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Our expert florists create stunning fall floral arrangements that capture the vibrant beauty of autumn with bold, seasonal colors perfect for any home or occasion. Each designer's choice arrangement features fresh, premium flowers in warm autumn tones, expertly crafted to bring the essence of fall into your space. Whether you're surprising someone special or refreshing your own decor, our custom fall arrangements deliver quality, creativity, and the rich colors of the season.",
      "service1": "designer's choice floral arrangements",
      "service2": " seasonal fall flower bouquets",
      "service3": " custom arrangement design",
      "service4": " fresh flower delivery",
      "service5": " home decor florals",
      "service6": " gift arrangements and surprises",
      "service7": " special occasion floral services",
      "submit_dt": "2025-04-04 16:05:55"
   },
   "location": {
      "uuid": "b0991904-116e-11f0-a909-b66e99367f32",
      "link_id": 344805,
      "account_id": 95500,
      "company": "Sequoia Plaza Flowers",
      "sid": 56,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2627",
      "zip": "93291",
      "address": "601 N Willis St Visalia, CA. 93291",
      "phone": "",
      "fax": null,
      "email": "sequoiaplazaflowers2@protonmail.com",
      "name": "sequoia plaza flowers",
      "status": "",
      "start_dt": null,
      "end_dt": null,
      "lat": "36.3347917",
      "lon": "-119.2980549",
      "cityname": "Visalia",
      "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": ""
}