15058 FREDERICK ROAD
About This Property
Sometimes real estate deals don't come together for reasons unrelated to the home itself. This beautiful property is back on the market and ready for its next owner. Don't miss your opportunity to make this incredible home yours!
The Long and Winding Drive
A private retreat hidden from the everyday.
A long approach from Frederick Road creates a sense of anticipation rarely found in today's homes. Nestled on 3 private acres, partially wooded and hidden from passing traffic, this timeless colonial offers the privacy and tranquility of a country estate while remaining just minutes from Routes 97 and 70.
As the home comes into view, its welcoming front porch and picturesque setting hint at the exceptional living spaces that await inside.
Step inside and discover a home designed for both grand entertaining and comfortable everyday living. The dramatic two-story family room is the heart of the home, where a breathtaking waterfall of windows fills the space with natural light and showcases views of the surrounding property. Complementing the soaring ceiling is a spectacular floor-to-ceiling stone fireplace that serves as the room's striking focal point, adding warmth, character, and timeless appeal. A private library provides the perfect retreat for reading, working, or quiet reflection, while a graceful dual staircase adds both beauty and functionality, connecting the main living spaces with the private quarters above.
Upstairs, the primary suite offers a true owner's retreat, complete with a luxurious bath and an adjoining sitting room originally designed as an optional fifth bedroom. This versatile space is ideal as a nursery, fitness room, hobby room, or additional bedroom. A private en-suite bedroom offers comfort and privacy for family or guests, while two additional spacious bedrooms are served by a beautifully appointed hall bath, creating a comfortable and functional layout for everyday living.
The finished lower level offers exceptional flexibility with a bedroom, full bath, and generous living space ideal for extended family, guests, an au pair, or a future in-law suite. With its separate entrance, the possibilities are endless. Also found on this level is a custom temperature-controlled wine cellar with capacity for approximately 335 bottles. Behind its elegant glass-paneled door, this distinctive space was thoughtfully designed to preserve and showcase a prized collection under ideal conditions. Complete with a humidor, it is a rare and memorable luxury feature that adds both character and sophistication to the home's already impressive list of amenities. A cozy propane fireplace further enhances the lower level, creating an inviting atmosphere for entertaining or relaxing year-round.
Outdoor living is every bit as impressive as the interior. Two screened porches invite you to enjoy the changing seasons, while the expansive Trex deck provides the perfect setting for entertaining. The covered gazebo, complete with a fireplace, creates a warm and inviting gathering space for family and friends. A charming treehouse adds a touch of whimsy to the property, while the electrified barn/shed provides additional flexibility for hobbies, storage, or workshop space. Whether hosting large gatherings or enjoying a quiet evening under the stars, these outdoor spaces were designed to be enjoyed year-round.
Offering 5 bedrooms, 4 full and 1 half baths, timeless architectural details, remarkable entertaining spaces, and a setting that feels a world away from the everyday, this is more than a home-it's a destination.
The journey is worth it.
Payment Calculator
Your Estimated Monthly Payment
Cap Rate Calculator
What does this mean?
Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.
How much can I actually make?
Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.
How is cap rate calculated?
Cap Rate = Net Operating Income (NOI) / Property Asset Value.
When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.
Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.
Price History
| Date / Event | Date | Event | Price |
|---|---|---|---|
| Sep 1, 2026 | Sold | ||
| Sold | |||
| Jul 19, 2026 | In contract | - | |
| In contract | |||
| Jul 17, 2026 | Relisted | $1,200,000 | |
| Relisted | |||
| Jun 30, 2026 | In contract | - | |
| In contract | |||
| Jun 25, 2026 | Listed by RE/MAX Advantage Realty | $1,200,000 | |
| Listed by RE/MAX Advantage Realty | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017