Mayfair Sub Real Estate

MLS® Disclaimer

Copyright 2026 Triangle MLS, Inc. of North Carolina. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Triangle MLS, Inc. of North Carolina. Real estate listings held by brokerage firms other than Costello Real Estate and Investment are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. Brokers make an effort to deliver accurate information, but buyers should independently verify any information on which they will rely in a transaction. The listing broker shall not be responsible for any typographical errors, misinformation, or misprints, and they shall be held totally harmless from any damages arising from reliance upon this data. This data is provided exclusively for consumer's personal, noncommercial use. Closed (sold) listings may have been listed and/or sold by a real estate firm other than the firm(s) featured on this website. Closed data is not available until the sale of the property is recorded in the MLS. Home sale data is not an appraisal, CMA, competitive or comparative market analysis, or home valuation of any property. Listings marked with an icon are provided courtesy of the Triangle MLS, Inc. of North Carolina, Internet Data Exchange Database. This site is monitored for scraping. Any use of listing data obtained from this web site, other than by a consumer looking to purchase real estate, is prohibited. This data has been updated as of September 25, 2026 12:52 PM UTC

Canopy MLS® Copyright ©2026 All rights reserved.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. §512, the DMCA, provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owners behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 Triad MLS, Inc. All rights reserved. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. This site will be monitored for "scraping" and any use of search facilities of data on the site other than by potential buyers/sellers is prohibited. All Sale data is for informational purposes only and is not an indication of a market analysis or appraisal. Data cannot be redistributed and cannot be used for any reason other than provided in the contract. Properties marked with the Triad MLS, Inc. icon are provided courtesy of the Triad MLS, Inc.'s, Internet Data Exchange Database. Data last updated September 25, 2026 1:47 AM UTC Show More...

The data relating to real estate on this web site comes in part from the Internet Data Exchange program of Hive MLS LLC, and is updated as of September 25, 2026 1:15 PM UTC All information is deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither listing broker(s) nor Costello Real Estate and Investment shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. © 2026 Hive MLS LLC Show More...