Loading...
Please wait
516.888.9711
Login
or
|
Register
Sign Up
for additional options
Saved Properties
Saved Searches
My account
Login
or
|
Register
Sign Up
for additional options
Saved Properties
Saved Searches
My account
Home
Search
MLS Search
Luxury Listings
Newest Listings
New Construction
Featured Listings
Our Sold
Explore NY
Explore NYC
Upper East Side
Upper West Side
MidTown
Downtown
Queens
Brooklyn
Explore The North Shore
Great Neck
Kings Point
Old Westbury
Muttontown
Roslyn
Manhasset
Sands Point
Garden City
The Brookville's
Lloyd Harbor
Oyster Bay
Port Washington
Plandome
Dix Hills
Syosset
Huntington
Nissequoge
Head of the Harbor
Belle Terre
Explore The South Shore
Hewlett's
Long Beach
Rockville Centre
Merrick
Bellmore
The Massapequa's
Wantagh
Babylon
Brightwaters
West Islip
Explore the Hamptons
Bridgehampton
East Hampton
Sag Harbor
Sagaponack
Quogue
South Hampton
Watermill
Westhampton
Wainscott
Amagansett
Why Us
About Ron & Mike
Meet the Team
Our Marketing Strategy
LIPropertySearch.com
Our Network
BHHS International
Berkshire Hathaway HomeServices
Market Reports
Buyers
Testimonials
Podcast/Social
Blog
Contact
Newest Listings
show search panel
Select Price:
to
Beds:
Min Beds
1
2
3
4
5
6
7
8
9
10
0
1
2
3
4
5
6
7
8
9
10
Max
Baths:
Min Baths
1
2
3
4
5
6
7
8
9
10
0
1
2
3
4
5
6
7
8
9
10
Max
Sq. Ft.:
Min SqFt
100
200
300
400
500
600
700
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
0
100
200
300
400
500
600
700
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
Max SqFt
ML #
ML #
ML #
ML #
ML #
ML #
ML #
ML #
Property Criteria
Select Type:
All Property Types
Retail
Lots and Land
Business/Property
Commercial
Farm and Agriculture
Apartment
Condo
Single Family
Land
Office
Heavy Industrial
General
Multi Family
Vacant Lot
Warehouse
Light Industrial
Commercial Co-op
Coop
Condo
Business Only
Apt House
Free St Bldg
Indus Bldg
Misc
Shop Center
Small Stores
Store
Office Bldg
In City Lot
Department Store
Apartment
Commercial
Altele
Hotel / Boarding House
Studio Apartment
Recreation Area
penthouse
Factory Area
Office Building
Out of City Lot
Farm
House
Production Area
Industrial
Mixed Use
Investment
LuxuryFull Service
Elevator
Walk-up
Live Work
Legal Accessory Apartment
Apartment in House
Advantage (DHS)
NYCHA Section 8
HPD Section 8
HASA
2-4 Multi-Family
5+ Multi-Family
Farm Estate
Half Duplex
Mobile Home With Land
Mobile Home Without Land
Multiple Residence
Commercial
Residential
1 Family Detached
Townhouse
HOA
Projects
1 Family + Access Apt
2 Family
3 Family
4 Family
Multi-Unit
Mobile Home
Vacation
House
Project
Gas Stations
Gas Station
Homeowner Assoc
Efficiency
Duplex
Triplex
Special
Lease
Zoned Boat Dock
Zoned Residential
Fourplex
Income
Hotel
Timeshare
Unimproved Agri/Recreation/Mobile Home
Villa
Zoned Boat Dock
Zoned Residential
Apartment In Building
Ranch
Property
Seasonal
Restaurant
Building
Studio
Unimproved Land
Stock Cooperative
Dockominium
ResidentialIncome
ResidentialLease
House Rental
Foreclosure
Short Sale
Property Style:
2 Family
2 Story
Antique/Hist
Apartment
Apt In Bldg
Apt In House
Barn
Building
Bungalow
Cape
Colonial
Comm/Ind
Condo
Contemporary
Coop
Co-Op
Cottage
Duplex
Estate
Exp Cape
Exp Ranch
Farm Ranch
Farmhouse
Garden Apt
GardenBuilding
Hi Ranch
HiRise
Homeowner Assoc
House Rental
Houseboat
Land
Mediterranean
Mixed Use
Mobile Home
Modern
Nantucket
Other
Post Modern
Prewar
Raised Ranch
Ranch
Room Rental
Saltbox
Share Condo
SingleFamily
Splanch
Split
Split Ranch
SplitRanch
Store+Dwell
StoreDwell
Studio
Timeshare
Townhouse
Traditional
Tudor
TwoFamily
Victorian
Foreclosure
Short Sale
For Sale or For Lease:
Lease
Sale
School District:
Select
Bronx 11
Brooklyn 13
Brooklyn 14
Brooklyn 17
Brooklyn 18
Brooklyn 19
Brooklyn 22
Brooklyn 23
Brooklyn 32
City of New York
Elmont
Floral Park-Bellerose
Great Neck
Hewlett-Woodmere
Lawrence
Manhattan 6
Queens 24
Queens 25
Queens 26
Queens 27
Queens 28
Queens 29
Queens 30
Amityville
Babylon
Baldwin
Bay Shore
Bay Terrace
Bayport-Blue Point
Bayside H.S.
Bellerose
Bellmore
Bethpage
Brentwood
Bridgehampton
Broaward
Bronx
Canarsie
Cardozo
Carle Place
Center Moriches
Central Islip
Clinton Hill
Cold Spring Harbor
Commack
Comsewogue
Connetquot
Copiague
Dacula
Deer Park
District 25
E.N.Y.
East Hampton
East Islip
East Meadow
East Moriches
East Quogue
East Rockaway
East Williston
Eastport
Elmont
Elwood
Eny
Farmingdale
Fire Island
Floral Park
Floral Park-Bellerose
Floral Parkway
Forest Hills
Franklin Square
Freeport
Garden City
Glen Cove
Great Neck
Greenport
Half Hollow Hills
Hampton Bays
Harborfields
Hauppauge
Hempstead
Herricks
Hewlett-Woodmere
Hicksville
Howard Beach
Huntington
Island Park
Island Trees
Islip
Jamaica
Jamaica Hills
Jericho
Kings Park
Laurel
Laurelton
Lawrence
Levittown
Lindenhurst
Locust Valley
Long Beach
Longwood
Lynbrook
Malverne
Manhasset
Maspeth
Massapequa
Mattituck-Cutchogue
Merrick
Middle Country
Miller Place
Mineola
Montauk
Mount Sinai
N. Babylon
N. Bellmore
N. Merrick
N/A
New Hyde Park
North Hills
North Shore
Northport-East Northport
Nyc Public
Oceanside
Oxford
Oyster Bay-East Norwich
Ozone Pk
Patchogue-Medford
Plainedge
Plainview-Old Bethpage
Port Jefferson
Port Washington
Queens
Queensvillage
Quogue
Remsenberg-Speonk
Richmond Hill
Riverhead
Rockville Centre
Rocky Point
Roosevelt
Rosedale
Roslyn
S. Huntington
S.Ozone Park
Sachem
Sag Harbor
Sayville
Seaford
Shoreham-Wading River
Smithtown
South Country
South Manor
Southampton
Southold
Springfield
Springs
St. Albans
Staten Island
Syosset
Three Village
Tuckahoe
Uniondale
Valley Stream 13
Valley Stream 30
Valley Stream 24
W. Babylon
W. Hempstead
Wantagh
West Islip
Westbury
Westhampton Beach
Whitestone
William Floyd
Wyandanch
27
29
Type Sale
Business
Bus+Office
Inc Prop
Office
Prop+Bus
Property
Store
StoreFnt
Space Use
Audio
Auto
Bar
Beauty/Barber
Church
Deli
Distributor
Drug/Beauty
Fast Food
Florist/Nursery
Gas Station
Health Spa/Gym
Laund/Dry Clean
Liquor Store
Maintenance
Manufacturer
Marine
Misc
Motel/Hotel
Pizza
Recreation
Restaurant
Retail
Retail Food
Routes
Services
Stationary
Video
Wholesale
Rental Type
Select
August
AugustLabor
Flexible
July
July/August
June
Memorial-Labor
Month-Month
OffSeason
1 Year
2 Weeks
2 Year
Weekly
Winter
Features
Adult Community
Basement
Beach Rights
All Cats
Central Air
Cul De Sac
Docking Rights
All Dogs
Eat In Kitchen
Fireplace
Furnished
Garage
Handicapped access
Heat
New Construction
No Restrictions
No Cats
No Dogs
Parking Spaces
Min Parking
1
2
3
4
5
6
7
8
9
10
0
1
2
3
4
5
6
7
8
9
10
Max Parking
Pets
Restricted Weight
Inground Pool
Private Entrance
Smoking
Waterfront
Waterview
Wood Floors
Gas Type
Select
Included
Not Included
Partial
Yes
No
Heating Type
Select
Baseboard
Central Furnace
Electric Air Filter
Forced Air
Heat Pump
Hot Water
Hot Water Radiant Floor
Humidifier
Included
N/A
No
None
Not Included
Other
Partial
Pellet Stove
Radiant Ceiling
Radiant Floor
Radiator
Solar Active
Solar Active Passive
Solar Passive
Space Heater
Steam
Stove
SW Changeover
Unknown
Wall Unit
Yes
Zoned
Display Tools
New to Market:
In Last Day
In Last Week
In Last Month
All
Include:
Photos
Virtual Tours
Open Houses
Sort by:
Price
Location
Date
Order:
Ascending
Descending
Search
4852
properties match your search
;
4614
with
Multiple photos
;
639
with
Virtual Tour
;
43
with
Videos
Save Search
Sort by
Price (High to Low)
Price (Low to High)
Price Reductions
Newest Listings
Open House Date
Number of Photos
Virtual Tours
Showing
311 - 320
of
4852
results
| view:
10
15
20
50
100
results per page
«
first
|
...
|
30
|
31
|
32
|
33
|
...
|
last
»
5
167-03 69th Avenue
Fresh Meadows
,
NY 11365
$1,888,000
3
Bedrooms
2
Full Baths
1
Half Bath
Sq. Ft.
1000.00
:# Square Feet
Single Family
For Sale
ML#
3586123
Very Nice Opportunity To Create Your Generational Home! Existing 40 x 100 Sold With Attached 20 x 100 - Corner Lot! Let The Offers begin!
Presented By:
Keller Williams Realty Greater
516-873-7100
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
29
154-70 11 Avenue
Whitestone
,
NY 11357
$1,880,000
4
Bedrooms
4
Full Baths
Sq. Ft.
2800.00
:# Square Feet
Single Family
For Sale
NEW
OPEN HOUSE
ML#
3591300
Beechhurst 50X100 Corner Lot, Oversized 2800 sqft. Brick Center Hall Colonial with 1988 Certificate of Occupancy. Renovated in 2019. High Ground Elevation 46 ft. Livable Sqft 2800. Boats 4 bedrooms, 4 Full baths. Entertaining Room. Enclosed Balcony and Porch. Open Floor Plan, Grand Foyer. Eat-in Kitchen With Granite Counter Tops & Custom Built Wood Cabinetry, High-End Stainsteel Appliances, Thermador Stove & Dishwasher, Family Room, Formal Dining Rm, Large living Room, Master EnSuite, Hardwood & Porcelain Tiles Throughout.Attached Garage. Quiet yet Convenient to all. All Information Is Deemed Reliable But Is Not Guaranteed. Buyer Is Advised To Verify The Accuracy Of All Information Independently.
Presented By:
Century Homes Realty Group LLC
718-886-6800
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
11/16/2024 - 11/16/2024
2:00PM - 4:00PM
Virtual Open House
Call To Schedule
16
42-15 165th Street
Flushing
,
NY 11358
$1,880,000
8
Bedrooms
6
Full Baths
Multi Family
For Sale
NEW
ML#
3589478
Presented By:
E Realty International Corp
718-886-8110
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
12
151-07 17th Avenue
Whitestone
,
NY 11357
$1,880,000
6
Bedrooms
4
Full Baths
Sq. Ft.
2310.00
:# Square Feet
Multi Family
For Sale
NEW
ML#
3589407
Young 2 families brick house in the heart of Whitestone. located in the quite residential street, There are two 3 bedrooms with 2 full baths units, high ceiling in the basement, walk out to backyard. central air system, hard wood floors, granite countertops. close school , could be 2-3 parking spaces on the driveway. will be delivered vacant. buyers should verify all information independently.
Presented By:
Sany Realty Group LLC
718-799-0726
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
31
243 150th Street
Whitestone
,
NY 11357
$1,880,000
4
Bedrooms
3
Full Baths
1
Half Bath
Single Family
For Sale
NEW
ML#
3588776
Welcome to this stunning, custom-built, two-story brick residence in the heart of Whitestone, meticulously renovated with top-tier imported finishes and premium appliances, including Miele, Bertazzoni, and Viking. The home radiates elegance and modern sophistication, starting with a grand foyer and custom walnut flooring that set a luxurious tone from the moment you enter. The upper level boasts four spacious bedrooms and two bathrooms, including a master suite complete with a walk-in closet. The expansive, high-ceilinged living room is both beautiful and functional, offering a welcoming and refined space for relaxation and gatherings. On the lower level, the open-concept kitchen combines elegance with functionality, featuring radiant heated floors, a large granite island, a premium appliance suite, and custom cabinetry. Adjacent to the kitchen, the cozy family room opens seamlessly to the tranquil patio and backyard through glass doors, perfect for effortless indoor-outdoor living. The spacious walk-out lower level offers abundant closet and storage space with additional access to the backyard. The versatile unfinished basement can be customized to suit the buyer’s preferred use. Outdoor spaces are thoughtfully designed for entertaining, and the home includes central air and an attached two-car garage. Every detail has been thoughtfully crafted, with custom walnut flooring throughout and bathrooms enhanced by walnut cabinetry, adding a refined, cohesive aesthetic. A beautiful staircase with imported walnut steps leads to the upper level, where you’ll find four spacious bedrooms and two bathrooms, including a luxurious master suite complete with a walk-in closet. The expansive, high-ceilinged living room is designed to offer both beauty and functionality, creating an inviting space for relaxation and gatherings. Conveniently located near Francis Lewis Park and just minutes from major highways and bridges, this exceptional home blends timeless elegance with modern convenience, creating an unparalleled living experience.
Presented By:
Tru International Realty Corp
929-608-9600
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
22
86-34 Grand Avenue
Elmhurst
,
NY 11373
$1,880,000
6
Bedrooms
3
Full Baths
2
Half Baths
Sq. Ft.
2500.00
:# Square Feet
Multi Family
For Sale
ML#
3588011
Location, location, and location!!!! 3 Story 2 family house on Grand Ave. Close to subway and bus station off Queens Blvd. The kitchens and baths are all recently updated. Two car attached garage at rear.
Presented By:
Karten Real Estate Svcs LLC
929-605-5545
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
25
42-74 149th Street
Flushing
,
NY 11355
$1,880,000
7
Bedrooms
2
Full Baths
Sq. Ft.
3067.00
:# Square Feet
Multi Family
For Sale
ML#
3587100
Welcome to this exceptional income-producing two-family property, perfectly nestled between Beech and Cherry Avenues on 149th Street in the heart of Murray Hill, Flushing. Whether you’re an investor or looking for multi-generational living, this home offers a prime opportunity in a highly sought-after neighborhood. With schools, shops, and restaurants just around the corner, you’ll also appreciate the convenience of Flushing Hospital just four blocks away. Commuting is a breeze with the Murray Hill LIRR station a mere five blocks from your doorstep, whisking you into Manhattan and throughout NYC and Long Island in no time. Set in a vibrant community, this property combines functionality with charm, providing spacious layouts in both units. A fantastic investment that offers comfort and convenience. Don’t miss out on owning a piece of one of Flushing’s best-kept secrets-schedule a viewing today and discover why this home is truly a cut above the rest. Potential income is worthwhile for any investor or end user.
Presented By:
Compass Greater NY LLC
646-404-1578
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
24
28-12 Astoria Boulevard
Astoria
,
NY 11102
$1,877,000
8
Bedrooms
3
Full Baths
3
Half Baths
Multi Family
For Sale
NEW
ML#
3589954
Discover this versatile three-family brick home perfectly situated just two blocks from the subway, with R6A, C1-3 zoning that allows for future expansion! The property includes an attached one-car garage and a full finished basement with direct access to the backyard - a rare find in a prime Astoria location. The top-floor unit features hardwood floors throughout, three bedrooms, 1.5 bathrooms, a spacious living room, and an eat-in kitchen, offering ample space and comfort. On the second floor, you’ll find another three-bedroom, 1.5-bathroom unit with hardwood floors throughout, a large living room that opens to a front balcony, perfect for morning coffee or evening relaxation. This level also includes an eat-in kitchen and a bedroom with private stairway access to the backyard. The first-floor apartment is a two-bedroom unit with a spacious living room, open layout kitchen and hardwood floors throughout. With expansion potential and proximity to everything Astoria has to offer, this property is an ideal investment or a wonderful place to call home.
Presented By:
Blue Brick Real Estate
718-614-8349
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
33
8433 60 Drive
Middle Village
,
NY 11379
$1,873,000
9
Bedrooms
5
Full Baths
Multi Family
For Sale
NEW
ML#
3589720
2005 Built two family building with an excellent layout. Total of 4 levels, there is a full basement walk-in, first floor is a legal 4 bedroom apartment, 2 full bathrooms, a living room, dining room and kitchen. Second floor is duplex with the third floor and has a beautiful high vaulted ceiling and balcony with a total of 5 bedrooms, 3 bathrooms and two full living rooms. Low taxes, private driveway, backyard and two car garage. Conveniently located within minutes to Q38, Q29, Q11, Q21, E, M, R Trains and the I-495 and Queens Blvd.
Presented By:
Compass Greater NY LLC
646-662-8888
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
32
22 Elliot Rd
Great Neck
,
NY 11021
$1,870,000
4
Bedrooms
3
Full Baths
1
Half Bath
Sq. Ft.
3172.00
:# Square Feet
Single Family
For Sale
ML#
3586716
Introducing this elegant brick home, boasting 4 spacious bedrooms and 3.5 baths. The property seamlessly blends timeless architectural charm with modern amenities. Its open-concept design connects the den, living, and dining areas, complete with a cozy fireplace and a built-in library. The large eat-in kitchen leads out to a delightful backyard porch, perfect for outdoor relaxation. The first floor showcases brand-new hardwood flooring throughout, a convenient bedroom, a full bathroom, and a powder room. On the second floor, the expansive primary suite features two walk-in closets and a newly renovated en-suite bath, complemented by two additional bedrooms with ample closet space and a shared full bath. The finished basement offers exceptional versatility with an additional bonus room, a home office, a laundry room, ample storage, and a boiler room. The property also includes a generator powered by gas, a long driveway, and a one-car garage, providing both convenience and privacy. This home is a perfect blend of comfort, functionality, and classic appeal, ideal for modern living.
Presented By:
Douglas Elliman Real Estate
516-205-2279
Save Listing
CONTACT
Email to a friend
Details
Call Today:
516.888.9711, or
Email:
The Pesce & Lanzillotta Team
Temporary Off Market
Upcoming Open House
View Location
Showing
311 - 320
of
4852
results
| view:
10
15
20
50
100
results per page
«
first
|
...
|
30
|
31
|
32
|
33
|
...
|
last
»
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
Please check I'm not a robot
Submit
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