Available Listings

$1,875,000
Pending

Sleepy Hollow Area Single Family Home

Pending

126 Millard Avenue Sleepy Hollow, NY 10591

4 Bed
3 Baths
3219 sqft
MLS# 878369
Welcome to this beautifully updated and meticulously maintained Tudor-style home nestled in the highly sought-after Philipse Manor neighborhood. With 4 BRs, 2.5 baths, and 3,200+ sq.ft. of living space, this spacious and sunlit home effortlessly blends timeless charm with modern comfort. An elegant stone walkway leads to the inviting front entry and gracious foyer, setting the tone for what’s inside. Rich oak floors run throughout, complemented by arched doorways, wood-beamed ceilings and classic architectural details. The heart of the home is a renovated, open-concept kitchen with a large center island which flows seamlessly into a stunning all-season sunroom. Upstairs, the serene and spacious primary suite includes a custom closet system and sleek, spa-like bathroom with heated floors and a deep soaking tub. Three additional BRs offer flexibility, abundant natural light, and a shared updated full bath with heated floors. The finished lower level adds nearly 1,500 sq. ft. of versatile space suitable for any number of uses. Outside, enjoy landscaped front and back yards, stone terraces perfect for dining al fresco, and a detached 2-car garage. All of this just two blocks from the Philipse Manor Beach Club—offering beach access, boat slips, and breathtaking Hudson River sunsets—and moments to the Metro-North express train to GCT. Truly a rare blend of elegance, space, location, and lifestyle *Some photos have been virtually staged*
Listing by: ONEKEY / ERA Insite Realty Services
$1,875,000
Contingent

Chicago Area Multi-Family Home

Contingent

3042 W Palmer Boulevard Chicago, IL 60647

7 Bed
5 Baths
sqft
MLS# 12440115
Virtual Tour
Experience elevated living and exceptional income potential with this meticulously gut-rehabbed two-flat, ideally positioned on one of Logan Square's most coveted tree-lined streets, facing the 7-acre Palmer Square park. Situated on an extra-wide 50-foot Chicago lot, this property offers unmatched curb appeal, expansive outdoor space, and premium finishes throughout. The first-floor duplex-down lives like a luxury single-family home, featuring 4 bedrooms and 3 baths. An expansive open-concept living and dining area flows seamlessly into a chef's kitchen adorned with custom cabinetry, quartzite countertops, high-end stainless steel appliances, and designer lighting. From the living area, step onto an oversized deck designed for both intimate conversations and outdoor dining. The deck spills down to a professionally landscaped yard featuring a paver patio, pergola, and gas fire pit. The main level also includes a serene primary suite with a spa-like bath and private terrace overlooking the park, an additional bedroom/office, and full bath. The lower level offers a spacious family room, two bedrooms, and a full bath, perfect for entertaining, guests, or multi-generational living. Radiant heat flooring in the lower level. The second-floor residence features 3 bedrooms and 2 baths, a bright, airy open concept layout with hardwood floors, a gourmet kitchen, modern fixtures, and a covered porch facing the park. Perfect for generating strong rental income or hosting extended family, this unit matches the craftsmanship and attention to detail of the home below. Additional highlights include 2 garage parking with EV charger + carport off Palmer, and a prime location just moments from Logan Square's renowned dining scene, boutiques, parks, and convenient transit. This is a rare opportunity to own a turnkey luxury property that blends elegance, functionality, and one of the city's most desirable addresses.
Listing Courtesy of Midwest Real Estate Data / Mark Allen Realty ERA Powered