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 11 - 20 of 28459 results| view:  results per page« 1|2|3|4|5|...|last »
  • Located south of the highway in Southampton’s prestigious Fordune Association and just moments from the ocean, close to town, this exceptional estate represents the epitome of luxury living in the Hamptons. Over 5.5 acres, the property boasts expansive lawns, meticulously-maintained gardens and millions of specimen plantings, ensuring unmatched privacy, tranquility and a parklike, amenity-rich environment. Built under the most rigorous commercial building standards/codes, This magnificent residence of approximately 20, 000 square feet (including the finished lower level) and including 2, 634 square foot accessory building that serves as a state-of-the-art fitness center. Additionally enjoy the pool house, saltwater 40x60 swimming pool, tennis court with pavilion, basketball court and a 2-car garage/service building, primarily used for storing golf carts, which provide access to the ocean beach via the Fordune Association’s beach access right of way.The home includes 13 bedrooms, 14 full baths and 2 half baths, a grand foyer entrance boasting 20 foot high ceilings and a one-of-a-kind Natural American and Brazilian walnut staircase and wood flooring. Impressive 35 x 25 foot living room with 21 foot ceilings and fireplace. The east wing first floor houses a media room, a beautiful office/library with a stunning walnut finish and coffered ceilings, and a bedroom suite.The second floor includes a library and 2 bedroom suites, the expansive suite primary bedroom with a sitting area, 4 closets, a large walk-in, 2 bathrooms and a balcony. The west wing first floor features 2 bedroom suites, a junior primary bedroom, formal dining room and a professional kitchen with an expansive sitting area plus breakfast area. A second staircase leads to the very private guest wing with 5 bedroom suites. The lower level, includes a state-of-the-art wine storage, a recreation room with a fireplace and media room and private staff/guests quarters with a living room, 2 bedrooms and 2 full baths. 36
    14 Fordune Drive Southampton, NY 11968
    $37,500,000
    13 Bedrooms 14 Full Baths 2 Half Baths Sq. Ft. 14807.00:# Square Feet
    Single Family For Sale ML# 3581459
    Located south of the highway in Southampton’s prestigious Fordune Association and just moments from the ocean, close to town, this exceptional estate represents the epitome of luxury living in the Hamptons. Over 5.5 acres, the property boasts expansive lawns, meticulously-maintained gardens and millions of specimen plantings, ensuring unmatched privacy, tranquility and a parklike, amenity-rich environment. Built under the most rigorous commercial building standards/codes, This magnificent residence of approximately 20, 000 square feet (including the finished lower level) and including 2, 634 square foot accessory building that serves as a state-of-the-art fitness center. Additionally enjoy the pool house, saltwater 40x60 swimming pool, tennis court with pavilion, basketball court and a 2-car garage/service building, primarily used for storing golf carts, which provide access to the ocean beach via the Fordune Association’s beach access right of way.The home includes 13 bedrooms, 14 full baths and 2 half baths, a grand foyer entrance boasting 20 foot high ceilings and a one-of-a-kind Natural American and Brazilian walnut staircase and wood flooring. Impressive 35 x 25 foot living room with 21 foot ceilings and fireplace. The east wing first floor houses a media room, a beautiful office/library with a stunning walnut finish and coffered ceilings, and a bedroom suite.The second floor includes a library and 2 bedroom suites, the expansive suite primary bedroom with a sitting area, 4 closets, a large walk-in, 2 bathrooms and a balcony. The west wing first floor features 2 bedroom suites, a junior primary bedroom, formal dining room and a professional kitchen with an expansive sitting area plus breakfast area. A second staircase leads to the very private guest wing with 5 bedroom suites. The lower level, includes a state-of-the-art wine storage, a recreation room with a fireplace and media room and private staff/guests quarters with a living room, 2 bedrooms and 2 full baths.
    Presented By: Brown Harris Stevens Hamptons  631-287-4900
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Welcome to your very own paradise, a 1, 945-acre sanctuary offering endless possibilities. Whether you envision a family compound, a personal or corporate retreat, a game preserve, or even a winery or brewery, this breathtaking property delivers. The countryside is awe-inspiring, with boundless skies, fresh air, and a natural beauty that is truly unparalleled. Picture a serene campground or multiple homesites, each offering complete privacy, stunning vistas, and an unmatched quality of life. The property’s diverse terrain includes mature woodlands, light forests, hedgerows, and both open and intimate fields. No matter where you stand, you’re treated to spectacular views: westward toward the Catskills, east and southeast to Stissing Mountain, and northeast to the Taconics, the foothills of the Berkshires. Rolling hills, tranquil ponds, streams, and nature trails provide endless opportunities for outdoor recreation, while protected wetlands preserve the natural habitat for wildlife. This offering also includes 4 single-family homes, a two-family residence, a vast office and warehouse facility, and a preexisting subdivision. With frontage on four country roads, this property is a gateway to extraordinary potential. 22
    Woodward Hill, Stissng Mount, Hicks Hill, Route 19 Pine Plains, NY 12567
    $36,000,000
    Unimproved Land For Sale ML# H6332462
    Welcome to your very own paradise, a 1, 945-acre sanctuary offering endless possibilities. Whether you envision a family compound, a personal or corporate retreat, a game preserve, or even a winery or brewery, this breathtaking property delivers. The countryside is awe-inspiring, with boundless skies, fresh air, and a natural beauty that is truly unparalleled. Picture a serene campground or multiple homesites, each offering complete privacy, stunning vistas, and an unmatched quality of life. The property’s diverse terrain includes mature woodlands, light forests, hedgerows, and both open and intimate fields. No matter where you stand, you’re treated to spectacular views: westward toward the Catskills, east and southeast to Stissing Mountain, and northeast to the Taconics, the foothills of the Berkshires. Rolling hills, tranquil ponds, streams, and nature trails provide endless opportunities for outdoor recreation, while protected wetlands preserve the natural habitat for wildlife. This offering also includes 4 single-family homes, a two-family residence, a vast office and warehouse facility, and a preexisting subdivision. With frontage on four country roads, this property is a gateway to extraordinary potential.
    Presented By: Havens Real Estate  845-373-8555
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • INDIAN NECK FARM: UNPARALLELED - UNRIVALED - UNSURPASSED Nestled along a deep-water creek on the North Fork of Long Island lies a once-in-a-lifetime, 148-acre waterfront estate. The perfect sanctuary for you and your guests to escape the frantic pace of everyday life. This extraordinary legacy assemblage is also refuge for an abundance of wildlife, including quail, pheasant, songbirds, owl, and red-tailed hawks. Spring and Summer offer some of the best fishing on the Island. Simply leave from your 60’ floating dock located on a sheltered cove along the east end of the property, which also has the designation from New York State, to harvest shellfish on a year-round basis. There is a 60-acre certified organic farm which includes a chef’s variety garden, an attached apothecary and greenhouse. The latest infrastructure includes solar technology, state-of-the-art cooling, vegetable washing and packing equipment. 20 acres of pasture for production and resident animals completes your farm to table experience. Lifestyle activities you and your guests can expect range from a short game golf course, full practice putting green, simulator barn, tennis, swimming, hunting, and fishing. A state-of-the-art fitness and wellness barn, include a Pilates reformer, indoor cycling with a video wall, free weights and strength training equipment, a hyperbaric chamber, cryo-unit, ColdTub, infrared sauna and more. Indian Neck Farm accommodations offer the ultimate in privacy and unsurpassed comfort. Unplug, relax and simply be, uninterrupted. Rustic simplicity and extraordinary luxury offer a unique and memorable experience. Nature is the backdrop and sets the tone for you and your guests. Blending comfort and style, with multiple ensuite guest rooms, common areas, and fireplace lounges. Enjoy exceptional meals from the main house gourmet kitchen or make pizzas in your pizza oven at the poolside covered bar and grill. Indian Neck Farm, make this your dream come true. This Could Be You! 20
    4170/3375+ Indian Neck Lane Peconic, NY 11958
    $35,500,000
    11 Bedrooms 10 Full Baths 6 Half Baths
    Single Family For Sale NEW ML# 3590171
    INDIAN NECK FARM: UNPARALLELED - UNRIVALED - UNSURPASSED Nestled along a deep-water creek on the North Fork of Long Island lies a once-in-a-lifetime, 148-acre waterfront estate. The perfect sanctuary for you and your guests to escape the frantic pace of everyday life. This extraordinary legacy assemblage is also refuge for an abundance of wildlife, including quail, pheasant, songbirds, owl, and red-tailed hawks. Spring and Summer offer some of the best fishing on the Island. Simply leave from your 60’ floating dock located on a sheltered cove along the east end of the property, which also has the designation from New York State, to harvest shellfish on a year-round basis. There is a 60-acre certified organic farm which includes a chef’s variety garden, an attached apothecary and greenhouse. The latest infrastructure includes solar technology, state-of-the-art cooling, vegetable washing and packing equipment. 20 acres of pasture for production and resident animals completes your farm to table experience. Lifestyle activities you and your guests can expect range from a short game golf course, full practice putting green, simulator barn, tennis, swimming, hunting, and fishing. A state-of-the-art fitness and wellness barn, include a Pilates reformer, indoor cycling with a video wall, free weights and strength training equipment, a hyperbaric chamber, cryo-unit, ColdTub, infrared sauna and more. Indian Neck Farm accommodations offer the ultimate in privacy and unsurpassed comfort. Unplug, relax and simply be, uninterrupted. Rustic simplicity and extraordinary luxury offer a unique and memorable experience. Nature is the backdrop and sets the tone for you and your guests. Blending comfort and style, with multiple ensuite guest rooms, common areas, and fireplace lounges. Enjoy exceptional meals from the main house gourmet kitchen or make pizzas in your pizza oven at the poolside covered bar and grill. Indian Neck Farm, make this your dream come true. This Could Be You!
    Presented By: Corcoran  631-848-7730
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • CONCIERGE AUCTION IS LIVE: STARTING BIDS as follows. $3.75M on lot 38-48, $7.25M on Lot 58, and $11M for the package. BIDDING ENDS 10/10/24. Unparalleled equestrian compound sprawled over 16 acres of exceptional land w/pastures, paddocks, orchards, vegetable gardens, stables & aviary. Scenic drive through iron gates leads to 3 residential structures w/total of 11 bedrooms/13 baths. Exquisite main residence, a 5-bedroom, 7 bath, shingle style house. French Country kitchen w/intricately designed wood-inlay floors is just the appetizer to this masterfully designed home. 1-bedroom guest cottage/pool house serves the infinity-edge pool. Secondary 7000 sq.ft. 5 bed/6 bath, guest house is unique w/another exquisite kitchen. 12-horse Mediterranean style stable, laser leveled ring w/TravelRight footing 36
    38, 48, 58 Quaker Lane Greenwich, CT 06831
    $35,000,000
    5 Bedrooms 5 Full Baths 2 Half Baths Sq. Ft. 10800.00:# Square Feet
    Single Family For Sale ML# H6258587
    CONCIERGE AUCTION IS LIVE: STARTING BIDS as follows. $3.75M on lot 38-48, $7.25M on Lot 58, and $11M for the package. BIDDING ENDS 10/10/24. Unparalleled equestrian compound sprawled over 16 acres of exceptional land w/pastures, paddocks, orchards, vegetable gardens, stables & aviary. Scenic drive through iron gates leads to 3 residential structures w/total of 11 bedrooms/13 baths. Exquisite main residence, a 5-bedroom, 7 bath, shingle style house. French Country kitchen w/intricately designed wood-inlay floors is just the appetizer to this masterfully designed home. 1-bedroom guest cottage/pool house serves the infinity-edge pool. Secondary 7000 sq.ft. 5 bed/6 bath, guest house is unique w/another exquisite kitchen. 12-horse Mediterranean style stable, laser leveled ring w/TravelRight footing
    Presented By: Sotheby’s International Realty  (203) 618-3111
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Brand new Mix-use building located at 60 street & 3 ave, Sunset park, Brooklyn, close to pier4, NYC Ferry, N Q R W subway station, with 25 year tax abatement, 5 stories plus 53 apartment & community facilities, 35: 2 bedroom 2 bath, 17 :2 bedroom 1 bath, 1 :1 bedroom 1 bath with 30 parking space, Each apartment average rental $2980, community facilities has been rented, $14900 per month, great for investment . 15
    6020 3 Avenue Sunset Park, NY 11220
    $35,000,000
    Mixed Use Commercial ML# 3471387
    Brand new Mix-use building located at 60 street & 3 ave, Sunset park, Brooklyn, close to pier4, NYC Ferry, N Q R W subway station, with 25 year tax abatement, 5 stories plus 53 apartment & community facilities, 35: 2 bedroom 2 bath, 17 :2 bedroom 1 bath, 1 :1 bedroom 1 bath with 30 parking space, Each apartment average rental $2980, community facilities has been rented, $14900 per month, great for investment .
    Presented By: Star Realty International LLC  718-779-3388
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • A Timeless World-Class Masterpiece defined by grace & style, Shangri-La is an unparalleled Gold Coast Estate designed for luxurious living, gracious entertaining & the enjoyment of Art. This stately residence was designed by the renowned architectural firm Shope Reno Wharton. Located on 21.86 captivating acres, the estate is a symphony of Artistry & Design. Complemented by breathtaking and vibrant landscaping, there are two idyllic Ponds & a Conservatory Greenhouse. Two swimming Pools each have their own Cabana. There is an additional Cabana with a full Catering Kitchen. This serene & refined estate impeccable captures sophistication & elegance. Architectural excellence & tasteful appointments make this the ultimate in luxury and lifestyle. World-class design, masterful detailed workmanship and the finest materials culminate in a spectacular estate imbued with the tranquility and grace that is Shangri-La. 21
    ONE Dupont Court Brookville, NY 11545
    $33,500,000
    8 Bedrooms 9 Full Baths 4 Half Baths Sq. Ft. 23155.00:# Square Feet
    Single Family For Sale ML# 3469398
    A Timeless World-Class Masterpiece defined by grace & style, Shangri-La is an unparalleled Gold Coast Estate designed for luxurious living, gracious entertaining & the enjoyment of Art. This stately residence was designed by the renowned architectural firm Shope Reno Wharton. Located on 21.86 captivating acres, the estate is a symphony of Artistry & Design. Complemented by breathtaking and vibrant landscaping, there are two idyllic Ponds & a Conservatory Greenhouse. Two swimming Pools each have their own Cabana. There is an additional Cabana with a full Catering Kitchen. This serene & refined estate impeccable captures sophistication & elegance. Architectural excellence & tasteful appointments make this the ultimate in luxury and lifestyle. World-class design, masterful detailed workmanship and the finest materials culminate in a spectacular estate imbued with the tranquility and grace that is Shangri-La.
    Presented By: Daniel Gale Sothebys Intl Rlty  516-466-4036
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Excellent! Excellent! Location. Great Investment Property Or Developer Right. Zoning R6/C1-3. Property On The Edge Of Roosevelt Avenue, Jackson Heights. A Package Of ONE Block 10 Unit Commercial Storefront For Sale. 3 Minute Away From 82nd Street Jackson Heights 7 Train Station. Cap Rate 4%.
    84-29 Roosevelt Avenue Jackson Heights, NY 11372
    $29,999,999
    Mixed Use Commercial ML# 3572166
    Excellent! Excellent! Location. Great Investment Property Or Developer Right. Zoning R6/C1-3. Property On The Edge Of Roosevelt Avenue, Jackson Heights. A Package Of ONE Block 10 Unit Commercial Storefront For Sale. 3 Minute Away From 82nd Street Jackson Heights 7 Train Station. Cap Rate 4%.
    Presented By: Apple Realty Group Corp  718-888-2965
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Located in a high traffic area on Roosevelt Ave. Excellent investment property with development right. Lot 200’x100’, Zoning R6, C1-3. Total 10 Commercial Units, Fully occupied and cash-flowing asset offers investors a low-maintenance property. This commercial building is close to many retail stores, restaurants, and NYC Health+ Hospitals/Elmhurst. 2 Blocks to 82nd St/Roosevelt Ave, Close proximity to subway 7 train. 7
    84-01 Roosevelt Avenue Jackson Heights, NY 11372
    $29,999,999
    Mixed Use Commercial ML# 3571892
    Located in a high traffic area on Roosevelt Ave. Excellent investment property with development right. Lot 200’x100’, Zoning R6, C1-3. Total 10 Commercial Units, Fully occupied and cash-flowing asset offers investors a low-maintenance property. This commercial building is close to many retail stores, restaurants, and NYC Health+ Hospitals/Elmhurst. 2 Blocks to 82nd St/Roosevelt Ave, Close proximity to subway 7 train.
    Presented By: Chase Global Realty Corp  718-355-8788
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Behold Applewood Estate, an expansive 35+ acre serene property nestled within the prestigious Village of Upper Brookville. This unmatched North Shore architectural masterpiece with 6+ dwellings, offers both grandeur and elegance. The unrivaled property was meticulously designed with professional landscaping, decorated with mature privacy hedges, formal gardens with water features and rolling green lawn space. Rooted in history, this magnificent estate was once an Apple Orchard Farm back in the early 1900’s and was also formerly owned by the celebrated 19th-century American Artist Montague Flagg. The bespoke Main Residence encompasses an impressive 13, 000 Sq.Ft. of living space, was custom built with Slate, Brick and Stone in 2005 and is a testament to high-end design and luxury living. Designer details include Onyx Marble installations, spacious primary rooms, oversized parquet wood floors, handmade iron fireplaces, thick-cut millwork and more. A grand Foyer with a winding staircase, a Great Room with intricate coffered 23 foot ceilings and a magnificent Library loft and a handcrafted Meditation Room, a Billiards/Game room with a Wet-Bar and a Eat-In-Kitchen with a Breakfast Room overlooking the peaceful backyard are just a few of the interior highlights that make this home truly special. Additionally, this unrivaled estate features several detached houses including a 2 Bedroom Colonial Residence and a meticulously reconstructed circa 1914 Stone Barn, now serving as a guest retreat. This distinguished horse-property includes a newly resurfaced tennis court, a separate sports court, a 6-door detached garage, a commercial-grade 150kW generator, a long tree-lined driveway and a secure gated entrance, ensuring peace, beauty and privacy. Equestrian enthusiasts will appreciate the formal horse stables complete with a training ring. The property further boasts a heated in-ground pool pavilion with a jetted jacuzzi spa and a built-in outdoor kitchen, as well as a 1 bedroom Pool House and numerous other refined amenities, making it a Gold Coast sanctuary of relaxation and sophistication. 36
    Applewood Estate Upper Brookville, NY 11545
    $29,900,000
    13 Bedrooms 11 Full Baths 6 Half Baths Sq. Ft. 12892.00:# Square Feet
    Single Family For Sale ML# 3578383
    Behold Applewood Estate, an expansive 35+ acre serene property nestled within the prestigious Village of Upper Brookville. This unmatched North Shore architectural masterpiece with 6+ dwellings, offers both grandeur and elegance. The unrivaled property was meticulously designed with professional landscaping, decorated with mature privacy hedges, formal gardens with water features and rolling green lawn space. Rooted in history, this magnificent estate was once an Apple Orchard Farm back in the early 1900’s and was also formerly owned by the celebrated 19th-century American Artist Montague Flagg. The bespoke Main Residence encompasses an impressive 13, 000 Sq.Ft. of living space, was custom built with Slate, Brick and Stone in 2005 and is a testament to high-end design and luxury living. Designer details include Onyx Marble installations, spacious primary rooms, oversized parquet wood floors, handmade iron fireplaces, thick-cut millwork and more. A grand Foyer with a winding staircase, a Great Room with intricate coffered 23 foot ceilings and a magnificent Library loft and a handcrafted Meditation Room, a Billiards/Game room with a Wet-Bar and a Eat-In-Kitchen with a Breakfast Room overlooking the peaceful backyard are just a few of the interior highlights that make this home truly special. Additionally, this unrivaled estate features several detached houses including a 2 Bedroom Colonial Residence and a meticulously reconstructed circa 1914 Stone Barn, now serving as a guest retreat. This distinguished horse-property includes a newly resurfaced tennis court, a separate sports court, a 6-door detached garage, a commercial-grade 150kW generator, a long tree-lined driveway and a secure gated entrance, ensuring peace, beauty and privacy. Equestrian enthusiasts will appreciate the formal horse stables complete with a training ring. The property further boasts a heated in-ground pool pavilion with a jetted jacuzzi spa and a built-in outdoor kitchen, as well as a 1 bedroom Pool House and numerous other refined amenities, making it a Gold Coast sanctuary of relaxation and sophistication.
    Presented By: Daniel Gale Sothebys Intl Rlty  516-466-4036
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
  • Two contiguous, mixed-use apartment buildings on 82 nd and 83 rd Street with a total of 55, 000 SF combined (27, 500 SF each) and 62 units (56 residential and 6 commercial), located in prime location of Jackson Heights, New York City. Most of the units are Free Market. New Roof in 2019. Conveniently located near shopping, schools and transportation. In a supply-constrained market with high barriers to entry, the property is a compelling investment opportunity. Location is the biggest amenity of this fee simple property. Rents in NYC have soared recently. The overflow of Manhattan has found its way to Jackson Heights. The eight towers, five-story buildings are situated on a large site of 0.60 acres (26, 000 SF). The shared interior, green landscaped courtyards offer residents respite from bustling city life. The property’s desirability further increased for tenants due to its commanding view along the Avenue, which has recently been converted by the City into a Promenade where residents can stroll for a leisurely walk or jog or push strollers as vehicular traffic has been restricted. Amenities include gated entrances and a central landscaped courtyard. Within 3 blocks of a subway station, and within a 20-minute drive to midtown Manhattan. 18
    Jackson Heights, NY 11372
    $28,800,000
    Sq. Ft. 55000.00:# Square Feet
    Multi Family For Sale ML# 3555131
    Two contiguous, mixed-use apartment buildings on 82 nd and 83 rd Street with a total of 55, 000 SF combined (27, 500 SF each) and 62 units (56 residential and 6 commercial), located in prime location of Jackson Heights, New York City. Most of the units are Free Market. New Roof in 2019. Conveniently located near shopping, schools and transportation. In a supply-constrained market with high barriers to entry, the property is a compelling investment opportunity. Location is the biggest amenity of this fee simple property. Rents in NYC have soared recently. The overflow of Manhattan has found its way to Jackson Heights. The eight towers, five-story buildings are situated on a large site of 0.60 acres (26, 000 SF). The shared interior, green landscaped courtyards offer residents respite from bustling city life. The property’s desirability further increased for tenants due to its commanding view along the Avenue, which has recently been converted by the City into a Promenade where residents can stroll for a leisurely walk or jog or push strollers as vehicular traffic has been restricted. Amenities include gated entrances and a central landscaped courtyard. Within 3 blocks of a subway station, and within a 20-minute drive to midtown Manhattan.
    Presented By: Reliance USA Inc  info@reliusa.com
    Call Today: 516.767.0200, or  Email: Heidi Spellman Realty
Showing 11 - 20 of 28459 results| view:  results per page« 1|2|3|4|5|...|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