Refine Search
Sort by
$4,500,000
5 Beds 7 Baths 950756 MLS
1906 Grandeur. 2026 Luxury: The Ultimate Gated Sanctuary. Perched majestically atop a private hilltop, this gated 7,800-square-foot, five-bedroom estate presents a rare convergence of Gilded Age prestige and contemporary luxury. Believed to have been commissioned in 1906 for railroad magnate A.H. Smith, the residence has been masterfully renovated to honor its historic soul, featuring original interior stone walls and soaring ceilings that strike a perfect balance between grand scale and intimate warmth. Anchored by three distinctive hearths, the home is designed for both elegant living and everyday ease. A sun-drenched chef’s kitchen showcases a central island, dramatic overhead skylight, and professional-grade appliances. Unique architectural moments—including a circular-skylit Stargazer’s Nook—add character and charm, while the versatile five-bedroom layout offers both a magnificent two-story primary wing and a coveted first-floor private suite. Set on more than four exceptionally private acres, the grounds unfold as a true outdoor sanctuary, featuring a beautiful pool and spa (32x20), refined pergola terraces ideal for entertaining, and a private tennis court. From its commanding hilltop position, the estate delivers an unparalleled sense of privacy, security, and timeless elegance. Welcome home!

150 Old Farm Road N, Chappaqua

$4,500,000
963382 MLS
Prime fully occupied mixed-use investment opportunity in the heart of Jackson Heights. 82-09 Roosevelt Avenue is positioned along one of Queens’ most active commercial corridors, offering exceptional visibility, consistent foot traffic, and immediate access to the 7, E, F, M, and R subway lines. Situated on a 20’ x 100’ lot, this 3,560 square foot building is configured for optimal income production and is currently 100% occupied, providing stable in-place cash flow. The property is zoned C4-3 / R6, allowing for a wide range of commercial and residential uses, making it attractive for both long-term hold investors and future redevelopment potential. Located in a dense residential and retail neighborhood surrounded by national tenants and established local businesses, the asset benefits from strong demographics and sustained demand. The offering generates a 4.3% cap rate, delivering reliable returns in a high-barrier-to-entry New York City submarket. Excellent opportunity for investors seeking a stabilized asset in a prime Roosevelt Avenue location with long-term upside potential.

82-09 Roosevelt Avenue, Jackson Heights

$4,500,000
PACE2517188 MLS
322 Self Storage offers a strong, stabilized investment opportunity in Centre County, located at 138 Yearicks Boulevard, Centre Hall, PA. The property is 79% occupied and delivers reliable in-place income with a current 6.4% cap rate, plus long-term value-add potential. The 35,850 SF, 216-unit facility was built in 2005 and features wide drive aisles, multiple access points, an on-site office, fenced grounds, security cameras, and excellent exterior lighting. Positioned directly off Highway 322, the property benefits from high visibility and illuminated signage seen by over 14,000 vehicles daily. Situated on 8.34 acres, the site includes significant excess land with permitted expansion opportunities, allowing a new owner to diversify income streams rather than relying on a single use. Future development options include additional self-storage, industrial storage, automotive storage, or even select retail uses, offering flexibility and downside protection. Located just 8.7 miles from State College and Penn State University, the property benefits from a built-in customer base of students, faculty, and staff. More than 116,000 residents within a 10-mile radius further support consistent demand. This is a rare opportunity to acquire a high-occupancy, income-producing asset with multiple paths for growth and diversification in a prime Centre County location.

138 Yearicks Blvd, Centre Hall

$4,500,000
PAPH2559042 MLS
Exceptional opportunity to acquire a 24-unit residential portfolio throughout the Northeast Philadelphia corridor, with the flexibility to purchase the entire package, buy in neighborhood blocks, or purchase individual properties. One unit may be sold separately depending on offer strength. Northeast Philly Portfolio (2) The portfolio spans several of the city’s strongest rental submarkets, including Mayfair, Oxford Circle, Frankford, Tacony, Lawncrest, and West Philadelphia. These areas are known for long-term tenant stability, consistent rent demand, strong appreciation trends, and low vacancy rates. The mix includes performing rentals, month-to-month tenants, and select vacant or value-add units, giving investors immediate income along with clear upside through turnover, rent increases, and light repositioning. Current rents across many properties remain below market due to long-term tenancy. This creates significant room for rent growth once units are brought to market levels or re-leased. The stabilized portfolio projects an estimated 8–10% cap rate, with additional built-in equity available at acquisition. Management can remain in place for a seamless transition if desired. This offering is suitable for cash buyers, conventional investors, DSCR financing, private lending, and potential seller financing. Exterior drive-by showings are allowed; interior access will be coordinated after an accepted offer to respect tenant privacy. A rare chance to secure substantial cash flow, appreciation, and scalable management efficiency across one of Philadelphia’s most resilient and high-demand rental markets. See Documents For Proforma. Full rent rolls, ledgers, photos, and the offering memorandum are available upon request.

6066 E Roosevelt Blvd, Philadelphia

$4,500,000
PAMC2161600 MLS
Exceptional multi-use property offering a rare combination of industrial, agricultural, equestrian and residential assets across 47+ acres. The site features a 3-acre contractor facility with a 5,000 SF and 2,000 SF garage, 2 acres of outside storage and a 2,400 SF home. Adjoining the contractor facility is the 44-acre “Our Farm” property, featuring a 45,000 SF clear-span indoor riding ring currently leased to a quality tenant, providing immediate income with the flexibility for future owner occupancy. This parcel also features 2 houses, including the original farmhouse which has 7 bedrooms, and 6,600 SF with the latest addition constructed in 1992. Additionally, there’s 2 apartments, 5 barns, outdoor riding ring, 2 acre parking lot and a +/- 130 horse stalls. There’s also 110 acres available for lease, if necessary. Great location near Blue Bell in Montgomery County with scenic views of the Philadelphia skyline and quick access to Routes 76, 476, 73, and 202. Asking $4,500,000. Call for more info.

1628 Berks Rd, Norristown

$4,500,000
931988 MLS
Douglas Elliman Commercial proudly presents 1001 Scott Avenue, Calverton — a planned Class A industrial development offering approximately 70,445 SF of premium warehouse space on 10.07 acres within a future industrial park. Designed for modern efficiency and scalability, the proposed facility features 38’ clear ceiling heights, 52' x 50' column spacing, and permitted outdoor storage, ideal for logistics, manufacturing, or distribution operations. Strategically located near I-495, NY-27, and NY-25, this property provides seamless access to the East End, Hamptons, and New York City markets. Plans are currently in the municipal approval phase. Notably, 1001 Scott Avenue is exempt from the Riverhead Town Board’s 2024 moratorium on industrial development outside the Calverton Enterprise Park, allowing this project to move forward without restriction. Highlights: Planned Class A industrial warehouse (approx. 70,445 SF) on 10.07 acres, 38’ clear ceiling heights and 52' x 50' column spacing, Permitted outdoor storage, Strategic East End location with NYC accessibility, Exempt from current industrial development moratorium

1001 Scott Avenue, Calverton

$4,500,000
918115 MLS
Welcome to the historic Friar Tuck Inn. Catskills Home Services is pleased to offer this exciting and unique opportunity to purchase and bring back to life this classic gem in the heart of The Catskills. This sale includes three adjacent parcels with a total of 170+ acres offering hiking trails, ponds, and streams. The resort and convention center, originally built in the 1970’s, needs a complete renovation. The hotel was built with a medieval motif offering over 370 guest rooms, more than 50,000sf of convention center space, and parking for nearly 1,000 vehicles. There are indoor and outdoor pools, conference rooms, banquet facilities, a massive garage, and a few smaller buildings, including some that housed time-share units. With well over 300,000sf of space, this former hotel is ready for new owners with a vision to bring it back to its former glory. The hotel sits on a 29.60-acre parcel zoned Commercial One. The second parcel (226 Mountain Turnpike Road) is a commercial lot with 60.16 acres that houses the 7,280sf auto body shop. The third parcel (61 Paul Saxe Road) is a vacant 80.70-acre lot zoned Residential. Possible uses for this site include Hotel, Summer Resort, Wellness Retreat, Housing Development, Retail, Recreational Facility and similar uses. Greene County and nearby Ulster County have been booming for the past few years; there is so much potential here! The property is located in a prime location within the Greene County Catskills, less than an hour from Hunter Mountain, Windham Mountain, and Belleayre Mountain Ski resorts. Surrounded by mountains, waterways, hiking trails and the best outdoor entertainment that the Catskills has to offer, this site is long overdue for a revival on a grand scale. Contact us today for more information.

4858 Route 32, Catskill

$4,500,000
6 Beds 8 Baths VAFX2274078 MLS
Green Building Group presents 1471 Waggaman in Salona Village—a stunning new transitional residence to be built in one of McLean’s most desired and convenient locations. Prominently sited on a .34-acre lot, this elegant home offers approx. 8,070 finished square feet on three levels with 6 bedrooms, 7 full bathrooms, and powder room, plus a three-car side-load garage. Oversized windows fill the home with natural light, complementing the 10-foot ceilings and wide-plank white oak floors throughout the main level. The gourmet kitchen features custom cabinetry, quartz countertops, high-end appliances, optional second island, and a convenient prep kitchen/pantry. The family room with an amazing gas fireplace and travertine mantel opens to an expansive patio, ideal for indoor-outdoor entertaining. A formal dining room, living room or study, guest suite with full bathroom, Family Lounge with cathedral ceilings, gas fireplace and screen porch completes the main level. Upstairs, the luxurious primary suite with cathedral ceilings includes spacious oversized walk-in closets, a spa-inspired bathroom, separate his and her washrooms, soaking tub, and a glass-enclosed shower with bench. Optional private deck. Three additional en-suite bedrooms, and laundry room complete the upper level. The walk-up lower level is designed for entertainment and flexibility, offering a large recreation room with modern wet bar, fitness or opt. golf simulator room, full bathroom, opt. sauna room, guest bedroom/bath, and storage. An elevator shaft is included for future elevator installation. Located just minutes from downtown McLean’s shops and restaurants, this exceptional home is scheduled for delivery in Fall Winter 2026. Interior photos shown are from recently completed Green Building Group projects. **Private swimming pool is available** Still time to customize and choose your finishes.

1471 Waggaman Cir, Mclean

$4,500,000
7 Beds 10 Baths VAFX2269678 MLS
To Be Built - Builder can customize to buyers taste at this time. Currently addressed as 1313 Ingleside Avenue presents a rare opportunity to own a brand-new luxury residence in the heart of McLean, blending timeless architectural elegance with modern craftsmanship. This striking stone-and-stucco transitional Tudor showcases a façade of South Bay building stone and Boral True Exterior trim, accented by black standing-seam metal details and 30-year architectural shingles. A welcoming motor court and asphalt driveway lead to a three-car garage and natural cleft flagstone walkways and patios, all surrounded by thoughtful plantings and a screened porch with motorized panels for year-round enjoyment. This home features seven bedrooms, seven full bathrooms, and two half bathrooms, boasting an open floor plan with numerous luxurious amenities. The main level includes an expansive family room that seamlessly connects to a large screened-in porch, creating an ideal space for indoor/outdoor living and entertaining. The gourmet kitchen is complemented by an additional service kitchen, perfect for catering or large gatherings. Upstairs, you'll find five bedrooms, each with an en suite bathroom. The primary suite features a "his and hers" style bathroom, adjoined by a spacious shared shower, and expansive walk-in closets. For convenience, there are two laundry rooms in the home (one on the main level and one upstairs). The basement level offers a private en suite bedroom, a separate powder room, a wet bar, and a versatile lounge/recreation room with a walk-up exit. This level also includes a dedicated space for an optional home theater or golf simulator. Additionally, the home will be equipped with an elevator. The location provides easy access to McLean Central Park, McLean Library, McLean Community Center, Restaurants, all of the downtown McLean conveniences, only 1.7 miles to the McLean Metro Station and less than 14 miles to two airports!

6911 Elm St, Mclean

$4,500,000
5 Beds 8 Baths MDBA2183508 MLS
Live authentically. Charlcote House. The James Swan Frick House, a monumental brick Classical Revival masterpiece by storied architect John Russell Pope, stands as one of Guilford’s most distinguished estates. Built between 1914 and 1916. Magnificent interiors steeped in history, thoughtfully reimagined by AD100 designer, Mark D. Sikes. A rare harmony of preservation and renewal. Artisanal architectural details that are inimitable. Charlcote House is an estate to be experienced. Marvel at the serenity and delight that you will experience within the walled gardens and ornamental fencing offering panoramic views of the city lights. Enter the luminous foyer with distinct marble floors and a sweeping staircase that sets the stage for revelry and repose. A chef’s kitchen where dinner parties come alive, and every detail elevates the joy of culinary artistry and effortless entertaining. The mahogany-paneled library, rich in texture and timeless detail, provides a sanctuary for reading and reflection. An elegant dining room provides a grand and gracious setting. Every meal is a celebration surrounded by divine wallcovering. Every gathering is unforgettable. Six remarkable fireplaces. Savor the warmth of the sun-filled conservatory. The primary suite is a serene sanctuary with indulgent bath, intimate lounge area, and signature curved wall of windows framing tranquil views. Unrivaled dressing rooms. Finished third floor is a modern loft style sanctuary with state of the art gym. Grand wrap around terrace. Inspiring top floor space for work, play or wellness. Light and joy abound. Meticulously landscaped grounds, sculpted gardens, and sweeping city vistas. Relish alfresco dining beneath the stars and quiet moments amid sculpted greenery. Hidden brick courtyard that is quite compelling. Detached brick building/garage with much potential. Xfinity Internet. Elevator. Cultivate your existence. The art of uniting human and home. Listed on the National Register of Historic Places Buyer to provide proof of ability to purchase prior to showing.

15 Charlcote Pl, Baltimore

$4,500,000
MDCH2046662 MLS
Prime Commercial Opportunity in Waldorf, MD! Discover the potential of 2215 Pinefield Station, Waldorf, MD 20601 — an expansive 20,488 sq. ft. commercial campus that includes 3 buildings with 6 units, strategically located in one of Southern Maryland’s fastest-growing corridors. Positioned just off MD-5 (Branch Avenue) with direct access to the Capital Beltway, this property offers exceptional visibility, accessibility, and adaptability for a wide range of businesses. Built to accommodate flexible commercial use, the building features: - Expansive floor plan ideal for retail, medical, office, or mixed-use. - Ample parking to support high customer traffic and employee convenience. - High-growth market location, drawing from Waldorf’s strong residential base and regional traffic. Waldorf is one of Maryland’s leading retail and business hubs, with a growing population and robust consumer demand. Situated minutes from Washington, D.C., Alexandria, and Northern Virginia, this property provides businesses with the reach of the D.C. metro market at a fraction of the cost. Whether you’re an owner-occupant seeking a signature location, a developer looking for a high-demand asset, or an investor pursuing strong long-term returns, 2215 Pinefield Station presents a rare and valuable opportunity.

2215 Pinefield Station Rd, Waldorf

$4,500,000
5 Beds 8 Baths 860682 MLS
Incredible price reduction! Incredible Value! For the Discerning Client who seeks only the Finest....Welcome to 8 Vista Lane in Brookville--where Timeless Design and Bespoke Materials are blended to create this Sophisticated Modern Luxury. A Grand Courtyard leads to the Entrance of this Spectacular Private Estate. The Tone is set as Guests are greeted in the Breathtaking 30'high Domed Circular Reception Gallery adorned with Magnificent Crystal Chandelier, Stunning Marble Floors, Marble Fireplace, Intricate Plaster Moldings & Delicately Hand Painted Gold Leaf Wall Accents. Grandeur continues to an Elaborate Formal Living Room with Mahogany Floors, Shimmering Designer Textured Walls, Built-In Bar/Wine Cabinet, French Marble Fireplace & 2 sets of French Doors leading to an enclosed bluestone Patio for Indoor/Outdoor entertaining ease. Elegant Dinner Parties can be hosted from the private Banquet Dining Room graced with Antique Crystal Chandeliers & wall Sconces surrounded by elegant Venetian Plaster walls with soft handpainted Topiary silhouettes. The spacious Family Room is complimented by beautifully detailed coffered ceiling, Magnificent stone Fireplace and custom Drapery covering 3 sets of French Doors that open to a covered patio with brick archways. The Dream Kitchen is a Gourmet's delight with the most exquisite custom High Resin Wood Cabinetry, Meile & Wolf appliances, a 350 Bottle Wine Refrigerator, custom Illuminated Glass countertops, heated porcelain floors & Breakfast Room overlooking lush greenery. A private Office/Bedroom with soaring Architectural ceiling & doors to a Juliet Balcony and rear Patio is set off a private Hallway. Intricate custom wrought iron railings with gleaming mahogany handrails adorn each of this Manor Homes 4 floors. A circular Hallway embraces the 2nd floor leading to the elaborate Primary Bedroom. This lavish retreat is the epitome of Luxury with custom built-in wardrobe closets, French Marble carved Fireplace,2 separate Full Baths, one in Onyx, the other Marble with large custom walk-in closet, electronic blackout shades & expansive private outdoor patio. 3 additional large bedrooms, each with generous closets, private baths and electric shades complete this floor. The lower level is an open floor plan with play rooms, game room, gym,laundry and full indoor sports court. An entrance to the 4 car garage and stairway to rear property are accessed from this level. A life of privilege and a sanctuary of luxury await the next owners of this extraordinary residence set on two acres with pool/jacuzzi ,tennis, built-in outdoor kitchen, bluestone patios & professional gardens. Jericho SD By Appointment

8 Vista Lane, Brookville

$4,500,000
H6302491 MLS
Exceptional 44-Acre Estate or Development Opportunity in Pound Ridge Build your dream estate, spacious compound, or luxury residential enclave on this extraordinary 44-acre property just one hour from New York City. Set in the unspoiled natural beauty of Pound Ridge, the land is defined by the Mill River meandering through a landscape of mountain laurel, pine, and hemlock, creating a setting of unmatched tranquility and forever privacy. This rare offering includes 10 building lots, offering endless possibilities for developers, builders, or an end user seeking to create a singular private retreat or multi-residence compound. The gentle topography, wooded vistas, and protected natural surroundings provide a stunning backdrop for architectural vision and modern country living. Ideally located just minutes from Scotts Corners shops and dining, and a short drive to New Canaan and Stamford, CT, the Merritt Parkway, I-95, and Metro-North, this is a once-in-a-generation opportunity to own prime estate acreage in one of Westchester County’s most coveted communities. Bring your architect, builder, and imagination - this property offers the ultimate blend of privacy, natural beauty, and accessibility.

Rolling Meadow Lane, Pound Ridge

$4,500,000
L3489221 MLS
Historical industrial building that has favorable zoning to allow both Roof Garden living & running your business from the same building. Utilize the double wide truck parking / loading dock for your cars / truck needs while utilizing the same space as your showroom/ Gallery / store / event space. This industrial building dates back at least as far as the 1920s and was home to a smoked fish company in the early 20th century making front page of the newspapers five times in it's 100yr history. With the four-story, 25-foot-wide, 8,200-square-foot property features 13 feet roll-up gate, parking for two trucks, and 12- to 14-foot-high ceilings throughout. It's currently utilized as a film / photographic production facility which can continue or be delivered vacant. The buildings usage is grandfathered in as Industrial but has a residential zoning which allows conversion to residential , mix used and or Industrial commercial. It offers a multi dynamic space. Very much industrial with a truck loading dock/ double street driveway, a stainless steel freight elevator, existing vintage graphics on front facade, has a private rooftop garden connected with an amazing Penthouse Office Space. The rooftop garden has approximately 1000 ft and is sitting on a solid concrete roof that could support the capacity and weight of around hundred people. Also available is a smaller front rooftop garden overlooking a wide Street and City Park. This is the hub of cultural Renaissance of Brooklyn. Surrounded by vibrant Greenpoint, Bushwick, downtown Manhattan, Bed-Stuy, Fort Greene. Building has multiple transportation options. Three separate subways, able to Bicycle to all surrounding areas and plenty of street parking. Located near (4) subways L, M & J, and G train. The L train stop, 4 blocks (Montrose Avenue) ; from the M & J train stop, block and a half away (Lorimer Street) and the G train, block and a half away the (Broadway stop). Do not miss this great Opportunity !, Building Size:25' x 100'

71 Montrose Avenue, Brooklyn

$4,500,000
H6318527 MLS
This enchanting property offers a unique opportunity to own a piece of 1920s charm combined with modern luxury. With its rich history as a five-star restaurant and former country club, this establishment has been a beloved destination for decades. Welcome to Rainbow Shores lakefront, and cabins a historic gem nestled in Pulaski, New York. Situated on 3.83 acres of pristine land, Rainbow Shores boasts an impressive 500 feet of meticulously manicured lakefront along the stunning shores of Lake Ontario. The panoramic views and tranquil ambiance make it a perfect location for wedding venues, creating unforgettable memories against the backdrop of the glistening waters. This extraordinary property features 15 beautifully appointed cabins, many of which have been tastefully updated, offering a comfortable and inviting retreat for guests. The cabins provide a seamless blend of vintage aesthetics and contemporary amenities, ensuring a delightful stay for all who visit. One of the most remarkable aspects of Rainbow Shores is its proximity to private state land, guaranteeing your privacy and preserving the unspoiled beauty of the area. The assurance that no further development will take place adds to the exclusivity and value of this exceptional property. With parking capacity for 50 to 100 cars, Rainbow Shores can easily accommodate large events, making it an ideal choice for hosting weddings, corporate functions, or other special occasions. The expansive grounds provide ample space for outdoor activities and allow guests to fully immerse themselves in the serene natural surroundings. Whether you are an investor seeking a prestigious hospitality establishment or an entrepreneur with a vision for an unforgettable dining experience, Rainbow Shores Restaurant and Cabins presents an unparalleled opportunity. Take advantage of this rare gem, combining the nostalgia of the past with the allure of modern luxury, and create your own legacy in this extraordinary lakeside retreat. Give us a call today for your private tour. Additional Information: HeatingFuel:Oil Above Ground,

179 S Rainbow Shores Road, Other

$4,500,000
PAPH2411924 MLS
This rare 1.4-acre industrial property with I-3 zoning and an 8,160 square foot flex/warehouse building offers a varied opportunities in a surging area of the Philadelphia industrial market. A surge of recent activity in the area is demonstrating the tremendous value this pocket of the city can provide for a variety of business and logistic uses. The property sits just across the river from the new Bellwether District, a 17.5 million-square-foot industrial and life sciences project at the former site of the Philadelphia Energy Solutions refinery. Right across the street, the new 5 acre soil recycling facility project by Alterra is well underway. This prime location on West Passyunk Ave offers easy access to major transportation hubs, including I-76 , I-95, Philadelphia International Airport, and the growing epicenter of Philadelphia industrial. The Philadelphia Navy Yard complex is 10 minutes away. The property has direct access from both W. Passyunk Ave and S. 61st St, providing high visibility with over 64,000 vehicles per day along Passyunk Ave and 52,000 vehicles per day along 61st Street. With other anchor industrial businesses all around, this area is bustling with development and is on track to being a key hub in the future of Philadelphia’s industrial market. This multi-tenant property generates over $28.5k in per month in rent with an additional $16.5k per month attainable from currently owner occupied space and the potential to generate approximately $59k per month upon fully utilizing the property and bringing each space to market rate. It is configured for both rental income and owner use, with a mix of month-to-month tenants and owner-occupied spaces, offering flexibility for future development. The main building includes a front office, two drive-in entrances with roll-up doors, and a spacious garage and warehouse, sixteen feet clear-height ceilings, ideal for a variety of industrial uses. The property also features two apartments, a rear garage and warehouse, and a detached four-car garage for additional storage or workspace. Recent upgrades have generated additional value, including newly coated roofs this year and replaced Central A/C and heating systems throughout. There are three electric service meters, one being 3-phase, and the property includes two 80-gallon water heaters. Additionally, it is well-equipped with an in-ground lift operated by air compressor, three above-ground lifts (approx. 11,000 lb capacity), and three floating I- beam rail hoists (with capacities ranging from 30-40 tons), perfect for heavy-duty operations. With two mobile trailer offices included in the sale, the property offers flexibility for various business needs. This industrial property, with its extensive features and prime location, presents a unique opportunity for investors or business owners looking to capitalize on the area's growth and connectivity and central location.

6123 W Passyunk Ave, Philadelphia

$4,500,000
VALO2067510 MLS
This property is an investor's dream. With approximately 475 feet of frontage on Route 50 you are sure to capture the attention of roughly 20,000 daily drivers passing by. Not only do you have this road frontage but you as well would have almost 600 foot of road frontage on Trailhead Drive including MLS Listing VALO2046390. Another beneficial feature of this property is the public sewer running through the back portion with an allowance for hookup. When the public sewer was set the installers put connectors in for the possibility of future development. Currently there is a traffic circle being installed at the front of the property on Route 50 to assist with turning vehicles coming from Trailhead Drive. This traffic circle ensures slower traffic for your future build or business. The small town of Aldie currently holds a population of around18,000 and that number is increasing daily with new subdivisions and homes being built. This property is a rare find with a TR-2 zoning on this stretch of road. Give us a call today to learn more or setup a showing.

41193 John Mosby Hwy, Aldie

$4,500,000
DESU2052756 MLS
Highly visible location. It is situated on 113 in Frankford. The property comprises 2 parcels, for a total of 4.88 acres. The property is located at a traffic light in the southbound lane of 113 DuPont BLVD. in Frankford. This location allows for several ways to access the parking lot with frontage on not only 113 but also Rd.402. This commercial listing has potential for several entities, the building currently houses Shore Appliance which resides in 6,600 sq. feet. The building has a remaining 7,150 sq. feet of space for lease. At the back of the parcel is a gated and fenced storage area (30,000 sq. feet) To the front of the parking lot M&T Bank has a free-standing ATM. The roof, garage doors, and parking lot were all recently renovated. An already approved sign completes the highly desirable location. The Potential of this property is unlimited. Book your showing today. The listing is tax Parcels #433-6.00-33.00, and #433-6.00-31.02.

34164 Dupont Blvd, Frankford

$4,499,900
5 Beds 5 Baths 1029824 MLS
SUMMERWIND – An Extraordinary Waterfront Estate on the Connetquot River. Welcome to Summerwind, one of Oakdale’s most distinguished waterfront estates. Privately set behind stone gates on 1.09 beautifully landscaped acres, this custom-built residence offers approximately 6,286 square feet of luxurious living space, 200 feet of Connetquot River frontage, and a 150-foot private deep-water dock with float and direct access to the Great South Bay, Fire Island, and the Atlantic Ocean. Built in 2004 with exceptional craftsmanship, this three-story brick Colonial showcases Brazilian cherry hardwood floors, handcrafted custom millwork including archways & crown moldings, soaring ceilings, crystal chandeliers, wall sconces and timeless architectural details throughout. The gourmet chef’s kitchen features custom cabinetry, expansive granite countertops, premium appliances, pantry with additional refrigerator, and an oversized center island that opens seamlessly to the spectacular Great Room with a coffered ceiling and fireplace. The luxurious primary suite offers a private sitting area with fireplace, spa-inspired bath, his/hers walk-in closet suite has custom dressing room and built-ins with inlaid custom doors and island with marble tops and lighting, laundry shoot from primary bedroom to laundry room and a private balcony overlooking the resort-style backyard and waterfront. Additional guest suites, a formal dining room, music room, executive office, billiards room, home theater, recreation rooms, tremendous amount of closets for storage, a finished 2000 square foot third floor, and a full finished basement with outside entrance provide exceptional space and flexibility, and the outdoor living rivals a private resort with a 48’x 28’ freeform Gunite pool featuring a natural rock waterfall and waterslide, a 10’x14’ pool cabana, expansive covered terraces, natural stone patios, fire pit, professionally landscaped gardens, and a private sports court. Western exposure provides breathtaking sunsets over the Connetquot River. Built to an exceptional standard, the home features 2x6 construction, 600-amp electrical service, 45kw whole-house diesel backup generator, security cameras and alarm, dual-fuel heating (natural gas and oil), six-zone high-efficiency air conditioning, radiant-heated bathroom floors, separate electrical subpanels throughout the home, garage, and cabana, and a 4-inch water service. Situated at an approximate elevation of 11.5 feet in an X Flood Zone, no FEMA flood insurance is currently required. Summerwind is a rare opportunity to own one of Long Island’s premier waterfront estates—where timeless architecture, exceptional engineering, world-class boating, and resort-style living come together in one extraordinary property. A legacy estate unlike any other.

608 Shore Drive, Oakdale

$4,499,000
4 Beds 4 Baths 1029440 MLS
First time to the market, this rare expression of modern coastal luxury is an extraordinary waterfront estate on prestigious Rampasture Point, masterfully reimagined to offer an unparalleled living experience overlooking the tranquil waters of Tiana Bay. Every finish, texture, and architectural detail have been intentionally selected to create a residence that is as timeless as it is breathtaking. From the moment you arrive, the home's striking architectural presence commands attention. A magnificent, oversized pivot entry door creates an unforgettable first impression, setting the stage for the sophisticated interiors beyond. It immediately reflects the home's exceptional craftsmanship and design. Inside, the impeccably designed living space unfolds beneath soaring ceilings and walls of glass that frame spectacular waterfront vistas from nearly every room. Thoughtfully curated by a luxury interior designer, it showcases wide-plank white oak flooring, custom architectural millwork, exquisite Phillip Jeffrey designer wallcoverings, statement lighting, and handcrafted details that elevate every space into a work of art. The chef's kitchen serves as the true centerpiece of the home. Custom inset cabinetry, dramatic honed quartz countertops, handcrafted range hood, Thermador appliances, and sophisticated coffee bar create a space equally suited for quiet mornings and elegant entertaining. The kitchen flows into the dining and living areas, where uninterrupted views of Tiana Bay become part of the home's everyday backdrop. Anchored by a natural gas fireplace, the living room exudes warmth and sophistication. Bespoke built-in shelving has been thoughtfully designed to showcase artwork, books, collections, and sculptural decor. Designed for effortless modern living, this four-bedroom, three-and-a-half-bath smart home seamlessly blends cutting-edge technology with timeless elegance. Motorized shades throughout provide privacy and convenience while allowing the breathtaking waterfront scenery to remain the focal point. The primary suite is a sanctuary unlike any other. Soaring ceilings, designer lighting, and expansive walls of glass create an atmosphere of serenity and sophistication. Begin each morning at your private coffee bar before stepping onto your balcony, where spectacular sunrises over Tiana Bay become part of your daily ritual. The spa-inspired primary bath offers a retreat worthy of a five-star resort. A freestanding soaking tub is perfectly positioned beside a picture window overlooking the open bay. Luxury entertaining extends throughout the home with multiple beverage stations, including two built-in temperature-controlled wine refrigerators serving both the indoor and outdoor living spaces. Outside, resort-style living reaches its finest expression. Expansive waterfront decking seamlessly extends the home's living space, offering a fully equipped outdoor kitchen, elegant dining area, generous lounge seating, multiple gathering spaces, and an exceptional gazebo that provides the perfect setting for afternoon relaxation or sunset cocktails. Every outdoor space has been thoughtfully designed to celebrate the beauty of waterfront living. Beyond the deck, your own private beach awaits, offering direct access to kayaking, paddleboarding, boating, swimming, and peaceful walks along the shoreline. A whole-house generator provides year-round comfort ensuring uninterrupted enjoyment of this remarkable waterfront estate. Perfectly positioned just minutes from the world-renowned white sand beaches of Dune Road, premier marinas, waterfront dining, boutique shopping, and the very best of the Hamptons lifestyle, this exceptional residence represents one of Hampton Bays' most compelling waterfront offerings. This is more than a home—it is a legacy property. A designer waterfront estate where architecture, craftsmanship, and nature exist in perfect harmony, creating a lifestyle that is both effortless and extraordinary.

29 Tiana Circle, Hampton Bays

$4,499,000
6 Beds 8 Baths 1005967 MLS
Experience luxury coastal living in this breathtaking 3-level Mediterranean-style estate, perfectly positioned on the shores of Northport Bay. Designed for both grand entertaining and intimate relaxation, this home offers 4 ensuite bedrooms, 5.5 bathrooms, and timeless architectural elegance throughout. The third-floor primary suite is a private retreat, featuring a balcony with panoramic water views, a spa-inspired bath with a soaking Jacuzzi tub, steam multi-jet shower, and dual walk-in closets, gas fireplace and home gym. A private elevator provides seamless access to all three levels. The main living area boasts a dramatic great room with 20-foot ceilings and floor-to-ceiling walls of glass that flood the home with natural light. Additional living and formal dining rooms provide versatile spaces for gatherings of any size. The chef’s eat-in kitchen is outfitted with premium Thermador appliances, including a tower refrigerator, freezer, and wine cooler system, as well as a Wolf commercial-grade stove—ideal for both everyday cooking and culinary entertaining. Outdoors, enjoy the heated inground salt water pool with a cascading waterfall, or unwind in the beachside cabana. Completing this remarkable waterfront compound is a charming 2-bedroom, 2-bathroom cottage—perfect for guests, extended family, or a private office. An oversized 3-car garage provides ample space for vehicles and storage. This is coastal Mediterranean luxury at its finest—where every detail is designed to impress and just one hour from NYC.

265 Asharoken Avenue, Northport

board logo

© 2026 TReND. All Rights Reserved.
The data relating to real estate for sale on this website appears in part through the TReND Internet Data Exchange (IDX) program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which Real Broker NY LLC participates, and is provided by TReND through a licensing agreement. Real estate listings held by brokerage firms other than Real Broker NY LLC are marked with the IDX icon and detailed information about each listing includes the name of the listing broker.
All information provided is deemed reliable but is not guaranteed. Some properties which appear for sale on this website may no longer be available because they are under contract, have sold or are no longer being offered for sale. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Listings courtesy of OneKey® MLS as distributed by MLS GRID. Based on information submitted to the MLS GRID as of . 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.