Refine Search
Sort by
$4,500,000
1024058 MLS
Looking for the High Income Producing Property with an Amazing View? You have all you need for your tenants to rent in this Magnificent Waterfront (6) Luxury, 4 Level, Upscale Townhouse Complex in New Rochelle, N.Y. TENANTS PAY ALL UTILITIES! Your Residents will enjoy the convenience of fabulous restaurants and stores at your fingertips! Not to mention, they'll happy to be able to walk to Metro North and get to Mid-town in less than an hour! Beautiful, WATERFRONT setting w/Breathtaking Views of Long Island Sound. 3 BR 2 1/2 Bath special homes. Your prospective tenants will be amazed, from the moment they walk through the front door of the garden entrance. Most of the pictures are from the recently renovated, Upscale unit (248) which features a Gorgeous Kitchen w/Sumptuous Gray Cabinets, Quartz Countertops, (the other units have Granite Counter Tops), Stainless Steel Appls, Huge Living/Dining Rm. Both 2nd and 3rd Floors have Gleaming HARDWOOD flrs. Sliding Glass Door to Terrace w/elec awning (only unit 248) & breathtaking views of the Long Island Sound. Up on the 3rd floor, you'll marvel at the view from the large windowed Master Bedroom w/walk-in closet, Master Bath w/Jacuzzi bathtub + Shower, 2 other Bedrooms + full hall Bath. Central/A/C. (4th Floor) Finished/Unfinished Walk-Up Attics w/Windows, wall/wall carpeting, 2 closets, alcove & smaller attic above. Down on the garage level, you'll find a Walkout Basement w/Laundry rm, fam room, utility rm, gar, & storage. Convenient to ALL: Walk to Elementary, Middle Schools and College. Mins to New Roc City & all Shops & Highways (I-95 & Hutch), Metro North Station. Beach rights(Glen Island/Hudson Park nearby). (Pls note that pictures 1-34 are from 248 Pelham Rd. Pics 35 & 36 are examples of the kitchen in the other units) All 6 units have approx a total of 2,700 Square feet of space within 4 levels in each unit! LOTS OF UPDATES! *Huge, Brand-new Oversized White Shed to keep refuse/recycle nicely organized *5 of the 6 units have 2 yr old heating/cooling systems & water heaters that were replaced within the past 3 years. *All balconies have NEW Trex Decks * All NEW Garage Doors & their tracks & motors newly replaced * NEW Patios with composite wood. *All Exterior Wood Trim Throughout has been Re-Done, all of the Exterior Freshly Painted June 2026 *Year-old Wrought Iron Fencing w/New Gates! Each unit comes w/a large Garage + 2 Parking spaces! The address of the entire building in City Hall is 254 Pelham Road, New Rochelle, New York 10805. Each Unit has an individual deed. So, Buyer can turn around and re-sell each unit individually while adhering to zoning regulations and laws.

240-250 Pelham Road, New Rochelle

$4,500,000
NJCD2121240 MLS
21-Unit Value-Add Apartment Community | Extensively Renovated | Turnkey Investment Opportunity Property Overview 607 W. Maple Avenue presents the opportunity to acquire a substantially renovated 21-unit multifamily community consisting of three residential buildings in the desirable Borough of Merchantville, Camden County, New Jersey. Current ownership has completed an extensive capital improvement program that has transformed the property into a modern, turnkey investment with significantly reduced deferred maintenance and strong long-term income potential. Over the course of ownership, nearly every major building system has been replaced or upgraded, including electrical, HVAC, roofing, windows, plumbing, insulation, and apartment interiors. These improvements provide investors with a stabilized asset requiring minimal near-term capital expenditures while offering modern amenities that attract and retain quality tenants. Investment Highlights 21 apartment units across three well-maintained residential buildings Extensive property-wide renovation and capital improvement program completed Complete replacement of electrical infrastructure, including new 600-amp services, individual meters, panels, wiring, and transformer Brand-new high-efficiency forced-air heating and central air conditioning installed in every apartment New hot water heaters and plumbing upgrades throughout Renovated kitchens featuring new cabinetry, stainless steel appliances, and dishwashers Updated bathrooms with modern fixtures and finishes New flooring and interior finishes throughout the property New roofs, plywood decking (where required), gutters, windows, and attic insulation Exterior stucco repairs, painting, landscaping, lighting, walkways, mailboxes, and site improvements Individually metered electric service Modern building systems significantly reduce future maintenance and capital costs Strong curb appeal with professionally improved exterior presentation Turnkey investment positioned for long-term stable cash flow Location Located in the heart of Merchantville, the property offers convenient access to Route 38, Route 70, Route 130, Interstate 295, the New Jersey Turnpike, and the Ben Franklin Bridge, providing quick connectivity to Philadelphia and the surrounding South Jersey markets. Residents enjoy proximity to shopping, dining, public transportation, major employers, and recreational amenities. Investment Opportunity 607 W. Maple Avenue represents a rare opportunity to acquire a fully renovated multifamily asset where ownership has already completed the heavy lifting. With modern infrastructure, updated apartment interiors, and significantly reduced deferred maintenance, the property is ideally suited for investors seeking a stabilized, low-maintenance apartment community with long-term appreciation potential in a strong South Jersey rental market.

607 W Maple Ave, Merchantville

$4,500,000
PAPH2645248 MLS
2314-56 N American St., Philadelphia, PA 19133 Exceptional Development Opportunity! Rare 0.91±-acre corner parcel in Philadelphia's rapidly transforming West Kensington/North Philadelphia East corridor. Strategically located at the highly visible intersection of N. American Street and W. York Street, this CMX-zoned property offers outstanding flexibility for a wide range of commercial, industrial, mixed-use, warehouse, or redevelopment projects (subject to zoning and approvals). The site includes fully approved plans for a four-story, approximately 101,312 SF self-storage facility with accessory office space and on-site parking, allowing a developer to move forward with minimal entitlement risk. Situated within a Qualified Opportunity Zone, the property may provide significant tax advantages for eligible investors. Convenient access to I-95, Center City Philadelphia, and major transportation routes makes this an ideal location for future development. Surrounded by ongoing residential and commercial growth, this is a rare opportunity to acquire a shovel-ready development site in one of Philadelphia's fastest-growing neighborhoods. Buyer is responsible for verifying all zoning, approvals, permits, and intended uses.

2314 N American St, Philadelphia

$4,500,000
18 Beds 11 Baths 1021095 MLS
The Arcadia Grand Estate Collection: 30.1 Acres of Hudson Valley History, Luxury & Resort-Style Living. Rare opportunity to acquire a remarkable three-property Hudson Valley compound offered together at 155, 157, and 159 Arcadia Road in historic Goshen, NY, spanning a total of 30.1 acres. This bundled offering combines an extraordinary 1907 historic estate with two beautifully updated residences, creating a one-of-a-kind private retreat with approximately 18 bedrooms, 10.5 bathrooms, and 12,229+ sq. ft. of combined living space. Ideal for a full-time residential compound, weekend escape, extended guest accommodations, multi-generational living, corporate retreats, executive off-sites, wellness weekends, or retreat-style use, this Arcadia Road portfolio delivers exceptional scale, privacy, acreage, amenities, and location just about 55 miles from New York City. At the heart of the offering is 157 Arcadia Road, one of Goshen’s most distinguished historic estates, featuring 9,100+ sq. ft. of grand living space on private, park-like acreage. Originally built in 1907, this 10-bedroom, 5.5-bath mansion has been thoughtfully restored with exquisite original woodwork, hand-carved chestnut moldings, stained glass, restored masonry, seven fireplaces, a sunroom, library, game room, formal dining room, chef’s kitchen with quartz center island, and rebuilt butler’s pantry. Modern upgrades include geothermal heating and central air, new plumbing, renovated baths, updated insulation, newer roof, restored historic details, and extensive masonry work. Outdoor amenities include a saltwater in-ground pool, resurfaced tennis and pickleball courts with lighting, and beautifully landscaped grounds. The bundle also includes 155 Arcadia Road, a fully updated 5-bedroom, 3-bath residence with 1,843 sq. ft. of living space, designed for comfort, entertaining, and relaxation. Enjoy a spacious renovated layout, large living and dining areas, private Swim Spa, outdoor swimming pool, luxury outdoor Jacuzzi/hot tub, expansive backyard, and peaceful countryside surroundings. Completing the offering is 159 Arcadia Road, a modernized 3-bedroom, 2-bath country home with 1,286 sq. ft. of living space, a stylish open layout, stainless steel kitchen with center island, separate dining room, main-level laundry, curated bedrooms, expansive private hilltop backyard with panoramic views, outdoor hot tub, patio deck, grill, dining area, fire pit, and recreation space. Perfectly located near LEGOLAND New York Resort, downtown Goshen, Woodbury Common Premium Outlets, Storm King Art Center, West Point, Greenwood Lake, Heritage Trail, Harriman State Park, Bear Mountain, local farms, vineyards, golf, skiing at Mount Peter and Mountain Creek, shopping, dining, and year-round Hudson Valley recreation. A once-in-a-generation offering, The Arcadia Grand Estate Collection brings together historic grandeur, modern luxury, resort-style amenities, and extraordinary acreage in one unforgettable Hudson Valley compound.

155 Arcadia Road, Goshen

$4,500,000
6 Beds 7 Baths 1020629 MLS
Breathtaking views of the Hudson River and the Tappan Zee Bridge define this hilltop home set on a private cul-de-sac. Expansive windows frame the landscape from nearly every room, filling the home with natural light, while covered decks extend the living space outdoors for year-round enjoyment. Completely rebuilt in 2015 by a local award winning architect, the home was designed with both function and style in mind. The sleek, contemporary architecture is complemented by an open, loft-like floor plan with radiant heat and Italian oak flooring throughout. A spacious home office, a well-appointed primary suite and a professional gym add to the luxury and livability of this sprawling residence. The first floor centers around a chef's kitchen with stainless steel appliances, custom Leicht cabinetry, walk-in pantry and a large quartzite center island that naturally serves as the gathering place for everyday living and entertaining. The second floor offers four large bedrooms all with en-suite bathrooms and a convenient laundry room. A private first-floor bedroom or office, tucked off the informal entrance, provides flexibility for guests or working from home. The lower level includes an additional guest bedroom with a full bath and laundry center. A professional gym with doors opening to the yard was added in 2026. An elevator provides easy access to all three levels. The outdoor spaces are equally impressive, featuring a heated saltwater pool surrounded by professionally landscaped grounds that offer both privacy and a beautiful natural setting. Throughout the home, high-quality and energy efficient features include radiant heated floors, an aluminum standing-seam roof, spray foam insulation, a Lutron smart home system, integrated indoor and outdoor ceiling speakers, elevator and a three-car garage. Just 30 miles from Midtown Manhattan, this exceptional property combines contemporary design, modern (smart) amenities, and sweeping river views in one of the Rivertowns' most desirable locations. Irvington is an historic and picturesque village with acres of greenspace and miles of trails. The Main street is dotted with destination restaurants and shops that lead down to the train station and waterfront, with ever present views of the Hudson.

4 Riverview Court, Irvington

$4,500,000
MDMC2239894 MLS
Premiere Equestrian Facility in Poolesville offered for sale for the first time! Set on 99 acres the farm boasts two indoors measuring 80x220 and 68x250, two outdoors measuring 150x300 and 125x250 and 75 total stalls. The stalls are distributed between four barns, three barns are 50x108 and one barn 34x120. This barn includes two apartments, one apartment is a 6 bedroom 3 full bath and the other is a 1 bedroom 1 full bath. The farm office and 2 full baths for boarders are on the main level of this barn as well. Additional buildings include a 30 x 80 bank barn, a 15x48 shed row barn, a 16x 28 run in shed, a 34x70 hay shed and a 30x80 workshop. Four custom made feed bins each holding one ton of feed make storage easy. There is an underground water holding tank approximately 120x12x6. All the pastures/paddocks have automatic waterers with power. Most of the property is fenced with board fencing creating 5 pastures and 28 paddocks. The main home on the property is a Craftsman/Farmhouse style with 4 bedrooms and 2 full bathrooms. With 3 TDRs included in the sale the new owner can build more homes or sell the TDRs.

20800 Whites Ferry Rd, Poolesville

$4,500,000
4 Beds 2 Baths MDMC2239884 MLS
Premiere Equestrian Facility in Poolesville offered for sale for the first time! Set on 99 acres the farm boasts two indoors measuring 80x220 and 68x250, two outdoors measuring 150x300 and 125x250 and 75 total stalls. The stalls are distributed between four barns, three barns are 50x108 and one barn 34x120. This barn includes two apartments, one apartment is a 6 bedroom 3 full bath and the other is a 1 bedroom 1 full bath. The farm office and 2 full baths for boarders are on the main level of this barn as well. Additional buildings include a 30 x 80 bank barn, a 15x48 shed row barn, a 16x 28 run in shed, a 34x70 hay shed and a 30x80 workshop. Four custom made feed bins each holding one ton of feed make storage easy. There is an underground water holding tank approximately 120x12x6. All the pastures/paddocks have automatic waterers with power. Most of the property is fenced with board fencing creating 5 pastures and 28 paddocks. The main home on the property is a Craftsman/Farmhouse style with 4 bedrooms and 2 full bathrooms. With 3 TDRs included in the sale the new owner can build more homes or sell the TDRs.

20800 Whites Ferry Rd, Poolesville

$4,500,000
4 Beds 2 Baths MDMC2239860 MLS
Premiere Equestrian Facility in Poolesville offered for sale for the first time! Set on 99 acres the farm boasts two indoors measuring 80x220 and 68x250, two outdoors measuring 150x300 and 125x250 and 75 total stalls. The stalls are distributed between four barns, three barns are 50x108 and one barn 34x120. This barn includes two apartments, one apartment is a 6 bedroom 3 full bath and the other is a 1 bedroom 1 full bath. The farm office and 2 full baths for boarders are on the main level of this barn as well. Additional buildings include a 30 x 80 bank barn, a 15x48 shed row barn, a 16x 28 run in shed, a 34x70 hay shed and a 30x80 workshop. Four custom made feed bins each holding one ton of feed make storage easy. There is an underground water holding tank approximately 120x12x6. All the pastures/paddocks have automatic waterers with power. Most of the property is fenced with board fencing creating 5 pastures and 28 paddocks. The main home on the property is a Craftsman/Farmhouse style with 4 bedrooms and 2 full bathrooms. With 3 TDRs included in the sale the new owner can build more homes or sell the TDRs.

20800 Whites Ferry Rd, Poolesville

$4,500,000
5 Beds 3 Baths MDCH2055988 MLS
94-Acre Equestrian Estate & Event Venue Opportunity – Offered at $4,500,000 Welcome to an extraordinary 94-acre private estate in Charles County, Maryland, where luxury, recreation, equestrian living, and income-producing potential come together. This remarkable property has received Charles County zoning approval for events, making it an exceptional opportunity for a private retreat, horse farm, event venue, agritourism operation, or family compound. The property features approximately 30 acres of fenced pastureland divided into eight separate paddocks, ideal for horses, livestock, or agricultural use. A picturesque one-acre stocked pond offers excellent fishing with bass, bluegill, trout, and catfish. The acreage is further enhanced by valuable timber resources including gum, oak, pine, walnut, maple, and pulpwood. At the heart of the estate sits a spacious 4,270-square-foot residence offering 5 bedrooms, 3 full bathrooms, and 2 full kitchens, making it perfect for multi-generational living, guest accommodations, or event operations. Additional features include a durable metal roof and a large, screened porch overlooking the peaceful surroundings. Supporting the property are five outbuildings, each equipped with a minimum of 300-amp electrical service, providing outstanding flexibility for equestrian, agricultural, workshop, storage, or event-related uses. Privacy is unmatched, with a stunning 2,500-foot private driveway leading to this secluded retreat. A planned 20-foot access road further enhances accessibility and future development potential. Despite its private setting, the property is conveniently located just minutes from downtown La Plata and approximately 30 miles from Washington, D.C., offering easy access to urban amenities while maintaining a true countryside atmosphere. Offered at $4,500,000 Private showings by appointment only. Contact the listing agent for additional information and to schedule your private tour. Property Address: 5745 Cues Favorite Place, Waldorf, MD 20602

5745 Cues Favorite Pl, Waldorf

$4,500,000
5 Beds 4 Baths MDAA2146036 MLS
There are places where you visit the water, and there are places where the water becomes part of your everyday life. Perfectly positioned along the shores of Spa Creek in the heart of Eastport, this exceptional waterfront residence offers a front-row seat to one of Annapolis' most coveted lifestyles. Imagine stepping from your back door onto your private pier, casting off for an evening cruise, a sunset sail, or a waterfront dinner in Annapolis Harbor just minutes away. Paddleboards and kayaks launch effortlessly from the floating dock, while the protected waters of Spa Creek become your backyard playground. Life here unfolds both on and off the water. Mornings begin with coffee on the balcony overlooking the creek as the masts in Annapolis Harbor come to life. Afternoons are spent entertaining friends across multiple waterfront terraces, watching sailboats glide past and city lights reflect across the water. Evenings conclude with a short stroll to Eastport's restaurants, marinas, yacht clubs, and waterfront gathering spots. Thoughtfully rebuilt and extensively updated, the home blends timeless craftsmanship with sophisticated coastal living. Wide-plank white oak flooring, custom millwork, designer finishes, and walls of glass frame breathtaking views from nearly every room. The open-concept living spaces flow seamlessly to the waterfront, creating an ideal setting for both intimate gatherings and large-scale entertaining. With a private 40-foot pier, 12,500-pound boat lift, floating dock, and direct access to the Chesapeake Bay, this is more than a waterfront home—it is an opportunity to embrace the Eastport lifestyle that draws people from around the world to Annapolis, . Properties that combine protected deep-water access, exceptional views, and walkability to Downtown Annapolis rarely become available. This is a home best experienced from the waterfront, where the views, the setting, and the lifestyle speak for themselves.

217 Lockwood Ct, Annapolis

$4,500,000
5 Beds 8 Baths VAFX2318520 MLS
Model Open Houses-Saturday & Sunday! Welcome to Aurora House — Miami in Mclean-a contemporary architectural masterpiece in the heart of McLean, VA, where modern luxury, cutting-edge technology, and resort-inspired living converge to create one of Northern Virginia’s most exceptional residences. Perfectly positioned in the prestigious Chesterbrook area of McLean, this newly constructed estate offers over 8,000± square feet of thoughtfully curated living space on a lush 15,564 SF lot. Designed for elevated everyday living and grand-scale entertaining alike, Aurora House seamlessly blends sophisticated architecture with functional luxury. From the moment you arrive, the residence makes a striking impression with its dramatic modern exterior, expansive walls of glass, floating architectural staircase, and seamless indoor-outdoor flow. Inside, the home features 5 spacious bedrooms, 8 luxurious bathrooms, soaring ceilings, designer finishes, and an open-concept layout curated for today’s modern lifestyle. At the center of the home is a world-class gourmet chef’s kitchen featuring premium Dekton countertops, top-of-the-line Wolf and Sub-Zero appliances, integrated coffee maker, and custom-designed cabinetry by CASAMODERNA finished in an ultra-luxury White Oak veneer. Frameless outlets have been thoughtfully integrated throughout the kitchen for a sleek, nearly invisible appearance that enhances the home’s clean contemporary aesthetic. Complementing the main kitchen is a fully equipped secondary kitchen, ideal for entertaining, catering, and multi-generational living. Aurora House was designed to deliver an elevated lifestyle experience with amenities rarely found in the Northern Virginia market. The home includes a bar, sauna, steam shower, heated floors (Primary bathroom), gym, wine display, custom closets systems, second kitchen, outdoor kitchen, swimming pool, covered patio, covered balcony, integrated speakers, elevator shaft, smart home features and privacy with mature trees. The lighting system at Aurora House was designed and implemented at a custom, state-of-the-art level, elevating the home’s architecture, ambiance, and functionality. Features include smart switches, low-voltage LED lighting, custom-built exterior lighting, custom-built interior lighting, and designer-style modern light fixtures throughout the residence. The sophisticated lighting design enhances every architectural detail and transforms the home into a true modern showcase. Designed with both comfort and performance in mind, the oversized 3-car garage features custom-built garage doors, ultra-quiet garage motors, EV charging capability, epoxy flooring, and custom tile baseboards — creating a true showroom-quality automotive experience. The resort-style outdoor living experience rivals luxury destinations around the world. The heated saltwater swimming pool features an automatic cover, integrated lighting, endless swim jets, spa/hot tub features, and a premium quartz plaster finish — a highly durable and stain-resistant surface that blends traditional plaster with crushed quartz aggregate for enhanced beauty and longevity. The outdoor entertaining area is completed by a fully equipped outdoor kitchen featuring a built-in grill, sink, and beverage center, creating the ideal setting for year-round entertaining. Aurora House is fully integrated with a comprehensive smart home ecosystem controlling lighting, cameras, music, pool systems. The property is already equipped with established high-speed internet infrastructure and a UniFi mesh network system throughout the residence. An iPad dedicated to the home automation system will convey to the purchaser at settlement, offering seamless control of the property’s technology systems. Ideally located just minutes from Tysons Corner, Arlington, and Washington, DC, Aurora House offers the perfect balance of privacy, convenience, sophistication, and connectivity. Owner/Agent

1803 Dumbarton St, Mclean

$4,500,000
DCDC2266274 MLS
An exceptional opportunity to acquire a nearly completed multifamily development in one of Washington, DC's most desirable and supply-constrained neighborhoods. Located in the highly sought-after Capitol Hill/Hill East corridor, 330 15th Street SE is a 12-unit residential development that has already progressed through the most challenging and capital-intensive phases of construction. With framing, mechanical, electrical, plumbing, roofing, and exterior construction substantially completed, the project is positioned for its next major milestone: drywall installation and interior finishes. This presents a rare opportunity for an investor or developer to step into a project that is well advanced and significantly de-risked. Investment Highlights 12-unit multifamily development in a premier Washington, DC location Advanced stage of construction Building structure completed Roofing completed Major mechanical, electrical, and plumbing systems installed Drywall and interior finishes represent the next phase of construction Opportunity to accelerate delivery and reduce development timelines Located in the highly desirable Capitol Hill/Hill East submarket Strong demand from both owner-occupants and renters Close proximity to parks, Metro access, restaurants, retail, and major employment centers The Opportunity Projects at this stage of completion are rarely offered for sale. By acquiring 330 15th Street SE, investors and developers can bypass much of the entitlement process, site work, and structural construction that typically consume the greatest amount of time and capital. The property's location within one of Washington, DC's most established and desirable residential neighborhoods provides strong market fundamentals, while the advanced construction status creates an opportunity to bring units to market on an accelerated timeline. Whether the strategy is condominium sales, rental stabilization, or long-term portfolio growth, this project offers an attractive path to value creation in a neighborhood where demand for new housing continues to outpace supply. Development plans, construction details, and additional project information available upon request. Serious investor and developer inquiries only.

330 15th St Se, Washington

$4,500,000
3 Beds 3 Baths 1001157 MLS
Sublime Sunsets Perfectly positioned on the bay, in the heart of Westhampton Beach Village, this exceptional three-bedroom, three-bath waterfront residence offers effortless coastal living with panoramic water views and seamless indoor-outdoor flow. Built in 2014 with a focus on modern comfort and timeless design, the home is filled with natural light and thoughtfully designed for both relaxed living and entertaining. Expansive waterside decking creates the perfect setting for sunset dining, lounging, or enjoying the tranquil bayfront backdrop. Complete with deeded path over the dune to the ocean, enjoy all that Dune Rd living has to offer, while being moments from the village shops, restaurants and the arts. This turnkey retreat delivers an elevated Hamptons lifestyle in one of the area’s most coveted waterfront locations.

398 Dune Road, Westhampton Beach

$4,500,000
5 Beds 6 Baths 1008515 MLS
New construction in a private beach community just moments from Sag Harbor Village. Situated on a corner lot of approximately 0.19 acres, this 5-bedroom, 5.5-bath residence offers approximately 3,800 square feet of living space designed for modern coastal living. The open floor plan features living and dining areas filled with natural light, a well-appointed kitchen with premium finishes and appliances, and two primary suites, including one on the main level and one on the second floor, providing flexibility for guests, multigenerational living, or a variety of lifestyle needs. Contemporary details include wide-plank flooring, an electric LED fireplace, and multiple indoor and outdoor gathering spaces. The landscaped grounds offer patio areas for outdoor dining and entertaining. Conveniently located near Sag Harbor Village shops, restaurants, marinas, and beaches, this newly constructed home offers a combination of modern design and coastal convenience. 5 Bedrooms | 5.5 Baths | Approx. 3,800 SF | Approx. 0.19 Acres | New Construction | Private Beach Community

46 Terry Drive, Sag Harbor

$4,500,000
6 Beds 9 Baths 1000400 MLS
This stunning new construction estate, South of the Highway in Westhampton Beach, offers an unparalleled blend of luxury and sophisticated design. Spanning three levels of living space with 10-foot ceilings on the first floor, the home opens with a grand foyer leading to a spacious living room and a gourmet chef’s kitchen equipped with a premium Thermador appliance package, dual dishwashers, and dedicated refrigeration drawers. The main level features a formal dining room, a junior suite with its own private patio, a mudroom area, and a convenient pool bath. The second level is a sanctuary of comfort, anchored by a magnificent primary suite featuring a sitting room with a wet bar, a laundry room, a master suite with a fireplace, a custom closet, and a private balcony. The upper floor is completed by four additional ensuite bedrooms, a second laundry room, and a versatile sitting room with a custom wet bar. The finished lower level is designed for ultimate entertainment, featuring a state-of-the-art movie theater, a recreation area with a wet bar, and an additional guest bedroom with a full bath. Set on professionally landscaped grounds, the outdoor oasis features a 20x40 heated saltwater Gunite pool with a custom swim shelf, a covered deck for alfresco dining, and a custom BBQ station. A geothermal heating and cooling system powers this environmentally conscious home and includes a two-car garage. Experience the pinnacle of Hamptons living just moments from Village shops and world-class beaches. This home is designed for both luxury and functionality, offering the perfect space for living and entertaining.

78 Meeting House Road, Westhampton Beach

$4,500,000
7 Beds 7 Baths 994090 MLS
Welcome to 2 Aspen Place, a sprawling residence nestled on a .78-acre lot along a quiet, tree-lined street, offering 7 bedrooms and 6.5 baths. Bright entry foyer leads to a dramatic double-height living room with soaring vaulted ceilings, architectural wood beams, and a stone fireplace. The formal dining room with a second fireplace flows into an expansive sunroom lined with arched windows and French doors, overlooking the lush backyard and patio, enhancing the home’s open, airy feel. The custom chef’s eat-in kitchen features vaulted ceilings, high-end appliances, and a separate breakfast room, and opens to a sunlit den, along with a powder room, laundry room, and a guest suite with full bath. The main level includes the primary suite with stone fireplace, dual walk-in closets, and direct access to the backyard and gunite pool with spa. The marble primary bath features a jacuzzi tub and steam shower. Three additional bedrooms and two full baths complete the first floor, including one with direct outdoor access, ideal as a cabana bath. The main living space is framed by two upper-level wings. One side features an open office balcony overlooking the living room, while the other offers a separate wing with a sitting area, two bedrooms, and two en-suite marble baths. Features include hardwood floors, central and ductless AC, a full-house generator, partial basement with laundry and storage, and an attached 2-car garage with direct kitchen access. The grounds feature a 50-foot gunite pool with spa, brick patio with built-in BBQ, and a circular Belgian block driveway. Set in the prestigious Village of Great Neck Estates with its own village police and access to the waterfront park just steps away, featuring Olympic pool, kiddie pool, tennis, pickleball, marina, sports fields, and playground. Zoned for Saddle Rock Elementary with optional North or South middle and high school

2 Aspen Place, Great Neck

$4,500,000
8 Beds 6 Baths 995921 MLS
Prime Bedford-Stuyvesant 2-family opportunity with serious income-producing potential and long-term upside. Welcome to 28 Saint Andrews Place, a brick 4-story, 3-family property offering a spacious layout with 8 bedrooms, 4 full bathrooms, 2 half bathrooms, duplex-style living, and a finished basement for added flexibility. This property is ideal for an end-user looking to live and collect income, or an investor seeking a solid Brooklyn asset in a high-demand rental corridor. The building offers generous interior space, multiple levels of use, and strong upside for repositioning, rental growth, or long-term hold value. Conveniently located near major transportation options, including nearby A/C subway access, LIRR Nostrand Avenue, and multiple Brooklyn bus routes. The surrounding area offers access to Fulton Street and Nostrand Avenue retail corridors, neighborhood shopping, restaurants, schools, parks, and everyday conveniences.

28 Saint Andrews Place, Brooklyn

$4,500,000
990514 MLS
Excellent investment opportunity to own a **7-unit mixed-use building** in the heart of Astoria. This income-producing property consists of **4 residential apartments and 3 commercial units**, offering a strong and diversified revenue stream. The residential units provide stable rental income, while the commercial spaces benefit from strong street presence and consistent foot traffic. Conveniently located near transportation, shopping, dining, and the waterfront, the property is positioned in a highly desirable and active neighborhood. Ideal for investors seeking a well-located asset with steady income and long-term growth potential. **Building Details:** * Total Units: 7 * Residential Units: 4 * Commercial Units: 3 * Property Type: Mixed-Use

3067 14th Street, Astoria

$4,500,000
PAMC2177722 MLS
A rare, fully entitled development opportunity in the high desirable Biltmore Estates, Skippack Township. This exceptional parcel is approved for 48 residential condominium units, with both preliminary and final land development approvals already secured. Significant infrastructure is already in place, including over $1.2M in underground stormwater systems. The site benefits from an active NPDES permit, no traffic impact assessment fee, and all public utilities, including gas, readily available at the street. With minimal remaining sitework, this offers a uniquely streamlined path from acquisition to vertical construction. Positioned within a beautifully maintained community with an established, well-managed HOA, the property is also just 4 miles from the Lansdale interchange of the Pennsylvania Turnpike, providing convenient regional connectivity. Opportunities like this, fully approved, partially improved, and located within an established community, are few and far between. Developer package available upon request.

Ashland Dr, Skippack

$4,500,000
4 Beds 4 Baths PAPH2612418 MLS
There are residences that are merely exceptional — and then there is The Barclay 4B. Occupying a commanding position above Rittenhouse Square, this museum-quality 5,400 square-foot residence stands in a category entirely its own. Panoramic views sweep across the treetops of Rittenhouse Square, the Philadelphia skyline, and South Philadelphia, offering a vista that changes with every hour of the day and every season of the year. A showplace for both entertaining and everyday living, Residence 4B's layout was as thoughtfully designed as the finishes were selected--with generously proportioned rooms that offer complete flexibility for the homeowner. Conceived and executed without compromise, the home was fully reimagined in 2001 by artisans and craftspeople of the highest international caliber. Every wall, every surface, every fitting reflects a singular curatorial vision — one that honors the grandeur of the history of the building while meeting the demands of modern life. All plumbing was replaced in its entirety and all windows were redone, ensuring that the infrastructure is as impeccable as the aesthetic. The hallways and kitchen are graced with hand-carved pine moldings executed by Ray Coggins Interiors of the United Kingdom, a firm celebrated worldwide for its bespoke architectural millwork and its mastery of repurposed antique elements. Original and reclaimed 18th-century architectural fittings are woven throughout, lending the residence an authenticity that cannot be replicated. Stained glass by the legendary Willet Stained Glass Studio — whose commissions include iconic windows in some of the most significant cathedrals in the United States — illuminates the primary bathroom and kitchen. Hand-painted floors by a renowned New York artist flow through the central hallway and kitchen, each one a work of art underfoot. The custom kitchen is a chef’s masterpiece in every sense. Designed by Joanne Hudson and executed without a single expense spared, it features a made-to-order Le Cornue Château Series range, cabinetry, and hood with a replacement value of $250,000; a Traulsen commercial refrigerator and freezer; William Ohs cabinetry with specialty finishes and a Putnam rolling library ladder; an authentic silver sink; and Herbeau faucets throughout. The tile and stonework in the kitchen and all bathrooms is extraordinary, with the foyer and guest bathroom appointed in rare marble and the primary bathroom distinguished by French hand-painted tiles. Throughout the residence, fabrics, wall coverings, and carpets have been sourced from the most revered names in decor: Stark carpeting and Schumacher drapery fabric with Scalamandré trim and P.E. Guerin hardware in the primary bedroom; Old World Weavers linen wall covering and Scalamandré window treatment trim in the study; and Brunschwig & Fils silk-screened wallpaper in select rooms. Hardware throughout — door hinges, bolts, pulls, bathroom faucets, and taps — is exclusively by P.E. Guerin of New York, hand-cast with select finishes in gold plate, representing the finest architectural hardware available anywhere in the world. This is not simply a home. It is a lifetime achievement — a work of art that lives and breathes, assembled by masters of their craft, waiting for a steward who understands the difference. Residents at The Barclay enjoy a twenty-four hour doorman, fitness center, chauffeur driven BMW, on-site management, and individually controlled heating and air conditioning. Stephen Starr’s Barclay Prime steakhouse is located on the building’s ground floor.

237 S 18th St Unit #4B, Philadelphia

$4,500,000
5 Beds 7 Baths 989861 MLS
Historic Estate in the Village Quogue. Welcome to a rare opportunity to own two homes on an extraordinary compound offering privacy, elegance, and unparalleled charm. Each house has its very own private pool with pool house creating an idyllic retreat for extended family and guests. The Main House exudes warmth and comfort with three spacious bedrooms and three full bathrooms. A Sun-filled Living room with a fireplace provides the perfect gathering space. A thoughtfully designed and updated Chef’s kitchen with high end appliances. Ideal for everyday living and entertaining. Discover timeless elegance in the meticulously restored two bedroom and two full bathroom Barn situated behind the main house. This architectural gem blends rustic charm with modern luxury creating a serene and stylish escape. Whether you are lounging by one of the private pools, strolling through the vibrant organic gardens, or enjoying the charm of Quogue Village just moments away this one of a kind compound offers the best of Hamptons living. Quogue Taxes. Quogue Village School. Quogue Village Ocean Beach. Close to the Jitney.

5A/5B Jessup Lane, Quogue

$4,500,000
4 Beds 5 Baths 986698 MLS
Welcome to 45 Pine Hill Drive, where modern luxury meets timeless sophistication. This fully renovated 4-bedroom, 4.5-bath residence has been transformed into a true showpiece, offering every amenity for elevated living. Inside, discover a breathtaking open-concept kitchen by Leicht (Germany) with premium electric stainless steel appliances, dual sinks, and a striking oversized island—perfect for both everyday living and entertaining. High ceilings, unique designer chandeliers, and a marble fireplace framed by expansive windows create a dramatic yet inviting ambiance. The primary suite is a private retreat, complete with a serene seating area, walk-in closet, and spa-inspired bath with soaking tub and his-and-hers sinks. The top-floor laundry room ensures effortless convenience, while the fully finished basement boasts a gym, media/recreation room, full bath, and direct walk-out to a covered patio with speakers and ceiling fans. Outdoors, an entertainer’s dream awaits: a stunning in-ground pool and hot tub with a glass railing, outdoor kitchen, fire pit lounge, and professionally landscaped grounds with Kentucky bluegrass sod and Thuja trees, creating your own private oasis. This home has been extensively updated with new roofing, siding, windows, flooring, systems, and high-end finishes, combining elegance with modern functionality. Every element has been thoughtfully curated to offer a posh lifestyle, flawless entertaining, and refined daily living. Nestled within the prestigious Pine Hill Estates, this home offers access to the highly rated Katonah-Lewisboro School District. Commuting is effortless, with close proximity to major highways and multiple Metro-North stations, providing convenient access to New York City and surrounding areas. Beyond the home's luxurious features, the location offers a wealth of recreational opportunities. Just a short drive away, Ward Pound Ridge Reservation, Westchester County's largest park, provides over 4,300 acres of natural beauty. Enjoy hiking, fishing, and camping amidst scenic landscapes and diverse wildlife. For shopping and dining, Ridge Hill is nearby, offering a variety of retail stores, restaurants, and entertainment options. Additionally, Untermyer Gardens Conservancy and Lenoir Preserve offer tranquil settings for nature walks and exploration. This residence is not just a home; it is an elevated lifestyle of comfort, convenience, as well as curated leisure and recreation. Seize the opportunity to make it yours today!

45 Pine Hill Drive, South Salem

$4,500,000
PABU2112782 MLS
Rare opportunity to acquire a private 26.1-acre campus in Milford Township featuring approximately 13,000 SF± of improvements, including a functional laboratory facility and additional structures. The property offers a unique setting suited for research and development, environmental or analytical testing, veterinary or animal health uses, and light industrial or institutional applications. The site provides a quiet, rural environment with natural buffering, making it ideal for users seeking privacy and separation from dense commercial areas. Existing infrastructure supports immediate occupancy or adaptive reuse, with potential for expansion subject to township approvals. Conveniently located within close proximity to Route 309, I-78, and the Pennsylvania Turnpike, the property offers regional access to the Lehigh Valley, Philadelphia, and New Jersey markets while maintaining a campus-style setting. Zoned Industrial. Buyer to verify permitted uses, utilities, and development potential.

1745 Wentz Rd, Quakertown

$4,500,000
5 Beds 3 Baths 977357 MLS
Introducing a rare oceanfront masterpiece in the coveted enclave of Ocean Bay Park on Fire Island, ideally positioned along the border of Point O’ Woods. This custom-built home offers an exceptional level of privacy, complete with semi-private beach access via a dedicated walkway. Designed to capture the essence of coastal living, the home showcases unobstructed, panoramic views of the Atlantic Ocean and the Great South Bay from nearly every vantage point. A stunning roof deck crowns the property, delivering breathtaking 360-degree water views—perfect for sunrise coffees, sunset cocktails, and stargazing under the open sky. Whether you’re relaxing beside the pool or enjoying the serenity of your own stretch of beach, the natural beauty surrounding you is unparalleled. Watch dolphins glide by, whales breach in the distance, and waves roll endlessly to shore—all from the comfort of your private retreat. Seamlessly blending indoor and outdoor living, this one-of-a-kind residence offers tranquility, exclusivity, and an elevated Fire Island lifestyle in one of its most desirable communities.

37 Traffic Avenue, Ocean Bay Park

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.