Skip main navigation
Sold for $2,400,000
  • $2,400,000

    27-34 Little Neck Boulevard, Bayside, NY 11360

    5beds
    4,116sqft
    Single Family Residence, Residential
    Built in 2023
    9,520 Square Feet Lot
    $2,725,800 Zestimate®
    $583/sqft
    $6,634 Estimated rent

    Home value

    $2,725,800

    $2.51M - $2.97M

    $6,634/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $6,634/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,634/mo

    Rent Zestimate®

    Refinance and save

    $14,791/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $14,791/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Final Co is ready. Located in the exclusive Gables community. Be part of this high end residential neighborhood surrounded by gorgeous mansions. This customized and lavishly built French-style mansion features luxurious 4,116 interior square foot, 5 bedrooms of which 3 are en suite, 5.5 bathrooms, full finished 1,700 square foot high ceiling basement and spacious attic. From the front yard, it stands tall and majestic, with an unparalleled grandeur! Coupled with carefully trimmed and arranged horticultural landscapes with inground sprinklers, the mansion and gardens are perfectly integrated, making the front yard look magnificent and elegant. The interior space is designed and matched by professional designers, the developer used extraordinary materials from the exterior facade to the interior wall tiles. Entering the foyer, the 20-foot-high gypsum wall panels decorated with gentle milk tea-colored gypsum-lined walls, coupled with the attention to detail in the design, creates a comfortable and artistic space that exudes a French-style softness, elegance, delicacy, and romance. The first floor features radiant floor heating throughout, along with high-end Italian-imported Versace tiles and marble bricks, which takes luxury to the extreme. It embodies a symbol of superior lifestyle and taste. In the kitchen, the most top-of-the-line and luxurious European kitchen appliances are used, with a marble island, steam oven, built-in coffee machine, and professional-grade high-end equipment that allows you to easily prepare a variety of delicious dishes and enjoy the ultimate cooking experience! The spacious private backyard, with breathtaking Clearview water view to meet your needs for large outdoor gatherings with family and friends! Enjoy the beautiful views of the North Shore of Long Island and experience various water recreational activities at the nearby Cross Island Parkway coastal park and Bayside Marina. It is conveniently located with easy access to highways by car. The Long Island Rail Road connects to Manhattan's Penn Station and Long Island. Bayside Terrace Shopping Mall is within walking distance, providing a one-stop shopping experience., Additional information: Appearance:Excellent,Interior Features:Lr/Dr,Marble Bath

    Zillow last checked:

    Listing updated:

    Listed by:

    Hsin Yuan Yang 718-886-8110,

    E Realty International Corp 718-886-8110,

    Lina Wang 516-880-3382,

    E Realty International Corp

    Bought with:

    Lina Wang, 10401297418

    E Realty International Corp

    Hsin Yuan Yang, 10311205376

    E Realty International Corp

    Source: OneKey® MLS as distributed by MLS GRID,MLS#: L3479169MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 6
    • Full bathrooms: 4
    • 1/2 bathrooms: 2
    Heating
    • Forced Air, Radiant
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Microwave, Refrigerator, Washer, Gas Water Heater
    Features
    • Cathedral Ceiling(s), Chandelier, Entrance Foyer, Formal Dining, Granite Counters, Marble Counters, Primary Bathroom
    • Flooring: Hardwood
    • Windows: Skylight(s)
    • Basement: Finished,Full,Walk-Out Access
    • Attic: Full,Unfinished
    • Number of fireplaces: 1
    Interior area
    • Total structure area: 4,116
    • Total interior livable area: 4,116 sqft

    Property

    Parking
    • Parking features: Attached, Driveway, Garage, Private
    • Has uncovered spaces: Yes
    Features
    • Has view: Yes
    • View description: Panoramic, Water
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 9,520 Square Feet
    • Dimensions: 80 x 119
    • Features: Corner Lot, Near Public Transit, Near Shops
    Details
    • Parcel number: 060070027
    • Zoning: R1-2

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Brick
    Condition
    • New Construction
    • New construction: Yes
    • Year built: 2023

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public

    Community & HOA

    HOA
    • Has HOA: No
    Location
    • Region: Bayside

    Financial & listing details

    • Price per square foot: $583/sqft
    • Tax assessed value: $1,969,000
    • Date on market: 11/21/2024
    • Listing agreement: Exclusive Right To Lease

    Price history

    DateEventPrice
    3/6/2024Sold$2,400,000-22.1%$583/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L3479169 Report a problem
    12/12/2023Pending sale$3,080,000$748/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3479169 Report a problem
    11/1/2023Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3479169 Report a problem
    8/17/2023Price change$3,080,000-8.9%$748/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3479169 Report a problem
    5/18/2023Listed for sale$3,380,000+100%$821/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3479169 Report a problem
    9/13/2021Listing removed--
    Source: OneKey® MLS as distributed by MLS GRID #3296855 Report a problem
    3/22/2021Listed for sale$1,690,000+42.3%$411/sqft
    Source: OneKey® MLS as distributed by MLS GRID #3296855 Report a problem
    6/24/2013Sold$1,188,000-0.9%$289/sqft
    Source: OneKey® MLS as distributed by MLS GRID #L2554804 Report a problem
    3/8/2013Listing removed$1,198,888$291/sqft
    Source: S. Bosco Realty Inc. #2554804 Report a problem
    2/1/2013Price change$1,198,888-7.7%$291/sqft
    Source: S. Bosco Realty Inc. #2554804 Report a problem
    1/9/2013Price change$1,299,000+1.6%$316/sqft
    Source: S. Bosco Realty Inc. #2548714 Report a problem
    10/20/2012Price change$1,279,000-5.9%$311/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    8/8/2012Price change$1,359,000+4.6%$330/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    7/27/2012Price change$1,299,000-5.5%$316/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    7/19/2012Price change$1,375,000-6.8%$334/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    6/6/2012Price change$1,475,000-1.6%$358/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    6/5/2012Price change$1,499,000-6.3%$364/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    4/27/2012Listed for sale$1,599,000+97.4%$388/sqft
    Source: S. Bosco Realty Inc. #2490147 Report a problem
    10/19/2009Sold$810,000$197/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $118,140 +5.7%
    2024-- $111,780 +59.5%
    2023-- $70,080 +10.6%
    2022-- $63,360 +6.9%
    2021-- $59,280 -8.5%
    2020$13,716 +3.4%$64,800 -9.2%
    2019$13,263 +7.3%$71,400 +20.8%
    2018$12,366 +3.9%$59,112 +1.2%
    2017$11,903 +5.2%$58,392 +0.9%
    2016$11,319 $57,888 +4.6%
    2015$11,319 +70.4%$55,347 +6%
    2014$6,644 $52,215 +6%
    2013-- $49,260 +1.2%
    2012-- $48,660 +0.9%
    2011-- $48,240 -4.4%
    2010-- $50,480 +6%
    2009-- $47,623 +6%
    2008-- $44,928
    Find assessor info on the county website

    Neighborhood: Bayside

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Ps 41 Crocheron
    • Middle: Ms 158 Marie Curie
    • High: Bayside High School

    Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.