Standard Operating Procedure Fair Housing Notice
Cell917-687-8454
Eran@mycenturyhomes.com

Newest Listings

    to
     
     
     
    Search Search
    » Property Criteria
    » Features
    •  
    » Display Tools
    Search

    3708  properties match your search;

    3708 with Multiple photos ;  370 with Virtual Tour ;  23 with Videos

    Save Search
    Showing 221 - 230 of 3708 results| view:  results per page« first|...|21|22|23|24|...|last »
    • 1611 Sqf !! Skyview ! ! . Locate in Center of Flushing, NY. Near #7 Subway Train, Buses, Express buses, LIRR and Commuter Mini Buses to Manhattan & Brooklyn. Also near all the Major Highways. Nearby have restaurants, a library, banks, shopping area, supermarkets, etc. Huge Parking Spaces. Elevators Are Available. Security Guard, Move In Condition, Completely Renovated In Few Years, Six Treatment Room, Two Office, large Waiting Room. 12
      131-07 40th Rd Unit E06 Flushing, NY 11354
      $1,869,000
      Office Commercial NEW ML# 3586706
      1611 Sqf !! Skyview ! ! . Locate in Center of Flushing, NY. Near #7 Subway Train, Buses, Express buses, LIRR and Commuter Mini Buses to Manhattan & Brooklyn. Also near all the Major Highways. Nearby have restaurants, a library, banks, shopping area, supermarkets, etc. Huge Parking Spaces. Elevators Are Available. Security Guard, Move In Condition, Completely Renovated In Few Years, Six Treatment Room, Two Office, large Waiting Room.
      Presented By: Great Ocean Realty  646-509-9311
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • 4
      267-19 Union Turnpike New Hyde Park, NY 11040
      $1,859,000
      4 Bedrooms 3 Full Baths
      Single Family For Sale NEW ML# 3583886
      Presented By: Signature Premier Properties  516-741-4333
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • Whitestone prime location, quiet neighborhood, corner lot property for sale. Well maintained solid brick property. Amazing income generating potential. Three bedrooms on each floor. Multiple entrances for privacy. Separated gas and electrical meters for each unit. Easy to manage, must see. Property Characteristics 12
      149-04 12th Avenue Whitestone, NY 11357
      $1,858,000
      12 Bedrooms 4 Full Baths 1 Half Bath
      Multi Family For Sale NEW ML# 3588599
      Whitestone prime location, quiet neighborhood, corner lot property for sale. Well maintained solid brick property. Amazing income generating potential. Three bedrooms on each floor. Multiple entrances for privacy. Separated gas and electrical meters for each unit. Easy to manage, must see. Property Characteristics
      Presented By: E Realty International Corp  718-886-8110
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • Outstanding Opportunity to acquire Two Well Maintained Buildings On a Busy Road W/30, 000 Traffic count per day. First Building 3072 Sq Ft. is a Thriving Mexican food Restaurant at this location for many years, Second Building Vacant, 4028 Sq Ft. Includes a full basement, Has a Well Known History as The Lakeland School House was Occupied by the seller operating their business for over 30 years. A highly visible Red Train Caboose is attached and can still be utilized. There are two driveways for easy access to both structures as well as lighted signage. 10
      3256-3258 Main Street E Cortlandt, NY 10547
      $1,850,000
      Retail Commercial NEW ML# H6333947
      Outstanding Opportunity to acquire Two Well Maintained Buildings On a Busy Road W/30, 000 Traffic count per day. First Building 3072 Sq Ft. is a Thriving Mexican food Restaurant at this location for many years, Second Building Vacant, 4028 Sq Ft. Includes a full basement, Has a Well Known History as The Lakeland School House was Occupied by the seller operating their business for over 30 years. A highly visible Red Train Caboose is attached and can still be utilized. There are two driveways for easy access to both structures as well as lighted signage.
      Presented By: Houlihan Lawrence Commercial  914-798-4900
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • Previously part of Rhinebeck’s Wilderstein estate, Wilderkill offers a unique blend of historic charm and modern comfort. This mid-19th century home was meticulously restored and modernized by the locally renown design / construction firm Art of Building. The original 18th-century Dutch stone house once the creamery of the Wilderstein estate anchors the home on the ground level. Step inside to find a modern foyer flanked by windows on the left and original stone foundation on the right. A poured radiant concrete floor warms the space. The foyer leads to a generously-sized guest suite or library with full bath. A charming wine cellar can be found tucked behind the stone foundation wall. Stairs lead from the foyer to the first level, revealing an open concept kitchen and dining space with adjacent living room. A formal parlor with wood-burning fireplace occupies the southern portion of the house. Three exposures of windows ensure the room is bathed in light throughout the day. Stairs bound by an exquisite bannister lead from the parlor to a landing on the second floor. The primary suite is accented with beautiful exposed beams and features a wall of built-in cabinetry. The primary bath includes a gracious soaking tub as well as a stand-alone shower. A second handsomely-finished full bath is shared by two bedrooms found off the landing. The house sits on 5 acres and includes a barn with a lofted office / storage space. Two hours from New York City and with easy access to Amtrak, this historic Hudson Valley property is idyllic yet accessible. 36
      521 Mill Rd Rhinebeck, NY 12572
      $1,850,000
      4 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 3000.00:# Square Feet
      Single Family For Sale NEW ML# H6333378
      Previously part of Rhinebeck’s Wilderstein estate, Wilderkill offers a unique blend of historic charm and modern comfort. This mid-19th century home was meticulously restored and modernized by the locally renown design / construction firm Art of Building. The original 18th-century Dutch stone house once the creamery of the Wilderstein estate anchors the home on the ground level. Step inside to find a modern foyer flanked by windows on the left and original stone foundation on the right. A poured radiant concrete floor warms the space. The foyer leads to a generously-sized guest suite or library with full bath. A charming wine cellar can be found tucked behind the stone foundation wall. Stairs lead from the foyer to the first level, revealing an open concept kitchen and dining space with adjacent living room. A formal parlor with wood-burning fireplace occupies the southern portion of the house. Three exposures of windows ensure the room is bathed in light throughout the day. Stairs bound by an exquisite bannister lead from the parlor to a landing on the second floor. The primary suite is accented with beautiful exposed beams and features a wall of built-in cabinetry. The primary bath includes a gracious soaking tub as well as a stand-alone shower. A second handsomely-finished full bath is shared by two bedrooms found off the landing. The house sits on 5 acres and includes a barn with a lofted office / storage space. Two hours from New York City and with easy access to Amtrak, this historic Hudson Valley property is idyllic yet accessible.
      Presented By: Rouse + Co Real Estate LLC  845-750-0196
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • Outstanding 4-Story Dwelling in the heart of Saint Nicholas Historic District, having the grand and impeccable beauty its era. Retaining the character and charm of its original exterior design, this building is presently framed out to accommodate a 3-Family layout, providing an exceptional opportunity to transform this historic property into a contemporary dream. 22
      203 W 139th Street New York, NY 10030
      $1,850,000
      Sq. Ft. 6756.00:# Square Feet
      Multi Family For Sale NEWFORECLOSURE ML# 3586571
      Outstanding 4-Story Dwelling in the heart of Saint Nicholas Historic District, having the grand and impeccable beauty its era. Retaining the character and charm of its original exterior design, this building is presently framed out to accommodate a 3-Family layout, providing an exceptional opportunity to transform this historic property into a contemporary dream.
      Presented By: Island Advantage Realty LLC  631-351-6000
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • Welcome to your dream home! This sprawling custom brick colonial at 18 Spinning Wheel Lane combines luxury living with resort-style amenities, setting the stage for a lifestyle of comfort and elegance. Nestled in the highly sought-after Dix Hills neighborhood, this magnificent property features five spacious bedrooms and 4.5 beautifully appointed bathrooms, making it perfect for families of all sizes. Step inside to discover an expansive floor plan filled with natural light and luxurious finishes. The massive primary bedroom suite is a true sanctuary, boasting multiple walk-in closets and a spa-like primary bath complete with a relaxing Jacuzzi tub-perfect for unwinding after a long day. The home’s open layout is ideal for entertaining, featuring a gourmet kitchen equipped with top-of-the-line appliances and generous counter space, seamlessly flowing into the inviting living and dining areas. The fully finished basement adds even more living space, perfect for a game room, home theater, or gym, providing endless possibilities for recreation and relaxation. The true gem of this property lies outside. Step into your own private paradise with a brand new backyard designed for ultimate enjoyment. Dive into the stunning pool, complete with a waterfall feature, or host summer barbecues on the expansive deck equipped with a built-in BBQ. The charming cabana offers a perfect retreat for guests, while the lush landscaping ensures utmost privacy, making this backyard an entertainer’s dream. Don’t miss this rare opportunity to own a piece of paradise in Dix Hills, where luxury meets comfort in a serene setting. Schedule your private showing today and experience all that 18 Spinning Wheel Lane has to offer! 35
      18 Spinning Wheel Lane Dix Hills, NY 11746
      $1,849,999
      5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 4777.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3587160
      Welcome to your dream home! This sprawling custom brick colonial at 18 Spinning Wheel Lane combines luxury living with resort-style amenities, setting the stage for a lifestyle of comfort and elegance. Nestled in the highly sought-after Dix Hills neighborhood, this magnificent property features five spacious bedrooms and 4.5 beautifully appointed bathrooms, making it perfect for families of all sizes. Step inside to discover an expansive floor plan filled with natural light and luxurious finishes. The massive primary bedroom suite is a true sanctuary, boasting multiple walk-in closets and a spa-like primary bath complete with a relaxing Jacuzzi tub-perfect for unwinding after a long day. The home’s open layout is ideal for entertaining, featuring a gourmet kitchen equipped with top-of-the-line appliances and generous counter space, seamlessly flowing into the inviting living and dining areas. The fully finished basement adds even more living space, perfect for a game room, home theater, or gym, providing endless possibilities for recreation and relaxation. The true gem of this property lies outside. Step into your own private paradise with a brand new backyard designed for ultimate enjoyment. Dive into the stunning pool, complete with a waterfall feature, or host summer barbecues on the expansive deck equipped with a built-in BBQ. The charming cabana offers a perfect retreat for guests, while the lush landscaping ensures utmost privacy, making this backyard an entertainer’s dream. Don’t miss this rare opportunity to own a piece of paradise in Dix Hills, where luxury meets comfort in a serene setting. Schedule your private showing today and experience all that 18 Spinning Wheel Lane has to offer!
      Presented By: SRG Residential LLC  516-774-2446
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
      Upcoming Open House View Location
      11/02/2024 - 11/02/2024 11:00AM - 12:30PM
    • Excellent opportunity in prime Maspeth location off Grand ave. this detached 3 family sits on a 29.17 x 125 lot with an impressive 21x58 building size and a private driveway with a 2-car garage and a private yard. All the apartments are in great condition with modern kitchens and bathrooms and hardwood floors throughout. 25
      54-16 69 Place Maspeth, NY 11378
      $1,849,000
      8 Bedrooms 3 Full Baths 1 Half Bath
      Multi Family For Sale NEW ML# 3584875
      Excellent opportunity in prime Maspeth location off Grand ave. this detached 3 family sits on a 29.17 x 125 lot with an impressive 21x58 building size and a private driveway with a 2-car garage and a private yard. All the apartments are in great condition with modern kitchens and bathrooms and hardwood floors throughout.
      Presented By: RE/MAX Team  718-429-4400
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
    • Beautiful Home in Woodbury Estates! Meticulously Redone! High Ceiling Entry Foyer w/Custom Bannister. Great Open Floor Plan. Refinished Hardwood Floors. Crown Moldings. Hi-Hats Galore. Wall of Windows Offers Wonderful Backyard Views from LR, Dr & Kitchen. Fabulous Center Kitchen w/Hi-end Appliances! Wolf 6 Burner Gas Stove, 2 Wolf Ovens (1 Steam Convection), Sub zero Refrigerator plus Refrigerator Drawers, Oversize Center Island w/Pendant Lights. Skylight, Farm Sink, Pot Filler & More! New Baths. Primary & Hall Bath - Radiant Heat & Bluetooth Speakers. Mostly Lutron Lighting. Lower level Open Floor Plan - Great Room w/Gas Fireplace & Atrium Doors to Covered Custom Stone Patio Leading out to the Pool. Wet Bar w/Mini Refrigerator & Icemaker! Office, Gym, Guest Room & Full Bath. Huge Laundry Room & Storage. 3 Zone Heating - Hydro Hot Air & Hot Water Heat. Nest Thermostat. 3 Zone Central Air (1-New in 2022). Incredible 360 Degree Views of 1 Acre Setting! Outdoor Trex Decking w/Custom Railings & Retractable Awning off Living Room/Dining Room/Kitchen. Heated Salt Water InGround Pool w/Spa & Patio. New Pool Heater. Basketball Court. Fire Pit Seating. Ultimate in Privacy! New Front & Side Vinyl Shakes & Custom Stone Work. 7 Outdoor Cameras. Note: Indoor Cameras Excluded. Outdoor Speakers as/is. 2 Car Garage w/Attic Access. Central Fire & Burglar Alarm Redone 2023, 5 Key Pads. It’s All Done! Just Move Right In and Enjoy Incredible Sunsets, the Country Club Backyard and in the Fall, the Bucolic Views!!! It’s Very Special.... 36
      151 Bristol Drive Woodbury, NY 11797
      $1,835,000
      4 Bedrooms 3 Full Baths Sq. Ft. 3995.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3588382
      Beautiful Home in Woodbury Estates! Meticulously Redone! High Ceiling Entry Foyer w/Custom Bannister. Great Open Floor Plan. Refinished Hardwood Floors. Crown Moldings. Hi-Hats Galore. Wall of Windows Offers Wonderful Backyard Views from LR, Dr & Kitchen. Fabulous Center Kitchen w/Hi-end Appliances! Wolf 6 Burner Gas Stove, 2 Wolf Ovens (1 Steam Convection), Sub zero Refrigerator plus Refrigerator Drawers, Oversize Center Island w/Pendant Lights. Skylight, Farm Sink, Pot Filler & More! New Baths. Primary & Hall Bath - Radiant Heat & Bluetooth Speakers. Mostly Lutron Lighting. Lower level Open Floor Plan - Great Room w/Gas Fireplace & Atrium Doors to Covered Custom Stone Patio Leading out to the Pool. Wet Bar w/Mini Refrigerator & Icemaker! Office, Gym, Guest Room & Full Bath. Huge Laundry Room & Storage. 3 Zone Heating - Hydro Hot Air & Hot Water Heat. Nest Thermostat. 3 Zone Central Air (1-New in 2022). Incredible 360 Degree Views of 1 Acre Setting! Outdoor Trex Decking w/Custom Railings & Retractable Awning off Living Room/Dining Room/Kitchen. Heated Salt Water InGround Pool w/Spa & Patio. New Pool Heater. Basketball Court. Fire Pit Seating. Ultimate in Privacy! New Front & Side Vinyl Shakes & Custom Stone Work. 7 Outdoor Cameras. Note: Indoor Cameras Excluded. Outdoor Speakers as/is. 2 Car Garage w/Attic Access. Central Fire & Burglar Alarm Redone 2023, 5 Key Pads. It’s All Done! Just Move Right In and Enjoy Incredible Sunsets, the Country Club Backyard and in the Fall, the Bucolic Views!!! It’s Very Special....
      Presented By: Howard Hanna Coach  631-427-1200
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
      Upcoming Open House View Location
      11/01/2024 - 11/01/2024 2:30PM - 4:00PM
      11/02/2024 - 11/02/2024 12:30PM - 2:30PM
      11/03/2024 - 11/03/2024 1:30PM - 3:30PM
    • This newly constructed 1 family located in Syosset with approx 3, 200 sqft. It features elegant living with 5 bedrooms and 4.5 bathrooms, and the lot side is 60x132. A gourmet kitchen equipped with white solid wood cabinetry, quartz countertops, and Samsung appliances, seamlessly connecting to a large family room. The house also includes a luxurious master suite with dual walk-in closets, and all bedrooms are designed with deep/illuminated closets. The fully basement, outfitted with recessed lighting and egress windows, provides additional living or recreational space. Also it located in the highly-rated Robbins Lane Elementary and HBT Middle School districts(Top-rate School District). It is surrounded by a range of shopping options, supermarkets, and diverse dining establishments, and offers quick access to major highways. 30 mins can drive to flushing main street. Perfect for families seeking both comfort and accessibility, this home is 100% complete and ready for move-in. 36
      125 Ketchams Rd Syosset, NY 11791
      $1,829,000
      5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 3200.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3587554
      This newly constructed 1 family located in Syosset with approx 3, 200 sqft. It features elegant living with 5 bedrooms and 4.5 bathrooms, and the lot side is 60x132. A gourmet kitchen equipped with white solid wood cabinetry, quartz countertops, and Samsung appliances, seamlessly connecting to a large family room. The house also includes a luxurious master suite with dual walk-in closets, and all bedrooms are designed with deep/illuminated closets. The fully basement, outfitted with recessed lighting and egress windows, provides additional living or recreational space. Also it located in the highly-rated Robbins Lane Elementary and HBT Middle School districts(Top-rate School District). It is surrounded by a range of shopping options, supermarkets, and diverse dining establishments, and offers quick access to major highways. 30 mins can drive to flushing main street. Perfect for families seeking both comfort and accessibility, this home is 100% complete and ready for move-in.
      Presented By: Prospes Real Estate Corp  718-321-2800
      Call Today: 718-886-6800, 917-687-8454, or  Email: Eran Hershco
      Upcoming Open House View Location
      11/02/2024 - 11/02/2024 1:00PM - 4:00PM
    Showing 221 - 230 of 3708 results| view:  results per page« first|...|21|22|23|24|...|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

    3436 Union St Ste 201, Flushing, NY, 11354
    (718) 886-6800

    Eran Hershco Licensed Real Estate Salesperson Office: 718-886-6800 Cell: 917-687-8454 3436 Union St Ste 201, Flushing, NY, 11354
    Connect With Me
    Standard Operating Procedure Fair Housing Notice
    Admin Login | DMCA Notice
    powered by www.erealtymedia.com
    Chat with us