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 2551 - 2560 of 28934 results| view:  results per page« first|...|254|255|256|257|...|last »
  • Vacant, Detached, Brick Two-family on a 40 x 100 lot. Location, Location, Location. Large building Size with 2 Apartments Each with a Spacious Layout. On the First Floor You Will Find a Family Room plus an Additional Room and a Full Bathroom. On the Second Floor There Are 3 Large Bedrooms, a Formal Dining Room, a Nice Size Living Room and a Full bathroom. On the Third Floor There 2 Large Bedrooms, a Formal Dining Room, Living Room, Kitchen, Full Bathroom and a 26 x 12 Terrace. Beautiful Hardwood Floors Throughout, Lots of Natural Light. This 2 Family Property is Perfect for Investors, Owner Occupancy or Multi-Generational Living. Located Near Shopping or Dining on Bell Blvd, , Schools, Places of Worship, LIRR, Express Bus, 18 min Bus ride to #7 Train in Main Street. A must see !! 25
    43-12 205th Street Bayside, NY 11361
    $1,888,000
    6 Bedrooms 3 Full Baths
    Multi Family For Sale ML# 3583464
    Vacant, Detached, Brick Two-family on a 40 x 100 lot. Location, Location, Location. Large building Size with 2 Apartments Each with a Spacious Layout. On the First Floor You Will Find a Family Room plus an Additional Room and a Full Bathroom. On the Second Floor There Are 3 Large Bedrooms, a Formal Dining Room, a Nice Size Living Room and a Full bathroom. On the Third Floor There 2 Large Bedrooms, a Formal Dining Room, Living Room, Kitchen, Full Bathroom and a 26 x 12 Terrace. Beautiful Hardwood Floors Throughout, Lots of Natural Light. This 2 Family Property is Perfect for Investors, Owner Occupancy or Multi-Generational Living. Located Near Shopping or Dining on Bell Blvd, , Schools, Places of Worship, LIRR, Express Bus, 18 min Bus ride to #7 Train in Main Street. A must see !!
    Presented By: Weichert Realtors TMT Group  646-358-7068
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Calling All Investors, Developers, & End-Users!!! 2, 180 Sqft. Free Market Apartment Building With Large Garage & Private Gated Parking For Sale!!! The Property Features Excellent Signage, Great Exposure, Strong M1-1 Zoning, 8 Gated Parking Spaces, High 8’ Ceilings, Separate Meters, Low Property Taxes, Full Basement, Separate Entrances, Gated Yard, 100 Amp Power, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Flushing Just Blocks From CitiField, The Shops At SkyView & The Van Wyck Expressway. Neighbors Include Nike, The Home Depot, Target, Best Buy, CubeSmart Self Storage, Macy’s, Dunkin’, Kohl’s, Applebee’s Bar & Grill, Blink Fitness, Mattress Firm, AMC Theaters, Micro Center, Shell, +++!!! The Entire Property Can Be Delivered Vacant If Need Be. This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or The Next Home For Your Business!!! Income: 1st Floor (1 Br. Apt.): $31, 200 Ann. (Available) 2nd Floor (1 Br. Apt): $30, 000 Ann. (Available) 1 Car Garage + 8 Gated Parking Spaces: $58, 300 Ann. (Available) Full Basement (800 Sqft.): $22, 800 Ann. (Available) Pro Forma Gross Income: $142, 300 Ann. Expenses: Oil : $0 Ann. Electric: $0 Ann. Water + Sewer: $980 Ann. Insurance: $1, 023 Ann. Maintenance & Repairs: $250 Ann. Taxes: $6, 428.44 Ann. Total Expenses: $8, 681.44 Ann. Net Operating Income (NOI): $133, 618.56 Ann. 12
    42-11 Haight Street Flushing, NY 11355
    $1,888,000
    Mixed Use Commercial ML# 3519183
    Calling All Investors, Developers, & End-Users!!! 2, 180 Sqft. Free Market Apartment Building With Large Garage & Private Gated Parking For Sale!!! The Property Features Excellent Signage, Great Exposure, Strong M1-1 Zoning, 8 Gated Parking Spaces, High 8’ Ceilings, Separate Meters, Low Property Taxes, Full Basement, Separate Entrances, Gated Yard, 100 Amp Power, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Flushing Just Blocks From CitiField, The Shops At SkyView & The Van Wyck Expressway. Neighbors Include Nike, The Home Depot, Target, Best Buy, CubeSmart Self Storage, Macy’s, Dunkin’, Kohl’s, Applebee’s Bar & Grill, Blink Fitness, Mattress Firm, AMC Theaters, Micro Center, Shell, +++!!! The Entire Property Can Be Delivered Vacant If Need Be. This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or The Next Home For Your Business!!! Income: 1st Floor (1 Br. Apt.): $31, 200 Ann. (Available) 2nd Floor (1 Br. Apt): $30, 000 Ann. (Available) 1 Car Garage + 8 Gated Parking Spaces: $58, 300 Ann. (Available) Full Basement (800 Sqft.): $22, 800 Ann. (Available) Pro Forma Gross Income: $142, 300 Ann. Expenses: Oil : $0 Ann. Electric: $0 Ann. Water + Sewer: $980 Ann. Insurance: $1, 023 Ann. Maintenance & Repairs: $250 Ann. Taxes: $6, 428.44 Ann. Total Expenses: $8, 681.44 Ann. Net Operating Income (NOI): $133, 618.56 Ann.
    Presented By: All Island Estates Realty Corp  516-783-5600
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Experience hotel style living at its finest in our meticulously designed condominium, where comfort and style harmonize seamlessly. Upon entry, you’re welcomed into a chic foyer, offering a glimpse of the sophistication that awaits within. A convenient powder room ensures practicality without compromising on style. Embrace culinary delights in the sleek and modern kitchen, equipped with top-of-the-line appliances and ample storage space. The adjoining dining area provides an inviting atmosphere for shared meals and cherished moments with loved ones. Unwind in the inviting living room or go out to your private balcony where you can savor moments of tranquility and take in the surrounding views. Retreat to the primary suite, featuring a luxurious ensuite bath and a spacious walk-in closet, offering both relaxation and functionality. For guests or family members, the second bedroom provides a cozy haven complete with its own ensuite bath, ensuring privacy and comfort for all. The Ritz-Carlton Residences is not just a home; it’s a private gated community that offers an unparalleled array of amenities. In our 25, 000 square foot Clubhouse, watch your favorite films in the theater, perfect your swing in the game and billiard room with a golf simulator, or maintain your fitness regimen in the state-of-the-art Fitness Center. When relaxation calls, take a dip in the Indoor/Outdoor Pool, or host grand gatherings in the banquet rooms and conference room. Unwind with friends and neighbors in the resident lounge and bar. At The Ritz-Carlton Residences, convenience is paramount. A 24-hour Concierge, doorman, and valet parking services ensure that your every need is met. A generator guarantees uninterrupted comfort. And when you’re ready to explore, you’ll find yourself in the heart of it all, with high-end shopping and renowned restaurants just minutes away. 25
    5000 Royal Court Unit 5112 North Hempstead, NY 11040
    $1,885,000
    2 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 1619.00:#
    Condo For Sale ML# 3547395
    Experience hotel style living at its finest in our meticulously designed condominium, where comfort and style harmonize seamlessly. Upon entry, you’re welcomed into a chic foyer, offering a glimpse of the sophistication that awaits within. A convenient powder room ensures practicality without compromising on style. Embrace culinary delights in the sleek and modern kitchen, equipped with top-of-the-line appliances and ample storage space. The adjoining dining area provides an inviting atmosphere for shared meals and cherished moments with loved ones. Unwind in the inviting living room or go out to your private balcony where you can savor moments of tranquility and take in the surrounding views. Retreat to the primary suite, featuring a luxurious ensuite bath and a spacious walk-in closet, offering both relaxation and functionality. For guests or family members, the second bedroom provides a cozy haven complete with its own ensuite bath, ensuring privacy and comfort for all. The Ritz-Carlton Residences is not just a home; it’s a private gated community that offers an unparalleled array of amenities. In our 25, 000 square foot Clubhouse, watch your favorite films in the theater, perfect your swing in the game and billiard room with a golf simulator, or maintain your fitness regimen in the state-of-the-art Fitness Center. When relaxation calls, take a dip in the Indoor/Outdoor Pool, or host grand gatherings in the banquet rooms and conference room. Unwind with friends and neighbors in the resident lounge and bar. At The Ritz-Carlton Residences, convenience is paramount. A 24-hour Concierge, doorman, and valet parking services ensure that your every need is met. A generator guarantees uninterrupted comfort. And when you’re ready to explore, you’ll find yourself in the heart of it all, with high-end shopping and renowned restaurants just minutes away.
    Presented By: Compass Greater NY LLC  516-517-4751
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • 17
    42-15 165th Street , NY 11358
    $1,880,000
    8 Bedrooms 6 Full Baths
    Single Family For Sale ML# 3589478
    Presented By: E Realty International Corp  718-886-8110
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Young 2 families brick house in the heart of Whitestone. located in the quite residential street, There are two 3 bedrooms with 2 full baths units, high ceiling in the basement, walk out to backyard. central air system, hard wood floors, granite countertops. close school , could be 2-3 parking spaces on the driveway. will be delivered vacant. buyers should verify all information independently. 13
    151-07 17th Avenue Queens, NY 11357
    $1,880,000
    6 Bedrooms 4 Full Baths Sq. Ft. 2310.00:#
    Misc For Sale ML# 3589407
    Young 2 families brick house in the heart of Whitestone. located in the quite residential street, There are two 3 bedrooms with 2 full baths units, high ceiling in the basement, walk out to backyard. central air system, hard wood floors, granite countertops. close school , could be 2-3 parking spaces on the driveway. will be delivered vacant. buyers should verify all information independently.
    Presented By: Sany Realty Group LLC  718-799-0726
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to this stunning, custom-built, two-story brick residence in the heart of Whitestone, meticulously renovated with top-tier imported finishes and premium appliances, including Miele, Bertazzoni, and Viking. The home radiates elegance and modern sophistication, starting with a grand foyer and custom walnut flooring that set a luxurious tone from the moment you enter. The upper level boasts four spacious bedrooms and two bathrooms, including a master suite complete with a walk-in closet. The expansive, high-ceilinged living room is both beautiful and functional, offering a welcoming and refined space for relaxation and gatherings. On the lower level, the open-concept kitchen combines elegance with functionality, featuring radiant heated floors, a large granite island, a premium appliance suite, and custom cabinetry. Adjacent to the kitchen, the cozy family room opens seamlessly to the tranquil patio and backyard through glass doors, perfect for effortless indoor-outdoor living. The spacious walk-out lower level offers abundant closet and storage space with additional access to the backyard. The versatile unfinished basement can be customized to suit the buyer’s preferred use. Outdoor spaces are thoughtfully designed for entertaining, and the home includes central air and an attached two-car garage. Every detail has been thoughtfully crafted, with custom walnut flooring throughout and bathrooms enhanced by walnut cabinetry, adding a refined, cohesive aesthetic. A beautiful staircase with imported walnut steps leads to the upper level, where you’ll find four spacious bedrooms and two bathrooms, including a luxurious master suite complete with a walk-in closet. The expansive, high-ceilinged living room is designed to offer both beauty and functionality, creating an inviting space for relaxation and gatherings. Conveniently located near Francis Lewis Park and just minutes from major highways and bridges, this exceptional home blends timeless elegance with modern convenience, creating an unparalleled living experience. 32
    243 150th Street , NY 11357
    $1,880,000
    4 Bedrooms 3 Full Baths 1 Half Bath
    Single Family For Sale ML# 3588776
    Welcome to this stunning, custom-built, two-story brick residence in the heart of Whitestone, meticulously renovated with top-tier imported finishes and premium appliances, including Miele, Bertazzoni, and Viking. The home radiates elegance and modern sophistication, starting with a grand foyer and custom walnut flooring that set a luxurious tone from the moment you enter. The upper level boasts four spacious bedrooms and two bathrooms, including a master suite complete with a walk-in closet. The expansive, high-ceilinged living room is both beautiful and functional, offering a welcoming and refined space for relaxation and gatherings. On the lower level, the open-concept kitchen combines elegance with functionality, featuring radiant heated floors, a large granite island, a premium appliance suite, and custom cabinetry. Adjacent to the kitchen, the cozy family room opens seamlessly to the tranquil patio and backyard through glass doors, perfect for effortless indoor-outdoor living. The spacious walk-out lower level offers abundant closet and storage space with additional access to the backyard. The versatile unfinished basement can be customized to suit the buyer’s preferred use. Outdoor spaces are thoughtfully designed for entertaining, and the home includes central air and an attached two-car garage. Every detail has been thoughtfully crafted, with custom walnut flooring throughout and bathrooms enhanced by walnut cabinetry, adding a refined, cohesive aesthetic. A beautiful staircase with imported walnut steps leads to the upper level, where you’ll find four spacious bedrooms and two bathrooms, including a luxurious master suite complete with a walk-in closet. The expansive, high-ceilinged living room is designed to offer both beauty and functionality, creating an inviting space for relaxation and gatherings. Conveniently located near Francis Lewis Park and just minutes from major highways and bridges, this exceptional home blends timeless elegance with modern convenience, creating an unparalleled living experience.
    Presented By: Tru International Realty Corp  929-608-9600
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to this exceptional income-producing two-family property, perfectly nestled between Beech and Cherry Avenues on 149th Street in the heart of Murray Hill, Flushing. Whether you’re an investor or looking for multi-generational living, this home offers a prime opportunity in a highly sought-after neighborhood. With schools, shops, and restaurants just around the corner, you’ll also appreciate the convenience of Flushing Hospital just four blocks away. Commuting is a breeze with the Murray Hill LIRR station a mere five blocks from your doorstep, whisking you into Manhattan and throughout NYC and Long Island in no time. Set in a vibrant community, this property combines functionality with charm, providing spacious layouts in both units. A fantastic investment that offers comfort and convenience. Don’t miss out on owning a piece of one of Flushing’s best-kept secrets-schedule a viewing today and discover why this home is truly a cut above the rest. Potential income is worthwhile for any investor or end user. 26
    42-74 149th Street Queens, NY 11355
    $1,880,000
    7 Bedrooms 2 Full Baths Sq. Ft. 3067.00:#
    Misc For Sale ML# 3587100
    Welcome to this exceptional income-producing two-family property, perfectly nestled between Beech and Cherry Avenues on 149th Street in the heart of Murray Hill, Flushing. Whether you’re an investor or looking for multi-generational living, this home offers a prime opportunity in a highly sought-after neighborhood. With schools, shops, and restaurants just around the corner, you’ll also appreciate the convenience of Flushing Hospital just four blocks away. Commuting is a breeze with the Murray Hill LIRR station a mere five blocks from your doorstep, whisking you into Manhattan and throughout NYC and Long Island in no time. Set in a vibrant community, this property combines functionality with charm, providing spacious layouts in both units. A fantastic investment that offers comfort and convenience. Don’t miss out on owning a piece of one of Flushing’s best-kept secrets-schedule a viewing today and discover why this home is truly a cut above the rest. Potential income is worthwhile for any investor or end user.
    Presented By: Compass Greater NY LLC  516-517-4751
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to Lloyed Harbor. This Renovated Farm Ranch Sets on a 2.74 Acre Land. It Offers Elegant Living at its Finest. Large Living Room with Fire Place, Formal Dining Room, Open Floor Kitchen with Wolf Stove, Center Island, Wine cooler and the 2nd Fire Place. High Ceiling, Huge Common Area is Great for Family Gathering. Both Primary & 2nd Primary Bedroom W/Bath, Primary Bath has Radiant Heat Floor. Full Finished Basement w/Full bath, Plenty Room to Make your own Gym or Home Theater, Separated Entrance. Hard Wood Floor, Central Air, 2 Attached Garage, 2 Car Drive way and a Separated Parking lot is perfect for Visitors. Brand New roof, Brand New Sprinkler System. In Ground Swimming Pool, Fish Pond and Tennis Court. It close to Water, Park, Schools, Shop and Dining. Award-winning Cold Spring Harbor School. Must See.The Owner is in the Process of Grieving the Taxes.The Estimate Tax will be Reduced about $8, 900 a year. 26
    7 Harbor Hill Drive Huntington, NY 11743
    $1,880,000
    7 Bedrooms 5 Full Baths
    Single Family For Sale OPEN HOUSE ML# 3575868
    Welcome to Lloyed Harbor. This Renovated Farm Ranch Sets on a 2.74 Acre Land. It Offers Elegant Living at its Finest. Large Living Room with Fire Place, Formal Dining Room, Open Floor Kitchen with Wolf Stove, Center Island, Wine cooler and the 2nd Fire Place. High Ceiling, Huge Common Area is Great for Family Gathering. Both Primary & 2nd Primary Bedroom W/Bath, Primary Bath has Radiant Heat Floor. Full Finished Basement w/Full bath, Plenty Room to Make your own Gym or Home Theater, Separated Entrance. Hard Wood Floor, Central Air, 2 Attached Garage, 2 Car Drive way and a Separated Parking lot is perfect for Visitors. Brand New roof, Brand New Sprinkler System. In Ground Swimming Pool, Fish Pond and Tennis Court. It close to Water, Park, Schools, Shop and Dining. Award-winning Cold Spring Harbor School. Must See.The Owner is in the Process of Grieving the Taxes.The Estimate Tax will be Reduced about $8, 900 a year.
    Presented By: Charles Rutenberg Realty Inc  516-575-7500
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/17/2024 - 11/17/2024 2:15PM - 4:00PM
  • BRING YOUR DESIGNER OR CONTRACTOR. Nestled on 2.3 acres of serene landscape set back from the street, this property offers a blank canvas to create your dream home. Recently gutted, it presents endless possibilities to craft a one-of-a-kind sanctuary tailored to your desires. This property will transfer into the hands of its new owners, ready to be transformed. Complete with 12 rooms, a 7-bedroom 4.5 baths, with new Marvin windows and doors already installed, this residence offers a blank slate for you to craft your dream home. The two-story layout provides ample space for customization, while the spacious backyard, large slate patio, and open layout basement are ready for your transformative touch. Picture yourself creating a masterpiece tailored to your tastes and lifestyle, supported by a recently installed 300-amp underground electrical service. 36 Farmstead Lane, a hidden gem nestled in the heart of Nassau County. Set back down a private cul-de-sac street, this property offers unrivaled privacy and tranquility, providing the perfect backdrop for your dream home. Brookville’s Ideal Location and Lifestyle: Brookville, renowned for its upscale charm and natural beauty, is perfectly situated just 25 miles from the vibrant heart of New York City-combining the best of suburban tranquility with urban convenience. The property is located on one of the most coveted streets within the prestigious Jericho school district, celebrated as the best in New York. As a resident, you’ll enjoy exclusive access to nearby gold clubs like Brookville Country Club, Old Westbury Golf & Country Club, Old Westbury Gardens, Brookville Park, Nearby Beaches, Shopping/ Dining, and other cultural and recreational amenities. 36
    36 Farmstead Lane Oyster Bay, NY 11545
    $1,880,000
    7 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 4495.00:#
    Single Family For Sale ML# 3575857
    BRING YOUR DESIGNER OR CONTRACTOR. Nestled on 2.3 acres of serene landscape set back from the street, this property offers a blank canvas to create your dream home. Recently gutted, it presents endless possibilities to craft a one-of-a-kind sanctuary tailored to your desires. This property will transfer into the hands of its new owners, ready to be transformed. Complete with 12 rooms, a 7-bedroom 4.5 baths, with new Marvin windows and doors already installed, this residence offers a blank slate for you to craft your dream home. The two-story layout provides ample space for customization, while the spacious backyard, large slate patio, and open layout basement are ready for your transformative touch. Picture yourself creating a masterpiece tailored to your tastes and lifestyle, supported by a recently installed 300-amp underground electrical service. 36 Farmstead Lane, a hidden gem nestled in the heart of Nassau County. Set back down a private cul-de-sac street, this property offers unrivaled privacy and tranquility, providing the perfect backdrop for your dream home. Brookville’s Ideal Location and Lifestyle: Brookville, renowned for its upscale charm and natural beauty, is perfectly situated just 25 miles from the vibrant heart of New York City-combining the best of suburban tranquility with urban convenience. The property is located on one of the most coveted streets within the prestigious Jericho school district, celebrated as the best in New York. As a resident, you’ll enjoy exclusive access to nearby gold clubs like Brookville Country Club, Old Westbury Golf & Country Club, Old Westbury Gardens, Brookville Park, Nearby Beaches, Shopping/ Dining, and other cultural and recreational amenities.
    Presented By: Luxian International Realty  917-567-8767
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Incredible Opportunity With This 3 STORY Legal TWO FAMILY + STORE FRONT MIX USE In FLUSHING. Each Of The Spacious Apartments Feature Large Three Bedrooms & Two Full Bathrooms. The Street Level Offers A Medical / Treatment Space-Office That Would Be Perfect For A Dentist Or Acupuncturist. This Magnificent Investment Was Built in 2007 And It Offers Even More Space In A Full Finished Basement While Front And Rear Of The Property Can Fit Up To 4 Cars. Situated On The Border Of Flushing And Bayside It Allows For An Easy Access To Multiple Bus Lines, Shopping, Restaurants, Community Centers And Much More! 12
    199-06 47th Avenue Flushing, NY 11358
    $1,880,000
    6 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 4595.00:# Square Feet
    Multi Family For Sale ML# 3572735
    Incredible Opportunity With This 3 STORY Legal TWO FAMILY + STORE FRONT MIX USE In FLUSHING. Each Of The Spacious Apartments Feature Large Three Bedrooms & Two Full Bathrooms. The Street Level Offers A Medical / Treatment Space-Office That Would Be Perfect For A Dentist Or Acupuncturist. This Magnificent Investment Was Built in 2007 And It Offers Even More Space In A Full Finished Basement While Front And Rear Of The Property Can Fit Up To 4 Cars. Situated On The Border Of Flushing And Bayside It Allows For An Easy Access To Multiple Bus Lines, Shopping, Restaurants, Community Centers And Much More!
    Presented By: Exit All Seasons Realty  718-416-4411
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
Showing 2551 - 2560 of 28934 results| view:  results per page« first|...|254|255|256|257|...|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