Refine Search
Sort by
Stamford
$75,000,000
8 Beds ⋅ 14 Baths ⋅ 959838 MLS
An extraordinary 268-acre legacy estate spanning the New York-Connecticut border, Hillandale offers unrivaled privacy and timeless grandeur. Once owned by the Sulzberger family of the New York Times, the 15,000+ sq ft, eight-bedroom European-inspired manor has been meticulously restored and features magnificent formal entertaining rooms, 11 fireplaces, two elevators, a paneled library, sun-filled conservatory, billiard room, sauna, gym and an Olympic-sized indoor pool with spa. There is also an outdoor pool with dedicated pool house. Vast, beautifully designed grounds showcase formal gardens, a private lake, woodland trails, a hedge maze and lighted tennis court. Four separate guest houses and a separate garage apartment on the property create a truly unparalleled private compound. This is a once in a generation offering for those seeking exceptional elegance and seclusion. Total Acreage 268+ acres: 173+ in Pound Ridge, New York, 95+ in Stamford, Connecticut

Stamford

25177 Jericho Turnpike, Bellerose
$45,500,000
1019082 MLS
Calling All Investors, Developers & End-Users!!! 84,300+ Sqft. 20 Unit Corner Building With National Tenants & Private Parking Garage On Jericho Tpke. For Sale!!! The Property Is Located In The Heart Of Bellerose On The Corner Of Little Neck Pkwy. Only Blocks From The Cross Island Pkwy.!!! The Building Features Excellent Signage, Great Exposure, R2A/C8-1 Zoning, High 15’ Ceilings, Private Underground Parking Garage, 2 Large Storage Areas, 4 Small Storage Areas, Elevator, Sprinklers, 2 Strategically Placed Curb Cuts, Signalized Intersection, 4 Stories, 120 Parking Spaces, 3 Phase Power, All New LED Lighting, CAC, +++!!! Neighbors Include Starbucks, Chase Bank, Webster Bank, Flagstar Bank, CubeSmart Self Storage, U-Haul, UPS, AT&T, Staples, Mobil, Gulf, Shell, CVS, Dunkin’, 7-Eleven, Mavis Discount Tire, Advance Auto Parts, Dollar Tree, CityMD, Jiffy Lube, Wendy’s, Taco Bell, KFC, +++!!! The Property Has 190’ Of Frontage On Jericho Tpke. + 134’ Of Frontage On Little Neck Pkwy.!!! This Property Has A Daily Traffic Count Of 32,000+ Vehicles Per Day!!! This Property Income: LL: Unit Parking (15,000 Sqft.): $225,000 Ann. (Available) C1 Storage (7,500 Sqft.): $112,500 Ann.; 3% Ann. Inc.; Lease Exp.: 7/31/26; (1) 2 Year Option. C2: Northbay Builders Corp Storage (5,000 Sqft.): $75,000 Ann.; Lease Exp.: 4/30/27. C2: AB Capstone File Room (600 Sqft.): $12,000 Ann.; Lease Exp.: 8/30/28. C3: Storage (600 Sqft.): $12,000 Ann. (Available) 1st Floor: Unit 1: Retro Fitness (2,850 Sqft.): $99,750 Ann.; 3% Ann. Inc.; Lease Exp.: 5/31/35; (1) 5 Year Option. Unit 2: Kung Fu Tea (589 Sqft.): $36,896.15 Ann.; 3% Ann. Inc.; Lease Exp.: 1/30/31; (1) 5 Year Option. Unit 3: US Kitchen Cabinet LLC (1,500 Sqft.): $77,660.11 Ann.; 3% Ann. Inc.; Lease Exp.: 12/31/33; (1) 5 Year Option. Unit 4-6: Tiger Schulman Karate (4,334 Sqft.): $204,317.12 Ann.; 10% Inc. Every 5 Years; Lease Exp.: 8/31/36; (2) 5 Year Options. Unit 7: Juice Bar (600 Sqft.): $30,000 Ann. 3 % Ann. Inc.; Lease Exp.: 8/31/28. Unit 8: LYMM Creations Krafty Hands (1,200 Sqft.): $60,777.46 Ann.; 3% Ann. Inc.; Lease Exp.: 12/31/33; (1) 5 Year Option. Unit 10: Children Of America (3,058 Sqft.): Included In Suite 302 Lease. 2nd Floor: Suite 201: Law Office (1,200 Sqft.): $46,275.84 Ann.; 3% Ann. Inc.; Lease Exp.: 11/30/26; (1) 5 Year Option. Suite 202: Office (800 Sqft.): $30,900 Ann.; 3% Ann. Inc.; Lease Exp.: 8/31/30; (1) 5 Year Option. Suite 203: Primerica (1,550 Sqft.): $80,922.03 Ann.; 3% Ann. Inc.; 11/30/26; (1) 5 Year Option. Suite 204: Retro Fitness (14,500 Sqft.): $623,805.96 Ann.; 10% Inc. Every 5 Years; Lease Exp.: 8/31/33; (3) 5 Year Options. 3rd Floor: Suite 301: Northwell Health (3,766 Sqft.): $179,790.72 Ann.; 10% Inc. Every 5 Years; Lease Exp.: 3/31/29; (1) 3 Year Option. Suite 302: Children Of America (9,267 Sqft.): $480,058.75 Ann.; 10% Inc. Every 5 Years; Lease Exp.: 4/30/39; (3) 5 Year Options. (Includes Unit 10 + Roof Space) 4th Floor: Suite 400: Body Language Aesthetics Corp (1,500 Sqft.): $61,744.38 Ann.; 3% Ann. Inc.; Lease Exp.: 12/31/29. Suite 401: Borealis Dermatology (2,400 Sqft.): $124,570.88 Ann.; 3% Ann. Inc.; Lease Exp.: 10/31/29; (1) 5 Year Option. Suite 403 (3,000 Sqft.): $144,000 Ann. (Available) Suite 404: Cash Advance Office (3,500 Sqft.): $144,000 Ann.; 3% Ann. Inc.; Lease Exp.: 7/31/33; (1) 5 Year Option. Roof: Antenna: Dish Network (1,000 Sqft.): $31,212 Ann.; 2% Ann. Inc.; Lease Exp.: 8/31/42. Playground: Children Of America (5,000 Sqft.): Lease Exp.: 10/31/38. Rental Income: $2,893,181.40 Ann. Reimbursement Income: $289,500 Ann. Expenses: Utilities: $24,000 Ann. Insurance: $46,890 Ann. Maintenance & Repairs: $37,500 Ann. Taxes: $450,000 Ann. Gross Income: $3,182,681.40 Ann. Total Expenses: $558,390 Ann. Pro Forma Net Operating Income (NOI): $2,624,291.40 Ann. Reply,

25177 Jericho Turnpike, Bellerose

36-63 Main Street, Flushing
$38,000,000
1031361 MLS
Rare opportunity to acquire a portfolio of six commercial storefronts offered as a package in the heart of Downtown Flushing. Strategically positioned along the Main Street retail corridor, the properties benefit from exceptional visibility, strong pedestrian traffic, and convenient access to the Flushing–Main Street 7 subway terminus, LIRR station, and multiple bus lines. The portfolio reportedly generates approximately $2,450,000 in annual income. Surrounded by national retailers, major shopping destinations, medical and professional offices, restaurants, and a densely populated residential community, this offering is well positioned for continued demand. An exceptional opportunity for investors seeking immediate cash flow, long-term appreciation, and potential value enhancement in one of New York City’s most active commercial districts. Any expansion, redevelopment, or change of use is subject to zoning regulations and all applicable governmental approvals. Financial information, income, expenses, capitalization rate, property details, and development potential are provided by the seller and must be independently verified by the purchaser.

36-63 Main Street, Flushing

39 Brookridge Drive, Call Listing Agent
$28,500,000
7 Beds ⋅ 12 Baths ⋅ 989570 MLS
Set along a quiet street 3 mins from town, this exceptional 2027 new construction blends timeless architecture with modern livability. A striking white brick façade, steep gables, and dark-framed windows create a refined yet welcoming presence. Warm interior light highlights expansive living spaces, including a dramatic kitchen and family room designed for both everyday living and elevated entertaining. Clean lines are balanced by classic detailing, while terraces and covered outdoor living areas overlook 2.43 level acres, a gracious pool, sports court and barn with basketball court and golf simulator. Generous room scale, soaring ceilings, multiple finished levels, and a flexible layout make this a standout offering. A rare opportunity to own a newly built home of architectural integrity and luxury. Available for rent.

39 Brookridge Drive, Call Listing Agent

738 Southern Boulevard, Bronx
$17,000,000
1014427 MLS
Prime Bronx Location Warehouse With Combined 40,000 SF (Two 20,000 SF Warehouse Combo Sale: 738~754 Southern Blvd). Strategically located in the Bronx with convenient access to the I-278 Bruckner Expressway, major commercial corridors and the #6 subway line, this 40,000-square-foot warehouse offers exceptional accessibility and operational flexibility. Property Highlights: Each Building Dimensions: 200' x 200' Ceiling Height: 16' Four (4) Drive-In Doors Zoning: C8-3 Centrally Located Near Transportation and Business Districts Ideal for a wide range of commercial, industrial, distribution, storage, or service-oriented businesses. The property's versatile layout and favorable zoning provide significant opportunities for owner-users, investors, and developers alike. Can be delivered vacant at closing. Please Note: Annual Tax Is For Two Lots.

738 Southern Boulevard, Bronx

78-21 Queens Boulevard, Elmhurst
$13,800,000
1042515 MLS
Prime Elmhurst development opportunity with excellent Queens Boulevard frontage. Lot approximately 6,557 SF with R7X/C2-4 zoning and approximately 32,785 buildable SF. Currently operating as an established wholesale and retail business specializing in herbal medicines and dried seafood products. Excellent location with strong visibility, high traffic, and convenient access to public transportation. Ideal for investors, developers, or owner-users seeking a property with both existing commercial use and significant future development potential. Buyer to independently verify zoning, allowable uses, FAR, buildable area, and all development possibilities with the NYC Department of Buildings and applicable authorities.

78-21 Queens Boulevard, Elmhurst

345 N Main Street, New City
$10,500,000
1032425 MLS
Pleased to present 345 North Main Street in New City, New York, a fully occupied, income-producing office property comprising approximately 30,019 square feet on a substantial 3-acre site. Originally constructed around 1965 and expanded by approximately 19,400 square feet in 2006, the property offers an established professional office environment with elevator access, well-maintained common areas, abundant on-site parking, and covered parking. Its current full occupancy provides an investor with immediate income and eliminates the initial lease-up risk often associated with commercial acquisitions. Ideally positioned along North Main Street, just south of Kennedy Dells County Park and within close proximity to the center of New City, the property benefits from a highly desirable and accessible location near one of Rockland County’s primary commercial and professional hubs. The combination of a stabilized tenant base, significant parking capacity, large parcel size, established office use, and strong New City location makes this a compelling investment opportunity. Financial information is available upon execution of a confidentiality agreement and submission of proof of funds.

345 N Main Street, New City

240 E 9th Street, New York (Manhattan)
$9,999,000
1024440 MLS
Calling All Investors, Developers, & End-Users!!! 100% Occupied 13 Unit Mixed-Use Building In Manhattan For Sale!!! The Property Features Excellent Signage, Great Exposure, R8B/R7A/C1-5 Zoning, 8 Free Market Apartments, High 8’ Ceilings, Separate Meters, 3 Phase Power, All New LED Lighting, A/C, +++!!! The Property Is Located In the Heart Of New York City Between 2nd Ave. & 3rd Ave. Only 6 Blocks From The FDR Drive!!! Neighbors Include Chase Bank, Citibank, Bank of America, NYU Langone, USPS, UPS, WholeFoods, Target, Best Buy, Staples, Walgreens, Ace Hardware, Trader Joe’s, IHOP, +++!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site or The Next Home For Your Business!!! Income: Tokyo Mama: $88,418.04 Ann.; 3% Ann. Inc.; Lease Exp.: 7/31/30. Apt. 1: $51,600 Ann.; Lease Exp.: 4/30/27. Apt. 2: $27,102.84 Ann.; Lease Exp.: 12/31/26. Apt. 3: $49,200 Ann.; Lease Exp.: 2/28/28. Apt. 4: $48,000 Ann.; Lease Exp.: 3/31/27. Apt. 5: $49,200 Ann.; Lease Exp.: 7/31/27. Apt. 6: $42,000 Ann.; Lease Exp.: 12/31/26. Apt. 7: $48,000 Ann.; Lease Exp.: 10/31/26. Apt. 8: $49,200 Ann.; Lease Exp.: 12/31/26. Apt. 9: $50,400 Ann.; Lease Exp.: 10/31/26. Apt. 10: $12,000.60 Ann. Apt. 11: $24,204.24 Ann.: Lease Exp.: 10/31/27. Apt. 12: $9,951.72 Ann.; Lease Exp.: 2/28/28. Gross Income: $549,277.44 Ann. Expenses: Fuel: $11,169.24 Ann. Electric: $1,297.16 Ann. Water & Sewer: $12,247.78 Ann. Insurance: $11,428 Ann. Maintenance & Repairs: $11,431.02 Ann. Taxes: $107,350.14 Ann. Total Expense: $154,923.35 Ann. Net Operating Income (NOI): $394.354.09 Ann.

240 E 9th Street, New York (Manhattan)

753, 755, 757, 759, 761 E 214th Street, Bronx
$8,995,000
1013187 MLS
50-Unit Bronx Portfolio | 11 Years 421A Tax Abatement | $7.98M @ 3.32% Assignable Financing — Exceptional opportunity to acquire a 50-unit multifamily portfolio consisting of five contiguous buildings located at 753, 755, 757, 759 & 761 E 214th Street in the Wakefield section of the Bronx. This income-producing package offers strong in-place cash flow, significant financing advantages, and long-term tax benefits rarely available in today's marketplace. The portfolio generates approximately $859,708 in annual gross income and is being offered at $8,995,000 ($179,900 per unit). Investors will benefit from an assignable mortgage balance of approximately $7,981,280 at an attractive fixed interest rate of 3.32% through August 30, 2031 (subject to lender approval), creating a substantial financing advantage compared to current market rates. The property also benefits from approximately 11 years remaining of a 421A 25-year tax abatement structure, resulting in exceptionally low real estate taxes and enhanced cash flow. Current estimated NOI is approximately $578,648 with additional upside through lease-up of existing vacant units and operational efficiencies. Property Highlights: • Five contiguous multifamily buildings • Approximately 50 residential units • Strong in-place cash flow • Gross Annual Income: $859,708 • Estimated NOI: $578,648 • 6.43% In-Place Cap Rate • Approx. $179,900 per unit • Assignable $7.98M mortgage at 3.32% fixed through 8/30/2031 • Approximately 11 years remaining on 421A 25-year tax abatement • Extremely low real estate taxes • Multiple vacant units providing immediate upside potential • Conveniently located near public transportation, shopping, schools, and major Bronx thoroughfares This is a rare opportunity for investors, operators, 1031 exchange buyers, affordable housing groups, and multifamily portfolio owners seeking scale, strong cash flow, favorable financing, and long-term appreciation potential. Financial package, rent roll, floor plans, and due diligence materials available upon request.

753, 755, 757, 759, 761 E 214th Street, Bronx

15 Little Cobb Road, Water Mill
$8,500,000
4 Beds ⋅ 3 Baths ⋅ 1034186 MLS
Perched on a hill overlooking breathtaking Mill Creek and Mecox Bay, 15 Little Cobb Road offers a rare combination of panoramic waterfront views, privacy, and history in the heart of Water Mill. Set in an X flood zone with no wetlands and fully bulkheaded, this exceptional property enjoys peace of mind along with one of the most beautiful outlooks on the East End. Once home to Toby and Dan Talbot, the pioneering couple behind Manhattan's legendary art-house theaters including the New Yorker and Lincoln Plaza Cinemas, the residence carries a quiet cultural legacy. Here, far from the projection booths of the Upper West Side, the Talbots spent their summers overlooking the same waters that have drawn artists, writers, and filmmakers to the Hamptons for generations. The home is designed for relaxed waterfront living, with a waterside stone pool, brick patio, private floating deck, covered porches, and porte cochere, all positioned to capture the extraordinary setting. Inside, the main level offers warm and inviting living spaces, including a dining room and sunroom each with wood-burning fireplaces, a bright kitchen with breakfast nook, and a private guest suite with screened porch. Upstairs, the primary suite commands sweeping views over the bay, joined by additional guest bedrooms, office space, and flexible third-level rooms, with room to add a full basement if desired. Just minutes from Southampton and Bridgehampton Villages, yet set in a peaceful waterfront enclave, this is a home that reflects the true spirit of Water Mill timeless, elevated, and deeply connected to the landscape. A rare opportunity to own not only a beautiful waterfront property, but a piece of Hamptons cultural history

15 Little Cobb Road, Water Mill

4858 32 Route, Catskill
$8,500,000
L3493792 MLS
Huge Price Deduction... Must see...This is a very good opportunity to invest in a hotel, located in the heart of the Catskill Mountains a few minutes from the village of Catskill, Woodstock, Hudson and two prominent ski resorts. 52,000 Exhibition, 2000 people convention and banquet, 800 parking space, 2000 people movie theater, 2 out door pools, Spa and Fitness center, 10 commercial building about 147,000 sq feet, Retail Boutiques, 380 hotel rooms, the approximately 382,894 square foot hotel is set on 29.6 sprawling acres which includes a one-acre pond and streams. Plus a 60.16 acre (Hight way Commercial Zoning) land with motel and a 80.7 acre land with Residential zoning. The property is surrounded by the lush beauty of the Catskill mountains with its rich wildlife and hiking trails, and ski resorts including Hunter Mountain and Windham Mountain. The nearby Hudson River School Art Trail includes the Thomas Cole National Historic Site in Catskill village, plus sites like kaaterskill falls and Sunset Rock, which inspired 19th-century landscape painters.

4858 32 Route, Catskill

2145 Ocean Avenue, Brooklyn
$8,000,000
1024367 MLS
Calling All Investors, Developers, & End-Users!!! 6.16 Cap 100% Occupied 40 Unit Apartment Building On A Huge 11,000 Sqft. Lot In Brooklyn For Sale!!! The Property Features Excellent Signage, Great Exposure, R7A Zoning, High 9’ Ceilings, 2 Skylights, 4 Stories, 3 Phase Power, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Madison Just Off Kings Hwy. Near Kings Plaza & Minutes From The Belt Pkwy.!!! Neighbors Include T-Mobile, Target, ShopRite, CubeSmart Self Storage, Extra Space Storage, Staples, Petco, T.J. Maxx, CVS, Dunkin’, Walgreens, Burlington, Michaels, CityMD, Meineke Car Care Center, Raising Cane’s, Aldi, +++!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or The Next Home For Your Business!!! Income: Apt A1: $15,270.72 Ann.; Lease Exp.: 11/30/27. Apt. A2: $14,159.76 Ann.; Lease Exp.: 10/14/26. Apt. A3: $18,852.72 Ann.; Lease Exp.: 8/31/27. Apt. A4: $21,600 Ann. Super. Apt. A5: $16,561.08 Ann.; Lease Exp.: 9/30/27. Apt. A6: $15,529.56 Ann.; Lease Exp.: 5/31/28. Apt. A7: $16,469.28 Ann.; Lease Exp.: 5/31/27. Apt. A8: $17,205.96 Ann.; Lease Exp.: 12/31/27. Apt. A9: $16,978.80 Ann.; Lease Exp.: 5/31/28. Apt. A10: $16,15896 Ann.; Lease Exp.: 4/30/27. Apt. B1: $25,200 Ann.; Lease Exp.: 3/31/27. Apt. B2: $15,115.44 Ann.; Lease Exp.: 8/31/27. Apt. B3: $15,154.92 Ann.; Lease Exp.: 6/30/27. Apt. B4: $224,407.28 Ann.; Lease Exp.: 8/31/28. Apt. B5: $16,860.84 Ann.; Lease Exp.: 7/31/27. Apt. B6: $19,988.88 Ann.; Lease Exp.: 4/30/27. Apt. B7: $15,993.72 Ann.; Lease Exp.: 5/31/27. Apt. B8: $17,700 Ann.; Lease Exp.: 2/28/27. Apt. B9: $12,975.48 Ann.; Lease Exp.: 3/31/27. Apt. B10: $18,171.48 Ann.; Lease Exp.: 11/30/26. Apt. C1: $24,291.96 Ann.; Lease Exp.: 5/31/28. Apt. C2: $16,456.68 Ann.; Lease Exp.: 12/31/26. Apt. C3: $17,556 Ann.; Lease Exp.: 12/31/27. Apt. C4: $12,715.08 Ann.; Lease Exp.: 3/31/27. Apt. C5: $18,776,04 Ann.; Lease Exp.: 11/30/27. Apt. C6: $19,192.08 Ann.; Lease Exp.: 11/30/26. Apt. C7: $19,200 Ann.; Lease Exp.: 4/30/28. Apt. C8: $16,176.60 Ann.; Lease Exp.: 5/31/28. Apt. C9: $19,662.48 Ann.; Lease Exp.: 5/31/28. Apt. C10: $17,987.40 Ann.; Lease Exp.: 1/31/28. Apt. D1: $22,354.08 Ann.; Lease Exp.: 3/31/27. Apt. D2: $18,627.12 Ann.; Lease Exp.: 7/31/26. Apt. D3: $18,112.68 Ann.; Lease Exp.: 12/31/26. Apt. D4: $23,038.92 Ann.; Lease Exp.: 8/31/26. Apt. D5: $17,734.68 Ann.; Lease Exp.: 8/31/26. Apt. D6: $18,355.20 Ann.; Lease Exp.: 5/31/28. Apt. D7: $16,810.44 Ann.; Lease Exp.: 12/31/26. Apt. D8: $17,642.16 Ann.; Lease Exp.: 2/28/28. Apt. D9: $16,823.64 Ann.; Lease Exp.: 5/31/28. Apt. D10: $16,686 Ann.; Lease Exp.: 2/28/27. Gross Income: $718,554.12 Ann. Expenses: Fuel: $43,031.92 Ann. Electric: $2,861.80 Ann. Water & Sewer: $33,764.48 Ann. Insurance: $17,954.11 Ann. Maintenance & Repairs: $19,964.95 Ann. Taxes: $107,930.10 Ann. Total Expenses: $225,507.36 Ann. Net Operating Income (NOI): $493,046.76 Ann. (6.16% Cap!!!) Reply, Reply All or Forward

2145 Ocean Avenue, Brooklyn

136-18 Maple Avenue Unit #C101, Flushing
$7,580,000
997743 MLS
Premier ground-floor commercial retail condo opportunity located at NuSun Tower in the heart of Downtown Flushing, immediately off Main Street and near Great Wall Supermarket. This high-visibility commercial space offers approximately 4,030 gross SF and benefits from strong surrounding foot traffic, dense residential and commercial activity, and a built-in customer base in one of Flushing’s busiest business corridors. The sale includes existing leases with stable tenants, providing immediate income, along with vacant spaces that offer additional upside. Units A and B are occupied with long-term leases in place. With approx. 3000sqft are currently vacant and available for lease at $15,000 per month, offering flexibility for an owner-user or additional rental income. Projected net income 5.5% CAP. The space is suitable for a variety of commercial uses, including retail, restaurant, medical, urgent care, or professional office use, subject to verification and approval. Each unit has a separate electric meter, with common area expenses shared among occupants. This asset presents a rare opportunity to acquire a flexible ground-floor retail condo in Downtown Flushing’s core commercial district, offering existing income, vacant upside, low current tax exposure, and long-term value in a prime location.

136-18 Maple Avenue Unit #C101, Flushing

13225 41st Avenue, Flushing
$7,490,000
1005964 MLS
Prime Downtown Flushing – Brand New Boutique Condo Building For Sale Prime “Golden Core” Location in Downtown Flushing Approx. 10,000 SF Condo Book / Condo Filing Completed Rare opportunity to acquire a newly constructed boutique elevator condo building in the heart of Downtown Flushing. Modern brick façade, luxury finishes, and exceptional long-term investment potential. Ideal for investors, developers, or end-users seeking both stable income and future appreciation. Property Features: 2 CF Units (Community Facility – ideal for medical, office, educational, or clubhouse use) 8 One-Bedroom Condo Residences Private balconies for select units Excellent natural light with north & south exposures High-end finishes throughout Stainless steel appliances & hardwood flooring Modern lobby with elevator access Prime Location Highlights: Located just steps from Main Street, the 7 Train, LIRR, supermarkets, banks, restaurants, library, and major commercial corridors. Situated in one of the most desirable and rapidly growing areas of Flushing with strong rental demand and outstanding appreciation potential. Investment Highlights: Condo Book Completed – Flexible Exit Strategy Brand-New Construction with Low Maintenance Rare Full Building Condo Asset Excellent Rental Income Potential Flexible CF Usage for Medical, Educational, Office, or Professional Use Trophy Asset in Prime Flushing Location

13225 41st Avenue, Flushing

37-16 Union Street, Flushing
$6,700,000
1049406 MLS
An exceptional approximately 5,200 SF retail ground-floor commercial condominium is now available for sale at Union Center, located at 37-16 Union Street along one of Flushing’s busiest and most established commercial corridors. Surrounded by dense residential blocks and a steady flow of office workers, the property benefits from strong built-in traffic throughout the day. The commercial space is positioned directly beneath a brand-new Class A office condominium rising fifteen floors above, creating a strong daily customer base of professionals, medical practices, and service-oriented businesses. With a clean modern facade, strong street visibility, flexible layout, available parking, and the benefit of a tax abatement, the property is well suited for a wide range of business owners and owner-users, including pharmacy, medical, wellness, retail, café, showroom, professional service, or other commercial uses, subject to applicable approvals. The space also presents an attractive opportunity for investors seeking a well-positioned commercial asset in the heart of Flushing. Positioned at the center of Flushing’s residential density and daily traffic patterns, the property offers consistent exposure, strong neighborhood activity, and convenient access to public transportation, surrounding commercial amenities, and major roadways. A rare opportunity to own a substantial ground-floor commercial condominium in the heart of Flushing, ideal for both owner-users and investors seeking long-term value in a strong commercial location. Expected delivery in Q4 2026.

37-16 Union Street, Flushing

7 Homelands Drive, Call Listing Agent
$6,700,000
7 Beds ⋅ 11 Baths ⋅ 1029006 MLS
Welcome to Knightsbridge Estate. Set behind a gated entrance in Colts Neck's Clover Hill section, this modern farmhouse estate compound is designed for luxury living, entertaining, wellness, equestrian pursuits, and animal-property use. The residence offers 7 bedrooms, 8 full baths, 3 half baths, soaring ceilings, black-framed windows, radiant-heated floors, a 3-level elevator, sauna, gym, wine room, generator, solar, and 5 fireplaces. The primary suite serves as a private retreat with a spa-inspired bath. Outdoor amenities include an in-ground pool, trails, dog wash room, fenced dog run, and expansive open acreage. A fully equipped 1950s-inspired casita includes an eat-in kitchen, bedroom, and full bath, providing separate guest accommodations. A 5-stall barn supports equestrian and animal-property use. A detached building currently configured as a dance/yoga and wellness studio offers flexible use and may be converted back to a 6-car garage. A rare offering combining acreage, equestrian facilities, guest accommodations, wellness amenities, and exceptional versatility in Colts Neck.

7 Homelands Drive, Call Listing Agent

102 Melius Road, Call Listing Agent
$6,695,000
7 Beds ⋅ 7 Baths ⋅ 918309 MLS
A rare opportunity to own one of Litchfield County's most exceptional legacy estates. Reverie Farm encompasses more than 101 acres across four separate parcels, offering extraordinary privacy, sweeping views, and endless possibilities as a country retreat or full-time family compound. The meticulously restored and updated 1799 stone and shingle residence, which features 7 bedrooms, 5 full and 2 half baths, intimate entertaining spaces, multiple fireplaces, and a 1-bedroom in-law apartment with both interior and private exterior access, is rich in historic character. Additional accommodations include a separate 3-bedroom, 2 bath guest house with its own driveway, and a separate 2–bedroom staff/guest apartment. Estate amenities include a heated gunite pool in a private garden space, tennis court, the renowned studio of Abstract Expressionist Cleve Gray and, across the driveway, his wife author Francine du Plessix's writing studio which has been transformed into a dance studio/entertaining space with a double height ceiling. Additional outbuildings offer exceptional flexibility for use as gathering spaces, remote workspaces, athletic facilities, studios, workshops, storage (wine, automobiles, and other collectibles), and other uses subject to local approvals. The open fields, woodland trails, ancient fruit trees, established gardens and stone walls create an extraordinary private setting with agricultural and equestrian potential. Several of the estate's four parcels offer additional residential building sites, presenting a rare opportunity to expand thoughtfully while still preserving the extraordinary privacy that defines the property today. Permitted access to Lake Waramaug for swimming and boating is available through the town of Warren. The Mayflower Inn, the villages of Washington, New Preston, and Kent, and many of New England's most celebrated independent schools are all close at hand. Reverie Farm is a truly unique Connecticut estate where history, artistry, recreation, and multigenerational living come together on one remarkable property that is magical in every season.

102 Melius Road, Call Listing Agent

250 Long Pond Road, Other
$6,475,000
9 Beds ⋅ 11 Baths ⋅ 983669 MLS
Experience a rare Zen-inspired retreat in the heart of the Berkshires, brilliantly designed to exist in harmony with its natural surroundings. Set on nearly 120 acres of protected land with striking rock outcroppings, sweeping mountain views, and frontage along the Williams River, this architecturally significant contemporary offers a true sense of privacy, tranquility, and escape- all just minutes from downtown Great Barrington. Designed by renowned architect Steven Haas and constructed of steel, glass, concrete, and wood, the main residence is defined by dramatic volumes and German Sorpetaler door and window systems that dissolve the boundary between indoors and out. Expansive decks made of exotic IPE hardwood overlook a 25-meter heated saltwater lap pool, outdoor kitchen, hot tub, stone fire pit, and the stunning surrounding landscape. A well-appointed pool cabana features a full bath with vanity and both indoor and outdoor showers for effortless poolside living. The newly updated chef's kitchen with wood burning fireplace anchors the home seamlessly connecting to the outdoor entertaining areas, ideal for gatherings. The main living room offers a second fireplace, separate bar area, and immersive views of nature. A covered courtyard seamlessly connects the spaces, enhancing the home's serene, contemplative design. The primary wing is a private sanctuary with spa-like bath, dressing room, a lounge/office room and private decks overlooking breathtaking views of the Berkshire Mountains. The lower level provides spaces for relaxation and entertainment, including a billiards room and additional living area with wet bar. Guest accommodations feel like a retreat, with luxurious baths and a sense of privacy. A separate guest house offers two bedrooms, an open kitchenette, dining and living space, and a rooftop deck with panoramic views. A beautifully finished 3,000 sq ft recreation barn with full kitchen, dining area, full bath, open loft area, and expansive open space offers remarkable versatility for entertaining, recreation, or creative pursuits. 8 miles of private hiking and biking trails wind through the property and lead to the serene Williams River, completing this extraordinary compound retreat. A quintessential Berkshire setting off a quiet country road, this one-of-a-kind sanctuary offers sophisticated aesthetics, effortless modern living, and an unparalleled connection to nature- just moments from the dining, shopping, and cultural attractions of Great Barrington and beyond.

250 Long Pond Road, Other

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.

How much is your home worth?

Get instant property value now!