The Liappas Team's Profile Photo

The Liappas Team

The Liappas Team at Compass
liappasteam@compass.com
M: 516-319-3274
O: 516-517-4751
About The Liappas Team
A home is made of hopes and dreams. Let us help you make your dreams come true!

The Liappas Team, led by award-winning agent Connie Liappas, boasts decades of sales success, innovative marketing campaigns, and world-class experience, distinguishing The Liappas Team as one of the leading real estate teams on Long Island. Serving the Queens market and the entire North Shore area from Great Neck and Manhasset to Cutchogue and Southold. The team brings exceptional service and a collection of varied talents to each and every transaction.

Fluent in English and Greek, the team guarantees that their clientele are never at a loss for experienced and supportive service. Whether a developer, investor, buyer or seller, Connie and her team have the resources and expertise to close a deal with skill, efficiency, and class…because our expectations are as high as yours.

With a shared passion for innovative solutions and uncompromising effort on behalf of our clients, we bring an extraordinary customer experience and unparalleled results. We’ve set new professional heights to Long Island real estate transactions. Each member of our team is hand-picked to provide a mix of experience, industry knowledge, and professional finesse to all of our clients’ endeavors. By blending each member’s personal strengths and combining our disparate experiences the team ensures that every matter is addressed promptly and to our clients’ ultimate satisfaction. The diligent, positive, and enthusiastic agents on the team have one objective in mind: to streamline the real estate process from your first visit to your happy closing day, for an ultimate customer experience.

Team Agents

The Liappas Team’s Listings

$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,755,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
1/32
Listed By CompassVirtual Tour

$5,755,000

6
Bedrooms
5,600
Square Feet
1.68
Acres

3360 Wunneweta Road, Cutchogue, NY 11935

a city street lined with parked cars and buildings
a view of a street with cars
a view of a cars parked in front of a building
1/3
Listed By CompassContract Out

$4,400,000

Unavailable
Bedrooms
Unavailable
Bathrooms
Unavailable
Square Feet
Unavailable
Acres

4010 Crescent Street

Long Island City

a front view of a house with a garden
a view of entryway and hall with wooden floor
wooden floor in an empty room with a window
a view of a kitchen with white cabinets and a refrigerator
a view of kitchen with stainless steel appliances granite countertop cabinets and wooden floor
a kitchen with a sink stove and window
a kitchen with stainless steel appliances granite countertop a stove and a sink
a bedroom with a bed and a window
a bathroom with a sink and mirror
a bathroom with a sink a toilet and shower
a view of staircase with wooden floor and staircase
a very nice looking room with a fireplace
a view of a hallway with wooden floor and staircase
a bathroom with a shower
a bathroom with a sink and a mirror
a bathroom with a shower
a white bath tub sitting next to a window
a view of walk in closet with empty racks
a bathroom with a sink a toilet and shower
wooden floor in an empty room with a window
a bathroom with a toilet a sink and mirror
an empty room with windows
a bathroom with a sink and a washer
a view of a hallway with wooden floor and staircase
a view of a big room with wooden floor and natural light
a view of empty room with wooden floor
a view of a house with a yard
a view of a building with a yard
a picture of a floor plan
a picture of a small refrigerator
$3,199,000 | 150 Milburn Lane, East Hills, NY 11577
1/31
Listed By CompassPending

$3,199,000

5
Bedrooms
4,350
Square Feet
0.27
Acres

150 Milburn Lane, East Hills, NY 11577

a view of a green field
a view of a bunch of trees and bushes
an aerial view of a house with beach and ocean view
a house with garden view
a view of a house with a yard
a front view of a house with a yard and green space
an aerial view of a house with a garden
an aerial view of a house with a yard
a view of a city with lush green forest
a view of a garden with a building in the background
a view of a big house with a big yard and large trees
a view of a big building with a big yard
a view of a garden with a lake view
an aerial view of a house with garden
a view of a city with green space
a view of a city
a bathroom with a glass door shower
a living room with furniture and a floor to ceiling window
a living room with furniture and a fireplace
a living room with furniture a fireplace and a floor to ceiling window
a living room with furniture and a floor to ceiling window
a view of a dining room with furniture window and wooden floor
a kitchen with stainless steel appliances granite countertop a stove a sink dishwasher a dining table and chairs with wooden floor
a kitchen with white cabinets and a stove
a kitchen with stainless steel appliances granite countertop a stove a sink and a microwave
a bedroom with double bed and a window
a bedroom with a bed and a dresser
a bedroom with a bed and a window
a bedroom with a bed and wooden floor
a view of swimming pool with lawn chairs plants and large tree
a view of a house with backyard sitting area and garden
a front view of a house with garden
a view of a yard with a house in back
a view of a big garden with plants and large trees
a view of a green field with clear sky
a view of outdoor space and ocean view
a view of a lake and mountain view
a view of ocean
a view of an ocean from a building
a view of a terrace
a view of a roof deck with wooden floor and fence
a view of an ocean
an aerial view of a house with garden space and street view
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
1/45
Listed By Compass

$2,799,000

4
Bedrooms
1,595
Square Feet
0.73
Acres

2100 Sound Drive, Greenport, NY 11944

a front view of a house with a yard
a view of a house with a small yard and a large tree
a view of entryway livingroom and hall with wooden floor
a living room with furniture and wooden floor
a dining room with furniture window and wooden floor
a living room with furniture and a potted plant
a kitchen with stainless steel appliances granite countertop a stove top oven a sink and a refrigerator
a kitchen with stainless steel appliances granite countertop a stove top oven a sink dishwasher a dining table and chairs with wooden floor
a living room with furniture and a flat screen tv
a living room with furniture and a large window
a bedroom with furniture and a large window
a view of a workspace with furniture and a window
a bathroom with a tub a sink shower and mirror
a bedroom with a bed and a large window
a bathroom with a granite countertop sink toilet and shower
a spacious bedroom with a bed and a window
a spacious bathroom with a double vanity sink mirror and double
a bathroom with a shower
a view of a room with gym equipment
a view of a house with patio
a view of a house with wooden floor
a front view of a house with a yard
a view of a patio with table and chairs and potted plants
a picture of a room
unknown
$2,340,000 | 74 Woods Drive, East Hills, NY 11576
$2,340,000 | 74 Woods Drive, East Hills, NY 11576
1/27
Listed By CompassPending

$2,340,000

5
Bedrooms
4,466
Square Feet
0.34
Acres

74 Woods Drive, East Hills, NY 11576

a front view of a house with garden
a front view of a house with a garden
a plant that is in front of a house
a front view of a house with a yard and potted plants
a living room with couches and a flat screen tv with kitchen view
a living room with a couch and a flat screen tv
a living room with furniture a rug and kitchen view
a living room with furniture fireplace and a view of kitchen
a view of a dining room with furniture
a dining room with furniture and window
a kitchen with a sink stainless steel appliances and cabinets
a kitchen with a dining table chairs stainless steel appliances and cabinets
a dining room with furniture and a window
a dining room with furniture and wooden floor
a bathroom with a toilet a sink and mirror
a view of an entryway with wooden floor
a bedroom with a bed and a flat screen tv
a spacious bedroom with a bed and a potted plant
a bathroom with a granite countertop sink a toilet and shower
a bedroom with bed and window
a bedroom with a large bed and a potted plant
a bed sitting in a bedroom next to a window and a chandelier
a bathroom with a sink a toilet and shower
a view of a room with gym equipment
a big room with closet
a living room with furniture and a flat screen tv
a living room with furniture and a flat screen tv
a bathroom with a sink a toilet and shower
a view of storage and utility room
a front view of a house with garden
a front view of a house with garden
a view of a house with a yard
a picture of a book and a book
unknown
a picture of a wall with a white wall
$1,988,000 | 1463 Burton Street | Whitestone
$1,988,000 | 1463 Burton Street | Whitestone
1/37
Listed By Compass

$1,988,000

4
Bedrooms
2,070
Square Feet
40' x 105'
lot size

1463 Burton Street

Whitestone

$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
$1,450,000 | 7307 6th Avenue | Bay Ridge
1/21
Listed By CompassContract Signed

$1,450,000

7
Bedrooms
2,520
Square Feet
24' x 90'
lot size

7307 6th Avenue

Bay Ridge

a front view of a house with a porch
a view of deck with patio
a bathroom with a sink and mirror
a living room with furniture and a flat screen tv
a living room with furniture and a large window
a living room with furniture a rug and a large window
a dining room with furniture and window
a dining room with furniture and window
a kitchen with stainless steel appliances granite countertop a stove and a refrigerator
a kitchen with stainless steel appliances granite countertop a sink and a stove
a kitchen with stainless steel appliances a stove a sink and a refrigerator
a bedroom with a bed and wooden floor
a bedroom with a bed and wooden floor
a bathroom with a toilet sink and mirror
a living room with furniture and a wooden floor
a living room with furniture and a table
a living room with furniture and a flat screen tv
a living room with furniture a flat screen tv and kitchen view
a kitchen with stainless steel appliances granite countertop a stove and a sink
a bedroom with furniture and a window
a kitchen with a stove a sink and a window
a utility room with dryer and washer
a bathroom with a granite countertop sink toilet and shower
a bedroom with a bed flat screen tv and a window
a bedroom with a bed and a dresser
a white toilet sitting next to a bathroom sink
a bathroom with a toilet and shower
$1,249,000 | 242-16 Pine Street | Douglaston
1/28
Listed By CompassContract Signed

$1,249,000

4
Bedrooms
1,805
Square Feet
27' x 74'
lot size

242-16 Pine Street

Douglaston

a front view of a house with garden
a front view of house with yard
a view of a livingroom with furniture and wooden floor
a view of a dining room with furniture a chandelier and wooden floor
a kitchen with stainless steel appliances granite countertop a stove top oven a sink a refrigerator with a dining table and chairs
a view of a dining room with furniture window and outside view
a living room with furniture a window and a flat screen tv
a living room with furniture and a flat screen tv
a bathroom with a sink a toilet and a mirror
a bedroom with a bed and wooden floor
a bedroom with a bed and wooden floor
a view of an front door
a view of an empty room with a window
a bed room with a bed and a window
a bathroom with a toilet a sink and mirror
a view of a house with large wooden deck and furniture
a front view of a house with garden
a view of a house with a backyard porch and sitting area
a view of a lake with outdoor space
a view of beach and ocean
an aerial view of a house with garden space ocean view
a view of a garden with a house
an aerial view of a forest with beach
a view of a city with ocean view
view of city and mountain
a picture of a park
a picture of a floor plan
unknown
$899,000 | 1380 Jackson Landing, Mattituck, NY 11952
1/29
Listed By CompassPending

$899,000

3
Bedrooms
2,250
Square Feet
0.47
Acres

1380 Jackson Landing, Mattituck, NY 11952

a view of a tree in a backyard of a house
a backyard of a house with lots of green space and trees
a view of a car parked in back of a house
a street view with couple of cars parked on road
a car parked in front of a building
$350,000 | 109-15 Lot A Guy R Brewer Boulevard | Jamaica
1/6
Listed By CompassContract Signed

$350,000

Unavailable
Bedrooms
Unavailable
Bathrooms
Unavailable
Square Feet
0.05
Acres

109-15 Lot A Guy R Brewer Boulevard

Jamaica