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 1681 - 1690 of 28459 results| view:  results per page« first|...|167|168|169|170|...|last »
  • Prime Location!! Excellent Investment Opportunity in the Heart of Astoria. This well-maintained, attached 10-Family building is an investor’s dream. The property features 2 spacious 2-bedrooms, 5-room apartments, and 6 large 1-bedrooms, 4-room apartment, & 2 Studio’s. Each unit boasts high ceilings, generously sized rooms, and is in excellent condition. With strong income potential, this is a rare find in a highly desirable area. Only a 15-minute walk to the N/W 30th Ave Station, with the Q18 bus just 2 block away on Steinway St. Close proximity to major routes: Queensboro Bridge, Grand Central Parkway, and Triboro Bridge. 14
    30-26 43rd Street Astoria, NY 11103
    $2,550,000
    12 Bedrooms 10 Full Baths
    Multi Family For Sale ML# 3583602
    Prime Location!! Excellent Investment Opportunity in the Heart of Astoria. This well-maintained, attached 10-Family building is an investor’s dream. The property features 2 spacious 2-bedrooms, 5-room apartments, and 6 large 1-bedrooms, 4-room apartment, & 2 Studio’s. Each unit boasts high ceilings, generously sized rooms, and is in excellent condition. With strong income potential, this is a rare find in a highly desirable area. Only a 15-minute walk to the N/W 30th Ave Station, with the Q18 bus just 2 block away on Steinway St. Close proximity to major routes: Queensboro Bridge, Grand Central Parkway, and Triboro Bridge.
    Presented By: Realty Executives Today  718-274-2400
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Great location! Whitestone is located in a secluded and quiet neighborhood with lots of sunlight, with 50x100 lot size, Exquisite decoration Beautifully designed Kitchen, Hardwood Floor and finished basement, Basement with floor heating, High ceiling, Near supermarket School, Near All......! Don’t miss this opportunity to own a here today, Must see!! 25
    24-11 157th Street Whitestone, NY 11357
    $2,550,000
    4 Bedrooms 3 Full Baths 2 Half Baths Sq. Ft. 2490.00:# Square Feet
    Single Family For Sale ML# 3576382
    Great location! Whitestone is located in a secluded and quiet neighborhood with lots of sunlight, with 50x100 lot size, Exquisite decoration Beautifully designed Kitchen, Hardwood Floor and finished basement, Basement with floor heating, High ceiling, Near supermarket School, Near All......! Don’t miss this opportunity to own a here today, Must see!!
    Presented By: E Realty International Corp  718-886-8110
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to luxury living in prestigious Wykagyl Park. This magnificent center hall Colonial is situated on stunning park-like grounds, recently refreshed to enhance its beautiful architectural features. The main floor is designed to meet today’s coveted life style with a grand entry, formal living and dining rooms, family room, eat-in kitchen with exposed beams and high-end appliances, a sunroom with three exposures, and a bedroom with a full bath. This residence is perfect for indoor and outdoor entertainment with multiple french doors that lead to amazing outdoor space boasting an impressively large terrace with a built-in Lynx barbecue. The formal living room features floor-to-ceiling windows, seamlessly bringing the outside indoors. The 2nd floor is equally impressive, with a primary suite featuring a balcony and luxurious bath, complemented by 4 additional bedrooms and three full baths. The lower level offers finished space ideal for recreation or home office. This expansive property provides ample room for a pool & tennis courts, guest home, or simply to enjoy as a private oasis. 36
    290 Overlook Rd New Rochelle, NY 10804
    $2,550,000
    7 Bedrooms 4 Full Baths 2 Half Baths Sq. Ft. 4213.00:# Square Feet
    Single Family For Sale ML# H6325488
    Welcome to luxury living in prestigious Wykagyl Park. This magnificent center hall Colonial is situated on stunning park-like grounds, recently refreshed to enhance its beautiful architectural features. The main floor is designed to meet today’s coveted life style with a grand entry, formal living and dining rooms, family room, eat-in kitchen with exposed beams and high-end appliances, a sunroom with three exposures, and a bedroom with a full bath. This residence is perfect for indoor and outdoor entertainment with multiple french doors that lead to amazing outdoor space boasting an impressively large terrace with a built-in Lynx barbecue. The formal living room features floor-to-ceiling windows, seamlessly bringing the outside indoors. The 2nd floor is equally impressive, with a primary suite featuring a balcony and luxurious bath, complemented by 4 additional bedrooms and three full baths. The lower level offers finished space ideal for recreation or home office. This expansive property provides ample room for a pool & tennis courts, guest home, or simply to enjoy as a private oasis.
    Presented By: Julia B Fee Sothebys Int. Rlty  914-725-3305
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Intricately crafted balance of traditional mid-century lines & modern purpose. Walls of glass, mixed natural materials including stone & hardwood floors complimented with high ceilings, provide a seamless transition from interior to exterior. A decadent, gorgeous indoor pool, skylights, hand crafted Italian tile & Venetian plaster walls with glass doors that lead to numerous private decks, terraces & irrigated organic gardens. The contemporary kitchen has Eggersmann cabinetry with strikingly colored stone countertops, Miele & SubZero appliance packages abound. Enter the dining room through a pair of mid-century modern style pocket doors, flowing into the large living room with a wood-burning fireplace. There are five bedrooms and a total of four luxurious bathrooms, an expansive top floor loft with exposed wooden beams, two decks, a full bathroom, walk-in closet & views. Adjacent to the pool and family size sauna is a full bathroom, workshop, laundry, storage & a heated two-car garage. 31
    177 Clinton Avenue Greenburgh, NY 10522
    $2,550,000
    5 Bedrooms 4 Full Baths Sq. Ft. 5270.00:# Square Feet
    Single Family For Sale ML# H6325308
    Intricately crafted balance of traditional mid-century lines & modern purpose. Walls of glass, mixed natural materials including stone & hardwood floors complimented with high ceilings, provide a seamless transition from interior to exterior. A decadent, gorgeous indoor pool, skylights, hand crafted Italian tile & Venetian plaster walls with glass doors that lead to numerous private decks, terraces & irrigated organic gardens. The contemporary kitchen has Eggersmann cabinetry with strikingly colored stone countertops, Miele & SubZero appliance packages abound. Enter the dining room through a pair of mid-century modern style pocket doors, flowing into the large living room with a wood-burning fireplace. There are five bedrooms and a total of four luxurious bathrooms, an expansive top floor loft with exposed wooden beams, two decks, a full bathroom, walk-in closet & views. Adjacent to the pool and family size sauna is a full bathroom, workshop, laundry, storage & a heated two-car garage.
    Presented By: Compass Greater NY, LLC  914-391-1526
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to 4 Jester Court, a hidden gem in beautiful Dix Hills. The home is situated in the highly sought after Half Hollow Hills (SD #5). This Resort like property offers an elegant and serene surrounding at the head of the cul-de-sac. Featuring 5 bedrooms, an office, a TRUE eat-in-kitchen and 6 1/2 bathrooms, one of which has a sauna & steam room. The house has 3 en-suites with one on the main level. The open floor plan flows harmoniously from one room to the next. Basement is fully finished and has cedar closet, a large room for entertaining and a bar. The sprawling backyard features a 2600 sq ft. deck with new hot tub and a newly resurfaced 7200 sq ft. Tennis Court. There is also a 450 sq ft. pool house with a bar for entertaining. The house was renovated in 2020 and the driveway was just repaved. Convenient to NSP & LIE as well as LIRR. 36
    4 Jester Court Dix Hills, NY 11746
    $2,699,000
    $2,550,000
    5 Bedrooms 6 Full Baths 1 Half Bath
    Single Family For Sale PRICE REDUCED ML# 3574354
    Welcome to 4 Jester Court, a hidden gem in beautiful Dix Hills. The home is situated in the highly sought after Half Hollow Hills (SD #5). This Resort like property offers an elegant and serene surrounding at the head of the cul-de-sac. Featuring 5 bedrooms, an office, a TRUE eat-in-kitchen and 6 1/2 bathrooms, one of which has a sauna & steam room. The house has 3 en-suites with one on the main level. The open floor plan flows harmoniously from one room to the next. Basement is fully finished and has cedar closet, a large room for entertaining and a bar. The sprawling backyard features a 2600 sq ft. deck with new hot tub and a newly resurfaced 7200 sq ft. Tennis Court. There is also a 450 sq ft. pool house with a bar for entertaining. The house was renovated in 2020 and the driveway was just repaved. Convenient to NSP & LIE as well as LIRR.
    Presented By: LAFFEY REAL ESTATE  631-547-5300
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Prime Property in the Heart of Elmhurst! This well-located building is just steps away from the 7 train, Elmhurst Hospital, restaurants, coffee shops, supermarkets, and banks. The three-story building includes a basement, retail spaces on the lower level and ground floor, and residential apartments on the second and third floors. All residential units are rent-stabilized 1-bedroom apartments.
    81-38 Baxter Avenue Elmhurst, NY 11373
    $2,550,000
    5 Bedrooms 5 Full Baths
    Multi Family For Sale ML# 3572937
    Prime Property in the Heart of Elmhurst! This well-located building is just steps away from the 7 train, Elmhurst Hospital, restaurants, coffee shops, supermarkets, and banks. The three-story building includes a basement, retail spaces on the lower level and ground floor, and residential apartments on the second and third floors. All residential units are rent-stabilized 1-bedroom apartments.
    Presented By: A Class Realty  516-226-1420
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • This is your opportunity to invest in a one-of-a-kind multifamily property in the heart of Cortlandt Manor, Westchester County in New York. Properties in the area are currently very valuable, much higher than the national average, and this particular one with 1.43 acres and eight units offers a ton of opportunity for renting, making it a smart investment. Two of the units have three bedrooms, five units have two bedrooms, and the smallest unit has one bedroom, each with one bathroom. Plus, three garages that add even more value to this great property. Take this opportunity and see these beautiful multi-family unit homes for yourself. 14
    291 Furnace Dock Rd Cortlandt, NY 10567
    $2,550,000
    17 Bedrooms 9 Full Baths Sq. Ft. 7500.00:# Square Feet
    Multi Family For Sale ML# H6316546
    This is your opportunity to invest in a one-of-a-kind multifamily property in the heart of Cortlandt Manor, Westchester County in New York. Properties in the area are currently very valuable, much higher than the national average, and this particular one with 1.43 acres and eight units offers a ton of opportunity for renting, making it a smart investment. Two of the units have three bedrooms, five units have two bedrooms, and the smallest unit has one bedroom, each with one bathroom. Plus, three garages that add even more value to this great property. Take this opportunity and see these beautiful multi-family unit homes for yourself.
    Presented By: eRealty Advisors, Inc  914 7126330
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Well maintained 4 unit building with Private yard. This well-maintained Building features 4 spacious apartments (Quadruplex). Each unit has an open concept living and ample bedrooms ideal for multi generational living AS IS. Lower and 1st-floor units have Private entrances to a shared, landscaped backyard. Close to shops, restaurants, schools, parks & public transportation (trains & buses). 19
    555 W 183rd Street New York, NY 10033
    $2,550,000
    8 Bedrooms 4 Full Baths
    Multi Family For Sale ML# 3560875
    Well maintained 4 unit building with Private yard. This well-maintained Building features 4 spacious apartments (Quadruplex). Each unit has an open concept living and ample bedrooms ideal for multi generational living AS IS. Lower and 1st-floor units have Private entrances to a shared, landscaped backyard. Close to shops, restaurants, schools, parks & public transportation (trains & buses).
    Presented By: BERKSHIRE HATHAWAY  718-650-5233
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • WELL MAINTAINED AND ONE OF THE LARGEST WAREHOUSE/OFFICE SPACES IN THE AREA. LOADING DOCKS, UPDATED HANDICAPPED BATHROOMS, AND FEATURES TONS OF PARKING WITH GREAT ACCESS TO ALL MAJOR ROADS. BUILDING IS IN GREAT SHAPE AND WILL BE DELIVERED EMPTY BUT SELLER WOULD LIKE TO RENT BACK TILL END OF YEAR TO ACCOMODATE AN OUT OF STATE MOVE. THIS PROPERTY IS UNIQUE AND CAN ACCOMODATE ANY KIND OF BUSINESS.MOVE RIGHT IN. 14
    200 Meacham Avenue Elmont, NY 11003
    $2,550,000
    Mixed Use Commercial ML# 3547538
    WELL MAINTAINED AND ONE OF THE LARGEST WAREHOUSE/OFFICE SPACES IN THE AREA. LOADING DOCKS, UPDATED HANDICAPPED BATHROOMS, AND FEATURES TONS OF PARKING WITH GREAT ACCESS TO ALL MAJOR ROADS. BUILDING IS IN GREAT SHAPE AND WILL BE DELIVERED EMPTY BUT SELLER WOULD LIKE TO RENT BACK TILL END OF YEAR TO ACCOMODATE AN OUT OF STATE MOVE. THIS PROPERTY IS UNIQUE AND CAN ACCOMODATE ANY KIND OF BUSINESS.MOVE RIGHT IN.
    Presented By: John Savoretti Realty  516-721-7257
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Remarkable investment opportunity in the heart of Bayside! Just two blocks from the Long Island Rail Road, this stunning, brand-new three-family residence is perfectly positioned near stores, delightful restaurants, and the vibrant allure of Manhattan. A legal 3 family building with 5 floors, with a total interior space of 3383 sq ft and an expansive 950 sq ft cellar for ample storage and versatility, this property offers exceptional living accommodations. Unit #1 - The first floor features a spacious 1-bedroom duplex with 1.5 baths spanning 1, 900 sqft (950 sq ft plus 950 cellar) and a large backyard. Unit #2 On the second floor, a 1, 028 sq ft unit with 3 bedrooms provides ample space for comfortable living with two balconies. Unit #3 The crowning jewel is the third-floor duplex, offering 1405 sqft of living space with high cathedral ceilings and 3 bedrooms, and an extra-large lofty with two balconies and a private terrace. (1, 028 Third Floor +377 sq ft 4th fl Loft) This property offers great returns with proposed high rents and boasts stunning curb appeal, ensuring maximum investment value. With 12-inch thick walls, extra insulation, and double-pane windows, it provides exceptional energy efficiency and a serene living environment. Imagine the endless possibilities and steady stream of rental income from such a prime investment. Don’t miss this unique opportunity to own a piece of Bayside’s finest real estate, where luxury meets convenience and potential meets reality. Secure your future today with this unparalleled investment. 26
    37-08 Francis Lewis Boulevard Bayside, NY 11361
    $2,538,000
    7 Bedrooms 4 Full Baths 2 Half Baths
    Multi Family For Sale OPEN HOUSE ML# 3577575
    Remarkable investment opportunity in the heart of Bayside! Just two blocks from the Long Island Rail Road, this stunning, brand-new three-family residence is perfectly positioned near stores, delightful restaurants, and the vibrant allure of Manhattan. A legal 3 family building with 5 floors, with a total interior space of 3383 sq ft and an expansive 950 sq ft cellar for ample storage and versatility, this property offers exceptional living accommodations. Unit #1 - The first floor features a spacious 1-bedroom duplex with 1.5 baths spanning 1, 900 sqft (950 sq ft plus 950 cellar) and a large backyard. Unit #2 On the second floor, a 1, 028 sq ft unit with 3 bedrooms provides ample space for comfortable living with two balconies. Unit #3 The crowning jewel is the third-floor duplex, offering 1405 sqft of living space with high cathedral ceilings and 3 bedrooms, and an extra-large lofty with two balconies and a private terrace. (1, 028 Third Floor +377 sq ft 4th fl Loft) This property offers great returns with proposed high rents and boasts stunning curb appeal, ensuring maximum investment value. With 12-inch thick walls, extra insulation, and double-pane windows, it provides exceptional energy efficiency and a serene living environment. Imagine the endless possibilities and steady stream of rental income from such a prime investment. Don’t miss this unique opportunity to own a piece of Bayside’s finest real estate, where luxury meets convenience and potential meets reality. Secure your future today with this unparalleled investment.
    Presented By: Luxian International Realty  917-567-8767
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
    Upcoming Open House View Location
    11/16/2024 - 11/16/2024 12:00PM - 1:30PM
    11/17/2024 - 11/17/2024 1:00PM - 3:00PM
Showing 1681 - 1690 of 28459 results| view:  results per page« first|...|167|168|169|170|...|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