Dream Kitchens and More

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349794,
      "site_id": 8,
      "cat_id": 67,
      "priority": 0,
      "url": "https://dreamkitchensandmore.com/",
      "title": "Dream Kitchens and More",
      "description": "At Dream Kitchens and More, we are a family business specializing in home remodeling. Our services encompass all aspects of construction and contracting. We feature a Kitchen %38 Bath Showroom and specialized design services at our location of 43 years, in Pembroke, MA. We are highly skilled and experienced in full scope kitchen, bath and home renovating. Our goal is to educate our clients throughout every step of the renovation process, provide all of the products and services for your renovation and form a collaboration utilizing our expertise, knowledge and concepts with your needs, style and ideas. We are as excited to create your new space as you are! Schedule an appointment to visit our showroom, send us a message or call us today!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100489,
      "approve_dt": "2025-09-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-21T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 0,
      "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": 70,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "088db907-7ebf-11f0-bb42-b66e99367f32",
      "subdate": "Aug 21, 2025",
      "subcategory": "Kitchen Appliances",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "At Dream Kitchens and More, we are a family business specializing in home remodeling. Our services encompass all aspects of construction and contracting. We feature a Kitchen & Bath Showroom and specialized design services at our location of 43 years, in Pembroke, MA. We are highly skilled and experienced in full scope kitchen, bath and home renovating. Our goal is to educate our clients throughout every step of the renovation process, provide all of the products and services for your renovation and form a collaboration utilizing our expertise, knowledge and concepts with your needs, style and ideas. We are as excited to create your new space as you are! Schedule an appointment to visit our showroom, send us a message or call us today!",
      "service1": "remodel",
      "service2": "Designs",
      "service3": "Kitchen Showroom",
      "service4": "Bathroom Remodeling",
      "service5": "kitchen remodeling\\",
      "service6": "Bathroom remodel",
      "service7": "kitchen renovation",
      "submit_dt": "2025-08-21 18:45:39"
   },
   "location": {
      "uuid": "088db907-7ebf-11f0-bb42-b66e99367f32",
      "link_id": 349794,
      "account_id": 100489,
      "company": "Dream Kitchens And More",
      "sid": 8,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "0",
      "zip": "02359",
      "address": "217 Water St",
      "phone": "(781) 826-9663",
      "fax": null,
      "email": "alaiyatitus@gmail.com",
      "name": "Website",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "",
      "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": ""
}