Brown Harris Stevens

Search
5727 246th Place Pl
Little Neck, Queens, NY
$2,980,000 Price
6 Bedrooms  
CloseClose Video
Photo 1 of 5727 246th Place Pl, Little Neck, Queens, NY, $2,980,000, Web #: 3561940Previous PhotoNext Photo1 of 28

Newly built Two Family Luxury Home in Little Neck offers approx. 3,200 sq.ft of living space on a 47X100 ft lot. It's located in the prime location is surrounded by luxury homes and beautiful scenery, making it one of the safest and most attractive residential areas. ...

Newly built Two Family Luxury Home in Little Neck offers approx. 3,200 sq.ft of living space on a 47X100 ft lot. It's located in the prime location is surrounded by luxury homes and beautiful scenery, making it one of the safest and most attractive residential areas. It's close to Douglaston Golf Course, with extremely convenient access to shopping and transportation. Various stores and supermarkets are within walking distance, including only a few minutes' walk to the New World Supermarket. Top rated 26 school district: PS221 Elementary School and 67 Junior High School are just steps away. It's a great layout and design, the home features stainless steel appliances, Pella windows, a brand new foundation, detached two car garage, and a wide private driveway with multiple parking spaces. The basement with a lot of windows and natural lights, 9-foot ceilings, and is built with an all brick and concrete structure. The roof high quality glazed tiles, with additional foam insulation for better temperature control and highly energy efficient. Heated floor, central air heating and cooling system. Three separate central air conditioning units ensure comfort while saving on energy. 360-degree outdoor surveillance cameras are installed. The first family unit includes 4 bedrooms and 3.5 bathrooms: the first floor is a grand living room with high ceilings, a dining room, and a half bath. The second floor has 4 bedrooms and 3 bathrooms, with 4 balconies that expand the living space and provide perfect spots for relaxing. The second family unit includes open kitchen, 2 bedrooms and 3 bathrooms, large living and dining room, also a huge attic bonus. It also features a hidden wine cellar, ideal for wine storage and entertaining guests. This perfectly designed two family luxury home combines the best of both investment and residence opportunities!

Listing courtesy of Skylux Realty Inc

Calculate your Payments

Asking Price:

Percent Down:

Loan Amount:

Interest Rate:

Loan Term (years):

Estimated Mortgage Payment:

Total Monthly Payment:

* All information furnished regarding property for sale, rental, financing or estimated mortgage rates is from sources deemed reliable but no warranty or representation is made as to the accuracy thereof. For further financing information, please contact a Brown Harris Stevens agent.

Listing Details

Little Neck, Queens, NY
Type:
Price: $2,980,000
Last Updated: 11/7/2024
Web ID: 3561940

Info & Amenities

Rooms: 14.0
Bedrooms: 6
Bathrooms: 8.0
Built: 2022

All information is from sources deemed reliable but is subject to errors, omissions, changes in price, prior sale or withdrawal without notice. No representation is made as to the accuracy of any description. All measurements and square footages are approximate and all descriptive information should be confirmed by customer. All rights to content, photographs and graphics are reserved to Brown Harris Stevens. Customer should consult with its counsel regarding all closing and tax costs. Broker represents the seller/owner on Broker's own exclusives, except if another agent of Broker represents the buyer/tenant, in which case Broker will be a dual agent, in Connecticut, or , in New York State and New Jersey, a dual agent with designated or disclosed agents representing seller/owner and buyer/tenant. Broker represents the buyer/tenant when showing the exclusives of other real estate firms. In Florida, Broker acts as a Transaction Broker with all sellers and buyers, unless a different form of agency has been established in writing. If you are looking to purchase or rent housing, are using a screen reader, and are having problems using this website, please call 1-212-712-1163 for assistance. All phone charges will be reimbursed by Brown Harris Stevens. Broker actively supports Fair Housing and Equal Housing Opportunities. BHS has adopted the attached policy statement - Prior to showing a homebuyer a property or providing services: (1) BHS does not require identification from a prospective homebuyer, (2) BHS may require a written agreement from a homebuyer before showing properties; and (3) BHS does not require a pre-approval for a mortgage loan in order to show a homebuyer properties. However, based upon the requirements of the seller, the building in which the properties is located, or others, some or all of the foregoing items may be required. Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York's Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer's personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. 2024 The Real Estate Board of New York, Inc., all rights reserved. RLS Data display by Brown Harris Stevens. Powered by Terra Holdings.