Heidi Spellman Realty, llc Working Remotely Port Washington, NY 11050 P: (516) 767-0200 ~ C: (516) 410-1172 E-Mail: Heidi@HSR-NY.com

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

28934  properties match your search;

27789 with Multiple photos ;  2782 with Virtual Tour ;  297 with Videos

Save Search
Showing 1511 - 1520 of 28934 results| view:  results per page« first|...|150|151|152|153|...|last »
  • Welcome to this distinguished Center Hall Colonial in the prestigious Gates. This exquisite 6-bed, 3.5 bth residence blends timeless elegance with modern luxury. An open floor plan filled with natural light creates a warm, inviting atmosphere.The gourmet kitchen features premium stainless steel appliances, quartz countertops, and custom cabinetry. Entertain in the grand family room with elegant fireplace, or host dinners in the formal dining room. Upstairs, the primary suite serves as a retreat with vaulted ceilings and a spa-like bathroom featuring a soaking tub and 7-foot shower. 4 additional bedrooms, including a versatile fifth bedroom or theater room, offer ample relaxation space. Step outside to your private oasis with a beautifully landscaped backyard, w/ a stunning Mountain Lake pool and an outdoor kitchen with a gas BBQ and refrigerator. Additional amenities include gas heating, central air, and a finished basement, making this home a true embodiment of refined living. Additional Information: ParkingFeatures:2 Car Attached, 32
    16 Nome Drive Woodbury, NY 11797
    $2,749,888
    $2,688,000
    6 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 4950.00:#
    Single Family For Sale PRICE REDUCED ML# H6328389
    Welcome to this distinguished Center Hall Colonial in the prestigious Gates. This exquisite 6-bed, 3.5 bth residence blends timeless elegance with modern luxury. An open floor plan filled with natural light creates a warm, inviting atmosphere.The gourmet kitchen features premium stainless steel appliances, quartz countertops, and custom cabinetry. Entertain in the grand family room with elegant fireplace, or host dinners in the formal dining room. Upstairs, the primary suite serves as a retreat with vaulted ceilings and a spa-like bathroom featuring a soaking tub and 7-foot shower. 4 additional bedrooms, including a versatile fifth bedroom or theater room, offer ample relaxation space. Step outside to your private oasis with a beautifully landscaped backyard, w/ a stunning Mountain Lake pool and an outdoor kitchen with a gas BBQ and refrigerator. Additional amenities include gas heating, central air, and a finished basement, making this home a true embodiment of refined living. Additional Information: ParkingFeatures:2 Car Attached,
    Presented By: Serhant LLC  646-480-7665
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • LUXURIOUS BRAND NEW CONSTRUCTION!!!! Located In West Birchwood in Jericho School District This stunning east-facing residence offers 5 bedrooms and 4.5 bathrooms, with a generous living space of 3, 875 square feet and a lot size of 10, 890 square feet. The house is bathed in natural sunlight and boasts custom finishes throughout. High-end SUB Zero appliances, a smart home system that can be controlled via iPad, and meticulous attention to every detail ensure a seamless blend of style and functionality. The property features two gourmet kitchens with marble countertops, luxurious marble bathrooms with premium shower systems, and radiant floor heating thru out sunroom and basement. The property features two car garages, and a full finished basement with a separate entrance. TOP to Bottom HIGH END finishes its a builder’s home! MUST SEE! Convenient transportation with multiple bus stops nearby, and just a 6-minute drive to the LIRR. The home is located in a highly convenient area, close to supermarkets, parks, Target, Ikea, schools, and various shops. LOW R.E. taxes! Don’t miss this rare opportunity! 37
    9 Warren Lane Oyster Bay, NY 11753
    $2,688,000
    5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 3875.00:#
    Single Family For Sale ML# 3578859
    LUXURIOUS BRAND NEW CONSTRUCTION!!!! Located In West Birchwood in Jericho School District This stunning east-facing residence offers 5 bedrooms and 4.5 bathrooms, with a generous living space of 3, 875 square feet and a lot size of 10, 890 square feet. The house is bathed in natural sunlight and boasts custom finishes throughout. High-end SUB Zero appliances, a smart home system that can be controlled via iPad, and meticulous attention to every detail ensure a seamless blend of style and functionality. The property features two gourmet kitchens with marble countertops, luxurious marble bathrooms with premium shower systems, and radiant floor heating thru out sunroom and basement. The property features two car garages, and a full finished basement with a separate entrance. TOP to Bottom HIGH END finishes its a builder’s home! MUST SEE! Convenient transportation with multiple bus stops nearby, and just a 6-minute drive to the LIRR. The home is located in a highly convenient area, close to supermarkets, parks, Target, Ikea, schools, and various shops. LOW R.E. taxes! Don’t miss this rare opportunity!
    Presented By: B Square Realty Inc  718-939-8388
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • 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! 10
    2601 4 Street Unit 1 H Astoria, NY 11102
    $2,685,000
    Mixed Use Commercial ML# 3587708
    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: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to 606 Purchase Street, a beautifully maintained Colonial residence offering the perfect blend of historic charm and modern amenities. As you step inside, you’re greeted by an elegant entry foyer featuring a cozy nook with seating and a welcoming fireplace, creating the perfect spot to unwind or greet guests in style. This spacious home offers 5 bedrooms and 3.5 bathrooms, making it ideal for families of all sizes. The bright living areas are complemented by 5 working fireplaces throughout, providing warmth and ambiance. The first floor includes a sunroom, bathed in natural light, perfect for enjoying your morning coffee or as a peaceful retreat to enjoy the surrounding views. The modern kitchen is equipped with high-end appliances and flows seamlessly into the main living spaces, making entertaining a breeze. The 0.90-acre lot provides ample outdoor space with beautifully landscaped grounds, ideal for hosting gatherings or enjoying quiet time outdoors. 30
    606 Purchase Street Harrison, NY 10580
    $2,685,000
    5 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 5352.00:#
    Single Family For Sale ML# H6322926
    Welcome to 606 Purchase Street, a beautifully maintained Colonial residence offering the perfect blend of historic charm and modern amenities. As you step inside, you’re greeted by an elegant entry foyer featuring a cozy nook with seating and a welcoming fireplace, creating the perfect spot to unwind or greet guests in style. This spacious home offers 5 bedrooms and 3.5 bathrooms, making it ideal for families of all sizes. The bright living areas are complemented by 5 working fireplaces throughout, providing warmth and ambiance. The first floor includes a sunroom, bathed in natural light, perfect for enjoying your morning coffee or as a peaceful retreat to enjoy the surrounding views. The modern kitchen is equipped with high-end appliances and flows seamlessly into the main living spaces, making entertaining a breeze. The 0.90-acre lot provides ample outdoor space with beautifully landscaped grounds, ideal for hosting gatherings or enjoying quiet time outdoors.
    Presented By: Julia B Fee Sothebys Int. Rlty  914-967-4600
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Legal 7-family located in a highly sought-after area of Corona offering over 6% CAP rate. The property comprises one duplex 3-bedroom unit and six 1-bedroom units, all of which are currently fully leased, and all units are sub-metered, Tenant pays their own utilities making it a low-maintenance investment opportunity. The property has significant tax savings with a 421 tax abatement, the property is expected to generate strong cash flow and appreciate in value over time. Situated in the vibrant neighborhood of Corona, residents benefit from the convenience of being close to a plethora of amenities, including shopping centers, restaurants, schools, parks, and public transportation options. 21
    53-12 102nd Street , NY 11368
    $2,680,000
    9 Bedrooms 8 Full Baths Sq. Ft. 5116.00:#
    Multi Family Commercial ML# 3588292
    Legal 7-family located in a highly sought-after area of Corona offering over 6% CAP rate. The property comprises one duplex 3-bedroom unit and six 1-bedroom units, all of which are currently fully leased, and all units are sub-metered, Tenant pays their own utilities making it a low-maintenance investment opportunity. The property has significant tax savings with a 421 tax abatement, the property is expected to generate strong cash flow and appreciate in value over time. Situated in the vibrant neighborhood of Corona, residents benefit from the convenience of being close to a plethora of amenities, including shopping centers, restaurants, schools, parks, and public transportation options.
    Presented By: B Square Realty Inc  718-939-8388
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Brand new Retail space located at 52-16 Roosevelt Ave prime Woodside area. Ground floor 3, 064 Sqft plus cellar 2, 354 sqft available. 1/2 block to 7 subway train station . Half mile from Long Island Rail Road. One block from Queens Blvd. 15 Minutes commute to Manhattan. High foot traffic. This retail space is eligible for 15 years ICAP. 3
    52-16 Roosevelt Avenue Unit B1 Queens, NY 11377
    $2,680,000
    Sq. Ft. 5418.00:#
    Retail Commercial ML# 3557503
    Brand new Retail space located at 52-16 Roosevelt Ave prime Woodside area. Ground floor 3, 064 Sqft plus cellar 2, 354 sqft available. 1/2 block to 7 subway train station . Half mile from Long Island Rail Road. One block from Queens Blvd. 15 Minutes commute to Manhattan. High foot traffic. This retail space is eligible for 15 years ICAP.
    Presented By: New Group Realty Inc  718-255-9100
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Introducing an unparalleled opportunity in the heart of prime commercial space. Presenting a remarkable 7, 818 square foot building situated on a 0.76-acre lot, this property is a beacon of potential, strategically located just across from the renowned Shops of Nanuet and conveniently positioned right off Route 59. This investment opportunity affords a buyer to occupy 2, 200 square foot for their own business. The building is highly visible and is a high-traffic location, offering unparalleled exposure to a diverse and dynamic customer base. Contact us for information. 12
    78 S Middletown Rd Clarkstown, NY 10954
    $2,680,000
    Retail Commercial ML# H6273088
    Introducing an unparalleled opportunity in the heart of prime commercial space. Presenting a remarkable 7, 818 square foot building situated on a 0.76-acre lot, this property is a beacon of potential, strategically located just across from the renowned Shops of Nanuet and conveniently positioned right off Route 59. This investment opportunity affords a buyer to occupy 2, 200 square foot for their own business. The building is highly visible and is a high-traffic location, offering unparalleled exposure to a diverse and dynamic customer base. Contact us for information.
    Presented By: Triforce Commercial RE LLC  845-450-6500
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Rare to find. 2 story + basement mixed used commercial building located at the busy intersection of Utopia Pkwy and Horace Harding Exwy. Built in 2008 and has been well maintained. All units are currently under a Net Net lease (over $154, 000/yr). The property is only 2 blocks to Francis Lewis High School; walking distance to the Fresh Meadows Shopping Center (Kohl’s and AMC). Easy access via Long Island Expressway. Great for investment and to start a business 12
    61-07 Utopia Parkway Queens, NY 11365
    $2,680,000
    Sq. Ft. 4800.00:#
    Mixed Use Commercial ML# 3468862
    Rare to find. 2 story + basement mixed used commercial building located at the busy intersection of Utopia Pkwy and Horace Harding Exwy. Built in 2008 and has been well maintained. All units are currently under a Net Net lease (over $154, 000/yr). The property is only 2 blocks to Francis Lewis High School; walking distance to the Fresh Meadows Shopping Center (Kohl’s and AMC). Easy access via Long Island Expressway. Great for investment and to start a business
    Presented By: AAA Young Shuen Realty Inc  718-461-9494
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to this magnificent Trophy Home located in the heart of Bayside. Here you will find this custom-built home is a remarkable find and is quite exquisite. Uncompromised quality is what you will see both inside and out. Flooded with Natural light, soaring ceilings, Impeccable craftmanship, Luxury high end appliances, this is the perfect setting for entertaining family and friends. Meticulously maintained Hardwoods, Imported Granite & Marble, 2 fireplaces, Radiant floor heating, 2 zone central air conditioning, 9 zone heating, Central vacuum, a Wine Cellar, and much more. In the warmer months, you can restore and relax as you enjoy Al-Fresco dining outdoors on your patio with a built=in cooking station, including Luxury grill, food warmer, cleaning station, refrigerator, refreshment compartment & your very own outdoor cabana. Centrally located to all Transportation, Schools, Shopping, Parks and more in this coveted community, this corner property sits adjacent to the Bayside Gables and is just down the street from the Bayside Marina. Absolutely Stunning & Elegant, this beauty awaits you and ready for its new owners! PRICED TO SELL and a MUST SEE! 37
    28-05 216th Street , NY 11360
    $2,675,888
    5 Bedrooms 3 Full Baths 2 Half Baths Sq. Ft. 3800.00:#
    Single Family For Sale ML# 3486312
    Welcome to this magnificent Trophy Home located in the heart of Bayside. Here you will find this custom-built home is a remarkable find and is quite exquisite. Uncompromised quality is what you will see both inside and out. Flooded with Natural light, soaring ceilings, Impeccable craftmanship, Luxury high end appliances, this is the perfect setting for entertaining family and friends. Meticulously maintained Hardwoods, Imported Granite & Marble, 2 fireplaces, Radiant floor heating, 2 zone central air conditioning, 9 zone heating, Central vacuum, a Wine Cellar, and much more. In the warmer months, you can restore and relax as you enjoy Al-Fresco dining outdoors on your patio with a built=in cooking station, including Luxury grill, food warmer, cleaning station, refrigerator, refreshment compartment & your very own outdoor cabana. Centrally located to all Transportation, Schools, Shopping, Parks and more in this coveted community, this corner property sits adjacent to the Bayside Gables and is just down the street from the Bayside Marina. Absolutely Stunning & Elegant, this beauty awaits you and ready for its new owners! PRICED TO SELL and a MUST SEE!
    Presented By: Keller Williams Rlty Landmark  718-475-2700
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to 467 Great hill road Beautiful new construction all high end finishes with attention to detail, three levels of space to enjoy! beautiful chefs kitchen, stainless appliances quartz counter tops in kitchen and bathrooms hardwood floors though out full finished basement with egress, large back yard with mahogany deck and inground pool with paver patio for all of your out door furniture, short ride to the village (virtual furniture and landscaping added (shower doors in primary bedroom are staged actual ones will be frameless) 25
    467 Great Hill Rd Southampton, NY 11968
    $2,675,000
    4 Bedrooms 3 Full Baths 1 Half Bath
    Single Family For Sale ML# 3547685
    Welcome to 467 Great hill road Beautiful new construction all high end finishes with attention to detail, three levels of space to enjoy! beautiful chefs kitchen, stainless appliances quartz counter tops in kitchen and bathrooms hardwood floors though out full finished basement with egress, large back yard with mahogany deck and inground pool with paver patio for all of your out door furniture, short ride to the village (virtual furniture and landscaping added (shower doors in primary bedroom are staged actual ones will be frameless)
    Presented By: Hampton Sales & Rentals Corp  631-728-0474
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
Showing 1511 - 1520 of 28934 results| view:  results per page« first|...|150|151|152|153|...|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 Heidi Spellman are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.

Questions? Just Ask!

 Submit

Heidi Spellman Realty, LLC
Working remotely - Port Washington 516.767.0200

Standard Operating Procedure
sitemap | admin login | DMCA Notice
powered by www.erealtymedia.com