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

28666  properties match your search;

27583 with Multiple photos ;  2721 with Virtual Tour ;  290 with Videos

Save Search
Showing 5251 - 5260 of 28666 results| view:  results per page« first|...|524|525|526|527|...|last »
  • Welcome to this exquisite and exceptional colonial 10 rooms or more legal single-family home located at 195-12 McLaughlin Avenue in Holliswood, Queens NY 11423. Holliswood is an exclusive suburban, tranquil, and serene neighborhood zoned for Blue Ribbon School District 26. This charming residence features 4 bedrooms, 3 bathrooms closets, and a pull-down attic staircase. The second floor has a landing, a linen closet, another closet space, 3 bedrooms, and a bathroom. The first floor features one bedroom, a powder room, and a laundry room with a washer and dryer for your convenience-Eat-in kitchen with pantry and appliances, and with entrances to the basement and backyard. A formal dining room, with huge windows, a spacious living room, an inviting foyer, and a deck all come together to create an ideal living space for customization to your desire and imagination. The living room and foyer have expansive windows that capture the sunlight and illuminate the living space with serenity, peace, and an inviting glow to the entire home. This serves as a focal point of the home and provides a seamless connection between indoor and outdoor living. The large private backyard has a shed that is a tranquil oasis that can be customized to your liking or desire. The property has an extended fully finished basement and a huge cedar closet. This home has a private walk-out garage attached to an extra long and spacious private walk-out driveway and front yard, providing security and convenience to accommodate several cars. The zoning permits extension up to 0.5 FAR on this 4356 square foot that offers the potential to customize to your desire to make this home your dream mansion. Close to houses of worship, colleges, nurseries, shopping, transportation, bus, subways, highways, and parks. A property of this caliber in such a prime location on a serene tree-lined street is rarely available in Holliswood Queens New York. Explore this exquisite neighborhood. 32
    195-12 Mclaughlin Avenue Holliswood, NY 11423
    $1,188,000
    4 Bedrooms 3 Full Baths
    Single Family For Sale ML# 3566951
    Welcome to this exquisite and exceptional colonial 10 rooms or more legal single-family home located at 195-12 McLaughlin Avenue in Holliswood, Queens NY 11423. Holliswood is an exclusive suburban, tranquil, and serene neighborhood zoned for Blue Ribbon School District 26. This charming residence features 4 bedrooms, 3 bathrooms closets, and a pull-down attic staircase. The second floor has a landing, a linen closet, another closet space, 3 bedrooms, and a bathroom. The first floor features one bedroom, a powder room, and a laundry room with a washer and dryer for your convenience-Eat-in kitchen with pantry and appliances, and with entrances to the basement and backyard. A formal dining room, with huge windows, a spacious living room, an inviting foyer, and a deck all come together to create an ideal living space for customization to your desire and imagination. The living room and foyer have expansive windows that capture the sunlight and illuminate the living space with serenity, peace, and an inviting glow to the entire home. This serves as a focal point of the home and provides a seamless connection between indoor and outdoor living. The large private backyard has a shed that is a tranquil oasis that can be customized to your liking or desire. The property has an extended fully finished basement and a huge cedar closet. This home has a private walk-out garage attached to an extra long and spacious private walk-out driveway and front yard, providing security and convenience to accommodate several cars. The zoning permits extension up to 0.5 FAR on this 4356 square foot that offers the potential to customize to your desire to make this home your dream mansion. Close to houses of worship, colleges, nurseries, shopping, transportation, bus, subways, highways, and parks. A property of this caliber in such a prime location on a serene tree-lined street is rarely available in Holliswood Queens New York. Explore this exquisite neighborhood.
    Presented By: Exit Realty First Choice  718-380-2500
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • This incredible new construction to be built by renowned builder recognized for Design and Craftsmanship is in the Heart of Hicksville with proximity to all public transportation and would be ready by September 2024.The 1800 sq. ft, East facing colonial style SMART home with double driveway, 4 Bedrooms and 3 Full bathrooms sits on 5340sq corner lot which brings in lots of daylight. With Anderson Windows and all exterior stucco, insulation is at its next level. A 9ft high Basement ceiling with egress window and side entrance could be great for entertainment. First Floor has an open layout with gas cooking Chef’s kitchen open to dining area, family room with gas fireplace, full bathroom and a good size bedroom. The second floor offers Primary en suite with WIC, two additional bedrooms with sharing full bath and Laundry Room. Gleaming hardwood floors throughout, two zoned Central A/C, and forced air gas heat would give you the comfort you deserve. Very low taxes until re assessment. Look no further and make this your dream home. 6
    10 Locust Street Hicksville, NY 11801
    $1,188,000
    4 Bedrooms 3 Full Baths Sq. Ft. 1800.00:# Square Feet
    Single Family For Sale ML# 3559373
    This incredible new construction to be built by renowned builder recognized for Design and Craftsmanship is in the Heart of Hicksville with proximity to all public transportation and would be ready by September 2024.The 1800 sq. ft, East facing colonial style SMART home with double driveway, 4 Bedrooms and 3 Full bathrooms sits on 5340sq corner lot which brings in lots of daylight. With Anderson Windows and all exterior stucco, insulation is at its next level. A 9ft high Basement ceiling with egress window and side entrance could be great for entertainment. First Floor has an open layout with gas cooking Chef’s kitchen open to dining area, family room with gas fireplace, full bathroom and a good size bedroom. The second floor offers Primary en suite with WIC, two additional bedrooms with sharing full bath and Laundry Room. Gleaming hardwood floors throughout, two zoned Central A/C, and forced air gas heat would give you the comfort you deserve. Very low taxes until re assessment. Look no further and make this your dream home.
    Presented By: Realty Connect USA LLC  mannysny@gmail.com
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Calling All Investors, Developers, End-Users & Entrepreneurs!!! Successful Corner Gas Station / Repair Shop + Convenience Store For Sale!!! The Property Features Great Exposure, Excellent Signage, Strong Zoning, Brand New Pumps, Brand New Double Walled Fiberglass Tanks, 2 Bay Repair Shop, 3 Strategically Placed Curb Cuts, (2) 9k Gallon Regular Tanks, 6k Gallon Premium Tank, 28 Parking Spaces, High 14’ Ceilings, Security System, 3 Phase Power, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Saint James On Lake Avenue 6 Blocks From The Saint James LIRR Station!!! The Property Has 106+ Feet Of Frontage On Busy Lake Avenue!!! Neighbors Include Starbucks, USPS, Mercedes, Lexus, Acura, Kia, Toyota, Jeep-Dodge-Ram, Chevrolet, Mazda, TD Bank, King Kullen, 7-Eleven, Dunkin’, Whole Foods, Costco, BP Gas, Lowe’s, Trader Joe’s, Macy’s, +++!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or The Next Home For Your Business!!! This Property Can Be Purchased With 386 Lake Avenue For Only $2.25m!!! Income: 2 Bay Auto Repair: $48, 000 Ann. Lease Exp.: 2026. Expenses: Taxes: $12, 572 Ann. 7
    255 Lake Avenue Saint James, NY 11780
    $1,188,000
    Mixed Use Commercial ML# 3546001
    Calling All Investors, Developers, End-Users & Entrepreneurs!!! Successful Corner Gas Station / Repair Shop + Convenience Store For Sale!!! The Property Features Great Exposure, Excellent Signage, Strong Zoning, Brand New Pumps, Brand New Double Walled Fiberglass Tanks, 2 Bay Repair Shop, 3 Strategically Placed Curb Cuts, (2) 9k Gallon Regular Tanks, 6k Gallon Premium Tank, 28 Parking Spaces, High 14’ Ceilings, Security System, 3 Phase Power, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Saint James On Lake Avenue 6 Blocks From The Saint James LIRR Station!!! The Property Has 106+ Feet Of Frontage On Busy Lake Avenue!!! Neighbors Include Starbucks, USPS, Mercedes, Lexus, Acura, Kia, Toyota, Jeep-Dodge-Ram, Chevrolet, Mazda, TD Bank, King Kullen, 7-Eleven, Dunkin’, Whole Foods, Costco, BP Gas, Lowe’s, Trader Joe’s, Macy’s, +++!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site Or The Next Home For Your Business!!! This Property Can Be Purchased With 386 Lake Avenue For Only $2.25m!!! Income: 2 Bay Auto Repair: $48, 000 Ann. Lease Exp.: 2026. Expenses: Taxes: $12, 572 Ann.
    Presented By: All Island Estates Realty Corp  516-783-5600
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Calling All Investors, Developers, End-Users & Entrepreneurs!!! Successful Corner Gas Station + Repair Shop For Sale!!! The Property Features Great Exposure, Excellent Signage, New Pumps, New Double Walled Fiberglass Tanks, Strong Central Business Zoning, 3 Strategically Placed Curb Cuts, 8k Gallon Regular Tanks, 8k Gallon Premium Tank, 8k Gallon Mid-Grade Blend Tank, 38 Parking Spaces, High 14’ Ceilings, 3 Phase Power, Security System, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Saint James On Lake Avenue Less Than 3 Blocks From The Saint James LIRR Station!!! The Property Has 115+ Feet Of Frontage On Busy Lake Avenue!!! Neighbors Include Starbucks, USPS, Mercedes, Lexus, Acura, Kia, Toyota, Jeep-Dodge-Ram, Chevrolet, Mazda, TD Bank, King Kullen, 7-Eleven, Dunkin’, Whole Foods, Costco, BP Gas, Lowe’s, Trader Joe’s, Macy’s, +++!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site, Investment Property Or Home For Your Business!!! This Property Can Be Purchased With 255 Lake Avenue For Only $2.25m!!! Income: 2 Bay Auto Repair: $48, 000 Ann. Lease Exp.: 2025 Expenses: Taxes: $17, 421 Ann. 9
    386 Lake Avenue Saint James, NY 11780
    $1,188,000
    Mixed Use Commercial ML# 3545998
    Calling All Investors, Developers, End-Users & Entrepreneurs!!! Successful Corner Gas Station + Repair Shop For Sale!!! The Property Features Great Exposure, Excellent Signage, New Pumps, New Double Walled Fiberglass Tanks, Strong Central Business Zoning, 3 Strategically Placed Curb Cuts, 8k Gallon Regular Tanks, 8k Gallon Premium Tank, 8k Gallon Mid-Grade Blend Tank, 38 Parking Spaces, High 14’ Ceilings, 3 Phase Power, Security System, All New LED Lighting, A/C, +++!!! The Property Is Located In The Heart Of Saint James On Lake Avenue Less Than 3 Blocks From The Saint James LIRR Station!!! The Property Has 115+ Feet Of Frontage On Busy Lake Avenue!!! Neighbors Include Starbucks, USPS, Mercedes, Lexus, Acura, Kia, Toyota, Jeep-Dodge-Ram, Chevrolet, Mazda, TD Bank, King Kullen, 7-Eleven, Dunkin’, Whole Foods, Costco, BP Gas, Lowe’s, Trader Joe’s, Macy’s, +++!!! This Property Offers HUGE Upside Potential!!! This Could Be Your Next Development Site, Investment Property Or Home For Your Business!!! This Property Can Be Purchased With 255 Lake Avenue For Only $2.25m!!! Income: 2 Bay Auto Repair: $48, 000 Ann. Lease Exp.: 2025 Expenses: Taxes: $17, 421 Ann.
    Presented By: All Island Estates Realty Corp  516-783-5600
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to this Beautiful Two Family by CO House, Offering 5 Bedrooms, 2 .5 Bathrooms Finished Basement With Outside Entrance, Also a Full Finished Walk-up Attic. With a powder Room. Two Car Detached Garage and Private Driveway. Meticulous Landscaped Back Yard, Nestle on a Flat 40X100 Property. The first floor Living Room greets you with an inviting ambiance, bathed in natural light. With sleek lines and Modern finishes. Venture a steps up to the heart of the home-the kitchen! equipped with modern stainless-steel appliances, and a chic back-splash.Just off the kitchen the dining area opens up to a beautiful patio that overlooks your private backyard oasis. Imagine sipping your morning coffee while basking in the sun or hosting summer under the stars gathering...Heading back inside, We Have Three Bedrooms and a Full Bathroom on the first Floor, As we journey to the upper level, you’ll discover the Second Unit with Living Room, Kitchen, two additional bedrooms and a full bathroom, and Additional Living space in the Full finished walk-up Attic with a powder room. Each room has Charming windows that let in just the right amount of light. We can’t ignore the versatile lower level, with an inside & outside entrance which can be used as a relaxing Family room, home office, Game room, Storage or Gym room and more and is ready to Move in, Just unpack and Relax!! Conveniently located To Train Station, Bus, JFK Airport, Shopping Center and More. 32
    107-29 134th Street Richmond Hill South, NY 11419
    $1,185,000
    5 Bedrooms 2 Full Baths 1 Half Bath
    Multi Family For Sale ML# 3585690
    Welcome to this Beautiful Two Family by CO House, Offering 5 Bedrooms, 2 .5 Bathrooms Finished Basement With Outside Entrance, Also a Full Finished Walk-up Attic. With a powder Room. Two Car Detached Garage and Private Driveway. Meticulous Landscaped Back Yard, Nestle on a Flat 40X100 Property. The first floor Living Room greets you with an inviting ambiance, bathed in natural light. With sleek lines and Modern finishes. Venture a steps up to the heart of the home-the kitchen! equipped with modern stainless-steel appliances, and a chic back-splash.Just off the kitchen the dining area opens up to a beautiful patio that overlooks your private backyard oasis. Imagine sipping your morning coffee while basking in the sun or hosting summer under the stars gathering...Heading back inside, We Have Three Bedrooms and a Full Bathroom on the first Floor, As we journey to the upper level, you’ll discover the Second Unit with Living Room, Kitchen, two additional bedrooms and a full bathroom, and Additional Living space in the Full finished walk-up Attic with a powder room. Each room has Charming windows that let in just the right amount of light. We can’t ignore the versatile lower level, with an inside & outside entrance which can be used as a relaxing Family room, home office, Game room, Storage or Gym room and more and is ready to Move in, Just unpack and Relax!! Conveniently located To Train Station, Bus, JFK Airport, Shopping Center and More.
    Presented By: Exit Family Realty  631-450-4777
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Introducing a remarkable multi-family property that offers endless possibilities! This four-family property is perfect for investors or homeowners looking to capitalize on a unique living situation. You can utilize this property solely as an investment or live in one unit while renting out the others, effectively allowing you to live rent-free. This property boasts tremendous upside potential, as it has yet to reach its total rental value. Currently, the rents are below market rate, presenting an excellent opportunity for increased income. Conveniently located just a short walk from the Mount Vernon East train station, you can enjoy a 26-minute commute to Grand Central Station. Everything you need is nearby, with various shops, restaurants, and government offices within easy reach. The vibrant and bustling Gramatan Avenue corridor is just steps away, adding to the appeal of this prime location. The property consists of (2) spacious 3-bedroom units and (2) comfortable 2-bedroom units. 28
    115 W Sidney Avenue Mount Vernon, NY 10550
    $1,185,000
    10 Bedrooms 4 Full Baths Sq. Ft. 3828.00:#
    Single Family For Sale ML# H6324656
    Introducing a remarkable multi-family property that offers endless possibilities! This four-family property is perfect for investors or homeowners looking to capitalize on a unique living situation. You can utilize this property solely as an investment or live in one unit while renting out the others, effectively allowing you to live rent-free. This property boasts tremendous upside potential, as it has yet to reach its total rental value. Currently, the rents are below market rate, presenting an excellent opportunity for increased income. Conveniently located just a short walk from the Mount Vernon East train station, you can enjoy a 26-minute commute to Grand Central Station. Everything you need is nearby, with various shops, restaurants, and government offices within easy reach. The vibrant and bustling Gramatan Avenue corridor is just steps away, adding to the appeal of this prime location. The property consists of (2) spacious 3-bedroom units and (2) comfortable 2-bedroom units.
    Presented By: Deutsche Gramatan Vanderbilt  914-407-4489
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Discover this inviting Ranch-style home just blocks from the sandy shores of Bootlegger’s Alley beach and breathtaking sunsets. Inside, you’ll find an open-concept floor plan featuring a country kitchen, dining area, living room, and den, perfect for both everyday living and entertaining guests. Cozy up by the wood-burning fireplace or relax on the spacious deck overlooking serene views and glimpses of Westmoreland Mill Pond. Enjoy refreshing summer days in the Gunite in-ground pool with patio surround. This home offers the perfect combination of comfort and outdoor leisure, making it ideal for enjoying island life. 19
    1 Rebel Rd Shelter Island, NY 11964
    $1,185,000
    2 Bedrooms 2 Full Baths Sq. Ft. 1472.00:# Square Feet
    Single Family For Sale ML# 3563528
    Discover this inviting Ranch-style home just blocks from the sandy shores of Bootlegger’s Alley beach and breathtaking sunsets. Inside, you’ll find an open-concept floor plan featuring a country kitchen, dining area, living room, and den, perfect for both everyday living and entertaining guests. Cozy up by the wood-burning fireplace or relax on the spacious deck overlooking serene views and glimpses of Westmoreland Mill Pond. Enjoy refreshing summer days in the Gunite in-ground pool with patio surround. This home offers the perfect combination of comfort and outdoor leisure, making it ideal for enjoying island life.
    Presented By: Daniel Gale Sothebys Intl Rlty  631-749-1155
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Rare Opportunity To Find New Construction Waterfront Property With A Brand New 100 Foot Bulkhead , Picturesque Views Of The Bay, Manhattan Skyline and Marina, Built On A 8, 500 Square Foot Irregular Lot, Part Of A New Development With Over 30 New Homes Being Built, Dead End Street, Kitchens With Quartz Countertops, Both Primary Bedrooms Have An En Suite, 2 Separate Hi Efficiency Gas Boilers, 2 Electric Meters, Surveillance Cameras, Still Time To Pic Your Colors and Finishes! 19
    62-04 Hillmeyer Rd Arverne, NY 11692
    $1,185,000
    6 Bedrooms 4 Full Baths Sq. Ft. 2200.00:# Square Feet
    Multi Family For Sale ML# 3558642
    Rare Opportunity To Find New Construction Waterfront Property With A Brand New 100 Foot Bulkhead , Picturesque Views Of The Bay, Manhattan Skyline and Marina, Built On A 8, 500 Square Foot Irregular Lot, Part Of A New Development With Over 30 New Homes Being Built, Dead End Street, Kitchens With Quartz Countertops, Both Primary Bedrooms Have An En Suite, 2 Separate Hi Efficiency Gas Boilers, 2 Electric Meters, Surveillance Cameras, Still Time To Pic Your Colors and Finishes!
    Presented By: John Savoretti Realty  516-327-6400
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • 2024 new built ground floor community facility office. Ceiling heights are 10’2. Ground to ceiling windows with a lot of natural lights. Ideal for any professional office such as doctor’s office, day care etc. Qualifying for 20 years tax abatement. Waking distance to bus station . close to hospital , university . 3
    163-07 72 Ave Unit 1C Fresh Meadows, NY 11365
    $1,182,000
    Mixed Use Commercial ML# 3564303
    2024 new built ground floor community facility office. Ceiling heights are 10’2. Ground to ceiling windows with a lot of natural lights. Ideal for any professional office such as doctor’s office, day care etc. Qualifying for 20 years tax abatement. Waking distance to bus station . close to hospital , university .
    Presented By: Winzone Realty Inc  347-200-8885
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Luxury living at the Solaria Condominium. This is the MOST UNIQUE and Largest 2 Bedroom 2 and a half Bathroom condo in the building in that there is a 58 foot by 7.5 foot Terrace. Flooded with light with East and South exposures maximized with Floor to ceiling Windows throughout. Grow an herb garden, tomatoes, veggies and flowers for TERRACE TO TABLE. A windowed Chef’s galley Kitchen with high end Viking professional series stainless steel gas range and Viking designer series paneled refrigerator, Fisher and Paykel dual dishwashers, Dual chamber deep stainless steel sinks, instant hot and filtered water dispenser, Insinkerator garbage disposal, all make for a dream Kitchen that will bring out the Chef in you! An oversized en suite Primary Bedroom with a walk in closet and you will love the main bath with radiant heated floors and a Zuma deep soaking tub with stone deck and surround, Jerusalem limestone full height walls, floor and countertop, a separate Frameless glass enclosed shower, Toto comfort height water closet and double sinks with DaVinci faucets. There is a vented washer/dryer in the apartment. The Solaria has a 24 hour Concierge, state of the art fitness center, lounge & entertainment center with a catering kitchen, a landscaped roof deck with extensive views, and a playroom. Local and express buses close by with access to #1, #4 and A trains, express buses to MID TOWN East and West Sides, Wall Street Express bus and Metro North Station Rail Link nearby. Central Riverdale shops just 4 blocks away. Shown by appointment only. ParkingFeatures: On Street, 32
    640 W 237th Street Unit 15A New York, NY 10463
    $1,181,000
    2 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 1541.00:#
    Condo For Sale ML# H6281495
    Luxury living at the Solaria Condominium. This is the MOST UNIQUE and Largest 2 Bedroom 2 and a half Bathroom condo in the building in that there is a 58 foot by 7.5 foot Terrace. Flooded with light with East and South exposures maximized with Floor to ceiling Windows throughout. Grow an herb garden, tomatoes, veggies and flowers for TERRACE TO TABLE. A windowed Chef’s galley Kitchen with high end Viking professional series stainless steel gas range and Viking designer series paneled refrigerator, Fisher and Paykel dual dishwashers, Dual chamber deep stainless steel sinks, instant hot and filtered water dispenser, Insinkerator garbage disposal, all make for a dream Kitchen that will bring out the Chef in you! An oversized en suite Primary Bedroom with a walk in closet and you will love the main bath with radiant heated floors and a Zuma deep soaking tub with stone deck and surround, Jerusalem limestone full height walls, floor and countertop, a separate Frameless glass enclosed shower, Toto comfort height water closet and double sinks with DaVinci faucets. There is a vented washer/dryer in the apartment. The Solaria has a 24 hour Concierge, state of the art fitness center, lounge & entertainment center with a catering kitchen, a landscaped roof deck with extensive views, and a playroom. Local and express buses close by with access to #1, #4 and A trains, express buses to MID TOWN East and West Sides, Wall Street Express bus and Metro North Station Rail Link nearby. Central Riverdale shops just 4 blocks away. Shown by appointment only. ParkingFeatures: On Street,
    Presented By: Brown Harris Stevens  718-878-1700
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
Showing 5251 - 5260 of 28666 results| view:  results per page« first|...|524|525|526|527|...|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