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,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
$5,350,000 | 3360 Wunneweta Road, Cutchogue, NY 11935
1/32
Listed By CompassVirtual Tour

$5,350,000

6
Bedrooms
8,500
Square Feet
1.68
Acres
$4,400,000 | 4010 Crescent Street | Long Island City
$4,400,000 | 4010 Crescent Street | Long Island City
$4,400,000 | 4010 Crescent Street | Long Island City
1/3
Listed By CompassContract Out

$4,400,000

Unavailable
Bedrooms
Unavailable
Bathrooms
Unavailable
Square Feet
Unavailable
Acres
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
$3,648,000 | 265 Northwoods Road, Manhasset, NY 11030
1/33
Listed By CompassPending

$3,648,000

4
Bedrooms
3,601
Square Feet
0.29
Acres
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$2,799,000 | 2100 Sound Drive, Greenport, NY 11944
$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
2,095
Square Feet
0.73
Acres
a front view of a house with a yard
a front view of a house with a yard and garage
a view of a house with a big yard
an aerial view of a house with swimming pool garden and patio
a front view of a house with a yard
an aerial view of a house with garden
an aerial view of a residential houses with outdoor space
a living room with furniture and a potted plant
a living room with furniture and wooden floor
a living room with furniture and a large window
a dining room with furniture and wooden floor
a kitchen with a counter top space and a sink
a kitchen with a sink cabinets and wooden floor
a kitchen with a sink a stove and chairs
a view of a dining room with furniture
a living room with furniture potted plant and a fireplace
a living room with furniture fireplace and a large window
a view of a dining room with furniture window and wooden floor
a view of a dining room with furniture and wooden floor
a bedroom with a bed and large windows
a spacious bedroom with a large bed and a large window
a spacious bedroom with a large bed and a large window
a view of a room with a large window and wooden floor
a view of a room from a window
a view of balcony and patio
a view of a garden with an outdoor space
a view of a swimming pool with a patio
a bathroom with a sink and a mirror
a bathroom with a shower
a living room with a furniture and a window
a view of walk in closet with empty racks
an empty room with wooden floor and windows
a bathroom with a sink toilet and shower
a view of an empty room with wooden floor and a window
a bathroom with a granite countertop sink toilet and shower
an empty room with wooden floor and windows
a view of a city
an aerial view of multiple house
$2,499,000 | 285 Blue Marlin Drive, Southold, NY 11971
$2,499,000 | 285 Blue Marlin Drive, Southold, NY 11971
1/40
Listed By CompassContract

$2,499,000

4
Bedrooms
2,842
Square Feet
0.46
Acres
a front view of a house with a garden and trees
a view of outdoor space yard and lake
a front view of a house with a garden and trees
a view of street with houses and trees in the background
a front view of a house with a yard and garage
front view of a house
a view of a chairs and table in patio with a yard
a view of entryway and hall with wooden floor
a view of entryway and hall with wooden floor
a view of a dining room with furniture window and wooden floor
a view of a dining room and livingroom with furniture wooden floor a chandelier
a kitchen with stainless steel appliances granite countertop a stove top oven a sink a dining table and chairs
a kitchen with granite countertop a refrigerator and cabinets
a large kitchen with stainless steel appliances granite countertop a stove and a sink
a open kitchen with stainless steel appliances granite countertop a sink and cabinets
a kitchen with cabinets and chairs
a living room with furniture a fireplace and a flat screen tv
a living room with furniture and a wooden floor
a living room with furniture and a rug
a living room with furniture and a rug
a living room with furniture and a wooden floor
a view of a dining room with furniture and wooden floor
a dining room with furniture and a chandelier
a view of a dining room with furniture a chandelier and wooden floor
a bathroom with a sink a mirror and a toilet
a view of a interior of the house
a bedroom with a bed and wooden floor
a bedroom with a bed and a lamp
a bathroom with a bathtub sink and mirror
a spacious bedroom with a bed and a night stand
a bedroom with a bed and a window
a bedroom with a bed and window
a bathroom with a granite countertop sink and a toilet
a view of a bike garage
a view of a house with backyard and sitting area
a view of a park with large trees
an aerial view of residential houses with outdoor space and trees
a view of lake view and mountain view
a view of a building with a yard
a view of a garden
a view of a house with a yard
a view of a yard
a backyard of a house
a view of a ocean beach
a view of an ocean beach
a view of ocean view with beach
view of city
$1,619,000 | 2655 Rocky Point Road, East Marion, NY 11939
1/48
Listed By Compass

$1,619,000

4
Bedrooms
2,564
Square Feet
1.2
Acres
a front view of house with yard
a view of entryway and hall with wooden floor
a living room with furniture a window and a fireplace
a living room with furniture and a wooden floor
a living room with furniture and a wooden floor
a living room with furniture a fireplace and a large window
a living room with furniture and a fireplace
a living room with furniture a potted plant and a table
wooden floor in an empty room with a window
a view of a dining room with furniture window and wooden floor
wooden floor in an empty room with a window
a view of a dining room with furniture window and wooden floor
a living room with furniture and a table
a kitchen with stainless steel appliances kitchen island granite countertop a refrigerator and chairs
a bathroom with a granite countertop sink a toilet a mirror and window
a kitchen with a sink and refrigerator
a kitchen with stainless steel appliances granite countertop a sink stove and cabinets
a bathroom with a sink a toilet and a mirror
a bathroom with a sink and a mirror
a view of front door with wooden floor
a view of an empty room with wooden floor and a window
a view of empty room with wooden floor
an empty room with wooden floor and windows
wooden floor in an empty room with a window
a bathroom with a sink a toilet and mirror
a white toilet sitting next to a bathroom sink
a view of an empty room with wooden floor and a window
a living room with furniture and a flat screen tv
a view of empty room
a bathroom with a sink mirror and shower
a view of a chair and table in backyard of the house
a front view of house with yard and seating area
1/32
Listed By Compass

$1,539,000

4
Bedrooms
2,292
Square Feet
0.20
Acres
$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
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

The Liappas Team’s Transactions

Past Sales
$5,800,000 | 22 Shore Drive, Manhasset, NY 11030

$5,800,000

2.87
Acres

Listing Courtesy of Douglas Elliman Real Estate, Connie Liappas; Douglas Elliman Real Estate, Camille Dussich

$5,650,000 | 35 Chestnut Hill Drive, Oyster Bay, NY 11771

$5,650,000

5
Bedrooms
10,500
Square Feet
5
Acres

Listing Courtesy of Nest Seekers LLC, Shawn R. Elliott; Nest Seekers LLC, Zachary Elliott

a front view of a house with a garden and trees

$4,825,000

7
Bedrooms
6,500
Square Feet
0.75
Acres
$4,300,000 | 75 8th Avenue | Park Slope

$4,300,000

7
Bedrooms
20' x 100'
lot size
a front view of a house with a yard

$4,280,000

5
Bedrooms
5,200
Square Feet
0.51
Acres

Listing Courtesy of Daniel Gale Sothebys Intl Rlty, Diane Curd; Daniel Gale Sothebys Intl Rlty, Maria Tsiolas

Photo of home

$4,243,908

6
Bedrooms

107 Gristmill Ln

Plandome Manor Village

front view of a house with a yard

$3,900,000

5
Bedrooms
5,600
Square Feet
0.51
Acres
$3,880,000 | 27 Victorian Lane, Glen Head, NY 11545

$3,880,000

5
Bedrooms
7,000
Square Feet
2
Acres

Listing Courtesy of Daniel Gale Assoc Inc of E Nor, Frances M. Covello CBR

$3,850,000 | 5 Knolls Lane, Manhasset, NY 11030

$3,850,000

6
Bedrooms
6,850
Square Feet
1.09
Acres
$3,835,000 | 77 Gristmill Lane, Manhasset, NY 11030

$3,835,000

6
Bedrooms
4,641
Square Feet
0.62
Acres
$3,365,000 | 5 Laurel Lane, Sands Point, NY 11050

$3,365,000

7
Bedrooms
6,000
Square Feet
1.00
Acres

Listing Courtesy of Douglas Elliman Real Estate, Liappas, Connie

a front view of a house with a garden

$3,200,000

5
Bedrooms
4,350
Square Feet
0.27
Acres
a front view of house with yard and green space

$3,149,000

4
Bedrooms
4,400
Square Feet
0.75
Acres
a front view of a house with a garden

$3,105,000

5
Bedrooms
4,200
Square Feet
0.29
Acres
$3,100,000 | 86 Abbey Road, Manhasset, NY 11030

$3,100,000

6
Bedrooms
6,700
Square Feet
0.39
Acres

Listing Courtesy of Douglas Elliman Real Estate, Liappas, Connie

$3,075,000 | 393 Grand Avenue | Clinton Hill

$3,075,000

5
Bedrooms
4,032
Square Feet
21' x 102'
lot size
$3,050,000 | 14-21 161st Street | Beechhurst

$3,050,000

4
Bedrooms
80' x 80'
lot size
Past Rentals
$36,000 | 126 Lynn Avenue, Unit 7, Hampton Bays, NY 11946

$36,000

2
Bedrooms
624
Square Feet
0.01
Acres
Photo of home

$23,891

179-11 Union Tpke

Fresh Meadows

a front view of a house with a big yard and potted plants

$17,000

3
Bedrooms
1,200
Square Feet
0.19
Acres
$11,250 | 9 The Intervale, Roslyn Heights, NY 11577

$11,250

5
Bedrooms
0.83
Acres
$10,800 | 303 Grist Mill Circle, Roslyn, NY 11576

$10,800

4
Bedrooms
2.69
Acres

Listing Courtesy of Douglas Elliman Real Estate, Jing Sun

$8,000 | 148 Shoreview Road, Manhasset, NY 11030

$8,000

4
Bedrooms
0.16
Acres
a patio with a table and chairs under an umbrella

$7,916

4
Bedrooms
3,200
Square Feet
0.92
Acres
a front view of a house with a yard

$6,750

3
Bedrooms
1,618
Square Feet
0.14
Acres
a front view of a house with garden

$6,500

4
Bedrooms
0.15
Acres

Listing Courtesy of Douglas Elliman Real Estate, Amr M El Guindy; Douglas Elliman Real Estate, Emily Wilson

$6,200 | 106 Trumbull Road, Manhasset, NY 11030

$6,200

3
Bedrooms
2,100
Square Feet
0.23
Acres

Listing Courtesy of Coldwell Banker American Homes, Adele M. Kuczmarski; Coldwell Banker American Homes, Nancy S. Holweger

$5,700 | 61 Bryant Avenue, Unit 314, Roslyn, NY 11576

$5,700

2
Bedrooms
1,250
Square Feet

Listing Courtesy of Douglas Elliman Real Estate, Stuart L Bayer; Douglas Elliman Real Estate, Carolyn D Gelb

a front view of a house with a garden

$5,500

3
Bedrooms
0.11
Acres
a front view of a house with garden

$5,200

3
Bedrooms
1,632
Square Feet
0.14
Acres
$5,200 | 84 Marjorie Court, Manhasset, NY 11030

$5,200

2
Bedrooms
1,596
Square Feet

Listing Courtesy of Douglas Elliman Real Estate, Connie Liappas; Douglas Elliman Real Estate,

front view of a house

$5,100

2
Bedrooms
1,600
Square Feet
$5,100 | 61 Bryant Avenue, Unit 314, Roslyn, NY 11576

$5,100

2
Bedrooms
1,200
Square Feet

Listing Courtesy of Douglas Elliman Real Estate, Carolyn Gelb; Douglas Elliman Real Estate, Stuart L Bayer

$5,050 | 61 Bryant Avenue, Unit 316, Roslyn, NY 11576

$5,050

2
Bedrooms

Listing Courtesy of Douglas Elliman Real Estate, Carolyn Gelb; Douglas Elliman Real Estate, Stuart L Bayer

a front view of a house with a yard and trees

$5,000

3
Bedrooms
0.62
Acres