Andreotti Family Farms

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336748,
      "site_id": 87,
      "cat_id": 1,
      "priority": 2,
      "url": "https://andreottifamilyfarm.com/",
      "title": "Andreotti Family Farms",
      "description": "The Andreotti Family Farm is located in Half Moon Bay, California, and is a fun place for families. It is famous for its bright pumpkin patch and rich farming history. Since 1926, this farm has been a loved part of the community, offering fun activities and fresh fruits and vegetables that attract visitors from many places.The  pumpkin patch in California at this farm is a popular family attraction that offers an idyllic place where you can pick your own pumpkins, enjoy magnificent coastal vistas, as well as partake in the happy fall festivities. This farm has the largest variety of pumpkins one can ever imagine making it an ideal site for families who wish to have some indelible autumn experiences.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87481,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2004,
      "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": 6388,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "57c22f1f-8a51-11ef-ab46-b66e99367f32",
      "subdate": "Oct 14, 2024",
      "subcategory": "Marketing Tools",
      "request_types": "",
      "visitcount": 30
   },
   "visits": {
      "storefront": 30,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-14 17:25:47"
   },
   "location": {
      "uuid": "57c22f1f-8a51-11ef-ab46-b66e99367f32",
      "link_id": 336748,
      "account_id": 87481,
      "company": "Andreotti Family Farms",
      "sid": 87,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2004",
      "zip": "94019",
      "address": "800 Cabrillo Hwy N, Half Moon Bay, CA 94019, United States",
      "phone": "6507200428",
      "fax": null,
      "email": "familyandreotti@gmail.com",
      "name": "Andreotti Family Farms",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "37.4736668",
      "lon": "-122.4367771",
      "cityname": "Half Moon Bay",
      "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": ""
}