Mayfair Real Estate Advisors, LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310542,
      "site_id": 24,
      "cat_id": 80,
      "priority": 0,
      "url": "http://www.mayfairadvisors.net/",
      "title": "Mayfair Real Estate Advisors, LLC",
      "description": "Mayfair Advisors specializes in buy and sell of new and pre-constructed luxury real estate in Miami.  ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61777,
      "approve_dt": "2015-09-24T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-09-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1000,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 3739,
      "ltop": "",
      "facebook": "https://www.facebook.com/mayfairadvisors",
      "tiktok": "",
      "linkedin": "https://www.linkedin.com/company/mayfair-real-estate-advisors",
      "twitter": "https://twitter.com/mayfairadv",
      "googleplus": "https://plus.google.com/+MayfairadvisorsNet/about",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 1433,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954deb51-56da-11ed-b77c-b66e99367f32",
      "subdate": "Sep 24, 2015",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 1167
   },
   "visits": {
      "storefront": 1167,
      "articles": 0,
      "videos": 0,
      "reviews": 17,
      "coupons": 0,
      "products": 0,
      "social": 13,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mayfair Advisors is a team of luxury real estate agents who specialize in buying and selling of new and pre-constructed luxury real estate in Miami. We here at Mayfair Advisors believe in the motto Quality over Quantity and thats exactly what we provide to the buyers and sellers who approach us, an impeccable service and an unmatched customer satisfaction. We are the one and only boutique firm in all of Miami to buy and sell luxury real estate properties-whether its a condominium, a bungalow, or an ultra-contemporary green house. We help our valued clients buy and sell new and pre-constructed properties in Coconut Grove, Coral Gables, Pinecrest, Miami Beach, Surfside, Bal Harbour, Sunny Isles Beach, Aventura, Midtown, Edgewater and anywhere else in Miami. Our real estate agents are known for their friendly rapport with clients, an unwavering work ethic and years of expertise in luxury real estate finance and development. Whether you are relocating to Miami or looking for the perfect vacation home, we can provide you with all the resources to find only the best in Miami. Our buyer and seller services not only include finding the perfect luxury real estate or finding the perfect buyer, but also extends to analysis and background check of luxury pre-constructed property, guidance on luxury real estate investment and also a peak into the well-known communities of Miami. For more details, visit http://www.mayfairadvisors.net/ and http://www.mayfairadvisors.net/properties/.",
      "service1": "Luxury real estate",
      "service2": "Preconstruction",
      "service3": "Real estate",
      "service4": " Relocating to Miami",
      "service5": " Buy your Dream Home",
      "service6": " Sell your Home",
      "service7": " Sell your Condo",
      "submit_dt": "2015-09-24 09:07:57"
   },
   "location": {
      "uuid": "954deb51-56da-11ed-b77c-b66e99367f32",
      "link_id": 310542,
      "account_id": 61777,
      "company": "Mayfair Real Estate Advisors, LLC",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3739",
      "zip": "33133",
      "address": "3390 Mary St, Suite 120",
      "phone": "786-610-9220",
      "fax": "",
      "email": "averyri87@gmail.com",
      "name": "Mayfair Real Estate Advisors, LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "25.7286579",
      "lon": "-80.2399673",
      "cityname": "Miami",
      "statename": "Florida"
   },
   "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": ""
}