Click to Select a Town:
Click to Remove a Town:
Search
  •  
Search

26575 properties match your search ;

Showing 24791 - 24800 of 26575 results| view:  results per page« first|...|2478|2479|2480|2481|...|last »
  • $2,800,000
    ›View details
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Island Advantage Realty LLC  631-351-6000
  • Discover your private sanctuary at the end of a serene cul-de-sac in Greenfield Hill. This country compound spans 4.5 acres, enveloping a French-inspired main house with 6 BRs, 4.2 baths, and an enchanting English garden. Go into the elegant formal living and dining rooms, both warmed by inviting FPs, setting the stage for memorable moments. The custom gourmet kitchen, designed for living, opens onto a charming stone patio-perfect for al fresco dining. The first level also houses a sun-drenched family room and sophisticated library. Ascend to discover a serene primary suite with a spacious walk-in closet and 5 additional versatile BRs. The estate further offers a unique barn featuring an office, a gym, a squash court and extra living space-catering to every aspect of your lifestyle. Immerse in the stunning landscaping, a beautiful gunite pool, tennis court, vegetable garden, fruit trees, and stone walls outside. This bucolic haven promises a lifestyle of comfort, wellness, and charm. Additional Information: Amenities:Guest Quarters, Tennis, HeatingFuel:Oil Above Ground, ParkingFeatures:4+ Car Attached, ConstructionDescription: Stucco,  Additional Information: Amenities:Tennis,
    $2,800,000
    ›View details
    ML# :H6334560   Discover your private sanctuary at the end of a serene cul-de-sac in Greenfield Hill. This country compound spans 4.5 acres, enveloping a French-inspired main house with 6 BRs, 4.2 baths, and an enchanting English garden. Go into the elegant formal living and dining rooms, both warmed by inviting FPs, setting the stage for memorable moments. The custom gourmet kitchen, designed for living, opens onto a charming stone patio-perfect for al fresco dining. The first level also houses a sun-drenched family room and sophisticated library. Ascend to discover a serene primary suite with a spacious walk-in closet and 5 additional versatile BRs. The estate further offers a unique barn featuring an office, a gym, a squash court and extra living space-catering to every aspect of your lifestyle. Immerse in the stunning landscaping, a beautiful gunite pool, tennis court, vegetable garden, fruit trees, and stone walls outside. This bucolic haven promises a lifestyle of comfort, wellness, and charm. Additional Information: Amenities:Guest Quarters, Tennis, HeatingFuel:Oil Above Ground, ParkingFeatures:4+ Car Attached, ConstructionDescription: Stucco, Additional Information: Amenities:Tennis,
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Coldwell Banker Realty  203-622-1100
  • $2,800,000
    ›View details
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Dream Castle Realty  516-812-8570
  • In the historic landmark of Hamilton Heights, this 18-foot-wide, 70-foot-deep, modern two-family townhouse offers versatile living. The ground floor features a two-bedroom, floor-through apartment with a home office, open kitchen, and in-unit washer & dryer, last leased at $3, 750/month and currently vacant. The owner-occupied triplex offers a large living room, open kitchen, dining area, covered rear deck, a full floor for recreation, 3 bedrooms, 2.5 baths, laundry, and a roof deck. Delivered vacant until the ground floor is re-rented. With central air, radiant heat, hardwood, and exposed brick, it blends comfort with character. The C1-4 commercial overlay allows for retail on the ground floor. Conveniently located near major parks, across from CUNY, and providing easy access to amenities on Amsterdam Ave and Broadway, as well as the #1, A, B, C, D trains, and southbound M100 & M101 buses to the 2, 3, 4, 5, 6 trains, and Metro-North. One subway stop from the Columbia University campus.
    $2,800,000
    ›View details
    ML# :H6333227   In the historic landmark of Hamilton Heights, this 18-foot-wide, 70-foot-deep, modern two-family townhouse offers versatile living. The ground floor features a two-bedroom, floor-through apartment with a home office, open kitchen, and in-unit washer & dryer, last leased at $3, 750/month and currently vacant. The owner-occupied triplex offers a large living room, open kitchen, dining area, covered rear deck, a full floor for recreation, 3 bedrooms, 2.5 baths, laundry, and a roof deck. Delivered vacant until the ground floor is re-rented. With central air, radiant heat, hardwood, and exposed brick, it blends comfort with character. The C1-4 commercial overlay allows for retail on the ground floor. Conveniently located near major parks, across from CUNY, and providing easy access to amenities on Amsterdam Ave and Broadway, as well as the #1, A, B, C, D trains, and southbound M100 & M101 buses to the 2, 3, 4, 5, 6 trains, and Metro-North. One subway stop from the Columbia University campus.
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Douglas Elliman Real Estate  
  • Modern 4-Story Residential Building  This newly constructed, four-story building features 7 beautifully designed one-bedroom apartments, perfect for urban living. The building is conveniently located just a short walk from public transportation and the subway at Archer Ave and Sutphin Blvd, making commuting easy and efficient. Each apartment boasts modern finishes, high-quality appliances, and ample natural light. The third and fourth-floor units include private balconies, offering residents their own outdoor space with views of the surrounding area. The first-floor apartment is thoughtfully designed to be handicap accessible, ensuring comfort and convenience for all. With its prime location, accessibility, and modern amenities, this building is an excellent opportunity for comfortable and stylish city living. 421A 35YR with Affordable Housing Pct. (End Year: 2058)
    $2,800,000
    ›View details
    ML# :3584909   Modern 4-Story Residential Building This newly constructed, four-story building features 7 beautifully designed one-bedroom apartments, perfect for urban living. The building is conveniently located just a short walk from public transportation and the subway at Archer Ave and Sutphin Blvd, making commuting easy and efficient. Each apartment boasts modern finishes, high-quality appliances, and ample natural light. The third and fourth-floor units include private balconies, offering residents their own outdoor space with views of the surrounding area. The first-floor apartment is thoughtfully designed to be handicap accessible, ensuring comfort and convenience for all. With its prime location, accessibility, and modern amenities, this building is an excellent opportunity for comfortable and stylish city living. 421A 35YR with Affordable Housing Pct. (End Year: 2058)
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Baring Homes Corp  718-441-0900
  • FAMILY COMPOUND/HORSE PROPERTY. Introducing Westerleigh-a distinguished ESTATE with a rich history, named by Theodore Roosevelt’s personal secretary. Nestled on just under 4.5 acres in the exclusive Mill Neck neighborhood and directly across from Oyster Bay Harbor, this multi-family compound offers both elegance and charm. The impressive main manor boasts 7 bedrooms, 5 full baths, 2 half baths, and 6 fireplaces, providing ample space and luxurious living. Complementing the main house is a delightful cottage-style residence featuring 5 bedrooms, 3 full baths, and 1 fireplace. The estate also includes stunning water views, an in-ground pool, a 6-stall horse barn with a paddock, and a tranquil pond-creating an equestrian paradise. This property presents a unique opportunity to renovate and personalize the main manor to fit your vision. Experience the potential to make Westerleigh your own private sanctuary. MANI HOUSE - Description FIRST Floor Front Entrance is a vestibule with powder room and large guest closet. Large Main Foyer front to back with Grand Staircase To the right of the main foyer is the living room with fireplace, French doors. To the left of the main foyer is the dining room with fireplace. After the dining room is the family room with fireplace, in addition has floor to ceiling built in wall units. Kitchen Large eat-in kitchen with fireplace, center island and breakfast area. Of the kitchen is the laundry room, maid’s bedroom and full bathroom. SECOND Floor Master Suite with full bathroom and walk-in closet, fireplace. A bedroom with full bathroom, large walk-in closet, fireplace. Coming from the back staircase, an entrance to a second Master Suite/Caretaker suite with full bathroom. THIRD Floor Two Bedrooms, one full bathroom. A third bedroom with one half bath can be accessed through a doorway from the bedroom to the right when you are on the third-floor foyer. BASEMENT: Full unfinished basement. COTTAGE 5-BEDROOMS & 3 BATH. Cottage was renovated 15 years ago. Electrical and plumbing is update to code.
    $2,800,000
    ›View details
    ML# :3575329   FAMILY COMPOUND/HORSE PROPERTY. Introducing Westerleigh-a distinguished ESTATE with a rich history, named by Theodore Roosevelt’s personal secretary. Nestled on just under 4.5 acres in the exclusive Mill Neck neighborhood and directly across from Oyster Bay Harbor, this multi-family compound offers both elegance and charm. The impressive main manor boasts 7 bedrooms, 5 full baths, 2 half baths, and 6 fireplaces, providing ample space and luxurious living. Complementing the main house is a delightful cottage-style residence featuring 5 bedrooms, 3 full baths, and 1 fireplace. The estate also includes stunning water views, an in-ground pool, a 6-stall horse barn with a paddock, and a tranquil pond-creating an equestrian paradise. This property presents a unique opportunity to renovate and personalize the main manor to fit your vision. Experience the potential to make Westerleigh your own private sanctuary. MANI HOUSE - Description FIRST Floor Front Entrance is a vestibule with powder room and large guest closet. Large Main Foyer front to back with Grand Staircase To the right of the main foyer is the living room with fireplace, French doors. To the left of the main foyer is the dining room with fireplace. After the dining room is the family room with fireplace, in addition has floor to ceiling built in wall units. Kitchen Large eat-in kitchen with fireplace, center island and breakfast area. Of the kitchen is the laundry room, maid’s bedroom and full bathroom. SECOND Floor Master Suite with full bathroom and walk-in closet, fireplace. A bedroom with full bathroom, large walk-in closet, fireplace. Coming from the back staircase, an entrance to a second Master Suite/Caretaker suite with full bathroom. THIRD Floor Two Bedrooms, one full bathroom. A third bedroom with one half bath can be accessed through a doorway from the bedroom to the right when you are on the third-floor foyer. BASEMENT: Full unfinished basement. COTTAGE 5-BEDROOMS & 3 BATH. Cottage was renovated 15 years ago. Electrical and plumbing is update to code.
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: A Class Realty  516-226-1420
  • Orient, The Hill. Perched high on a hill above the Long Island Sound, is this exceptional offering in the coveted The Hill historic estate enclave. Authentic, classic, grand. Architectural details include 5 fireplaces, 16/1 windows, front entry door with sidelight panes. Beautiful landscape, hardscape, paths and plantings adorn this rolling 1.3 acre property. Swimming pool. 6 bedrooms 4.5 baths. Generous size rooms and waterside screened porch. Stunning sunsets. Owned by the same family for 65 years. The next one could be yours. A truly special Orient property. The possibilities are endless. Set above the stretch where the Sound meets the Bay, it doesn’t get any more North Fork than this!
    $2,800,000
    ›View details
    ML# :3573568   Orient, The Hill. Perched high on a hill above the Long Island Sound, is this exceptional offering in the coveted The Hill historic estate enclave. Authentic, classic, grand. Architectural details include 5 fireplaces, 16/1 windows, front entry door with sidelight panes. Beautiful landscape, hardscape, paths and plantings adorn this rolling 1.3 acre property. Swimming pool. 6 bedrooms 4.5 baths. Generous size rooms and waterside screened porch. Stunning sunsets. Owned by the same family for 65 years. The next one could be yours. A truly special Orient property. The possibilities are endless. Set above the stretch where the Sound meets the Bay, it doesn’t get any more North Fork than this!
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Daniel Gale Sothebys Intl Rlty  631-734-5439
  • This property has 3 units, one of which is leased. Units have ceiling cranes installed as well. Overall sq footage is approximately 7, 500 sq ft, and if need be for greater space utilization, the spaces can be connected. A rare opportunity in Ozone Park,  to own a large warehouse property whether for investment or personal business needs. With this location being a minuscule distance from the JFK airport and Ozone Park becoming more and more of a prosperous neighborhood, the opportunities are only as endless as imagination and creativity allow.
    $2,800,000
    ›View details
    ML# :3560501   This property has 3 units, one of which is leased. Units have ceiling cranes installed as well. Overall sq footage is approximately 7, 500 sq ft, and if need be for greater space utilization, the spaces can be connected. A rare opportunity in Ozone Park, to own a large warehouse property whether for investment or personal business needs. With this location being a minuscule distance from the JFK airport and Ozone Park becoming more and more of a prosperous neighborhood, the opportunities are only as endless as imagination and creativity allow.
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Keller Williams Realty Liberty  718-848-4700
  • Legal 4 units brick, fully rented good income in excellent location location location good for investment Fort units property 2006 built: 1store+3Fam. close to All Bus Q58, N/R Trains, Supermarket, Schools.
    $2,800,000
    ›View details
    ML# :3559874   Legal 4 units brick, fully rented good income in excellent location location location good for investment Fort units property 2006 built: 1store+3Fam. close to All Bus Q58, N/R Trains, Supermarket, Schools.
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Graceful Realty LLC  718-353-0068
  • Enjoy summer in this beautiful Hamptons-style home nestled in the Mandalay area of Wantagh is unlike any other. Picture breathtaking bay views thru custom Marvin windows showcasing the serene waterfront setting. Enter into the grand center hall with a formal dining room and a sunlit study. The large kitchen with a center island is a chef’s dream. The spacious dining area is perfect for casual dining and tasteful holiday gatherings. The grand living room features extra high ceilings and views of the open bay and Jones Beach tower. The primary bedroom includes an en-suite bathroom, walk-in closet, and office nook. The third and fourth floor boast 7 generously sized bedrooms a laundry room and a unique attic. Enjoy cozy winters by the fireplace and unforgettable summers poolside, on the water, or from the roof balcony. Over 100 feet of marine construction bulkheading in a deep waterway makes it suitable for any boat. Comfort and elegance find each other in this house. Make this unique 5, 772 square foot house your dream home.
    $2,800,000
    ›View details
    ML# :3558299   Enjoy summer in this beautiful Hamptons-style home nestled in the Mandalay area of Wantagh is unlike any other. Picture breathtaking bay views thru custom Marvin windows showcasing the serene waterfront setting. Enter into the grand center hall with a formal dining room and a sunlit study. The large kitchen with a center island is a chef’s dream. The spacious dining area is perfect for casual dining and tasteful holiday gatherings. The grand living room features extra high ceilings and views of the open bay and Jones Beach tower. The primary bedroom includes an en-suite bathroom, walk-in closet, and office nook. The third and fourth floor boast 7 generously sized bedrooms a laundry room and a unique attic. Enjoy cozy winters by the fireplace and unforgettable summers poolside, on the water, or from the roof balcony. Over 100 feet of marine construction bulkheading in a deep waterway makes it suitable for any boat. Comfort and elegance find each other in this house. Make this unique 5, 772 square foot house your dream home.
    Call Today: (718) 848-7700, or  Email: Mega Star Realty
    MLS
    Presented by: Signature Premier Properties  516-785-0100
Showing 24791 - 24800 of 26575 results| view:  results per page« first|...|2478|2479|2480|2481|...|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 Mega Star Realty are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.