Yafen Lightings and Ceiling Fans

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 346338,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://yafen.sg",
      "title": "Yafen Lightings and Ceiling Fans",
      "description": "Yafen Lighting & Ceiling Fan is a premier online platform that specializes in providing a wide range of home products, including ceiling fans, LED lights, bathroom products, and kitchen products. With our commitment to quality, innovation, and customer satisfaction, we aim to elevate your home living experience to new heights.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 97033,
      "approve_dt": "2025-08-13T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-05-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 231,
      "countrycode": "SG",
      "loc_id": 231,
      "state_id": 0,
      "city_id": 1106,
      "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": 6626,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "dcedc54f-2850-11f0-a909-b66e99367f32",
      "subdate": "May 03, 2025",
      "subcategory": "Home Energy",
      "request_types": "",
      "visitcount": 27
   },
   "visits": {
      "storefront": 27,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Your premier destination for ceiling fans and home fixtures at guaranteed lowest prices. We offer an extensive selection of quality products from trusted brands including AeroAir, Alaska, Alpha, Bestar, Crestar, Efenz, Fanco, Fanztec, Haiku, KDK, and Yafen to enhance comfort and style in every room of your home.",
      "service1": "ceiling fans with lighting options",
      "service2": " LED ceiling lights",
      "service3": " bathroom accessories",
      "service4": " toilet bowls",
      "service5": " faucets",
      "service6": " kitchen products",
      "service7": " brand consultation",
      "submit_dt": "2025-05-03 19:00:22"
   },
   "location": {
      "uuid": "dcedc54f-2850-11f0-a909-b66e99367f32",
      "link_id": 346338,
      "account_id": 97033,
      "company": "Yafen Lightings and Ceiling Fans",
      "sid": 76,
      "country": 231,
      "countrycode": "SG",
      "state": 0,
      "city": "1106",
      "zip": "539182",
      "address": "Defu Lane 10 Blk 1",
      "phone": "83224220",
      "fax": null,
      "email": "ryansh8423@gmail.com",
      "name": "Yafen Lightings and Ceiling Fans",
      "status": "",
      "start_dt": null,
      "end_dt": null,
      "lat": "1.3587237",
      "lon": "103.8936012",
      "cityname": "Singapore",
      "statename": ""
   },
   "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": ""
}