Newest Listings

to
 
 
 
Property Criteria
Features
  •  
Display Tools
Search

    4678  properties match your search;

    4448 with Multiple photos ;  613 with Virtual Tour ;  43 with Videos

    Save Search
    Showing 281 - 290 of 4678 results| view:  results per page« first|...|27|28|29|30|...|last »
    • Stunning 7-Bedroom Home with Abundant Space and Modern Amenities. Welcome to your dream home! This expansive residence boasts 7 spacious bedrooms and 4.5 bathrooms, offering plenty of room for your family and guests. An additional bedroom in the finished basement provides extra flexibility for your needs, while the convenient laundry room ensures household tasks are a breeze. Main Floor Highlights: Step inside to find a welcoming entry room that doubles as a mudroom, leading into a versatile office space. The living room, bathed in natural light, seamlessly connects to the dining room, making it perfect for entertaining. The dining area opens up to the kitchen, which is a chef’s delight, featuring two ovens, dual sinks, and a dishwasher. An adjoining large living room provides a cozy seating area for gatherings and relaxation. Second Floor: Ascend to the second floor, where you’ll discover four generously-sized bedrooms with large walk-in closets for ample storage. A family room on this level offers additional space that can easily be converted into an additional bedroom if desired. Two full bathrooms ensure that everyone has their own space. Third Floor Retreat: The top floor features two more bedrooms and a full bathroom, ideal for guests or older children seeking privacy. Additional Features: The finished basement not only houses an extra bedroom but also a dedicated laundry room, enhancing the home’s functionality. With its expansive layout and thoughtfully designed spaces, this home is perfect for growing families or those who love to entertain. Don’t miss your chance to own this incredible property that blends comfort, style, and versatility. Schedule a showing today and imagine the memories you’ll create in this beautiful home! Please use link for Virtual Tour https://my.matterport.com/show/?m=w3WoEfxCezc&brand=0&mls=1& 33
      122-05 Metropolitan Avenue Kew Gardens, NY 11415
      $1,899,999
      7 Bedrooms 4 Full Baths 1 Half Bath
      Single Family For Sale ML# 3588257
      Stunning 7-Bedroom Home with Abundant Space and Modern Amenities. Welcome to your dream home! This expansive residence boasts 7 spacious bedrooms and 4.5 bathrooms, offering plenty of room for your family and guests. An additional bedroom in the finished basement provides extra flexibility for your needs, while the convenient laundry room ensures household tasks are a breeze. Main Floor Highlights: Step inside to find a welcoming entry room that doubles as a mudroom, leading into a versatile office space. The living room, bathed in natural light, seamlessly connects to the dining room, making it perfect for entertaining. The dining area opens up to the kitchen, which is a chef’s delight, featuring two ovens, dual sinks, and a dishwasher. An adjoining large living room provides a cozy seating area for gatherings and relaxation. Second Floor: Ascend to the second floor, where you’ll discover four generously-sized bedrooms with large walk-in closets for ample storage. A family room on this level offers additional space that can easily be converted into an additional bedroom if desired. Two full bathrooms ensure that everyone has their own space. Third Floor Retreat: The top floor features two more bedrooms and a full bathroom, ideal for guests or older children seeking privacy. Additional Features: The finished basement not only houses an extra bedroom but also a dedicated laundry room, enhancing the home’s functionality. With its expansive layout and thoughtfully designed spaces, this home is perfect for growing families or those who love to entertain. Don’t miss your chance to own this incredible property that blends comfort, style, and versatility. Schedule a showing today and imagine the memories you’ll create in this beautiful home! Please use link for Virtual Tour https://my.matterport.com/show/?m=w3WoEfxCezc&brand=0&mls=1&
      Presented By: Astor Brokerage Ltd  718-263-4500
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Welcome to this stunning, renovated home in one of the most desirable sections of Rockville Centre. Nestled on a quiet block adorned w/decorative street lamps, this property offers elegance with modern luxury. Greeted by a grand entry foyer inviting you into a home designed for both comfort and style. A generously-sized formal dining room and spacious living room featuring gas fireplace, built-ins and custom window treatments. French doors lead you to a family room with a stone, wood-burning fireplace, seamlessly opening to a gourmet eat-in kitchen that boasts stainless steel appliances, double oven, oversized fridge, quartz countertops, large island w/breakfast area and sliding glass doors leading to the private backyard. Enjoy the convenience of a touch faucet w/filtered drinking water, under-cabinet lighting, and pantry. Perfect for entertaining, the home features a dinner party flow, wide wraparound staircase and beautiful hardwood floors throughout. The main level includes a powder room, laundry room w/additional backyard access and a bedroom currently set up as an office. Second floor hosts four spacious bedrooms, including a master suite w/sitting area, expansive walk-in closet (WIC) and luxurious ensuite bath featuring oversized stand-up shower, soaker tub, double sinks and radiant heat. The master suite also offers a huge bonus room, perfect for a glam room, gym, or additional WIC. Three additional bedrooms feature generous storage w/large WICs, complemented by an updated full bathroom. A full basement w/a high ceiling provides endless possibilities, while a Sonos sound system enhances entertainment on the 1st floor and outdoor space. This home boasts an abundance of storage complete w/a two-car, oversized garage offering direct home access. Situated close to the Rockville Links Golf Club, this property personifies upscale living, blending privacy and luxury. 36
      30 Columbia Rd Rockville Centre, NY 11570
      $1,899,000
      5 Bedrooms 2 Full Baths 1 Half Bath Sq. Ft. 3500.00:# Square Feet
      Single Family For Sale NEWOPEN HOUSE ML# 3591135
      Welcome to this stunning, renovated home in one of the most desirable sections of Rockville Centre. Nestled on a quiet block adorned w/decorative street lamps, this property offers elegance with modern luxury. Greeted by a grand entry foyer inviting you into a home designed for both comfort and style. A generously-sized formal dining room and spacious living room featuring gas fireplace, built-ins and custom window treatments. French doors lead you to a family room with a stone, wood-burning fireplace, seamlessly opening to a gourmet eat-in kitchen that boasts stainless steel appliances, double oven, oversized fridge, quartz countertops, large island w/breakfast area and sliding glass doors leading to the private backyard. Enjoy the convenience of a touch faucet w/filtered drinking water, under-cabinet lighting, and pantry. Perfect for entertaining, the home features a dinner party flow, wide wraparound staircase and beautiful hardwood floors throughout. The main level includes a powder room, laundry room w/additional backyard access and a bedroom currently set up as an office. Second floor hosts four spacious bedrooms, including a master suite w/sitting area, expansive walk-in closet (WIC) and luxurious ensuite bath featuring oversized stand-up shower, soaker tub, double sinks and radiant heat. The master suite also offers a huge bonus room, perfect for a glam room, gym, or additional WIC. Three additional bedrooms feature generous storage w/large WICs, complemented by an updated full bathroom. A full basement w/a high ceiling provides endless possibilities, while a Sonos sound system enhances entertainment on the 1st floor and outdoor space. This home boasts an abundance of storage complete w/a two-car, oversized garage offering direct home access. Situated close to the Rockville Links Golf Club, this property personifies upscale living, blending privacy and luxury.
      Presented By: Douglas Elliman Real Estate  516-669-3700
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
      Upcoming Open House View Location
      11/17/2024 - 11/17/2024 2:00PM - 3:30PM
    • ParkingFeatures: On Street, 28
      640 237th Street Unit 15C New York, 10463
      $1,899,000
      3 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 1996.00:# Square Feet
      Condo For Sale NEW ML# H6331520
      ParkingFeatures: On Street,
      Presented By: Brown Harris Stevens  718-878-1700
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Fully detached free-standing home for families or investors with multiple levels of living space. Six-bedroom, three-bathroom home. 25’ × 100’ lot, offers a shared driveway that leads to a two-car garage. Third floor, has three bedrooms, oversized windows. Living room, dining room that connect through an eat in kitchen. Second floor, has an open-concept living and dining area and eat-in kitchen. Two comfortable bedrooms on this level. The first level is a renovated mother-daughter suite. Open-concept kitchen, living, and dining area, plus ample storage. A legal two-family home with a mother-daughter suite on the lower floor; it’s three stories of possibilities. Whether you’re looking for rental income, space for extended family, or room to grow. Virtual photo and video staging are used to illustrate furniture placement possibilities. The house is currently unfurnished. 20
      1174 Bay Ridge Parkway Bay Ridge, NY 11228
      $1,899,000
      6 Bedrooms 3 Full Baths Sq. Ft. 3120.00:# Square Feet
      Multi Family For Sale NEW ML# H6335850
      Fully detached free-standing home for families or investors with multiple levels of living space. Six-bedroom, three-bathroom home. 25’ × 100’ lot, offers a shared driveway that leads to a two-car garage. Third floor, has three bedrooms, oversized windows. Living room, dining room that connect through an eat in kitchen. Second floor, has an open-concept living and dining area and eat-in kitchen. Two comfortable bedrooms on this level. The first level is a renovated mother-daughter suite. Open-concept kitchen, living, and dining area, plus ample storage. A legal two-family home with a mother-daughter suite on the lower floor; it’s three stories of possibilities. Whether you’re looking for rental income, space for extended family, or room to grow. Virtual photo and video staging are used to illustrate furniture placement possibilities. The house is currently unfurnished.
      Presented By: Keller Williams NYC  212-301-1140
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Blue Island Homes is proud to present this well-maintained 3-family property, located on a charming, sunlit block in the heart of Astoria. This multi-unit residence offers an ideal blend of spacious layouts, recent upgrades, and separate utilities, making it a smart investment choice in one of Queens’ most desirable communities. The First Floor features a 3-bedroom apartment complete with a bright living room, fully equipped kitchen, and a recently renovated bathroom, all designed for comfortable living. The Second Floor has 3-bedrooms offering a similar layout with a generous kitchen and a beautifully updated bathroom, perfect for families or roommates. The Third Floor is a 2-bedroom apartment that includes an eat-in kitchen with stainless steel appliances, a large living room with new luxury vinyl flooring, and a bathroom equipped with a tub and shower. Modern conveniences include two split HVAC systems for customized heating and cooling. Nestled in a thriving community, this property enjoys close proximity to popular dining, entertainment, and transit options, making it an attractive option for tenants. This multi-family residence is a rare find in Astoria, presenting endless potential for investors or multi-generational living. 32
      23-37 33rd Avenue Astoria, NY 11106
      $1,899,000
      8 Bedrooms 3 Full Baths
      Multi Family For Sale NEW ML# 3589432
      Blue Island Homes is proud to present this well-maintained 3-family property, located on a charming, sunlit block in the heart of Astoria. This multi-unit residence offers an ideal blend of spacious layouts, recent upgrades, and separate utilities, making it a smart investment choice in one of Queens’ most desirable communities. The First Floor features a 3-bedroom apartment complete with a bright living room, fully equipped kitchen, and a recently renovated bathroom, all designed for comfortable living. The Second Floor has 3-bedrooms offering a similar layout with a generous kitchen and a beautifully updated bathroom, perfect for families or roommates. The Third Floor is a 2-bedroom apartment that includes an eat-in kitchen with stainless steel appliances, a large living room with new luxury vinyl flooring, and a bathroom equipped with a tub and shower. Modern conveniences include two split HVAC systems for customized heating and cooling. Nestled in a thriving community, this property enjoys close proximity to popular dining, entertainment, and transit options, making it an attractive option for tenants. This multi-family residence is a rare find in Astoria, presenting endless potential for investors or multi-generational living.
      Presented By: Blue Island Homes NY LLC  516-613-3600
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Situated on a beautiful street in Northern New Rochelle, this Stunning Colonial incorporates the perfect space for family gatherings, modern living and entertaining. Upon entering, the spacious foyer brings you to an expansive kitchen/great room which is the natural heart of the home. Surrounded by glass, this incredible space features a separate eating area. lounging area, a fireplace, an oversized granite island, two sinks, two dishwashers, loads of cabinets and a desk, sliding glass doors to a huge patio and park-like backyard. A formal living room, dining room, powder room, laundry room and two car garage complete this level. A few steps up brings you to an enormous family room with high ceilings - another perfect spot for get togethers with loved ones and friends. The upper level is comprised of a primary bedroom with lots of closets, a primary bathroom, four additional bedrooms, two hall bathrooms and a television room. Additionally, there is a finished playroom in the basement, which is included in square footage. Additional Information: ParkingFeatures:2 Car Attached, 27
      25 Harlan Drive New Rochelle, 10804
      $1,899,000
      5 Bedrooms 3 Full Baths 1 Half Bath Sq. Ft. 4106.00:# Square Feet
      Single Family For Sale ML# H6332003
      Situated on a beautiful street in Northern New Rochelle, this Stunning Colonial incorporates the perfect space for family gatherings, modern living and entertaining. Upon entering, the spacious foyer brings you to an expansive kitchen/great room which is the natural heart of the home. Surrounded by glass, this incredible space features a separate eating area. lounging area, a fireplace, an oversized granite island, two sinks, two dishwashers, loads of cabinets and a desk, sliding glass doors to a huge patio and park-like backyard. A formal living room, dining room, powder room, laundry room and two car garage complete this level. A few steps up brings you to an enormous family room with high ceilings - another perfect spot for get togethers with loved ones and friends. The upper level is comprised of a primary bedroom with lots of closets, a primary bathroom, four additional bedrooms, two hall bathrooms and a television room. Additionally, there is a finished playroom in the basement, which is included in square footage. Additional Information: ParkingFeatures:2 Car Attached,
      Presented By: Houlihan Lawrence Inc.  914-723-8877
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • This mixed-use property features a street -level commercial space, ideal for small retail store, cafe’ or office. The store front has large windows providing excellent visibility and natural light. Above the shop there is a large 3-bedroom apartment equipped with a living room, dining room, eat in kitchen and rooftop patio. Lower-level features four studio apartments, each with a compact kitchenette and bathroom, the units have potential but require updates, overring an opportunity to customize and renovate. The building is being sold as is , which means it may need repairs or modernization. It’s a great investment prospect for someone looking to operate a business and earn rental income. 18
      24-01 23rd Avenue Astoria, NY 11105
      $1,899,000
      3 Bedrooms 5 Full Baths 1 Half Bath Sq. Ft. 2160.00:# Square Feet
      Multi Family For Sale ML# 3586094
      This mixed-use property features a street -level commercial space, ideal for small retail store, cafe’ or office. The store front has large windows providing excellent visibility and natural light. Above the shop there is a large 3-bedroom apartment equipped with a living room, dining room, eat in kitchen and rooftop patio. Lower-level features four studio apartments, each with a compact kitchenette and bathroom, the units have potential but require updates, overring an opportunity to customize and renovate. The building is being sold as is , which means it may need repairs or modernization. It’s a great investment prospect for someone looking to operate a business and earn rental income.
      Presented By: Daniel Gale Sothebys Intl Rlty  718-650-5855
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • 6 Family Building for Sale in PRIME Astoria/LIC Location! Superbly maintained building offering investors an income generating opportunity without upfront renovation costs. Located in the heart of Astoria, just off the ever-popular Broadway and steps to the train, this multi-family building sees continuous tenant demand! SET-UP ***First floor: (2) 1 Bedroom Apartments ***Second floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Third floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Basement: Full, unfinished ***Semi-Detached, Brick - Beds: 8 Baths: 6 Rooms: 20 Sqft: 2, 067 ***Annual Income: $131, 064 ***Annual Expenses: $38, 579 ***Net Operating Income: $ $92, 485 ***Lot Size: 20.67x100 ***Bldg Size: 20.75x85 ***Taxes: $21329 ***Zoning: R5 TRANSPORTATION & LOCATION: Conveniently located just a 5-minute walk from the N/W subway station, providing quick access to Manhattan in under 20 minutes. With Citibike stations and multiple bus lines nearby, residents enjoy numerous transportation options. This prime Astoria spot is surrounded by popular dining, shopping, and entertainment options and is a high demand area for renters. ***TURN-KEY INCOME*** Ready for immediate income generation with easy to rent units. All units in great condition with some recent updates meeting modern tenant requirements. *HIGH RENTAL DEMAND* Astoria is known for its booming rental market and sees consistent tenant demand driven by all of the conveniences, cultural appeal and convenient transit/proximity to Manhattan. 22
      34-35 30th Street Astoria, NY 11106
      $1,898,000
      8 Bedrooms 6 Full Baths Sq. Ft. 5200.00:# Square Feet
      Multi Family For Sale NEW ML# 3590466
      6 Family Building for Sale in PRIME Astoria/LIC Location! Superbly maintained building offering investors an income generating opportunity without upfront renovation costs. Located in the heart of Astoria, just off the ever-popular Broadway and steps to the train, this multi-family building sees continuous tenant demand! SET-UP ***First floor: (2) 1 Bedroom Apartments ***Second floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Third floor: (1) 1-Bedroom Apartment (1) 2-Bedroom Apartment ***Basement: Full, unfinished ***Semi-Detached, Brick - Beds: 8 Baths: 6 Rooms: 20 Sqft: 2, 067 ***Annual Income: $131, 064 ***Annual Expenses: $38, 579 ***Net Operating Income: $ $92, 485 ***Lot Size: 20.67x100 ***Bldg Size: 20.75x85 ***Taxes: $21329 ***Zoning: R5 TRANSPORTATION & LOCATION: Conveniently located just a 5-minute walk from the N/W subway station, providing quick access to Manhattan in under 20 minutes. With Citibike stations and multiple bus lines nearby, residents enjoy numerous transportation options. This prime Astoria spot is surrounded by popular dining, shopping, and entertainment options and is a high demand area for renters. ***TURN-KEY INCOME*** Ready for immediate income generation with easy to rent units. All units in great condition with some recent updates meeting modern tenant requirements. *HIGH RENTAL DEMAND* Astoria is known for its booming rental market and sees consistent tenant demand driven by all of the conveniences, cultural appeal and convenient transit/proximity to Manhattan.
      Presented By: Realty Executives Today  718-274-2400
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • NEW CONSTRUCTION Spacious and Stylish, in a private Beach community. This thoughtfully designed plan, features 5 beds, 4.5 bath. Two en-suite primary bedrooms. 9ft ceilings thru out. Designer kitchen with island. Second floor has an additional bonus space. Large walkout basement with 9 ft ceilings.Heated pool and outdoor showing add to the North Fork experience.Close to winery’s, shopping and transportation. Additional Information: ParkingFeatures:1 Car Attached, 3
      1855 Greenway East Southold, 11957
      $1,895,000
      5 Bedrooms 4 Full Baths 1 Half Bath Sq. Ft. 2950.00:# Square Feet
      Single Family For Sale NEW ML# H6335251
      NEW CONSTRUCTION Spacious and Stylish, in a private Beach community. This thoughtfully designed plan, features 5 beds, 4.5 bath. Two en-suite primary bedrooms. 9ft ceilings thru out. Designer kitchen with island. Second floor has an additional bonus space. Large walkout basement with 9 ft ceilings.Heated pool and outdoor showing add to the North Fork experience.Close to winery’s, shopping and transportation. Additional Information: ParkingFeatures:1 Car Attached,
      Presented By: Corcoran Baer & McIntosh  845-358-9440
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    • Experience the epitome of Hudson River living in this stunning 3-bedroom condominium at the prestigious River House at Hudson Harbor. This spacious residence, spanning over 1, 864 square feet, offers breathtaking views of the majestic Hudson River and the village of Tarrytown, creating a serene backdrop for your daily life. The property boasts open concept living, a bathroom for each bedroom, motorized shades and custom-upgraded closets, providing ample storage and organization solutions. Convenience is key with two dedicated garage spaces, complete with electric car charging stations for eco-friendly living. Residents enjoy access to a luxurious amenity building featuring a state-of-the-art fitness center, a lap swimming pool, and a private outdoor community terrace with cozy fire pits - perfect for relaxation and socializing. This prime location offers the best of both worlds: minutes away from the Tarrytown Metro-North station for easy commutes to New York City, walking distance to the charming Village of Tarrytown, the new Edge on Hudson shops featuring DeCicco’s market opening soon, and direct access to the scenic Hudson RiverWalk Park. This meticulously designed condo presents a rare opportunity to own a slice of riverfront paradise in the sought-after Hudson Harbor community, combining modern elegance with unparalleled convenience in one of Westchester’s most desirable locations. 28
      11 River Street Unit 401 Mount Pleasant, NY 10591
      $1,895,000
      3 Bedrooms 3 Full Baths Sq. Ft. 1864.00:# Square Feet
      Condo For Sale NEW ML# H6335017
      Experience the epitome of Hudson River living in this stunning 3-bedroom condominium at the prestigious River House at Hudson Harbor. This spacious residence, spanning over 1, 864 square feet, offers breathtaking views of the majestic Hudson River and the village of Tarrytown, creating a serene backdrop for your daily life. The property boasts open concept living, a bathroom for each bedroom, motorized shades and custom-upgraded closets, providing ample storage and organization solutions. Convenience is key with two dedicated garage spaces, complete with electric car charging stations for eco-friendly living. Residents enjoy access to a luxurious amenity building featuring a state-of-the-art fitness center, a lap swimming pool, and a private outdoor community terrace with cozy fire pits - perfect for relaxation and socializing. This prime location offers the best of both worlds: minutes away from the Tarrytown Metro-North station for easy commutes to New York City, walking distance to the charming Village of Tarrytown, the new Edge on Hudson shops featuring DeCicco’s market opening soon, and direct access to the scenic Hudson RiverWalk Park. This meticulously designed condo presents a rare opportunity to own a slice of riverfront paradise in the sought-after Hudson Harbor community, combining modern elegance with unparalleled convenience in one of Westchester’s most desirable locations.
      Presented By: Christie’s Int. Real Estate  914-355-1137
      Call Today: 516.888.9711, or  Email: The Pesce & Lanzillotta Team
    Showing 281 - 290 of 4678 results| view:  results per page« first|...|27|28|29|30|...|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 Douglas Elliman - Pesce Lanzillotta Group are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.
    The Pesce & Lanzillotta Group C:  516.888.9711 E:  info@pl-team.com

    Contact Us

     Submit

    Offices in NYC, Long Island, & The Hamptons
    516.888.9711

    NY Fair Housing Notice
    NY Reasonable Accomodations Notice for Prospective Tenants
    DMCA Notice   |   Login
    powered by www.erealtymedia.com
    Share
    O: 516.888.9711
    Contact

    The Pesce & Lanzillotta Group

    Office: 516.888.9711 Email: info@pl-team.com
    8223 Jericho Turnpike, Woodbury, NY 11797