13405 QUERY MILL ROAD
About This Property
Elegance Abounds: A Custom Contemporary Oasis on lush 3+ Acres
Step into luxury with this magnificent 2024-built, 5BR, 5.5BA, 4-car garage dream home showcasing modern design and the finest conveniences. Nestled on over 3 acres of lush landscaped grounds, this stately 5,435 above grade sq ft brick and hardie siding showstopper boasts endless upgrades and thoughtful touches on a serene wooded lot.
Upon entering, the grand FOYER welcomes with triple crown molding, a sparkling chandelier, and a sweeping staircase. 10' ceilings, oversized energy efficient windows, and high-end Mohawk waterproof Revwood flooring throughout the home add to the luxurious atmosphere. Off the foyer, French doors lead into a private OFFICE or library, with built-in shelves, generous windows, and detailed wood trim. Perfect for hosting, the formal DINING ROOM features tray ceilings, recessed lighting, two chandeliers, and built-in speakers. A circular hallway leads to the expansive FAMILY ROOM, where 20-foot coffered ceilings and a stunning Palladian window fill the space with light and a view of your private forest. A cozy gas fireplace, flanked by custom shelves, adds warmth and charm to the room.
A chef's dream, the gourmet KITCHEN boasts a seamless suite of flush-mounted high-end Professional GE Cafe appliances including TWO SINKS, TWO DISHWASHERS, sleek cabinetry dual islands, undercounter beverage center, 48" range with wok burner and flat top griddle, quartz countertops and 4 ovens. Adjacent to the kitchen is a bright BREAKFAST ROOM and a charming screened-in PORCH that overlooks the property, complete with a second gas fireplace, high-end Trex flooring, panoramic views of the 3+ acres, and all the amenities for outdoor entertaining-including a 9 ft glass accordion door, propane hookups for additional heating during cooler months and wiring for outdoor speakers.
A separate BAR area with wine fridge and DUAL MUDROOM with built-in storage for shoes, jackets and gear offer ultimate convenience. An additional walk-in coat closet provides plenty of extra storage. The home also boasts two separate two-car garages (four spaces in total), each with barn-style doors, openers, and ample space, electric car charging, including one garage with extra length to accommodate 2 larger vehicles. A GUEST SUITE with an adjacent full bath completes the first level.
Upstairs, luxury continues with 9-foot ceilings and an open landing with a balcony that overlooks the family room. The spacious PRIMARY SUITE is a private retreat, featuring French doors leading to both the bedroom and a separate sitting area. With a tray ceiling, recessed lighting, and abundant natural light, this suite offers a serene escape. The spa-like EN SUITE BATHROOM includes a massive double shower with dual rain heads, a soaking tub framed by windows, a double vanity, and a separate water closet. The expansive walk-in closet completes this luxurious space.
Three secondary bedrooms each offer en-suite baths, walk-in or double-door closets, and custom details like mosaic or ceramic tile flooring. The upstairs laundry room is equipped with top-of-the-line front-loading washer and dryer, and includes base and wall cabinets, quartz countertops, large SS sink and pull down faucet.
Another 2,782 of unfinished SF walk-out basement with 9' ceilings, large windows and multiple glass doors awaits for a dream entertainer's haven with endless possibilities. Insulated and partially framed, with a 100 amp basement sub panel, it's ready for customization.
More highlights include full house generator wiring and hookup, architectural uplighting system, propane heating system & hot water heater, a lawn irrigation system, and safe, clean well water from a 600 ft deep, high capacity, 12 gallon per minute well, filtered with UV, carbon iron, and charcoal systems.
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 |
|---|---|---|---|
| Jun 19, 2025 | Sold | ||
| Sold | |||
| May 18, 2025 | In contract | - | |
| In contract | |||
| May 15, 2025 | Price Decreased |
$2,090,000
↓ $160K
(7.1%) | |
| Price Decreased | |||
| Apr 10, 2025 | Listed by Long & Foster Real Estate, Inc. | $2,250,000 | |
| Listed by Long & Foster Real Estate, Inc. | |||
| Feb 9, 2021 | Sold | ||
| Sold | |||
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017