Share By
Copy Link
Email
Text MessageListing Courtesy of Houlihan Lawrence Inc..914-591-2700
Photo Gallery
(1 of 33)
(1 of 33)
See all 33 Photos
Jerrin John
Copy LinkEmailText Message
ShareShare$799,000
Est. N/A/mo
500 Marietta Avenue
Hawthorne, NY, 10532
For Sale
500 Marietta Avenue
Hawthorne, NY, 10532
For Sale
4 Beds
4 Baths
Lot Size: N/A | House Size: 2451 sq.ft.
Overview
Step into this beautifully kept Colonial home that offers space, comfort, and convenience for every lifestyle. Located within walking distance to the train, town center, and shops, this home combines classic charm with modern amenities. The spacious and sunlit living room is perfect for relaxing or entertaining, while the elegant dining room sets the stage for memorable gatherings. The heart of the home features a stunning primary bedroom suite complete with a spa-like bathroom—a serene retreat at the end of the day. Upstairs, you'll find generously sized bedrooms and the convenience of second-floor laundry. The full basement with a separate entrance and provides incredible flexibility—ideal for a home office, playroom, or au-pair/multigenerational living. This is a must-see home where every detail has been thoughtfully maintained. Move right in and enjoy the best of suburban living with easy access to everything you need.
Property Type:
Single Family Residence
Year Built:
1920
Features
Total Bathrooms: 4
Full Bathrooms: 4
Half Bathrooms: 0
Details: "Wall/Window Unit(s)"
Garage Spaces: 1
Heating: "Baseboard"
Description: "In Hall"
Office Info
Listing Broker:
Houlihan Lawrence Inc.
Listing Agent:
Aileen P. Riordan
MLS Info
MLS #:
859579
MLS Name:
OneKey MLS
Status:
Active
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers' personal, non-commercial use. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of OneKey MLS.
Monthly Costs
$
$
20%
Optional
$
/mo
$
/mo
$
/mo
TOTAL
$3,431.36
/mo
Principal & Interest
$3,431.36
Property Taxes
$0.00
Other
$0.00
Homeowners Insurance
$0.00
HOA
$0.00
Licensed States
State: NY,
License: 10401390413
Licenses
© 2025 The Real Brokerage 2025. All Rights Reserved. Powered by Home Junction.
Consumer Alert: Real is committed to protecting consumers. In our continuous effort to protect all customers, we discovered a few cases of fraudulent and fake representations on Craigslist in various states for short term rentals using Real logo. We do not solicit payments for third parties on CL and urge you not to send any payments to publishers of such ads. Please always contact us to confirm agent affiliation.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers' personal, non-commercial use. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of OneKey MLS.
Listing Information © 2025 OneKey MLS. All Rights Reserved.
Listing Courtesy of Houlihan Lawrence Inc..
Real Broker, LLC
Licensed Real Estate Broker
Broker is licensed as “Real Broker, LLC” in the following U.S. states: Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming. View state licenses.
Broker is licensed as “Real Brokerage Technologies, Inc”, in the State of California, CA DRE #2022092. Office Address: 1420 Kettner Blvd. #100, San Diego, CA 92101
Broker is licensed as “Real Broker AZ, LLC in the State of Arizona.
Broker is licensed as “Real Broker CT, LLC in the State of Connecticut.
Broker is licensed as “Real Broker MA, LLC in the State of Massachusetts.
Broker is licensed as “Real Broker NH, LLC in the State of New Hampshire.
Broker is licensed as “Real Broker NY, LLC and Real Broker, LLC in the State of New York.
Broker is licensed as “Real Brokerage Technologies, Inc.” in the State of Ohio.
Broker is licensed as “Real Broker Commercial, LLC” in the states of Maryland, North Carolina, New Jersey, New York, South Carolina, Virginia and the District of Columbia.
State/Province Office Addresses:
- AL - 1 Chase Corporate Center, Suite 400, Birmingham, AL 35244 - Connie Alexander - DB
- AK - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Jacob Sebring - Designated Broker
- AB - 1816 Crowchild Trail NW, Suite 700, Calgary, AB T2M 3Y7 - Tyrel Laqua - DB
- AZ - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Courtney Yant - DB
- AR - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Rachel Vann - Designated Broker
- BC - 666 Burrard St, Suite 500, Vancouver, BC V6C 3P6 - Adrian Langereis - RB
- CA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Jason Lopez
- CO - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - David Mathewes - DB
- CT - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Justin Mandese
- DE - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - David Sordelet - DB
- DC - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Dave Kolakowski - Designated Broker
- FL - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Rebecca Redman-Hamaoui - Designated Broker
- GA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Steve Freeman - DB
- HI - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - David Lundstrom
- ID - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Gerald Dalton - Designated Broker
- IL - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - John Barnak III - Firm #471019889 - License #471019889 - ilbroker@therealbrokerage.com - 217.960.8605
- IN - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Drew Dial - Designated Broker
- IA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Timothy Scott Lucken
- KS - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Wayne A Gray-Designated Broker
- KY - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Andrew Pruitt
- LA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Wendy LeBlanc - Designated Broker
- ME - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Julie Perrino - Designated Broker
- MB - Suite 300, 330 St. Mary Avenue, Winnipeg , MB R3C 3Z5 - Cassandra Zwiers
- MD - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Dave Kolakowski - Designated Broker
- MA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Jeffrey Winston Hall - Designated Broker
- MI - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Angela Hyde - DB
- MN - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Travis Michael Sabby - Designated Broker
- MS - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Aritt Davis - Designated Broker
- MO - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Nicci Fears - DB
- MT - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Courtney Foster
- NE - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Laura Jo Eisenmenger - DB
- NV - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Bryan Jones - Designated Broker
- NH - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Julie Perrino - Designated Broker
- NJ - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Robert Eric Axelson
- NM - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Cassandra D Morrison - DB
- NY - 477 Madison Ave, Ste 648, New York , NY 10022 - Todd Stevens - NY Designated Broker
- NC - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - LaDonna Drake - Designated Broker
- ND - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Josh Boschee - Designated Broker
- OH - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Nicole Ward - DB
- OK - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Brice Taylor
- ON - 130 King Street West, Suite 1900, Toronto, ON M5X 1E3 - Lori Ann West - DB
- OR - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Jason Walchli - Designated Broker
- PA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - William Ryan - Designated Broker
- RI - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Justin Mandese
- SC - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Ashley Eller - DB
- SD - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Andrea Simunek
- TN - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Tina Baker - Designated Broker
- TX - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Michael Yarrito - Designated Broker
- UT - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Dawn Yvette Stevens - DB
- VT - 39899 Balentine Dr, 200, Newark, CA 94560 - Sandy Reavill- Designated Broker
- VA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Dave Kolakowski - Designated Broker
- WA - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Dan Pehlke - DB
- WV - 39899 Balentine Dr, 200, Newark, CA 94560 - Bernard Pudimott
- WI - 39899 Balentine Dr, Suite 200, Newark, CA 94560 - Dan Dyslin - Designated Broker
- WY - 39899 Balentine Dr, Suite 200, Newark, WY 94560 - JP Fluellen - Designated Broker
Texas Real Estate Commission Information About Brokerage ServicesTexas Real Estate Commission Consumer Protection Notice
New York State Fair Housing NoticeNew York State Standard Operating ProceduresNew Mexico Real Estate LicensesIllinois Real Estate Licenses
State Brokerage Licenses: NY : 10991228639
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 owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.