Newest Listings

    to
     
     
     
    Search Search
    •  
    Search

    3819  properties match your search;

    Save Search
    Showing 151 - 160 of 3819 results| view:  results per page« first|...|14|15|16|17|...|last »
    • 145-85 9th Avenue Whitestone, NY 11357
      $2,350,000
      4 Bedrooms 3 Full Baths 1 Half Bath
      Single Family For Sale NEW ML# 3586470
      Pristine home featuring 4 bedrooms and 3.5 bathrooms, located in the desirable Whitestone area. This elegant custom-built residence includes a spacious living area, a galley kitchen, and a luxurious extra-large backyard with space for an inground pool. The home is fully renovated with modern amenities, central air conditioning, and energy-efficient windows. Additional highlights are a finished basement and a private driveway with carport access.
      Presented By: Signature Spaces NYC Corp  718-517-0379
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 2601 4 Street Unit 1 K Astoria, NY 11102
      $2,314,024
      Mixed Use Commercial NEW ML# 3587711
      Welcome to Astoria Riverview - A New Perspective on Modern Living. Located at 26-01 4th Street in the heart of the vibrant Halletts Point section of Astoria, Queens, Astoria Riverview offers a unique blend of industrial charm and contemporary comfort. This stunning 13-story building houses 143 tastefully designed units, including studios, one-bedroom, and two-bedroom apartments. Each unit reflects the rich industrial history of the neighborhood, with modern finishes that echo the gritty yet sophisticated city vibe of Astoria’s past. Historic & Cultural Charm Meets Modern Convenience. Astoria Riverview is more than just a place to live; it’s a lifestyle. Nestled in the historically industrial Halletts Point, the building’s design complements the area’s legacy while offering residents all the conveniences of contemporary urban living. The industrial aesthetic of the units features sleek finishes, high ceilings, and large European soundproof windows that flood the spaces with natural light. Unbeatable Location & Accessibility. Situated just steps away from 27th Avenue, Astoria Riverview enjoys unmatched accessibility to Manhattan, Brooklyn, and beyond. The Q18, Q19, Q102, and Q103 buses are conveniently located right at the corner, providing seamless travel options throughout Queens. The Astoria Ferry, just minutes away, offers a picturesque and fast commute to Midtown and Downtown Manhattan, as well as to Brooklyn’s waterfront communities. For those who prefer the subway, the N and W lines are easily accessible, making this an ideal location for professionals and city dwellers alike. And when you’re in the mood to stay local, there’s no better place to be than Astoria. Neighborhood Amenities & Attractions. Astoria is known for its rich cultural heritage, diverse dining scene, and vibrant art community. Residents of Astoria Riverview will be a short distance from the Astoria Waterfront, where you can enjoy stunning views of the East River, or relax and unwind at Astoria Park, with its scenic trails, tennis courts, and Olympic-size pool. For culture enthusiasts, Astoria boasts a variety of renowned museums, including the Museum of the Moving Image, the Noguchi Museum, and the Socrates Sculpture Park. You’ll also find a dynamic nightlife scene, eclectic shopping, and some of the best restaurants and cafes in New York City, offering everything from traditional Greek cuisine to modern fusion dining. Building Features & Amenities. Astoria Riverview is designed with convenience and luxury in mind. Residents will enjoy for more than 10, 000 sqft outdoor and indoor amenities: - Doorman service for added security and peace of mind.- On-site parking for residents - A fully equipped gym to meet all your fitness needs.- A tenant lounge perfect for relaxing or entertaining guests - Roof top terrace with City and East Riverview.- A work space on each floor for you to have a quiet working environments. - Perfect Business meeting room creative spaces perfect for your corporate meeting. The Best Views in Astoria. The highlight of Astoria Riverview is undoubtedly its breathtaking views. Wake up to panoramic vistas of the East River and the iconic Manhattan skyline. These picture-perfect views make coming home feel like an escape from the hustle and bustle of the city, while still being close enough to enjoy all it has to offer. Astoria Riverview: The Future of Astoria Living. As one of the newest condominium projects in Astoria, Astoria Riverview embodies the unique design, culture, and heritage of this historic neighborhood. With its prime location, thoughtful design, and unmatched amenities, it offers a lifestyle that reflects the diversity and vibrant energy of Astoria. Don’t miss out on your chance to be part of this exciting new development!
      Presented By: Winzone Realty Inc  917-678-8888
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 191 Cty Rte 23B Loop Hudson, NY 12534
      $2,300,000
      Mixed Use Commercial NEW ML# H6334281
      Unusual opportunity to own your own 12+ acre lake, with a clubhouse! Unlock the future of your business on Clay Pond Farms, a centrally located, easily accessible property that blends endless opportunity for both business and recreation. Just minutes from downtown HUDSON NY this iconic property offers a prime opportunity for investors, developers, recreational and sports enthusiasts, or anyone with vision. Perhaps an In town mens clubhouse, or a sportsmen’s get away. Set on 31.4 acres on Route 23B (Columbia Turnpike) this high-visibility property includes a 7200 sq. ft. tenants occupied COMMERCIAL BUILDING, with 8 OVER HEAD GARAGE BAYS, ample CLEARED ACREAGE, and also has a secluded, picturesque 12+- ACRE LAKE! This commercial zoned property is serviced by municipal water and sewer, provides ample parking for working or oversized construction vehicles and has easy access off State Route 23B? Directly across from the Columbia County Highway garage. The 7200SF building has endless possibilities ..light manufacturing, medical offices, showroom, warehouse, Gym/Recreation, and many other uses? Or expand it and go bigger on the additional acreage with a barn or large makers shed. The crystal clear 12+-acre lake is 40 feet at its deepest and has big fish, frogs and turtles. Several spots for easy in for a clean swim. (Think your own private sporting camp.) This is an investment opportunity with endless potential. Centrally located to NYC, Albany, and The Berkshires. Easy to show and calls are welcome for any additional questions!
      Presented By: Houlihan Lawrence Inc.  845-473-9770
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 155-30 99th Street Howard Beach, NY 11414
      $2,299,999
      6 Bedrooms 5 Full Baths
      Multi Family For Sale NEW ML# 3586653
      Welcome to this beautifully maintained two-family home, nestled on a spacious, fenced-in double lot spanning nearly 3/4 of an acre in the sought after Howard Beach neighborhood. With two private backyards, this property offers the perfect blend of luxury and comfort-ideal for both family living and investment opportunities. Step inside to discover gleaming hardwood floors and an abundance of natural light that provides an inviting atmosphere. The main level features a primary bedroom with an en-suite bathroom for ultimate convenience. The well-appointed kitchen with stainless steel appliances makes it perfect for both everyday meals and entertaining. The finished basement with a separate outside entrance, offers additional living space and is perfect for guests or extended family. Outside, the expansive backyard feels like your own private resort, complete with an in-ground pool, outdoor shower, and charming gazebos perfect for relaxing or hosting gatherings. There’s also a shed for extra storage and a spacious two car garage for secure parking. Centrally located, you’ll enjoy the convenience of nearby dining, shops, schools, houses of worship, and public transportation, all just minutes away. This home offers not just a place to live but a lifestyle. Whether you are seeking a comfortable home, an income-generating property, or a relaxing retreat, this residence has it all. Don’t miss out on this incredible opportunity!
      Presented By: Coldwell Banker American Homes  718-206-1340
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 2 Tompkins Court Orangetown, NY 10960
      $2,295,000
      5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 5096.00:# Square Feet
      Single Family For Sale NEW ML# H6333872
      HUDSON RIVER HAVEN - Welcome home to Nyack’s finest address at 2 Tompkins Court, Upper Nyack, NY. This exclusive area in Upper Nyack is an exhilarating, private enclave of seven homes with Hudson River access via a private rocky beach. Located on the former estate of Supreme Court Justice Tompkins, this single-family home, built in 2005, is more than just a residence; it’s an embodiment of modern elegance and a testament to meticulous craftsmanship. Aside from living in luxury, 2 Tompkins Court is situated on a spectacular .63 acre site with Hook Mountain in the background, and the east bank of the river in the foreground, acting like a perpetual mural that changes by the season. Completely turn-key, this 5096 SF residence flaunts river views from almost every room. This six-bedroom, four-and-a-half-bathroom home is a sanctuary of tranquility, providing a perfect blend of contemporary living and timeless design. Upon entering, the foyer welcomes you with its warm ambiance and sets the tone for the rest of the home. The open-concept great room with 18’ ceilings and fireplace seamlessly connects to the culinary kitchen, equipped with breakfast nook, state-of-the-art appliances, custom cabinetry, and exquisite granite countertops, flaunting river views from all windows. Off the kitchen is the formal dining room with lush river view vistas, fireplace and a second walk out to the outdoor oasis. The primary suite is a haven for relaxation, featuring a spacious layout and a private en-suite bathroom. Five additional bedrooms provide ample space for family members or guests, each thoughtfully designed with comfort in mind. The home’s layout ensures privacy and fosters a sense of togetherness, making it an ideal space for both intimate gatherings and lively celebrations. If your indoor space isn’t enough, 2 Tompkins Court also includes a three car garage and fully finished basement with home gym, billiards, movie theater and potential for wine cellar. Outside, the expansive patio is perfect for al fresco dining or simply enjoying the serenity of the mighty Hudson River. The meticulously maintained garden is a burst of color and fragrance, creating a tranquil retreat right at your doorstep. Located near Hook Mountain Park with miles of riverfront hiking/biking trails, Upper Nyack community tennis court, Upper Nyack Field Club, Nyack Boat Club and best of all, the historic Village of Nyack is walking distance or a short bike ride away. The property is conveniently close to NYC transportation with the Mario Cuomo Bridge only 5 minutes away and the GW Bridge just 20 minutes away. If you are seeking an unparalleled lifestyle with impeccable river views and water access, come witness Hudson River Haven and arrange your private tour today.
      Presented By: Corcoran Baer & McIntosh  845-358-9440
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 25 Spring House Rd Pound Ridge, NY 10576
      $2,295,000
      4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 4998.00:# Square Feet
      Single Family For Sale NEW ML# H6332576
      Refined Country Colonial. Impressive and beautifully finished interior with high ceilings, beautiful hardwoods and substantial moldings. Two-Story Entrance Hall. Formal Living and Dining Rooms for elegant entertaining. Chef’s Kitchen with center island and breakfast area open to spacious Family Room. Private Primary Suite with Sitting Room, two Walk-in Closets and spacious Bath. Three additional Bedrooms plus Second Floor Bonus Room. Lower Level Recreation Room offers 2000+ square feet, with Dog Bath. Large deck and dining terrace for an ideal outdoor lifestyle. Three private acres at the end of a quiet cul-de-sac across the street from the Ward Pound Ridge Reservation. Gorgeous gardens with Boxwood, Rhododendrons, Rose of Sharon, Hydrangeas, Hosta and incredible flowering perennials. A spectacular offering!
      Presented By: Ginnel Real Estate  914-234-9234
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 34 Oakland Beach Avenue Rye City, NY 10580
      $2,275,000
      5 Bedrooms 3 Full Baths 2 Half Baths Sq. Ft. 3976.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# H6334620
      Spanning nearly 4, 000 sq ft, this colonial home boasts a flexible floor plan that adapts to your lifestyle with five spacious bedrooms and five bathrooms great for an in-law or au pair suite all nestled on an expansive, private level yard. As you step through the inviting foyer, you’ll be greeted by a gracious living room adorned with a wood-burning fireplace and a bay window that flows into the elegant dining room boasting a large picture window. The eat-in kitchen will surely delight with its custom cabinetry, pantry closet and center island, while it seamlessly flows to the 29’ x 23’ covered deck to enjoy your morning coffee and host BBQs while basking in the tranquil sounds of nature. The true gem of this property, the private flex space, is located down the entry hall offering a second kitchen, office/family room, bedroom, and full bath, complete with a separate entrance to the rear deck. The primary ensuite with walk-in closet overlooks the lush backyard. Each bedroom is impressively sized, ensuring comfort and ample storage. The lower level offers over 1, 200 sq ft including a recreational room with a fireplace, a half bath, and endless storage. Rounding out the features, note the two-car garage, carport, and 24kW standby generator. Within the neighborhood, you will find Osborn Elementary School, Oakland Beach, and Rye Golf Club. It is only a quick mile to the Harrison train station. Explore downtown Rye, where delightful restaurants and boutique shops await. Indulge in the essence of elevated small-town living that Rye so gracefully offers.
      Presented By: Coldwell Banker Realty  914-967-0059
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
      Upcoming Open House View Location
      11/03/2024 - 11/03/2024 2:00PM - 5:00PM
    • 9 Canterbury Rd Old Brookville, NY 11545
      $2,275,000
      4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 3850.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3586098
      This classic center hall Colonial offers a wonderful layout including guest quarters, with 4 bedrooms, 3.5 baths, huge den with vaulted ceiling and wet bar, plus 2-car garage. The spectacular 2-acre property features a sparkling 20’ x 45’ heated, saltwater infinity-edge gunite pool with stunning herringbone brick patio, separate saltwater hot tub and cabana with wet bar, bathroom and outdoor shower, and gorgeous landscaping, providing the perfect setting for a grand lifestyle and exceptional entertaining. Other highlights include an expanded kitchen, sunroom for gym or office, finished basement, buried electrical lines to the home, a natural gas generator and grill, providing easy conversion from oil to gas heat since natural gas already comes to the property. Impressively situated on a quiet cul de sac, this home offers seclusion, yet close proximity to Young’s Farm, fine restaurants and shopping. Part of award-winning North Shore School District, offering the International Baccalaureate Program.
      Presented By: Compass Greater NY LLC  516-551-5241
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
      Upcoming Open House View Location
      11/02/2024 - 11/02/2024 12:00PM - 2:00PM
    • 91-23 Corona Avenue Unit S1 Elmhurst, NY 11373
      $2,271,500
      Retail Commercial NEW ML# 3587517
      Welcome to Apollo Plaza, a brand new modern condominium building. Apollo Plaza offers prime retail space in the heart of Elmhurst. This ground floor unit features street facing windows and great business exposure. Apollo Plaza is steps away from public transportation. Experience the wonderful commercial opportunity at Apollo Plaza.
      Presented By: E Realty International Corp  718-886-8110
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 5 Pintail Lane Amagansett, NY 11930
      $2,250,000
      Unimproved Land For Sale NEW ML# 3586941
      Exclusive Amagansett Oasis: Prime 2.5-Acre Parcel Exclusive Amagansett Oasis: Prime 2.5-Acre Parcel Discover an unparalleled opportunity to own a prestigious piece of land in the heart of Amagansett. This expansive 2.5+/-acre lot is perfectly situated just moments from the vibrant village, offering immediate access to world-class dining and shopping. Enveloped by natural beauty, this exceptional property is within a short distance to pristine ocean and bay beaches, making it an ideal canvas for your dream residence. With ample space for a substantial home and luxurious pool, envision a bespoke retreat tailored to your lifestyle. Surrounded by upscale properties, this location promises both exclusivity and prestige. Don’t miss your chance to invest in one of the Hamptons’ most coveted locales. Seize the opportunity to create your legacy in Amagansett. (All Photos are approximate lot lines)
      Presented By: Sothebys Int’l Realty Hamptons  631-283-0600
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    Showing 151 - 160 of 3819 results| view:  results per page« first|...|14|15|16|17|...|last »
    OneKeyâ„¢ MLS The data relating to real estate for sale on this web site comes in part from the OneKeyâ„¢ MLS. Real Estate listings held by brokerage firms other than Century Homes Realty - Eran Hershco are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.
    Eran Hershco
    Eran Hershco
    Licensed Real Estate Salesperson Cell: 917-687-8454
    Connect With Me

    Questions? Just Ask!

    Submit
    Chat with us