Gretchen A. Loomis
Licensed Associate Real Estate Broker & Branch Manager
Accredited Buyer Representative, Certified Real Estate Brokerage Manager, Coldwell Banker Diamond Society, Coldwell Banker Multi-Million Dollar, Coldwell Banker Premier Office, Equal Housing Opportunity, Realtor, Year round homes, Starter homes, Camps, Seasonal cottages, Small farms, NYS canal area, Streams, Oneida Lake, Rivers, Acreage, Fish Creek, Commercial properties, Older homes and New construction, REALTOR®
Sylvan Beach, NY
Property Description
The Crown Jewel of Philipse Manor. Set within the storybook charm of coveted Philipse Manor, this extraordinary 1910 Six Bedroom Colonial is a rare offering-where historic elegance and modern refinement exist in perfect harmony. From the moment you arrive, the home's presence is undeniable. A gracious 12-foot-deep rocking chair porch, framed by stately fluted columns, invites quiet mornings and golden-hour evenings, setting the stage for what lies within. Step through the sun-drenched formal entrance and into a world of timeless beauty. Soaring 11-foot ceilings, luminous blond oak floors, and four fireplaces create an atmosphere that is both grand and deeply inviting. Each space unfolds with intention, balancing architectural integrity with effortless livability. At the heart of the home, the chef's gourmet eat-in kitchen is as functional as it is beautiful-thoughtfully designed for gathering and entertaining. Expansive workspaces, a walk-in pantry, and seamless flow into the main living areas make it the true centerpiece of daily life. A well-appointed mudroom adds a layer of modern convenience. Private quarters offer a serene escape. Marble-clad bathrooms with heated floors evoke a spa-like indulgence, while the primary suite is a sanctuary unto itself-complete with a 10x12 dressing and sitting room, ideal for quiet moments. Outdoors, the beautifully landscaped grounds create a picturesque backdrop for both relaxation and entertaining, adding to the home's exceptional curb appeal. It's perfect for hosting large gatherings both inside and out. Beyond the main residence, a detached garage with a private studio or home office and bathroom above offers endless flexibility-perfect for remote work, guests, or creative pursuits. Perfectly positioned at 150 Harwood, just moments from the Hudson Riverwalk, Metro-North train, and the exclusive Beach & Boat Club, this home delivers a lifestyle defined by both tranquility and connection-only 38 minutes from the heart of New York City. This is more than a home-it is a legacy property, offering timeless beauty, modern luxury, and an unparalleled Rivertowns lifestyle.
150 Harwood Avenue | MLS# 981678
This single family home located at 150 Harwood Avenue, Sleepy Hollow, NY 10591 is currently listed for sale with an asking price of $2,500,000. This property was built in 1913 and has 6 bedrooms and 4 full and 2 partial baths with 4925 sq. ft. Harwood Avenue is located in the Philipse Manor subdivision within the Union Free School District Of The Tarrytowns school district. Search Philipse Manor real estate on gretchen-loomis.coldwellbankerprime.com today.
Gallery
Property Features
Property Type: Residential - Single Family
Basement: Yes
Basement: Finished, Full, Partially Finished, Storage Space
Cooling: Central Air
Fireplaces: 4
Garage: 2
Heating: Hot Water, Natural Gas, Radiant, See Remarks, Radiant
Home Style: Colonial
Lot Size: 0.33 Acres
Taxes: $52,382
Year Built: 1913
Amenities
Breakfast Bar
Built-in Features
Chefs Kitchen
Crown Molding
Double Vanity
Eat-in Kitchen
Entertainment Cabinets
Entrance Foyer
Formal Dining
High Ceilings
His and Hers Closets
Marble Counters
Natural Woodwork
Original Details
Pantry
Primary Bathroom
Quartz/Quartzite Counters
Recessed Lighting
Stone Counters
Storage
Walk-In Closet(s)
Fire Pit
Garden
Lighting
Mailbox
Feature Descriptions
Appliances: Dishwasher, Dryer, Gas Range, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer
Attic: Finished, Storage, Unfinished
Building Area Total: 4925
Community Features: Curbs, Other, Sidewalks
Days on Site: 4
Exclusions: See Agent to Agent Remarks
Exterior: Stucco
Fireplace Features: Bedroom, Family Room, Gas, Living Room, Wood Burning
Fireplace Y/N: Yes
Flooring: Carpet, Ceramic Tile, Combination, Hardwood, Tile, Wood
Formal Dining: Yes
GarageY/N: Yes
Heating Zones: 3
Hot Tub: Yes
Inclusions: Range, Refrigerator, Dishwasher, Washer, Dryer, Light Fixtures, Hot Tub
Laundry: Laundry Room
Number Of Kitchens: 1
On Market Date: 2026-04-20
Other Structures: Garage(s), Outbuilding, Workshop
Parcel Number: 3401-110-019-00002-052-0000
Parking Features: Detached, Garage, Storage
Patio And Porch: Covered, Patio, Porch, Wrap Around
Rental Term: Monthly
Rooms Total: 14
Sewer: Public Sewer
Special View Info: Neighborhood, Trees/Woods
Utilities: Sewer Connected, Water Connected
Water: Public
Local Schools
High School: Sleepy Hollow High School
Middle School: Sleepy Hollow Middle School
Elementary School: Washington Irving Interm School
School District: Union Free School District Of The Tarrytowns
TOUR THIS HOME
150 Harwood Avenue, Sleepy Hollow, NY 10591
I will get in touch with you shortly.
Estimate Your Payment
Estimated Payment
$ 10,658.25 per month $5,563.92 Principal & Interest $4,365.17 Property Tax $729.17 Homeowner's InsuranceChange Payment Information
Demographics
Listed By / Shown By
Listing By
Agency Name: Corcoran Legends Realty
Agency Contact: 914-332-6300
Shown By
Agent Name: Gretchen A. Loomis
Agent Phone: (315) 264-3548 Cell
Agency Title: Coldwell Banker Prime Properties
SHARE THIS HOME
![]()
![]()
![]()
150 Harwood Avenue, Sleepy Hollow, NY 10591
Send an email with a link to
150 Harwood Avenue, Sleepy Hollow, NY 10591.
Print This Listingx
Select a format below, new window will open and will prompt you to print.
Gretchen A. Loomis Licensed Associate Real Estate Broker & Branch Manager
Office: (315) 762-4032
Cell: (315) 264-3548
Fax: (315) 762-4070
Email: gretchen.loomis@coldwellbankerprime.com
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.
Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information
Coldwell Banker®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --