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

128  properties match your search;

128 with Multiple photos ;  128 with Virtual Tour ;  128 with Videos

Save Search
Showing 91 - 100 of 128 results| view:  results per page« first|...|9|10|11|12|13 »
  • Charming and inviting property in the Orient By The Sea beach community. Desirable half-acre corner lot property. Three bedroom, one and a half bath Colonial with two car garage. This home boasts a welcoming living room with a wood-burning fireplace, adjacent to a cozy sitting room with a wood-burning stove. Large eat-in kitchen with barstool countertop. The dining area has sliding glass doors that lead to a backyard oasis, which includes an awning-covered deck, a 20x40 in-ground saltwater pool with patio surround, and an outdoor shower. Also full basement with tons of potential! The private community beach is a short distance from the home! Located close to the Cross Sound Ferry, Orient State Park, and 10 mins to the heart of Greenport Village. Nature and serenity abound with nearby hiking trails, glorious beaches, and breathtaking sunsets. 25
    1365 Plum Island Lane Orient, NY 11957
    $995,000
    3 Bedrooms 1 Full Bath 1 Half Bath
    Single Family For Sale ML# 3570792
    Charming and inviting property in the Orient By The Sea beach community. Desirable half-acre corner lot property. Three bedroom, one and a half bath Colonial with two car garage. This home boasts a welcoming living room with a wood-burning fireplace, adjacent to a cozy sitting room with a wood-burning stove. Large eat-in kitchen with barstool countertop. The dining area has sliding glass doors that lead to a backyard oasis, which includes an awning-covered deck, a 20x40 in-ground saltwater pool with patio surround, and an outdoor shower. Also full basement with tons of potential! The private community beach is a short distance from the home! Located close to the Cross Sound Ferry, Orient State Park, and 10 mins to the heart of Greenport Village. Nature and serenity abound with nearby hiking trails, glorious beaches, and breathtaking sunsets.
    Presented By: Douglas Elliman Real Estate  631-354-8100
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Desirable area in CP north, Beautiful Condo townhouse community; Legal two units; walk to MacNeil Park, bus and school; Ground level features Large One BR, LR with access to a private yard; Eik, fbath; broiler and laundry room, pvt driveway and one car garage; 2nd Fl features high ceiling LR, Dinette, EiK w/skylight, 3BR w/two fbath and back porch over looking the garden; move in conditions; HOA fee($486 monthly included: Snow removal, water; roof and siding maintenance, landscaping and etc. Both units be delivered upon closing 35
    4-19 121 Street College Point, NY 11356
    $937,000
    4 Bedrooms 3 Full Baths Sq. Ft. 2270.00:# Square Feet
    Multi Family For Sale OPEN HOUSE ML# 3583110
    Desirable area in CP north, Beautiful Condo townhouse community; Legal two units; walk to MacNeil Park, bus and school; Ground level features Large One BR, LR with access to a private yard; Eik, fbath; broiler and laundry room, pvt driveway and one car garage; 2nd Fl features high ceiling LR, Dinette, EiK w/skylight, 3BR w/two fbath and back porch over looking the garden; move in conditions; HOA fee($486 monthly included: Snow removal, water; roof and siding maintenance, landscaping and etc. Both units be delivered upon closing
    Presented By: Eagle Realty Group New York  718-663-4366
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/17/2024 - 11/17/2024 2:00PM - 4:00PM
  • Desirable area in CP north, Beautiful Condo townhouse community; Legal two units; walk to MacNeil Park, bus and school; Ground level features Large One BR, LR with access to a private yard; Eik, fbath; broiler and laundry room, pvt driveway and one car garage; 2nd Fl features high ceiling LR, Dinette, Eik w/skylight, 3BR w/two fbath and back porch over looking the garden; move in conditions; HOA fee($486) included: Snow removal, water; roof and siding maintenance, landscaping and etc. Both units deliver upon closing. 35
    4-19 121 Street Unit 15 College Point, NY 11356
    $937,000
    4 Bedrooms 3 Full Baths
    Condo For Sale OPEN HOUSE ML# 3583106
    Desirable area in CP north, Beautiful Condo townhouse community; Legal two units; walk to MacNeil Park, bus and school; Ground level features Large One BR, LR with access to a private yard; Eik, fbath; broiler and laundry room, pvt driveway and one car garage; 2nd Fl features high ceiling LR, Dinette, Eik w/skylight, 3BR w/two fbath and back porch over looking the garden; move in conditions; HOA fee($486) included: Snow removal, water; roof and siding maintenance, landscaping and etc. Both units deliver upon closing.
    Presented By: Eagle Realty Group New York  718-663-4366
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/17/2024 - 11/17/2024 2:00PM - 4:00PM
  • Nestled in a prime location just 10 minutes from the heart of the Barclays Center, this charming 2family duplex, seamlessly blends historical allure with modern convenience thanks to thoughtful renovations completed as recently as 2023. The property now sports a brand-new roof and a freshly installed staircase, ensuring both safety and style. Each of the two units within this duplex boasts a spacious layout that includes two bedrooms, one bath, and a generous EIK, providing a perfect blend of comfort and functionality. The rooms are bathed in natural light, highlighting the unique character and details that only a home of this era can offer, all while featuring modern updates that cater to today’s living standards. The basement is a highlight in itself, transformed into a versatile space with two nicely-sized bedrooms, a full summer kitchen, and a complete shower. It’s an ideal area for guests, an in-law suite, or additional living space, enhanced by two separate means of egress through the front and back doors, adding both convenience and safety. Outdoor living has not been overlooked, with the property offering ample space for relaxation and entertainment. Its location is a significant advantage, situated within close proximity to the Atlantic Ocean, inviting endless opportunities for seaside adventures and leisure. This duplex home is more than just a place to live; it’s a gateway to a lifestyle of comfort, convenience, and historical charm, all within reach of the vibrant life and amenities the area has to offer. Whether you’re seeking a property with an additional income unit or an investment opportunity in a sought-after location, this property promises to meet your needs & exceed your expectations.House is being sold AS IS. Property has solar panels that provides a tax abatement incentive, transferable w/the sale of the property to qualified buyer. Home also qualifies for M&T Bank’s Home Starter Mortgage program, requiring just 3% down payment, significantly reducing a buyer’s out-of-pocket expenses.1 year home warranty included that will be transferred to the buyer. Warranty covers major home appliances and systems, helping offset potential costs for repairs and replacements, providing peace of mind and financial security for the new homeowner. 34
    25 Marconi Bedford-Stuyvesant, NY 11233
    $900,000
    6 Bedrooms 3 Full Baths
    Multi Family For Sale ML# 3540218
    Nestled in a prime location just 10 minutes from the heart of the Barclays Center, this charming 2family duplex, seamlessly blends historical allure with modern convenience thanks to thoughtful renovations completed as recently as 2023. The property now sports a brand-new roof and a freshly installed staircase, ensuring both safety and style. Each of the two units within this duplex boasts a spacious layout that includes two bedrooms, one bath, and a generous EIK, providing a perfect blend of comfort and functionality. The rooms are bathed in natural light, highlighting the unique character and details that only a home of this era can offer, all while featuring modern updates that cater to today’s living standards. The basement is a highlight in itself, transformed into a versatile space with two nicely-sized bedrooms, a full summer kitchen, and a complete shower. It’s an ideal area for guests, an in-law suite, or additional living space, enhanced by two separate means of egress through the front and back doors, adding both convenience and safety. Outdoor living has not been overlooked, with the property offering ample space for relaxation and entertainment. Its location is a significant advantage, situated within close proximity to the Atlantic Ocean, inviting endless opportunities for seaside adventures and leisure. This duplex home is more than just a place to live; it’s a gateway to a lifestyle of comfort, convenience, and historical charm, all within reach of the vibrant life and amenities the area has to offer. Whether you’re seeking a property with an additional income unit or an investment opportunity in a sought-after location, this property promises to meet your needs & exceed your expectations.House is being sold AS IS. Property has solar panels that provides a tax abatement incentive, transferable w/the sale of the property to qualified buyer. Home also qualifies for M&T Bank’s Home Starter Mortgage program, requiring just 3% down payment, significantly reducing a buyer’s out-of-pocket expenses.1 year home warranty included that will be transferred to the buyer. Warranty covers major home appliances and systems, helping offset potential costs for repairs and replacements, providing peace of mind and financial security for the new homeowner.
    Presented By: EXP Realty  888-276-0630
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Charming Colonial Home nestled in Historic Idle Hour! Welcome to this beautifully maintained 3-bedroom, 2-bath colonial home built in 1971, This property offers a perfect blend of classic charm and modern amenities, set on a serene .45-acre lot that appeals to nature enthusiasts. Enjoy the convenience of a spacious first Floor Primary bedroom with an en-suite bath, providing a private retreat. The inviting living room features stunning wood beams, ceiling fans and oversized picture windows, flooding the space with natural light and offering picturesque views of the tranquil landscape. On the 2nd Floor: Two additional bedrooms, a full bath with a jacuzzi tub and shower, a walk-in closet, and a stand-up attic provide ample space for family and guests. Host gatherings in the formal dining room or unwind in the cozy den, complete with a wood-burning fireplace for those chilly evenings. The eat-in kitchen boasts granite countertops and a functional layout, making meal preparation a joy. Step outside to a 20x20 deck with a custom awning. Perfect for outdoor entertaining and enjoy the beauty of protected wetlands surrounding the property. Features include central air, central vacuum, a laundry, a 2-car attached garage, and a workshop ideal for hobbies. A paver patio and walkway enhance the front of the home, complemented by a gravel driveway and a storage shed. Equipped with 200-amp electrical service. Connetquot school district. This home is a rare find in a historic area, offering both comfort and an idyllic setting. Don’t miss your chance to make it your own!! 33
    52 Riverview Court Oakdale, NY 11769
    $879,000
    3 Bedrooms 2 Full Baths Sq. Ft. 2292.00:# Square Feet
    Single Family For Sale OPEN HOUSE ML# 3585619
    Charming Colonial Home nestled in Historic Idle Hour! Welcome to this beautifully maintained 3-bedroom, 2-bath colonial home built in 1971, This property offers a perfect blend of classic charm and modern amenities, set on a serene .45-acre lot that appeals to nature enthusiasts. Enjoy the convenience of a spacious first Floor Primary bedroom with an en-suite bath, providing a private retreat. The inviting living room features stunning wood beams, ceiling fans and oversized picture windows, flooding the space with natural light and offering picturesque views of the tranquil landscape. On the 2nd Floor: Two additional bedrooms, a full bath with a jacuzzi tub and shower, a walk-in closet, and a stand-up attic provide ample space for family and guests. Host gatherings in the formal dining room or unwind in the cozy den, complete with a wood-burning fireplace for those chilly evenings. The eat-in kitchen boasts granite countertops and a functional layout, making meal preparation a joy. Step outside to a 20x20 deck with a custom awning. Perfect for outdoor entertaining and enjoy the beauty of protected wetlands surrounding the property. Features include central air, central vacuum, a laundry, a 2-car attached garage, and a workshop ideal for hobbies. A paver patio and walkway enhance the front of the home, complemented by a gravel driveway and a storage shed. Equipped with 200-amp electrical service. Connetquot school district. This home is a rare find in a historic area, offering both comfort and an idyllic setting. Don’t miss your chance to make it your own!!
    Presented By: Howard Hanna Coach  631-499-1000
    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
  • Welcome to Woodhaven. renovated one family home with full finished basement flus attic. Located in the heart of Woodhaven. First floor Dining area open kitchen stainless steels appliances living room, 2 bedroom and access to the back yard. Second floor 3 bedroom full bath and walk up attic you can easy make extra bedroom or office space. full finished basement washers and dryers access to the back yard. Two block from Forest Park and one block from J& Z Subway station. many grocery stores and restaurants around. 23
    86-24 79th Street Woodhaven, NY 11421
    $865,000
    4 Bedrooms 2 Full Baths
    Single Family For Sale ML# 3559241
    Welcome to Woodhaven. renovated one family home with full finished basement flus attic. Located in the heart of Woodhaven. First floor Dining area open kitchen stainless steels appliances living room, 2 bedroom and access to the back yard. Second floor 3 bedroom full bath and walk up attic you can easy make extra bedroom or office space. full finished basement washers and dryers access to the back yard. Two block from Forest Park and one block from J& Z Subway station. many grocery stores and restaurants around.
    Presented By: Charles Rutenberg Realty Inc  347-334-2927
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • This is the only 1 bedroom condominium in this brand new construction building - The Rose at Great Neck. 40-New luxury condos with amenities on the North Shore of Long Island now finished inside with immediate occupancy available. This brand new mid-rise building offers an unparalleled residential experience including 24hr virtual doorman services connected to management company, a welcoming lobby, business lounge with tv plus gym fitness center with equipment and free weights. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards the New York City Skyline. A very special golf simulator is coming soon to this new building. Private indoor garage parking and outside private lot parking options. The earliest residents have preferred choice of parking spaces and limited storage options available. The allure of The Rose extends beyond its walls as residents instantly part of the Village of Great Neck Estates and enjoy access to the Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts that have a bubble in the Winter, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and Throgs Neck Bridge, marina and dock area, baseball fields and soccer fields, playground and snack bar, basketball, pickleball and handball courts. The Rose was creatively designed by local famed architects Mojo Stumer Associates with the very best of quality and modern sophistication. Exterior brick and metal panels accent the prominently located solid structure. Three floors have a mix of 1 bedroom, 2 bedroom and 3 bedroom condos in this new building. Unit 314 here is the only 1 bedroom and 1bath condo in the new building. Large windows bring in tons of natural light. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Just 0.7 miles to the Great Neck LIRR Train Station where direct routes to Penn Station and Grand Central take just 37 minutes. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to national and international airports. Great Neck North School District with an option for Great Neck South High School in some instances and The Rose is zoned for Saddle Rock Elementary. Welcome home. 30
    218 Middle Neck Rd Unit 314 Great Neck, NY 11021
    $864,800
    1 Bedroom 1 Full Bath Sq. Ft. 783.00:# Square Feet
    Condo For Sale OPEN HOUSE ML# 3562116
    This is the only 1 bedroom condominium in this brand new construction building - The Rose at Great Neck. 40-New luxury condos with amenities on the North Shore of Long Island now finished inside with immediate occupancy available. This brand new mid-rise building offers an unparalleled residential experience including 24hr virtual doorman services connected to management company, a welcoming lobby, business lounge with tv plus gym fitness center with equipment and free weights. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards the New York City Skyline. A very special golf simulator is coming soon to this new building. Private indoor garage parking and outside private lot parking options. The earliest residents have preferred choice of parking spaces and limited storage options available. The allure of The Rose extends beyond its walls as residents instantly part of the Village of Great Neck Estates and enjoy access to the Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts that have a bubble in the Winter, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and Throgs Neck Bridge, marina and dock area, baseball fields and soccer fields, playground and snack bar, basketball, pickleball and handball courts. The Rose was creatively designed by local famed architects Mojo Stumer Associates with the very best of quality and modern sophistication. Exterior brick and metal panels accent the prominently located solid structure. Three floors have a mix of 1 bedroom, 2 bedroom and 3 bedroom condos in this new building. Unit 314 here is the only 1 bedroom and 1bath condo in the new building. Large windows bring in tons of natural light. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Just 0.7 miles to the Great Neck LIRR Train Station where direct routes to Penn Station and Grand Central take just 37 minutes. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to national and international airports. Great Neck North School District with an option for Great Neck South High School in some instances and The Rose is zoned for Saddle Rock Elementary. Welcome home.
    Presented By: Compass Greater NY LLC  917-293-0915
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/17/2024 - 11/17/2024 2:00PM - 4:00PM
  • First time on the market for this Farm Ranch in the Hamlet of Saint James on Long Island’s north shore. When you enter this mid century home, you will be greeted with warm sunlight from the living room windows overlooking the In the Ground Pool and tranquil backyard. You will find the Den through the French doors in the entrance hallway. The formal Living room has extensive crown molding and wood burning fireplace. The Formal Dining room is where you will find a slider to the deck and pool. This home features a first floor bedroom and additional two bedrooms upstairs. The Eat in Kitchen is where you will find your entrance to the Sun Room. Full partially finished basement provides an additional Family room with bar, laundry area and storage. This unique home has room for extended family with spacious additional living space (CO’s in place), which features Bedroom, Full Bath, Eat in Kitchen and Living Room. 33
    292 Northern Boulevard Saint James, NY 11780
    $840,000
    4 Bedrooms 3 Full Baths Sq. Ft. 2645.00:# Square Feet
    Single Family For Sale OPEN HOUSE ML# 3561353
    First time on the market for this Farm Ranch in the Hamlet of Saint James on Long Island’s north shore. When you enter this mid century home, you will be greeted with warm sunlight from the living room windows overlooking the In the Ground Pool and tranquil backyard. You will find the Den through the French doors in the entrance hallway. The formal Living room has extensive crown molding and wood burning fireplace. The Formal Dining room is where you will find a slider to the deck and pool. This home features a first floor bedroom and additional two bedrooms upstairs. The Eat in Kitchen is where you will find your entrance to the Sun Room. Full partially finished basement provides an additional Family room with bar, laundry area and storage. This unique home has room for extended family with spacious additional living space (CO’s in place), which features Bedroom, Full Bath, Eat in Kitchen and Living Room.
    Presented By: Realty Connect USA L I Inc  631-941-4300
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/16/2024 - 11/16/2024 12:30PM - 2:30PM
    11/17/2024 - 11/17/2024 12:30PM - 2:30PM
  • Welcome to Glendale! This one-of-a-kind detached, corner property stands out from the rest and is ready to hit the market! This 3300 sq. ft. IRR lot offers so much with three bedrooms (with a possible fourth if needed), a massive living room, an updated kitchen, a formal dining room, two full bathrooms, a full basement, and an attached two-car garage as part of a community driveway is all just the start! The property is located minutes away from the M Train on Fresh Pond Rd. and up the block from the Q55 as well as the QM24/QM25/QM34 Express Buses to the city! In addition to all of the above, you also have a private fenced-in backyard and many recent, important improvements to the home such as brand-new exterior siding and hot water heater, and a new model gas boiler and roof. This move-in property offers it all! Come tour it for yourself before it is gone! 24
    70-25 64th Pl. Glendale, NY 11385
    $799,000
    3 Bedrooms 2 Full Baths
    Single Family For Sale NEW ML# 3590543
    Welcome to Glendale! This one-of-a-kind detached, corner property stands out from the rest and is ready to hit the market! This 3300 sq. ft. IRR lot offers so much with three bedrooms (with a possible fourth if needed), a massive living room, an updated kitchen, a formal dining room, two full bathrooms, a full basement, and an attached two-car garage as part of a community driveway is all just the start! The property is located minutes away from the M Train on Fresh Pond Rd. and up the block from the Q55 as well as the QM24/QM25/QM34 Express Buses to the city! In addition to all of the above, you also have a private fenced-in backyard and many recent, important improvements to the home such as brand-new exterior siding and hot water heater, and a new model gas boiler and roof. This move-in property offers it all! Come tour it for yourself before it is gone!
    Presented By: Coldwell Banker Kueber Realty  718-628-0100
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • New Construction! - The home will be completed by around February 2025. Discover a charming modern masterpiece on a 1-acre lot a delightful haven with endless potential. Featuring 4 bedrooms and 2.5 baths, the thoughtfully designed layout enhances the sweet essence of each space. The main floor boasts bright, light-filled rooms creating an inviting atmosphere for daily living and entertaining. The walk-out basement with 8-foot ceilings adds versatility to suit your preferences. A peaceful retreat for gardening enthusiasts. This home blends comfort and sophistication, captivating from the moment you step through the door. A blacktop driveway will be added. The builder is committed to customization to your needs! from landscaping to finishes. Ask about tailoring your space and transform this dream home into a personalized sanctuary. Your dream home awaits, crafted to your vision! ** All financing options are welcome!** 21
    632 Middle Country Rd Ridge, NY 11961
    $749,999
    4 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 2412.00:# Square Feet
    Single Family For Sale ML# 3536623
    New Construction! - The home will be completed by around February 2025. Discover a charming modern masterpiece on a 1-acre lot a delightful haven with endless potential. Featuring 4 bedrooms and 2.5 baths, the thoughtfully designed layout enhances the sweet essence of each space. The main floor boasts bright, light-filled rooms creating an inviting atmosphere for daily living and entertaining. The walk-out basement with 8-foot ceilings adds versatility to suit your preferences. A peaceful retreat for gardening enthusiasts. This home blends comfort and sophistication, captivating from the moment you step through the door. A blacktop driveway will be added. The builder is committed to customization to your needs! from landscaping to finishes. Ask about tailoring your space and transform this dream home into a personalized sanctuary. Your dream home awaits, crafted to your vision! ** All financing options are welcome!**
    Presented By: Realty Connect USA L I Inc  631-881-5160
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
Showing 91 - 100 of 128 results| view:  results per page« first|...|9|10|11|12|13 »
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