to
 
 
 
Search Search
» Property Criteria
» Features
  •  
» Display Tools
Search

25497  properties match your search;

23936 with Multiple photos ;  2452 with Virtual Tour ;  189 with Videos

Save Search
Showing 25061 - 25070 of 25497 results| view:  results per page« first|...|2505|2506|2507|2508|...|last »
  • This versatile mixed-use building combines retail and residential spaces, perfectly situated just a minute’s walk from the vibrant Main Street corridor. Spanning 5, 230 square feet, the first floor features four independent retail stores tax units and seven indoor parking spaces, all 100% occupied. Investors will appreciate the long-term development potential and robust cash flow this prime location offers.The building is mix of strong tenants, including a pharmacy, clinic, and adult day care center, all with solid financial standings and significant investments in the property. Positioned in the most bustling shopping district of downtown Flushing, it’s just minutes away from the 7 train and a short 10-minute walk to the Long Island Rail Road, allowing guests to reach Manhattan in under 20 minutes. This property is a must-see for savvy investors looking to capitalize on a thriving community!Information: Building Size:59X100
    134-40 Cherry Avenue Unit S1-S4 Flushing, NY 11355
    $5,380,000
    Mixed Use Commercial ML# 3591248
    This versatile mixed-use building combines retail and residential spaces, perfectly situated just a minute’s walk from the vibrant Main Street corridor. Spanning 5, 230 square feet, the first floor features four independent retail stores tax units and seven indoor parking spaces, all 100% occupied. Investors will appreciate the long-term development potential and robust cash flow this prime location offers.The building is mix of strong tenants, including a pharmacy, clinic, and adult day care center, all with solid financial standings and significant investments in the property. Positioned in the most bustling shopping district of downtown Flushing, it’s just minutes away from the 7 train and a short 10-minute walk to the Long Island Rail Road, allowing guests to reach Manhattan in under 20 minutes. This property is a must-see for savvy investors looking to capitalize on a thriving community!Information: Building Size:59X100
    Presented By: E Realty International Corp  718-886-8110
    Call Today: or  Email: Judy Fruitbine
  • Nestled in the heart of Sag Harbor, this stunning 6, 400sq. ft new construction home is situated on .52 acres moments from Sag Harbor Village. Boasting 6 bedrooms and 8.2 bathrooms, the thoughtful layout coupled with high end finishes and amenities creates the perfect haven for entertaining and enjoying all season long from the spacious double height foyer, sun-filled great room with floor-to-ceiling, custom chef’s kitchen with oversized island, butler pantry, formal dining room, first floor junior primary and wine cellar. Ascending to the second level, the primary bedroom beckons with a fireplace, private balcony, sitting room, and a spa-like primary bathroom with soaking tub and dual sinks. Three additional bedrooms, each with their own walk-in closet and bathroom, offer unparalleled comfort and privacy married by a sitting room for all to enjoy. The expansive lower level was designed with wellness and entertainment in mind, featuring a gym, sauna, temperature-controlled wine cellar, large recreational area with wet bar, media room, and additional ensuite bedroom with full bathrooms. Outdoors, the estate presents an exquisite retreat with an 40’x20’ pool and 256+/- sq. ft. pool house, professional landscaping, and expansive porcelain patios for dining and lounging, offering the ultimate in outdoor and outdoor entertainment set for completion early Spring 2025. 20
    7 Rosemary Lane Sag Harbor, NY 11963
    $5,395,000
    6 Bedrooms 8 Full Baths 2 Half Baths Sq. Ft. 6377.00:#
    Single Family For Sale ML# 3567664
    Nestled in the heart of Sag Harbor, this stunning 6, 400sq. ft new construction home is situated on .52 acres moments from Sag Harbor Village. Boasting 6 bedrooms and 8.2 bathrooms, the thoughtful layout coupled with high end finishes and amenities creates the perfect haven for entertaining and enjoying all season long from the spacious double height foyer, sun-filled great room with floor-to-ceiling, custom chef’s kitchen with oversized island, butler pantry, formal dining room, first floor junior primary and wine cellar. Ascending to the second level, the primary bedroom beckons with a fireplace, private balcony, sitting room, and a spa-like primary bathroom with soaking tub and dual sinks. Three additional bedrooms, each with their own walk-in closet and bathroom, offer unparalleled comfort and privacy married by a sitting room for all to enjoy. The expansive lower level was designed with wellness and entertainment in mind, featuring a gym, sauna, temperature-controlled wine cellar, large recreational area with wet bar, media room, and additional ensuite bedroom with full bathrooms. Outdoors, the estate presents an exquisite retreat with an 40’x20’ pool and 256+/- sq. ft. pool house, professional landscaping, and expansive porcelain patios for dining and lounging, offering the ultimate in outdoor and outdoor entertainment set for completion early Spring 2025.
    Presented By: Douglas Elliman Real Estate  631-725-0200
    Call Today: or  Email: Judy Fruitbine
  • First Floor 8, 000 sq ft frontage on Steinway street - Two 4, 000 sq ft divided (total is 8, 000) No Lease 2nd Floor- 7, 000 sq ft- Executives Offices 3rd Floor- Studio Caretakers Apartment 2nd floor back has Hugh 80 foot patio you can enclose them and have additional space 3 blocks from WILD FLOWERS, ROBERT DE NIRO’S FILM PRODUCTION STUDIO $400 MILLION DEVELOPMENT short term leases wide street owner motivated, Additional information: Building Size:14785 9
    18-65 Steinway Street Unit 1 Astoria, NY 11105
    $5,399,000
    Sq. Ft. 14850.00:#
    Warehouse Commercial ML# 3490996
    First Floor 8, 000 sq ft frontage on Steinway street - Two 4, 000 sq ft divided (total is 8, 000) No Lease 2nd Floor- 7, 000 sq ft- Executives Offices 3rd Floor- Studio Caretakers Apartment 2nd floor back has Hugh 80 foot patio you can enclose them and have additional space 3 blocks from WILD FLOWERS, ROBERT DE NIRO’S FILM PRODUCTION STUDIO $400 MILLION DEVELOPMENT short term leases wide street owner motivated, Additional information: Building Size:14785
    Presented By: Realty Executives Today  718-274-2400
    Call Today: or  Email: Judy Fruitbine
  • Nestled on a spacious 7, 200 square foot lot, this majestic Grand Center Hall Colonial embodies luxury and sophistication. With meticulous attention to detail and an array of premium features, this residence offers unparalleled comfort and elegance. Spanning over 8 bedrooms and 10 bathrooms, this home is designed to accommodate the most discerning tastes. The entire first floor boasts underfloor heating and is equipped with 6 independent AC zones, ensuring optimal comfort year-round. A 300-gallon fish tank adds a touch of aquatic charm to the expansive living space. For convenience, the property includes a versatile 2 car garage and is equipped with provisions for a sidewalk ice-melt system, perfect for winter maintenance. The residence operates as a full smart house, featuring integrated security cameras, a built-in speaker system, and electric shades throughout the first floor. Custom built-in millwork and wide slat wood floors enhance the interior ambiance, complemented by a vacuum system and double insulation for soundproof tranquility. The gourmet kosher kitchen is outfitted with striking red oven knobs, alongside a range of high-end appliances tailored for culinary enthusiasts. The master suite epitomizes luxury with an ensuite bathroom showcasing his and her sinks set in a custom vanity, a self-cleaning freestanding air tub, and a 13-head shower system. Underfloor heating and a dedicated toilet room add to the suite’s comfort, while a double-height ceiling over the tub is adorned with a Swarovski chandelier for added opulence. Outside, a private porch offers a serene retreat, perfect for morning coffee or evening relaxation. Walk-through closets are illuminated by custom LED lighting, featuring a tie wall, built-in dresser, pull-out valets, and bespoke knobs that exemplify thoughtful design. This remarkable property seamlessly blends timeless elegance with modern conveniences, offering a rare opportunity for luxurious living in a coveted neighborhood. Schedule your private tour today to experience this exceptional residence firsthand. 36
    78-32 138th Street Kew Garden Hills, NY 11367
    $5,400,000
    8 Bedrooms 8 Full Baths 2 Half Baths
    Single Family For Sale ML# 3573483
    Nestled on a spacious 7, 200 square foot lot, this majestic Grand Center Hall Colonial embodies luxury and sophistication. With meticulous attention to detail and an array of premium features, this residence offers unparalleled comfort and elegance. Spanning over 8 bedrooms and 10 bathrooms, this home is designed to accommodate the most discerning tastes. The entire first floor boasts underfloor heating and is equipped with 6 independent AC zones, ensuring optimal comfort year-round. A 300-gallon fish tank adds a touch of aquatic charm to the expansive living space. For convenience, the property includes a versatile 2 car garage and is equipped with provisions for a sidewalk ice-melt system, perfect for winter maintenance. The residence operates as a full smart house, featuring integrated security cameras, a built-in speaker system, and electric shades throughout the first floor. Custom built-in millwork and wide slat wood floors enhance the interior ambiance, complemented by a vacuum system and double insulation for soundproof tranquility. The gourmet kosher kitchen is outfitted with striking red oven knobs, alongside a range of high-end appliances tailored for culinary enthusiasts. The master suite epitomizes luxury with an ensuite bathroom showcasing his and her sinks set in a custom vanity, a self-cleaning freestanding air tub, and a 13-head shower system. Underfloor heating and a dedicated toilet room add to the suite’s comfort, while a double-height ceiling over the tub is adorned with a Swarovski chandelier for added opulence. Outside, a private porch offers a serene retreat, perfect for morning coffee or evening relaxation. Walk-through closets are illuminated by custom LED lighting, featuring a tie wall, built-in dresser, pull-out valets, and bespoke knobs that exemplify thoughtful design. This remarkable property seamlessly blends timeless elegance with modern conveniences, offering a rare opportunity for luxurious living in a coveted neighborhood. Schedule your private tour today to experience this exceptional residence firsthand.
    Presented By: Astor Brokerage Ltd  
    Call Today: or  Email: Judy Fruitbine
  • Unparalleled elegance in this 6-bedroom brick Georgian Colonial, reminiscent of an English estate on rare 1.5 private & picturesque property. A long private drive bordered by flowering shrubs, beautiful circular entrance w/ artistically landscaped medallion. Unique front-to-back reception rooms, center hall layout, high ceilings throughout.Magnificent inground pool & hot tub surrounded by gracious terrace, putting green/sand trap, tennis backboard/basketball court. Sq ftge does NOT include additional 875 legal sq ft in basement.With its prime location, residents enjoy easy access to the station and a short stroll to the quaint village of Rye with its charming shops and restaurants. Experience the epitome of luxury living in this exquisite Georgian Colonial, where every detail is designed for comfort and sophistication. Inclusions galore and Furniture can also be purchased. Additional Information: Amenities:Marble Bath, Storage, ParkingFeatures:2 Car Detached, 35
    55 Hillside Rd Rye, NY 10580
    $5,400,000
    6 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 4834.00:#
    Single Family For Sale ML# H6320645
    Unparalleled elegance in this 6-bedroom brick Georgian Colonial, reminiscent of an English estate on rare 1.5 private & picturesque property. A long private drive bordered by flowering shrubs, beautiful circular entrance w/ artistically landscaped medallion. Unique front-to-back reception rooms, center hall layout, high ceilings throughout.Magnificent inground pool & hot tub surrounded by gracious terrace, putting green/sand trap, tennis backboard/basketball court. Sq ftge does NOT include additional 875 legal sq ft in basement.With its prime location, residents enjoy easy access to the station and a short stroll to the quaint village of Rye with its charming shops and restaurants. Experience the epitome of luxury living in this exquisite Georgian Colonial, where every detail is designed for comfort and sophistication. Inclusions galore and Furniture can also be purchased. Additional Information: Amenities:Marble Bath, Storage, ParkingFeatures:2 Car Detached,
    Presented By: Coldwell Banker Realty  914 9670059
    Call Today: or  Email: Judy Fruitbine
  • Wealth Building Investment Opportunity! Investment Opportunity! 13000+/- sq ft, 100% occupied, Attractive current Return On Investment(ROI) with UPSIDE -Turn Key - Rare find in the subject area. Ideal for investor/end user or combination. Uses include but are not limited to; Specialty trade, contractor, warehouse, Flex, Storage, office, industrial, showroom, retail, professional, creative. Easy access to all, great demographics and large demand for this uses in the area. Great tenant-based, solid leases, and escalations., Additional information: vac_perc:0, Building Size:13000 8
    137 Montauk Highway Westhampton, NY 11977
    $5,450,000
    Sq. Ft. 13000.00:#
    Misc Commercial ML# 3429590
    Wealth Building Investment Opportunity! Investment Opportunity! 13000+/- sq ft, 100% occupied, Attractive current Return On Investment(ROI) with UPSIDE -Turn Key - Rare find in the subject area. Ideal for investor/end user or combination. Uses include but are not limited to; Specialty trade, contractor, warehouse, Flex, Storage, office, industrial, showroom, retail, professional, creative. Easy access to all, great demographics and large demand for this uses in the area. Great tenant-based, solid leases, and escalations., Additional information: vac_perc:0, Building Size:13000
    Presented By: First Hampton Int’l Realty LLC  631-288-2122
    Call Today: or  Email: Judy Fruitbine
  • Prime location in Long Island City (LIC), a high-demand area for businesses due to proximity to Manhattan and strong infrastructure. 10, 200 square feet with fireproof construction, which is a significant asset for safety and insurance purposes. Two drive-in doors make it ideal for logistics, deliveries, or storage-heavy operations. 14-foot ceiling height is beneficial for storage and equipment flexibility. Equipped with 3-phase 600 amps, supporting heavy machinery or advanced HVAC systems if needed. R5 zoning with a certificate of occupancy (C/O) for office and storage use, allowing mixed uses under certain conditions. HVAC, a small office, and a new conference room add value for companies looking for both operational and administrative space. The option to deliver the property vacant or lease back a portion of the space offers flexibility for different types of buyers., Building Size:10200 15
    34-51 Vernon Boulevard Long Island City, NY 11106
    $5,490,000
    Sq. Ft. 10200.00:#
    Industrial Commercial ML# 3590775
    Prime location in Long Island City (LIC), a high-demand area for businesses due to proximity to Manhattan and strong infrastructure. 10, 200 square feet with fireproof construction, which is a significant asset for safety and insurance purposes. Two drive-in doors make it ideal for logistics, deliveries, or storage-heavy operations. 14-foot ceiling height is beneficial for storage and equipment flexibility. Equipped with 3-phase 600 amps, supporting heavy machinery or advanced HVAC systems if needed. R5 zoning with a certificate of occupancy (C/O) for office and storage use, allowing mixed uses under certain conditions. HVAC, a small office, and a new conference room add value for companies looking for both operational and administrative space. The option to deliver the property vacant or lease back a portion of the space offers flexibility for different types of buyers., Building Size:10200
    Presented By: B Square Realty Inc  718-939-8388
    Call Today: or  Email: Judy Fruitbine
  • Stunning young brick colonial built in 2010 and largely remodeled w. exquisite detail in 2018. Features include but not limited to: custom kosher kitchen w. high end appliances, 10-foot ceilings throughout, floor-to-floor windows, all 2nd floor bedrooms w. en-suite baths and custom closets, 7 bedrooms and 7.5 baths total, huge basement with gym, multipurpose room, 2nd kitchen & guest suite area, 10 zone radiant heat, 6 zone CAC, whole house generator, all overlooking magnificent mainucred dream property. 36
    522 Chauncey Lane Lawrence, NY 11559
    $5,490,000
    7 Bedrooms 7 Full Baths 1 Half Bath Sq. Ft. 10800.00:#
    Single Family For Sale ML# 3587700
    Stunning young brick colonial built in 2010 and largely remodeled w. exquisite detail in 2018. Features include but not limited to: custom kosher kitchen w. high end appliances, 10-foot ceilings throughout, floor-to-floor windows, all 2nd floor bedrooms w. en-suite baths and custom closets, 7 bedrooms and 7.5 baths total, huge basement with gym, multipurpose room, 2nd kitchen & guest suite area, 10 zone radiant heat, 6 zone CAC, whole house generator, all overlooking magnificent mainucred dream property.
    Presented By: Five Towns Miller Realty Inc  516-374-4100
    Call Today: or  Email: Judy Fruitbine
  • It is rare opportunity to own legal 4 family house located in the Best Location in Boerum hill, Situated on a picturesque tree-lined street, this townhome half block from most coveted smith & Courts street, one block from train station and Major transits. This is an exquisite, remarkable building size 22 ft x 43 ft with total living space 3, 936 ft. Building gut renovated since 2010 to present , from bottom to top, New facade , New brick back wall with newly painted fire escape ladder, Metal staircase, Hardwood floor throughout, New electric wiring, New electric Panel, New 4 separate boilers & hot water tanks, Reinforced foundation. Garden duplex unite featuring 2 bedrooms, I full bathroom, and access to beautiful garden, plus large full finished basement with 8 feet high ceiling perfect for entrainment, gym, studio... Second unit featuring 2 large bedrooms could accommodate king-size beds and furniture set, I full bathroom with cozy living room, huge parlor window overlook landscaped garden. The third and fourth floor apartment both are designed into 3 bedrooms, 1 full bathroom, and LR/DR Rental unit filled with nature light. Excellent location close to Restaurants, bars, shops, club, and subway right on corner, convenient to all, this property offers the opportunity to live with great income, own a prime investment property or convert the building into a single home in the heart of Boerum Hill. Don’t miss out, must see it !!! 26
    120 Dean Street Unit 4 Brooklyn, NY 11201
    $5,490,000
    10 Bedrooms 4 Full Baths Sq. Ft. 3936.00:#
    Townhouse For Sale ML# H6333321
    It is rare opportunity to own legal 4 family house located in the Best Location in Boerum hill, Situated on a picturesque tree-lined street, this townhome half block from most coveted smith & Courts street, one block from train station and Major transits. This is an exquisite, remarkable building size 22 ft x 43 ft with total living space 3, 936 ft. Building gut renovated since 2010 to present , from bottom to top, New facade , New brick back wall with newly painted fire escape ladder, Metal staircase, Hardwood floor throughout, New electric wiring, New electric Panel, New 4 separate boilers & hot water tanks, Reinforced foundation. Garden duplex unite featuring 2 bedrooms, I full bathroom, and access to beautiful garden, plus large full finished basement with 8 feet high ceiling perfect for entrainment, gym, studio... Second unit featuring 2 large bedrooms could accommodate king-size beds and furniture set, I full bathroom with cozy living room, huge parlor window overlook landscaped garden. The third and fourth floor apartment both are designed into 3 bedrooms, 1 full bathroom, and LR/DR Rental unit filled with nature light. Excellent location close to Restaurants, bars, shops, club, and subway right on corner, convenient to all, this property offers the opportunity to live with great income, own a prime investment property or convert the building into a single home in the heart of Boerum Hill. Don’t miss out, must see it !!!
    Presented By: East Coast Realtors, Inc.  718-428-6888
    Call Today: or  Email: Judy Fruitbine
  • It is rare opportunity to own legal 4 family house located in the Best Location in Boerum hill, Situated on a picturesque tree-lined street, this townhome half block from most coveted smith & Courts street, one block from train station and Major transits. This is an exquisite, remarkable building size 22 ft x 43 ft with total living space 3, 936 ft. Building gut renovated since 2010 to present , from bottom to top, New facade , New brick back wall with newly painted fire escape ladder, Metal staircase, Hardwood floor throughout, New electric wiring, New electric Panel, New 4 separate boilers & hot water tanks, Reinforced foundation. Garden duplex unite featuring 2 bedrooms, I full bathroom, and access to beautiful garden, plus large full finished basement with 8 feet high ceiling perfect for entrainment, gym, studio... Second unit featuring 2 large bedrooms could accommodate king-size beds and furniture set, I full bathroom with cozy living room, huge parlor window overlook landscaped garden. The third and fourth floor apartment both are designed into 3 bedrooms, 1 full bathroom, and LR/DR Rental unit filled with nature light. Excellent location close to Restaurants, bars, shops, club, and subway right on corner, convenient to all, this property offers the opportunity to live with great income, own a prime investment property or convert the building into a single home in the heart of Boerum Hill. Don’t miss out, must see it !!!, Additional information: Appearance:Excellent, Interior Features:Lr/Dr 23
    120 Dean Street Brooklyn, NY 11201
    $5,490,000
    10 Bedrooms 4 Full Baths Sq. Ft. 3936.00:#
    Single Family For Sale ML# 3579006
    It is rare opportunity to own legal 4 family house located in the Best Location in Boerum hill, Situated on a picturesque tree-lined street, this townhome half block from most coveted smith & Courts street, one block from train station and Major transits. This is an exquisite, remarkable building size 22 ft x 43 ft with total living space 3, 936 ft. Building gut renovated since 2010 to present , from bottom to top, New facade , New brick back wall with newly painted fire escape ladder, Metal staircase, Hardwood floor throughout, New electric wiring, New electric Panel, New 4 separate boilers & hot water tanks, Reinforced foundation. Garden duplex unite featuring 2 bedrooms, I full bathroom, and access to beautiful garden, plus large full finished basement with 8 feet high ceiling perfect for entrainment, gym, studio... Second unit featuring 2 large bedrooms could accommodate king-size beds and furniture set, I full bathroom with cozy living room, huge parlor window overlook landscaped garden. The third and fourth floor apartment both are designed into 3 bedrooms, 1 full bathroom, and LR/DR Rental unit filled with nature light. Excellent location close to Restaurants, bars, shops, club, and subway right on corner, convenient to all, this property offers the opportunity to live with great income, own a prime investment property or convert the building into a single home in the heart of Boerum Hill. Don’t miss out, must see it !!!, Additional information: Appearance:Excellent, Interior Features:Lr/Dr
    Presented By: East Coast REALTORS Inc  718-428-6888
    Call Today: or  Email: Judy Fruitbine
Showing 25061 - 25070 of 25497 results| view:  results per page« first|...|2505|2506|2507|2508|...|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 Judys Condos are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.
Judy Fruitbine (516) 298-5382 Judy@JudysCondos.com

Questions? Just Ask!

 Submit

317 Jackson Ave. Syosset, NY 11791

© 2017 Judy’s Condos.com  |  Website & search engine powered by erealtysolution.com
Share
Cell: (516) 298-5382
Contact

JUDY FRUITBINE

Licensed Associate Real Estate Broker

Cell: (516) 298-5382 Email: jfruitbine@aol.com
317 Jackson Ave. Syosset, NY 11791