Refine Search
Sort by
226 West End Avenue, Brooklyn
$1,649,000
4 Beds ⋅ 3 Baths ⋅ 11433447 MLS
In one of the most beautiful and picturesque areas of Brooklyn, Manhattan Beach, a 2-family home is for sale on a 40x100 lot with a 21x56 house. The first level features a 2-bedroom apartment with a spacious foyer, a combined living room and custom-made kitchen, and a sliding door leading to a beautiful backyard. The second level includes a 2-bedroom, 2-bath unit with 2 terraces. The finished basement, with a separate entrance, offers a huge family room. The house can be used as large single-family home as well. The property also includes a garage and parking for six cars. It's within a short distance to charming cafes, restaurants, and stores, with very convenient transportation option nearby. Just minutes away from the beach and Sheepshead Bay Canal.

226 West End Avenue, Brooklyn

285 Edie Rd, Gansevoort
$1,633,333
5 Beds ⋅ 3.5 Baths ⋅ 12016033 MLS
Every once in a while, I'll be stunned by a home I list - and this is one of them. I'll do my best to describe it, but you really need to see it for yourself. If you've ever toured a Showcase Home, this is exactly that - where every detail has been thought through with style, technology, comfort, and efficiency in mind. Ten-foot ceilings and eight-foot doors throughout give the home an impressive sense of scale. The open living space is anchored by what I can only describe as a floating staircase - a true work of art. One of the most beautiful kitchen islands I've ever seen sits at the heart of the home, while the floor-to-ceiling black slate fireplace is a showstopper. Even the heating and cooling ductwork blends seamlessly into the design. The front and back covered porches feature cedar ceilings, recessed lighting, paddle fans, and stamped concrete floors. The oversized mudroom and laundry combination adds everyday practicality, complete with heated floors. Five bedrooms include a standout first-floor primary suite with 11-foot ceilings and an attractive barn door closet. Clozetivity systems outfit every closet. The porcelain primary bath stuns with heated floors extending into the shower, a heated towel rack, soaking tub, and generous shower loaded with spa-style sprays. A door leads directly from the bath to the private rear covered porch, adding a villa-like feel. The heated garage features an epoxy floor and high ceilings with room for a lift. Designed as a two-car garage, it can accommodate up to three vehicles. The home is also over-insulated and exceptionally efficient - it truly ''sips propane.'' From the finishes you notice immediately to the details working quietly behind the scenes, this is a home where design and function were considered at every turn. The scale, craftsmanship, and thoughtful upgrades give it the feeling of a custom Showcase Home without sacrificing everyday comfort. Brand new, beautifully designed, and ready for you. Come see it!

285 Edie Rd, Gansevoort

no property photo
$1,626,000
5 Beds ⋅ 2.5 Baths ⋅ 11802703 MLS
Nestled at the end of a private long drive shared with only 2 other homes and Not directly on Landing, this magnificent custom brick home offering Luxurious living space on a private 1.2 acre setting. features include a dramatic two-story grand entry foyer with two staircases, soaring vaulted ceilings, gourmet chef's kitchen with cherry cabinetry, granite countertops and Viking appliances, especially including Sub-Zero refrigerator, hardwood floors throughout entire house. Master suite with radiant heated floors, spa-inspired primary suite, and beautiful views of preserved land, Designed for elegant entertaining and comfortable living with vaulted veiling and extra-large windows. Three high ceiling attached car garage with potential for double car lift storage. The full basement features high ceilings and a separate outside entrance, offering excellent potential for recreation, home office, gym, workshop or future finished living space. This exceptional residence combines timeless architecture, privacy. quite and premium craftsmanship.

589 Landing Avenue, Smithtown

1721 Stephen Street, Ridgewood
$1,625,000
3 Beds ⋅ 1.5 Baths ⋅ 11982050 MLS
3 BEDROOM • 1.5 BATH • REIMAGINED 1920s RIDGEWOOD TOWNHOUSE • TWO-CAR GARAGE & PRIVATE PATIO RESIDENCE HIGHLIGHTS Three bedrooms and one and a half bathrooms Soaring 9-foot ceilings throughout Six-window sunroom filled with natural light Private two-car garage Generous closets and storage throughout Expansive private rear patio for outdoor living ARCHITECTURE & INTERIORS All-brick semi-detached residence Original 1920s details thoughtfully restored Stained-glass windows and dramatic stair-hall skylight Restored plasterwork, moldings, millwork, and door casings Fluted Classical Revival columns and original French doors Original brass sconces with designer lighting throughout New 3-inch oak flooring throughout Custom entry doorNew black aluminum double-glazed windows KITCHEN & BATHS Custom European-inspired kitchen with full-height cabinetry Quartz countertops and integrated quartz sink Kohler fixtures, LG appliances, and Fisher & Paykel refrigerator Spa-inspired bathrooms with full-height tilework Deep soaking tub and recessed shower niche Floating vanity, integrated sink, and LED-lit mirror COMFORT & LOWER LEVEL Mitsubishi Hyper-Heat heating and cooling system Energy-efficient double-pane, double-glazed windows Finished lower level with flexible additional space Washer and dryer plus additional storage LOCATION One block from the Halsey Street L train Close to future Whole Foods Market at Myrtle-Wyckoff Near shopping, dining, cafés, and everyday amenities Convenient access throughout Ridgewood and surrounding neighborhoods

1721 Stephen Street, Ridgewood

14 East Landing, Hampton Bays
$1,625,000
6 Beds ⋅ 3 Baths ⋅ 11642295 MLS
Hamptons Multi-Family Compound - Three Separate Residences | 0.34 Acres | Near Peconic Bay - Compound Near Peconic Bay - Set on 0.34 acres in Hampton Bays and located approximately 1,000 feet to the Peconic Bay shoreline, this unique three-cottage property delivers the feel of a private coastal retreat with the flexibility of multiple separate residences on one parcel. - Three Separate Two-Bedroom Cottages - The compound includes three individual cottages, each offering 2 bedrooms, 1 bath, a kitchen, and a living room, with an appealing beach-cottage aesthetic originally built in 1969 and renovated in 2022. Two of the cottages include full basements with outside entrances, adding valuable utility for storage and seasonal gear. - Turnkey Lifestyle With Coastal Amenities - Water views, outdoor living areas, and classic Hamptons beach energy define the experience-ideal for days on the water, kayaking or paddle boarding, rinsing off in outdoor showers, and returning to patios and open-air space for evening downtime and sunset plans nearby. - Rare Multi-Unit Flexibility in a Beach Setting - A true "camp-style" compound with three independent residences is exceptionally hard to replicate, creating a compelling opportunity for an owner seeking a family-and-friends retreat, a multi-generational setup, or a versatile investment format near one of the South Fork's most accessible bayfront environments. - Unit Breakdown - Unit 1: ±741sf (2BR/1BA) | Unit 2: ±731sf (2BR/1BA) | Unit 3: ±590sf (2BR/1BA) - Inquire with the Hamptons Commercial RE Team for additional information.

14 East Landing, Hampton Bays

358 linden Blvd, Brooklyn
$1,625,000
8 Beds ⋅ 4 Baths ⋅ 11490571 MLS
Welcome to 358 Linden Blvd,Brooklyn NY.A Beautiful Three-Family Home Offering Comfort, Convenience & Charm.Discover your sanctuary in this stunning three-family residence located in the heart of Brooklyn.Thoughtfully designed and beautifully maintained, this home is perfect for families, investors, or anyone seeking spacious city living with a touch of tranquility. Step into a modern, spacious and well-maintain kitchen featuring a four-burner stovetop, versatile microwave/convection oven, deep stainless steel sink, and stylish cabinetry that makes cooking both efficient and enjoyable. The inviting living room offers a picturesque view of the neighborhood and access to a peaceful patio-ideal for relaxing or entertaining.This charming property includes: Two spacious 3-bedroom units each unit comprised of three spacious bedrooms, living, dining room, foyer, office space and den. One 2-bedroom unit with living room, kitchen and dining room.Elegant fireplace and hardwood flooring throughout each apartment with Generous closet space and dedicated office areas on each floor. Private patios for outdoor enjoyment. Each apartment boasts unique hardwood floors, exquisite doors, bright and airy bedrooms, and ample storage space, creating a warm and welcoming atmosphere. Full finished basement unit. Two-car detached garage plus driveway. Perfectly situated near public transportation with easy access to the 2, 5, B, and Q trains, and bus lines 12, 34, 44, 49, and 41. You'll also be just minutes from Kings County Hospital, Downstate Medical Center, Prospect Park, and numerous shopping destinations.Don't miss this exceptional opportunity to own a beautiful and functional home in one of Brooklyn's most convenient locations. This house is Sold as it,with no contingencies.

358 linden Blvd, Brooklyn

1204 EAST 72ND ST, Brooklyn
$1,599,999
10 Beds ⋅ 6 Baths ⋅ 11899746 MLS
A Rare Corner Investment & Luxury Living Opportunity in Bergen Beach! Welcome to 1204 E 72nd Street, Brooklyn, NY 11234-an exceptional fully renovated corner property currently set up as a four-family residence, offering the perfect blend of luxury, size, versatility, and income-producing potential. Set on an impressive 41.5 ft. x 99.25 ft. corner lot, this remarkable property encompasses approximately 4,443.62 square feet of beautifully renovated living space. Designed with both comfort and functionality in mind, the building features a total of 10 spacious bedrooms and 6 designer bathrooms, making it ideal for investors, owner-occupants, or multi-generational living. Every residence has been thoughtfully renovated with high-quality finishes, creating modern, turnkey living spaces that are ready for immediate occupancy. The fully finished basement adds valuable bonus space, perfect for recreation, storage, or additional living use. One of the property's standout features is its private driveway and garage, providing the convenience of off-street parking-an amenity that's increasingly rare in Brooklyn. As a true corner property, the home is flooded with natural light and enjoys enhanced privacy, generous frontage, and outstanding curb appeal. Whether you're looking to expand your investment portfolio, generate strong rental income, or live in one unit while benefiting from the income of the others, this property presents an extraordinary opportunity in one of Brooklyn's most desirable neighborhoods. Property Highlights Currently configured as a four-family property Massive 41.5 ft. x 99.25 ft. corner lot Approximately 4,443.62 sq. ft. of interior living space 10 generously sized bedrooms 6 beautifully renovated bathrooms Fully renovated and move-in ready Spacious finished basement Private driveway and attached garage Excellent opportunity for investors and owner-occupants alike Conveniently located near parks, shopping, restaurants, schools, and public transportation Properties offering this combination of size, condition, location, and income potential are exceptionally rare.

1204 EAST 72ND ST, Brooklyn

164-14 85th Street, Howard Beach
$1,599,999
4 Beds ⋅ 3 Baths ⋅ 11663205 MLS
Welcome to this beautifully designed and meticulously upgraded mother-daughter style residence situated on a desirable 47 x 110 corner lot. This exceptional home blends flexibility, elegance, and modern comfort, making it ideal for extended living or multi-generational use. The first floor offers a thoughtfully designed private living space featuring an open-concept layout with a summer kitchen, perfect for entertaining or accommodating guests. A spacious bedroom and a beautifully appointed full bathroom with a jacuzzi soaking tub complete this level, creating a comfortable and functional retreat. The second floor showcases a stunning open-concept design with soaring cathedral ceilings and an abundance of natural light. The chef's kitchen is a true showpiece, featuring a Thermador oven, pot filler, marble mosaic backsplash, and high-end finishes throughout. Radiant comfort is enhanced by electric floor heating mats, adding warmth and luxury beneath your feet. The living room centers around a striking electric cast concrete fireplace, creating a modern yet inviting atmosphere - the perfect focal point for gatherings or quiet evenings at home. The upper level bathroom features a Bain Ultra air-jet tub, offering a spa-like experience with therapeutic air massage technology. Originally designed as three bedrooms, the layout has been thoughtfully reconfigured into two generously sized bedrooms, including an expansive primary suite. The main bedroom boasts a massive walk-in closet and a private en-suite bath adorned with elegant Calacatta Gold marble finishes, creating a true luxury retreat. Situated on a prominent corner lot with added privacy and curb appeal, this home offers exceptional flexibility, high-end upgrades, and refined design throughout. A rare opportunity to own a distinctive property that seamlessly combines sophistication, comfort, and functionality.

164-14 85th Street, Howard Beach

13 MARLIN RD, East Quogue
$1,599,000
3 Beds ⋅ 2 Baths ⋅ 11966674 MLS
Set within the coveted Shinnecock Shores community, this tastefully updated waterfront ranch offers turnkey Hamptons living with a thoughtful layout, elevated finishes, and direct access to Shinnecock Bay. At the center of the home, an open-concept kitchen, living and dining area creates a bright, inviting space for everyday living and entertaining. Beyond, the spacious great room features high ceilings, a wood-burning fireplace and sliding glass doors opening directly to the rear deck and pool. The primary suite is privately positioned on one wing of the home, while two additional bedrooms and a full bath are located on the opposite side. A rare full unfinished basement provides valuable additional storage and utility space-an uncommon feature for a canal-front home. Outside, enjoy an expansive Ipe deck, heated pool, outdoor shower, 80 feet of bulkheaded waterfront, and private dock with direct boating access to Shinnecock Bay. Residents of Shinnecock Shores also enjoy access to a private members-only bay beach. Turnkey and beautifully maintained, this is an exceptional opportunity to enjoy the waterfront Hamptons lifestyle from both land and sea.

13 MARLIN RD, East Quogue

5433 State Route 23, Windham
$1,599,000
5 Beds ⋅ 3.5 Baths ⋅ 11927828 MLS
Contemporary design blends with historic character in this thoughtfully renovated single-family classic colonial home located on charming Main Street in Windham. Originally built in 1930 and fully redesigned in 2024, this turnkey home creates the perfect environment for hosting lavish get-togethers and unforgettable family memories. Gaze into the skies to celebrate summer fireworks from your enclosed balcony or sip hot cocoa as you follow skiers as they slalom down Windham Mountain trails from your generous eat-in-kitchen. The distinct layout of this home design features a 2nd level entertainer's paradise with sprawling kitchen island, custom beverage center, and unobstructed mountain views. An insulated covered deck off the great room and kitchen brings the outside into your entertainment space. After the sun goes down, the gas fireplace is a perfect place to cozy up and enjoy listening to music from one of the 4-zone multimedia systems. Downstairs, five spacious and bright bedrooms encircle the center staircase on the 1st level with 2 well-appointed full baths, a powder room, and laundry room equipped with an oversized washer and dryer. Enter through the elegant front foyer with its grand staircase or trudge around the side entrance into a massive snow room to remove and store all your winter gear. Soaring high ceilings on both sleeping and living floors. Rear barn with plumbing, electric, and metal roof is ready to become your studio, workshop, or recreation space. The covered wrap-around front porch with exterior recessed lighting completes the picture and invites you sit, relax, and unwind. A perfect blend of style, comfort, lifestyle, and modern luxury. All this is just steps away from dining, shopping, and all the wonderful reasons why people have sought out Windham for generations. A rare opportunity to own a home of this quality and location. Come create the memories your family will enjoy for a lifetime!

5433 State Route 23, Windham

14-44 154 St., Whitestone
$1,599,000
5 Beds ⋅ 3 Baths ⋅ 11866556 MLS
Indulge in modern luxury with this fully renovated architectural masterpiece. This impressive residence offers: Expansive Living: 5 beautifully appointed bedrooms and 3 luxurious baths, meticulously designed. Gourmet kitchen: The chef's kitchen boasts state-of-the-art appliances, a waterfall marble island, sleek cabinetry, and integrated lighting. Grand Open Spaces: A wide, light-filled open floor plan perfect for sophisticated living and seamless entertaining. Finished Lower Level: A superbly finished basement ideal for a home theater, recreation room, or private gym. Exceptional Outdoor Amenities: Two expansive, private terraces with composite decking and a remarkably spacious backyard for a perfect outdoor retreat. Convenience and More: A spacious two-car garage. This home seamlessly integrates stunning design with unparalleled functionality. Discover refined living at its finest. Also, the property is subject to minimal property tax.

14-44 154 St., Whitestone

39a FOSTER RD, Quogue
$1,595,000
4 Beds ⋅ 4 Baths ⋅ 11632370 MLS
Located in the Hamptons coveted Quogue Village! This stunning 4-bedroom 4-full bath home, complete with a 1st floor guest en-suite and elevator, blends coastal charm with modern luxury. Take the stairs or elevator upstairs (or to any floor) you will find the primary en-suite and a well-designed Jack and Jill bathroom connects the additional upstairs 2 bedrooms. The finished basement is designed for entertainment and relaxation, featuring a versatile game room and theater space for unforgettable movie nights and billiards tournaments. An en-suite bonus room and a well-appointed laundry room complete this level, offering both convenience and additional living space. Dive into endless fun in the expansive backyard, perfect for barbecues, lawn games, or soaking up the sun.

39a FOSTER RD, Quogue

845 County Rd 39, Southampton
$1,559,000
4 Beds ⋅ 2.5 Baths ⋅ 11959692 MLS
A chic, well-appointed Hamptons cottage offering an easy entry into the Southampton lifestyle. This four-bedroom, two-and-a-half-bath home is set on a generous half-acre with a fully fenced backyard, ample room for a pool, and thoughtfully designed outdoor spaces made for relaxed summer living. Inside, bright, updated interiors feature an open concept living, dining, and kitchen area with hardwood floors, a spacious center island, stone countertops, stainless steel appliances, and an effortless coastal feel. Four comfortable bedrooms and beautifully updated baths provide plenty of room for family and guests, while central air and a dedicated laundry area add everyday convenience. Outdoors, an expansive lawn creates a private backdrop for summer gatherings, with a patio, Jacuzzi, fire pit, outdoor shower, and storage shed already in place, while still leaving plenty of room to make the property your own. Adjacent to Southampton Golf Club and within easy reach of Southampton Village, ocean beaches, dining, shopping, and everything the East End has to offer, the home is equally suited as a year-round residence, weekend escape, or investment property with a strong rental history. Turnkey, inviting, and refreshingly easy - a versatile Southampton home ready to enjoy from day one.

845 County Rd 39, Southampton

78 CHANNING CROSS, Hampton Bays
$1,550,000
3 Beds ⋅ 3 Baths ⋅ 11941680 MLS
Welcome to 78 Channing Cross in Hampton Bays, a beautifully maintained and light-filled home set on nearly two private acres. Enter through dramatic 10-foot double doors into a cathedral-ceiling living room featuring hardwood floors, a wood-burning fireplace, and a striking wall of glass opening to the patio. The eat-in kitchen includes a charming breakfast nook surrounded by floor-to-ceiling windows that capture beautiful morning light. A formal dining room, laundry area, and access to the oversized two-car garage complete this wing of the home. On the opposite side of the house is the main-level primary ensuite with office, den or potential fourth bedroom. Upstairs are two additional spacious bedrooms and a full bath. The full basement features high ceilings and excellent finishing potential, while unfinished space above the garage offers another opportunity for expansion. Major utility systems have been installed or updated within the past five years. Immaculately maintained and move-in ready, the home also features a covered porch and expansive private grounds with ample room for a pool and potential tennis court. Just minutes from West Landing Beach, 78 Channing Cross is an ideal place to unwind and enjoy everything the Hamptons has to offer. Pool, tennis court, bedroom conversion, and expansion are subject to customary permits and approvals.

78 CHANNING CROSS, Hampton Bays

3905 220st, Bayside
$1,550,000
4 Beds ⋅ 3 Baths ⋅ 11922646 MLS
Welcome to this beautifully maintained Expanded Ranch on an oversized 61.97' x 90' lot in the heart of Bayside. This move-in-ready home features 4 bedrooms and 3 full bathrooms, offering a versatile layout with three bedrooms on the main level and a private upper-level bedroom. The sun-filled interior boasts gleaming hardwood floors, a spacious living room, formal dining room with sliding doors to the sunroom and an updated eat-in kitchen featuring quartz countertops, custom cabinetry, a skylight, and stainless steel appliances. This bright sunroom adds valuable year-round living and entertaining space. The home is further enhanced by an expansive finished lower level offering approximately 1,500 SF of additional living space with a separate entrance. Complete with a summer kitchen, oversized recreation room, bar, private office, bonus room, full bathroom, and abundant storage, it offers incredible flexibility for entertaining, working from home, extended living, or guests. Step outside to beautifully landscaped front and back yards featuring a charming garden pavilion and private stone patio-perfect for morning coffee, afternoon tea, or entertaining family and friends. Additional highlights include a young roof, brand-new boiler, brand-new hot water heater, attached garage, and a wide private driveway. Conveniently located near parks, shopping, restaurants, schools, public transportation, and major highways. A rare opportunity to own a meticulously maintained home offering exceptional indoor and outdoor living spaces in one of Bayside's most desirable neighborhoods. Move right in and enjoy everything this special home has to offer!

3905 220st, Bayside

115 Marguerite Ave, Elmont
$1,549,000
5 Beds ⋅ 5 Baths ⋅ 11695398 MLS
Welcome to 115 Marguerite Avenue-a beautifully new home that seamlessly blends modern updates with timeless appeal on the border of Elmont and South Floral Park This thoughtfully built home sits on a 6090SF lot with 5 Bedrooms and 5 Bathrooms. The house showcases high-quality finishes, a refreshed layout, and attention to detail throughout. From the moment you step inside, you'll notice the bright, open living spaces, enhanced by natural light and contemporary design elements that create a warm and inviting atmosphere. The kitchen has been fully reimagined with modern cabinetry, sleek countertops, and updated appliances-perfect for both everyday living and entertaining. Bathrooms have been stylishly renovated, offering a clean, sophisticated feel. Additional improvements include new mechanical systems, new flooring, and carefully curated finishes that elevate the entire home. Situated in a desirable location, 115 Marguerite Avenue offers convenient access to local amenities, shopping, dining, and transportation, making it an ideal choice for homeowners seeking both comfort and convenience. Move-in ready and designed for modern living, this is a rare opportunity to own a new home in a sought-after neighborhood. Schedule your private showing today and experience all that 115 Marguerite Avenue has to offer.

115 Marguerite Ave, Elmont

2135 east 65 street, Brooklyn
$1,548,000
4 Beds ⋅ 3.5 Baths ⋅ 11691893 MLS
Welcome to 2135 East 65th Street, an extraordinary custom-built home nestled in the heart of Mill Basin, Brooklyn. Perfectly suited for families, this spacious residence sits on a generous 5,000-square-foot lot and offers the ultimate blend of luxury, comfort, and practicality. Step inside and be greeted by expansive living spaces highlighted by radiant heat hardwood floors, soaring ceilings, and large windows that flood the home with natural light. With four oversized bedrooms, including a lavish master en suite complete with a walk-in dressing room, everyone in the family will enjoy their own private retreat. An additional private office offers the perfect setting for remote work or study. The custom kitchen is a chef's dream, featuring premium finishes and plenty of room to cook and entertain. Three and a half designer bathrooms provide comfort and convenience for busy family life. Entertain guests in the generous family room or step outside to the outdoor deck and rooftop balcony-ideal for summer gatherings or quiet relaxation. This home also boasts modern amenities including central air conditioning, central vacuum, and a dedicated laundry room. The floating stairs add a contemporary touch, while private parking ensures your vehicles are always secure. Don't miss the opportunity to make this exceptional Mill Basin property your family's forever home. Schedule a private tour today and experience upscale Brooklyn living at 2135 East 65th Street!

2135 east 65 street, Brooklyn

898 DUNE RD, Westhampton Beach
$1,500,000
3 Beds ⋅ 1.5 Baths ⋅ 11983586 MLS
Escape to the quiet beauty of Westhampton Dunes in this beautifully maintained three-bedroom, one-and-a-half-bath beach house featuring sweeping bay views and ocean access directly across the street. Designed for effortless coastal living, this clean and comfortable home offers an exceptional opportunity to enjoy the Hamptons lifestyle. Begin your mornings with coffee overlooking the bay, spend afternoons at the beach, and end each day watching unforgettable sunsets from home. Whether biking along Dune Road, paddleboarding on the bay, or relaxing in the ocean breeze, this property is perfectly positioned for waterfront living. Located near Cupsogue Beach County Park, the home also features a hot tub and Tesla charger. Relaxed, scenic, and surrounded by natural beauty, this is a special opportunity to own a beach house in Westhampton Dunes.

898 DUNE RD, Westhampton Beach

LA CASTELLANA, Barranquilla, Colombia
$1,500,000
5 Beds ⋅ 6.5 Baths ⋅ 11959560 MLS
Mansion La Castellana embodies refined European grandeur with modern sophistication, crafted for those who value exclusivity, elegance, and elevated living. This exceptional estate offers 4 luxurious bedroom suites, each designed with premium finishes and serene ambiance, plus 1 dedicated service‑staff bedroom discreetly positioned for seamless household support. The home includes 7 impeccably finished bathrooms and three distinct luxury living rooms, each curated for a unique experience. Indulge in intimate evenings within the open bar living room, a curated space perfect for crafted cocktails and private gatherings. For high level conversations, the formal executive living room provides a distinguished setting ideal for private meetings, strategic discussions, and elevated entertaining. The Italian style designer kitchen showcases artisanal craftsmanship and premium finishes, while the modern outdoor barbecue kitchen creates a seamless indoor outdoor flow for hosting friends, family celebrations, and sophisticated soirées. The exclusive cava wine cellar adds a touch of prestige for collectors and connoisseurs. Outdoors, the estate features a large inground pool area, offering a serene retreat for relaxation, sun drenched afternoons, and elegant poolside entertaining. Within the private complex, residents enjoy tennis and basketball courts, a social lounge, and executive conference rooms, delivering a resort level lifestyle where every detail is curated for comfort, sophistication, and an elevated retreat experience. A rare masterpiece where luxury, intimacy, and executive functionality converge in perfect harmony. Mansion La Castellana representa la grandeza europea con una sofisticación moderna, creada para quienes valoran la exclusividad, la elegancia y un estilo de vida verdaderamente elevado. Esta propiedad excepcional ofrece 4 dormitorios de lujo, cada uno diseñado con acabados premium y un ambiente sereno, además de 1 dormitorio privado para el personal de servicio, discretamente ubicado para un funcionamiento impecable del hogar. Incluye 7 baños impecables y tres salas de estar de lujo, cada una creada para una experiencia distinta. Disfrute de la intimidad en la sala de estar con bar disponible, un ambiente perfecto para reuniones privadas, cócteles artesanales y momentos de elegancia absoluta. Para conversaciones de alto nivel, la sala ejecutiva formal brinda un entorno distinguido ideal para reuniones privadas, decisiones estratégicas y entretenimiento de categoría. La cocina de diseño italiano destaca por su artesanía y acabados premium, mientras que la cocina moderna de barbacoa exterior ofrece una transición perfecta entre interiores y exteriores, ideal para recibir amigos, celebrar con la familia y organizar eventos sofisticados. La exclusiva cava de vinos añade un toque de prestigio para coleccionistas y amantes de la excelencia. El complejo privado incluye cancha de tenis, cancha de baloncesto, salón social y salas de conferencias ejecutivas, ofreciendo un estilo de vida tipo resort donde cada detalle está pensado para la comodidad, la sofisticación y un retiro verdaderamente distinguido. Adicionalmente una gran área de piscina, creando un retreat privado para la relajación, tardes soleadas y entretenimiento elegante junto al agua. Una obra maestra donde el lujo, la intimidad y la funcionalidad ejecutiva se unen en perfecta armonía.

LA CASTELLANA, Barranquilla, Colombia

143-07 84th Road, Briarwood
$1,500,000
5 Beds ⋅ 3 Baths ⋅ 11937877 MLS
Welcome to 143-07 84th Road, a truly unique detached home offering exceptional space, flexibility, parking, and a remarkable history. Built in 1935 by the same family that has owned and cared for it ever since, this is the first time this special property is being offered for sale. Situated on an oversized 47 x 100 lot, the home offers approximately 2,058 square feet of living space plus a spacious lower level. The property also features a separate two-car garage with electric service and parking for up to six cars in total-a rare find in Queens. What makes this home especially unique is its flexible layout, with private entrances serving the basement/lower level, first floor, and second floor. The second floor is currently set up as a full two-bedroom apartment-style living space with its own balcony, making the home ideal for a mother-daughter arrangement, extended family, guests, or other flexible living needs. The lower level offers even more possibilities, featuring its own private entrance, numerous rooms, multiple windows, and space well suited for home offices, professional workspace, recreation, storage, or additional flexible-use areas. Generously sized rooms, abundant natural light, outdoor space, extensive parking, and an unusually wide lot provide an incredible foundation for the next owner to make this longtime family home their own. Conveniently located in Briarwood near shopping, schools, transportation, the F train, buses, and major roadways. A rare opportunity to purchase a home that has remained with one family for more than 90 years, offering the space, parking, versatility, and multigenerational possibilities that are increasingly difficult to find in Queens.

143-07 84th Road, Briarwood

111 Browns Rd, Walden
$1,500,000
6 Beds ⋅ 3 Baths ⋅ 11926600 MLS
Set on 48.9 picturesque acres, this versatile two-family property offers endless possibilities for homeowners, investors, or those seeking a private country retreat. Featuring a total of 6 bedrooms and 3 bathrooms, the home provides ample living space with one side currently rented on a month-to-month basis, with tenants willing to stay, offering immediate rental income potential. The property also includes three barns, one of which features a two-car garage with a finished upper-level room perfect for a studio, office, workshop, guest space, or recreational use. The expansive acreage is classified as field and seed, making it ideal for farming, livestock, outdoor recreation, or simply enjoying the open landscape and privacy. One side of the property borders Christ Brothers Orchards, while the other borders a horse farm, adding to the scenic and peaceful country setting. Conveniently located just minutes from shopping, schools, major highways, casinos, and local farmers markets, this property offers the perfect balance of peaceful country living with easy access to everyday amenities and entertainment. Whether you are looking for a multi-generational living opportunity, income-producing property, or a serene rural escape with room to grow, this unique offering combines space, functionality, and country charm.

111 Browns Rd, Walden

4983  State Highway 28, Cooperstown
$1,500,000
10 Beds ⋅ 8.5 Baths ⋅ 11363531 MLS
INCOME-GENERATING INVESTMENT OPPORTUNITY - Prime Cooperstown Location on State Highway 28! Welcome to the Hope Mill property portfolio, a rare, fully operational, and highly successful investment opportunity in the heart of Cooperstown, NY. Set on approximately 5 scenic acres bordering picturesque Oaks Creek, this turnkey business includes three established and professionally managed rental homes, a heated in-ground saltwater pool, and an unmatched location between the Village of Cooperstown and Cooperstown Dreams Park. This rare multi-home compound consists of the historic stone Hope Mill House, the charming Hope Mill Cottage, and the spacious Hope Mill Ranch. Together, the properties are currently operating as highly successful short-term summer baseball rentals with strong demand and summer 2026 bookings already secured, generating over $140,000 in projected revenue. The established booking history and repeat rental demand highlight the strength and stability of this proven income-producing portfolio. In total, the three homes offer 10 bedrooms and 8.5 bathrooms, providing exceptional flexibility for large groups, tournament families, vacation rentals, and extended-stay guests. Each residence is thoughtfully positioned to offer privacy while still benefiting from shared access to the beautifully maintained grounds and resort-style heated saltwater pool. In addition to its strong summer performance, the property has a proven history of both short-term and long-term rentals, offering clear expansion potential for year-round income optimization. Opportunities exist to further increase revenue through extended seasonality, rate adjustments, and additional use strategies, making this a scalable hospitality investment. Ideally located just 3.2 miles from the Village of Cooperstown, the property provides convenient access to the National Baseball Hall of Fame, Bassett Medical Center, shopping, dining, breweries, and all local attractions. Cooperstown Dreams Park is only minutes away, making this one of the most desirable rental locations for baseball families and tournament visitors. The property also sits directly on the public bus line, offering easy transportation to both Cooperstown and Oneonta. Whether you are seeking a fully operational income-producing business, a rare multi-home compound investment, or a legacy property with strong upside potential, the opportunities here are exceptional. Schedule your private showing today!

4983 State Highway 28, Cooperstown

5528 Sound Avenue, Riverhead
$1,500,000
3 Beds ⋅ 2 Baths ⋅ 11688573 MLS
A rare and remarkable opportunity to own 22 sprawling acres on highly sought-after Sound Avenue in Riverhead. This unique property features a historic homestead dating back to the 1800s, offering timeless character and endless potential. Surrounded by the natural beauty of the North Fork, the expansive land which extends to Sound Shore Road, provides the perfect setting for agricultural use, or an opportunity to own your own farm/winery. The existing home showcases classic charm with original details, ready to be restored, expanded, or reimagined to suit your vision. With wide open fields and prime frontage along Sound Avenue, this property delivers both privacy and convenience-just moments from local farms, wineries, beaches, and all that Riverhead and the North Fork have to offer. Whether you're looking to create a legacy property, invest in land, or embrace the North Fork lifestyle, this is a truly exceptional offering with limitless possibilities.

5528 Sound Avenue, Riverhead

457 Pond Path, East Setauket
$1,499,990
4 Beds ⋅ 3.5 Baths ⋅ 11679402 MLS
Builder's new construction Dorchester model offering approximately 3,134 SF of living space with 5 bedrooms and 3.5 bathrooms. First floor includes approximately 1,692 SF with 9' ceilings, featuring a formal living room, dining room, family room, and a first-floor office/bedroom with full bath. The kitchen is designed with a center island, breakfast area, and opens directly to the main living space, providing a functional layout for everyday use and entertaining. The second floor offers approximately 1,442 SF with 8' ceilings and includes a primary bedroom with en-suite bath featuring double vanity, soaking tub, and separate shower, along with additional bedrooms, full hall bath, and laundry room. Bedrooms include wall-to-wall carpeting, with hardwood flooring continuing through the first floor and upper hallway. Full basement with 8' ceilings provides additional space and flexibility. The home includes a 2-car garage (approx. 474 SF) with interior access. Built with quality materials and finishes including 4" red oak flooring, ceramic tile bathrooms, custom molding and trim, fireplace with mantle, and shaker-style kitchen cabinetry with quartz countertops, ceramic tile backsplash, and stainless steel appliances. Additional features include 2-zone central air system, tankless hot water, 200 amp electric service, and energy-efficient construction. Exterior includes vinyl siding, architectural roof shingles, paver walkway, driveway, sprinkler system, and seeded yard. Located in a 4-lot subdivision in East Setauket, offering new construction in an established residential setting. Buyer to pay transfer tax, survey, and utility connection fees. Model pricing, specifications, and finishes are subject to change.

457 Pond Path, East Setauket

8019 Utopia Pkwy, Jamaica Estates
$1,495,000
11690999 MLS
Exceptional property in the heart of prestigious Jamaica Estates, Gorgeous Brick home, fully detached, perfect corner view, Private Garage Parking + Driveway, perfectly positioned for natural light all day on a generous 54x74 lot, . This inviting fully Renovated home blends timeless charm with endless potential, The main level welcomes you an entrance Foyer with Decorative Crown moldings in a sun-filled living room & in the formal dining room ideal for entertaining, a Beautiful Brand New Eat-in Kitchen, with Breakfast area, Next to the rear patio door, Full Bedroom with a convenient powder room. Upstairs, enjoy three well-proportioned bedrooms, Primary Bedroom with attached Full Bath, two additional beautifully renovated BRs + 2nd Full bath, and access to a versatile attic offering abundant storage. The fully finished basement extends your living space with a family room, perfect for relaxation, hobbies, or guest accommodations. recreation room, New Full Bath, separate Laundry room, and utility room. Outdoor features include a private driveway, garage, and a delightful balcony perched above the garage, offering an ideal spot to unwind and enjoy the outdoors. Inside, you'll find Newly painted wall with beautiful hardwood floors, soaring ceilings with new Light fixtures & Fans, and original architectural details that add elegance and character throughout. Situated directly across from St. John's University and just moments from transportation, shopping, dining, and everyday conveniences, this property offers unmatched accessibility. A rare opportunity to own a truly special home in one of Queens' most sought-after neighborhoods.

8019 Utopia Pkwy, Jamaica Estates

68 FOSTER AVE., #Unit 9 Unit #Unit 9, Hampton Bays
$1,495,000
3 Beds ⋅ 3 Baths ⋅ 11683950 MLS
Exclusive opportunity to own one of the limited 3-bedroom, 3-bathroom canalfront townhouses at 68 Foster. This stunning 2,000+ square foot home offers a luxurious coastal lifestyle with views of Shinnecock Bay and Dune Road from your private rooftop deck and expansive 1st- and 2nd-story terraces and includes 30' of broadside floating dock space. Step inside the 1st floor, where an open-concept layout invites you to relax or entertain. Gather around the natural gas fireplace in the living room, whip up a meal in the stylish kitchen featuring a waterfall-edge quartz island with seating for four, or host guests in the conveniently located first-floor bedroom and full bath. Upstairs, retreat to the serene primary en-suite bedroom with a direct walkout to the sprawling 2nd-story deck-shared with the third bedroom and another full bath. Need a quiet escape? Head up to the private rooftop deck, where you'll find a bonus interior landing that's perfect as a home office, creative studio, or reading nook. This home is brimming with custom upgrades, including premium lighting fixtures, chic wallpaper and wall accents, sleek electric blinds, and a beautifully enhanced kitchen island with 2" quartz countertops. Every detail has been thoughtfully curated for modern luxury. Located in the exclusive 21-unit 68 Foster community, amenities include a private pool and an assigned parking space. Best of all, you're just over a mile from the Town of Southampton ocean beaches and Dune Road. ****Seller was one of the first 4 in the development to go into contract. Thus the Sponsor sold to him at a discounted price.

68 FOSTER AVE., #Unit 9 Unit #Unit 9, Hampton Bays