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

28459  properties match your search;

26807 with Multiple photos ;  2756 with Virtual Tour ;  297 with Videos

Save Search
Showing 3391 - 3400 of 28459 results| view:  results per page« first|...|338|339|340|341|...|last »
  • Step into this spectacular Victorian Farmhouse with a wrap-around front porch, clapboard siding and working wood shutters in Huntington Historic District. Completely renovated and added onto by its architect owner in 2009, this home exudes historic charm while offering all of today’s luxury amenities. Upon entering you are greeted with the warmth of cherry wood floors and an eye catching staircase with its original carved banister and finial. There is an office with pocket doors on the left which could also be a 5th bedroom. Moving through the first floor you’ll enter the luxurious living room/dining room area with custom cherry millwork and a wood-burning stove. The all white marble, eat-in chef’s kitchen is state of the art featuring a large center island, 2 sinks, 2 dishwashers, a pot filler, 6 burner gas range, Viking double oven, a warming drawer, marble counters and a tin ceiling. Upstairs there are 4 spacious, bright and airy bedrooms and 2 full bathrooms. The primary suite has its own full bath and dressing area. The laundry is conveniently located on the 2nd floor. There is an extra large bonus/entertainment room on the 3rd floor with a counter, sink, microwave and fridge for drinks and snacks. The backyard is a private oasis highlighted by a glistening inground heated saltwater pool (2009). The paver driveway leads to a barn/garage with a large loft. 35
    64 Dewey Street Huntington, NY 11743
    $1,650,000
    $1,600,000
    4 Bedrooms 3 Full Baths
    Single Family For Sale OPEN HOUSEPRICE REDUCED ML# 3580586
    Step into this spectacular Victorian Farmhouse with a wrap-around front porch, clapboard siding and working wood shutters in Huntington Historic District. Completely renovated and added onto by its architect owner in 2009, this home exudes historic charm while offering all of today’s luxury amenities. Upon entering you are greeted with the warmth of cherry wood floors and an eye catching staircase with its original carved banister and finial. There is an office with pocket doors on the left which could also be a 5th bedroom. Moving through the first floor you’ll enter the luxurious living room/dining room area with custom cherry millwork and a wood-burning stove. The all white marble, eat-in chef’s kitchen is state of the art featuring a large center island, 2 sinks, 2 dishwashers, a pot filler, 6 burner gas range, Viking double oven, a warming drawer, marble counters and a tin ceiling. Upstairs there are 4 spacious, bright and airy bedrooms and 2 full bathrooms. The primary suite has its own full bath and dressing area. The laundry is conveniently located on the 2nd floor. There is an extra large bonus/entertainment room on the 3rd floor with a counter, sink, microwave and fridge for drinks and snacks. The backyard is a private oasis highlighted by a glistening inground heated saltwater pool (2009). The paver driveway leads to a barn/garage with a large loft.
    Presented By: Signature Premier Properties  631-692-4800
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/16/2024 - 11/16/2024 12:30PM - 2:00PM
  • Legal 2 family detached frame house in Corona. This ideal multi-family property is an excellent income producer. Features 6 Bedrooms 5 bathrooms plus full finished basement with separate entrance. Excellent location, Situated just minutes from the most iconic attractions & parks in NYC/Queens - such as the New York Hall of Science, Queens Zoo, Queens Museum, Citi Field and Flushing Meadows Park. Located near Junction Blvd, Northern Blvd and Roosevelt Ave with supermarkets, restaurants, pharmacies, variety stores, playgrounds, #7 train station, Q-72/66 bus stops. 15
    35-17 99th Street Corona, NY 11368
    $1,600,000
    6 Bedrooms 5 Full Baths
    Multi Family For Sale ML# 3579719
    Legal 2 family detached frame house in Corona. This ideal multi-family property is an excellent income producer. Features 6 Bedrooms 5 bathrooms plus full finished basement with separate entrance. Excellent location, Situated just minutes from the most iconic attractions & parks in NYC/Queens - such as the New York Hall of Science, Queens Zoo, Queens Museum, Citi Field and Flushing Meadows Park. Located near Junction Blvd, Northern Blvd and Roosevelt Ave with supermarkets, restaurants, pharmacies, variety stores, playgrounds, #7 train station, Q-72/66 bus stops.
    Presented By: Chase Global Realty Corp  718-355-8788
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • This is your chance to own an iconic historic building in the heart of downtown Red Hook. While the property currently houses a thriving, turnkey restaurant and the famous Charlie O’s speakeasy, this is not a restaurant sale. The building itself is for sale, and the new owner has the flexibility to either continue the restaurant operation or repurpose the space for their own vision. Key Features: Building Details: The property includes a well-maintained restaurant and pub with a capacity of 200+ patrons, a newly added outdoor enclosed patio, and open-air courtyard dining. Iconic Speakeasy: Located on the lower level, this original Prohibition-era speakeasy retains a vintage charm with a classic bar, pressed tin ceilings, and a separate entrance. With a capacity for 80 guests, it’s perfect for a piano bar, nightclub, or a unique new concept. Historic Theatre Space: The original section of the building was once the Lyceum movie theatre, featuring 20-foot ceilings and fantastic acoustics. Currently leased on a month-to-month basis, this area offers incredible flexibility for future use ideal for arts, retail, warehouse or office space. Parking: With a 35-space parking variance and additional on- and off-street parking, parking will never be an issue for patrons or staff. Located in the bustling heart of Red Hook, this property is steeped in history and offers endless opportunities for creative redevelopment. Whether you choose to keep the existing businesses or transform the space to suit your needs, this is a must-see listing for investors, restaurateurs, or those looking to make their mark in a thriving market. Don’t miss out on owning a slice of Red Hook’s history! 32
    23 E Market Street Red Hook, NY 12571
    $1,600,000
    Industrial Commercial ML# H6327903
    This is your chance to own an iconic historic building in the heart of downtown Red Hook. While the property currently houses a thriving, turnkey restaurant and the famous Charlie O’s speakeasy, this is not a restaurant sale. The building itself is for sale, and the new owner has the flexibility to either continue the restaurant operation or repurpose the space for their own vision. Key Features: Building Details: The property includes a well-maintained restaurant and pub with a capacity of 200+ patrons, a newly added outdoor enclosed patio, and open-air courtyard dining. Iconic Speakeasy: Located on the lower level, this original Prohibition-era speakeasy retains a vintage charm with a classic bar, pressed tin ceilings, and a separate entrance. With a capacity for 80 guests, it’s perfect for a piano bar, nightclub, or a unique new concept. Historic Theatre Space: The original section of the building was once the Lyceum movie theatre, featuring 20-foot ceilings and fantastic acoustics. Currently leased on a month-to-month basis, this area offers incredible flexibility for future use ideal for arts, retail, warehouse or office space. Parking: With a 35-space parking variance and additional on- and off-street parking, parking will never be an issue for patrons or staff. Located in the bustling heart of Red Hook, this property is steeped in history and offers endless opportunities for creative redevelopment. Whether you choose to keep the existing businesses or transform the space to suit your needs, this is a must-see listing for investors, restaurateurs, or those looking to make their mark in a thriving market. Don’t miss out on owning a slice of Red Hook’s history!
    Presented By: KFortuna All Aspects Realty  845-867-4046
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • One of the most strategic properties to own along State Route 32, and the only one available this close to the highways, shopping, overlooking the world renowned Woodbury Commons Premium Outlet Center. Two hotel projects currently in Planning Board stage surrounding the building adding potentially 220 hotel rooms. This totally renovated former restaurant building has been re-purposed for a personal services business, with an entirely open span that can lend itself to many uses. Highest traffic count in town located seconds from the Woodbury Commons entrance with easy access and extreme visibility. Perfect for retail, storage, restaurant, office. Bring your vision, resources and let’s put something together today. 32
    140 Route 32 Woodbury Town, NY 10917
    $1,600,000
    Mixed Use Commercial ML# H6328244
    One of the most strategic properties to own along State Route 32, and the only one available this close to the highways, shopping, overlooking the world renowned Woodbury Commons Premium Outlet Center. Two hotel projects currently in Planning Board stage surrounding the building adding potentially 220 hotel rooms. This totally renovated former restaurant building has been re-purposed for a personal services business, with an entirely open span that can lend itself to many uses. Highest traffic count in town located seconds from the Woodbury Commons entrance with easy access and extreme visibility. Perfect for retail, storage, restaurant, office. Bring your vision, resources and let’s put something together today.
    Presented By: Keller Williams Realty  845-928-8000
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Great Investment Opportunity in Prime Area just minutes away from NYC.. This is an investors delight in the heart of Astoria. This 6 family consists of 6 renovated apartments. 5 -2 Bedrooms Apartments and an a 1 Bedroom Several apartments have been fully renovated with new kitchens and bathrooms. All other’s are in excellent condition. All apartments have large rooms with high ceilings. The basement has 2 separate entrances and is the entire length of the building. The property is well maintained and close to shops and public transportation. 34
    26-21 30th Street Long Island City, NY 11102
    $1,600,000
    Mixed Use Commercial ML# 3578659
    Great Investment Opportunity in Prime Area just minutes away from NYC.. This is an investors delight in the heart of Astoria. This 6 family consists of 6 renovated apartments. 5 -2 Bedrooms Apartments and an a 1 Bedroom Several apartments have been fully renovated with new kitchens and bathrooms. All other’s are in excellent condition. All apartments have large rooms with high ceilings. The basement has 2 separate entrances and is the entire length of the building. The property is well maintained and close to shops and public transportation.
    Presented By: Keller Williams Rlty Landmark  718-475-2700
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Great Investment Opportunity in Prime Area just minutes away from NYC.. This is an investors delight in the heart of Astoria. This 6 family consists of 6 renovated apartments. 5 -2 Bedrooms Apartments and an a 1 Bedroom Several apartments have been fully renovated with new kitchens and bathrooms. All other’s are in excellent condition. All apartments have large rooms with high ceilings. The basement has 2 separate entrances and is the entire length of the building. The property is well maintained and close to shops and public transportation. 33
    26-21 30th Street Astoria, NY 11102
    $1,600,000
    11 Bedrooms 6 Full Baths Sq. Ft. 5859.00:# Square Feet
    Multi Family For Sale ML# 3578647
    Great Investment Opportunity in Prime Area just minutes away from NYC.. This is an investors delight in the heart of Astoria. This 6 family consists of 6 renovated apartments. 5 -2 Bedrooms Apartments and an a 1 Bedroom Several apartments have been fully renovated with new kitchens and bathrooms. All other’s are in excellent condition. All apartments have large rooms with high ceilings. The basement has 2 separate entrances and is the entire length of the building. The property is well maintained and close to shops and public transportation.
    Presented By: Keller Williams Rlty Landmark  718-475-2700
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Opportunity knocks! Two new custom built homes on two approved lots --3.07 acres and .83 acre --to be built--each 1.6. Buyer can select their design from: naturalelementhomes.com. Square footage can be increased or decreased.Price can be increased or decreased based on the selected customization. Buyer will meet with esteemed builder to customize design. Construction financing by buyer to convert into mortgage. Photo displayed is an example and is not the house to be built---unless the purchaser selects this design. Heat: oil, geothermal or propane--selected by buyer.Prime-rare-amazing---location opportunity.A short walk to the beautiful, quaint and colorful Village of Tannersville.Close to nearby slopes and the Onteora Club. Rear lot: view of stream. Note: existing house to be removed.
    170 Route 23C Hunter, NY 12485
    $1,600,000
    3 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 2800.00:# Square Feet
    Single Family For Sale ML# H6325777
    Opportunity knocks! Two new custom built homes on two approved lots --3.07 acres and .83 acre --to be built--each 1.6. Buyer can select their design from: naturalelementhomes.com. Square footage can be increased or decreased.Price can be increased or decreased based on the selected customization. Buyer will meet with esteemed builder to customize design. Construction financing by buyer to convert into mortgage. Photo displayed is an example and is not the house to be built---unless the purchaser selects this design. Heat: oil, geothermal or propane--selected by buyer.Prime-rare-amazing---location opportunity.A short walk to the beautiful, quaint and colorful Village of Tannersville.Close to nearby slopes and the Onteora Club. Rear lot: view of stream. Note: existing house to be removed.
    Presented By: The Foxes Real Estate  914-949-7903
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • 6
    42 New Dorp Plaza Staten Island, NY 10306
    $1,600,000
    Mixed Use Commercial ML# 3577626
    Presented By: Neuhaus Realty Inc  718-979-3400
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Discover endless possibilities with this spacious land off Broadway in Monticello, NY. Perfect for development or your dream project. Includes existing home at 46 Lakewood Ave. Embrace the potential in a growing area make it yours today! Lots included: 115.-5-4, 115.-5-5 , 115.-5-6.1 & 115.-5-8.1. Public Water & Sewer. Oasis or development, your choice.
    46 Lakewood Avenue Thompson, NY 12701
    $1,600,000
    5 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 2441.00:# Square Feet
    Single Family For Sale ML# H6322697
    Discover endless possibilities with this spacious land off Broadway in Monticello, NY. Perfect for development or your dream project. Includes existing home at 46 Lakewood Ave. Embrace the potential in a growing area make it yours today! Lots included: 115.-5-4, 115.-5-5 , 115.-5-6.1 & 115.-5-8.1. Public Water & Sewer. Oasis or development, your choice.
    Presented By: Century 21 Full Service Realty  845-782-2221
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Styled with the romantic elegance and nestled in a picturesque setting, this Spacious English Tudor combines the classic allure of exquisite architecture with refined sophistication of French-inspired design. The storybook facade captivates with its steeply pitched rooflines, decorative half-timbering, & striking stonework. Charming arched doorways, leaded glass windows, and beautifully detailed masonry with original wood doors adorned with antique-style hardware, including large, ornamental hinges and door handles made from wrought iron or brass. The high ceilings enhance the sense of space and grandeur, making a powerful first impression in every room throughout the home. A Welcoming Front Door is adorned with decorative elements elaborate wrought-iron accents, and window of leaded glass inserts, which is characterized by small, diamond-shaped panes set within lead cames. This not only allows for privacy and filtered light but also adds a distinctive, period-appropriate element to the entryway the Stunning Rotunda Foyer with round dome high ceiling lit by Iron Grand Chandelier like no other! Walking through another hallway with closets, you are then greeted by a beautiful Grand Foyer Staircase. An inviting living room features a majestic stone fireplace and exposed Wood beam ceilings, original hardwood Floors that resonate elegance and sophistication. The formal dining room is a showcase of detailed craftsmanship, perfect for hosting elegant dinners and special gatherings. Graceful arches introduce an additional room with pantry and a kitchen of form & function with high-end master chef Viking Stove. An adjacent intimate dining room with large windows creates perfect environment for morning coffee or casual dining.The powder room for guests is designed with a nod to timeless beauty of mosaic windows and stunning flooring. Second Floor is introduced by the grand foyer staircase large hallway with high ceilings and handcrafted chandelier that leads to 3 three generously sized bedrooms, each offering a unique blend of elegance and comfort. The primary suite is a true retreat, with an adjacent additional room for ample space and a serene atmosphere. Again the high ceilings with beautiful chair rail designs only enhance your bedroom! A Second full Bathroom radiates more of Old-world charm while your foyer offers more closets. Step out onto your Balcony of soft lighting and enjoy your wine and morning or evening serene moments, overlooking your lovely landscaped yard, and a view of storybook of stone walls shed. A Large Full Finished Basement is left to your imagination with its high ceilings, additional rooms, & faux fireplace. A walk up full finished spacious attic has finished flooring, high ceilings, large windows, and a radiator. A stone archway leads to Backyard. Home has one car garage and private driveway. Close to Shopping, Transportation, Schools, and Parks... 36
    29-37 168th Street Flushing, NY 11358
    $1,680,000
    $1,600,000
    3 Bedrooms 2 Full Baths 1 Half Bath
    Single Family For Sale OPEN HOUSEPRICE REDUCED ML# 3576602
    Styled with the romantic elegance and nestled in a picturesque setting, this Spacious English Tudor combines the classic allure of exquisite architecture with refined sophistication of French-inspired design. The storybook facade captivates with its steeply pitched rooflines, decorative half-timbering, & striking stonework. Charming arched doorways, leaded glass windows, and beautifully detailed masonry with original wood doors adorned with antique-style hardware, including large, ornamental hinges and door handles made from wrought iron or brass. The high ceilings enhance the sense of space and grandeur, making a powerful first impression in every room throughout the home. A Welcoming Front Door is adorned with decorative elements elaborate wrought-iron accents, and window of leaded glass inserts, which is characterized by small, diamond-shaped panes set within lead cames. This not only allows for privacy and filtered light but also adds a distinctive, period-appropriate element to the entryway the Stunning Rotunda Foyer with round dome high ceiling lit by Iron Grand Chandelier like no other! Walking through another hallway with closets, you are then greeted by a beautiful Grand Foyer Staircase. An inviting living room features a majestic stone fireplace and exposed Wood beam ceilings, original hardwood Floors that resonate elegance and sophistication. The formal dining room is a showcase of detailed craftsmanship, perfect for hosting elegant dinners and special gatherings. Graceful arches introduce an additional room with pantry and a kitchen of form & function with high-end master chef Viking Stove. An adjacent intimate dining room with large windows creates perfect environment for morning coffee or casual dining.The powder room for guests is designed with a nod to timeless beauty of mosaic windows and stunning flooring. Second Floor is introduced by the grand foyer staircase large hallway with high ceilings and handcrafted chandelier that leads to 3 three generously sized bedrooms, each offering a unique blend of elegance and comfort. The primary suite is a true retreat, with an adjacent additional room for ample space and a serene atmosphere. Again the high ceilings with beautiful chair rail designs only enhance your bedroom! A Second full Bathroom radiates more of Old-world charm while your foyer offers more closets. Step out onto your Balcony of soft lighting and enjoy your wine and morning or evening serene moments, overlooking your lovely landscaped yard, and a view of storybook of stone walls shed. A Large Full Finished Basement is left to your imagination with its high ceilings, additional rooms, & faux fireplace. A walk up full finished spacious attic has finished flooring, high ceilings, large windows, and a radiator. A stone archway leads to Backyard. Home has one car garage and private driveway. Close to Shopping, Transportation, Schools, and Parks...
    Presented By: Keller Williams Rlty Landmark  718-475-2700
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/16/2024 - 11/16/2024 1:00PM - 3:00PM
    11/17/2024 - 11/17/2024 1:00PM - 3:00PM
Showing 3391 - 3400 of 28459 results| view:  results per page« first|...|338|339|340|341|...|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