Crest Gardens, Mayfair, Signature Real Estate

MLS® Disclaimer

Based on information from California Regional Multiple Listing Service, Inc. as of September 24, 2026 6:30 PM UTC This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.

Based on information from September 24, 2026 6:30 PM UTC The information being provided by CRMLS is for the visitor's personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CRMLS, CLAW, i-Tech MLS, PSRMLS and/or VCRDS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.

Any property information referenced on this website comes from the Internet Data Exchange (IDX) program of CRMLS. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

Last updated: September 24, 2026 6:04 PM UTC Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. The data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than Land Concepts are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents. The information being provided by CARETS (CLAW, CRISNet MLS, DAMLS, CRMLS, i-Tech MLS, and/or VCRDS) is for the visitor's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. Any information relating to a property referenced on this web site comes from the Internet Data Exchange (IDX) program of CARETS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. The accuracy of all information, regardless of source, including but not limited to square footages and lot sizes, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals. The data contained herein is copyrighted by CARETS, CLAW, CRISNet MLS, DAMLS, CRMLS, i-Tech MLS and/or VCRDS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. CARETS, California Real Estate Technology Services, is a consolidated MLS property listing data feed comprised of CLAW (Combined LA/Westside MLS), CRISNet MLS (Southland Regional AOR), DAMLS (Desert Area MLS), CRMLS (California Regional MLS), i-Tech MLS (Glendale AOR/Pasadena Foothills AOR) and VCRDS (Ventura County Regional Data Share) Show More...

© 2026 Fresno Association of REALTORS ®. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings held by brokerage firms other than Land Concepts are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Show More...

All measurements and all calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data maintained by MetroList© may not reflect all real estate activity in the market. All real estate content on this site is subject to the Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination. MetroList CA data last updated: September 24, 2026 6:06 PM UTC Terms of Use. Vendor data provided by Inside Real Estate, LLC.

Tulare County Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than Land Concepts may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 All rights reserved. Last Updated: September 24, 2026 6:30 PM UTC Show More...

Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended.Kings County Board of REALTORS® Copyright ©2026 All rights reserved. Last Update: September 24, 2026 6:00 PM UTC

Information deemed reliable, but not guaranteed. Copyright Golden Empire MLS, Inc. 2026 Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited.