44
Map
574 Camillo Road
About This Property
Listed By
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 10, 2026 | Listed by COMPASS | $2,998,000 | |
| Listed by COMPASS | |||
| Apr 15, 2025 | Listed | $3,345,000 | |
| Listed | |||
| | |||
|
Welcome to this magnificent Mediterranean-style custom estate -- a rare gem nestled in the heart of Sierra Madre.As you enter through the impressive 8.5ft custom iron and glass double doors, you're greeted by a high-ceilinged entryway. The foyer leads into the heart of the main level: a chef's dream kitchen with an 8-burner Viking stove, built-in refrigerator and Sub-Zero wine cooler.Open to the eat-in kitchen is the living room, complete with a wood-burning fireplace and bespoke built-in cabinetry for television and immersive sound AV components.The formal living room features a second wood-burning fireplace with a distinctive marble mantle. This elegant space flows into the formal dining room. The high ceilings throughout contribute to the grand and airy feel.The first floor also includes a guest suite, a powder room, and a versatile bonus room.Ascend the grand, curved staircase to the home's upper level. There, you're welcomed by a stunning custom library with vaulted and beamed ceilings with two built-in Spanish-style desks. The curved balcony just outside the library offers sweeping views of city lights, treetops, and mountains.The primary suite - also with vaulted ceilings - serves as a retreat, featuring a walk-in dressing room with double doors leading to an en-suite bath. The primary bath boasts a Kohler jetted tub, a large rain shower, and a Toto Washlet. The suite also opens to a private balcony.Upstairs you'll also find a private home gym, complete with yet another balcony. Two additional bedrooms with walk-in closets, a full bathroom with double vanities, and a generous laundry room complete the upper level.The park-like backyard is an entertainer's dream. The outdoor space features a full outdoor kitchen with a Twin Eagles gas grill, and a Fornetto wood-burning pizza oven. A gas fireplace sits beneath a canopy with 36 solar panels, which help power the home and charge the two Tesla backup batteries.The terraced side yard is lined with several types of fruit-bearing trees, while the opposite side yard contains a boxed herb garden.Additional highlights include 2 HVAC units, 2 tankless water heaters, 2 LifeSource whole-house water filtration systems, 2 220 EV charging outlets located in the 3-car garage, recreational vehicle parking, 6 cam CCTV system, central vacuum and a multi-zone Sonos sound system.Don't miss this rare opportunity to own a truly one-of-a-kind estate in beautiful Sierra Madre.
| |||
Property Highlights
Building Info
Comparables
Status
Price/ft²
Listed On
Sold On
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017