Total: {{ totalFound }}

Selected: {{ Object.values(filter.idsInSelected).filter(Boolean).length }}

No results found.
Try adjusting or resetting your filters.

Featured OPEN HOUSE:
{{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}
For sale For rent {{ property.price | toCurrency }} NEW RENTED UNDER CONTRACT Expired SOLD

{{ property?.neighbourhood?.name }}

{{ property?.borough?.name }}

{{ property.address }}

{{ property.propertysubtype }}

Building {{ property.buildingwidth }} Ft x {{ property.buildinglength }} Ft

Lot {{ property.lotsizewidth }} Ft x {{ property.lotsizelength }} Ft

{{ property.bedstotal }} Beds | {{ property.bathstotal }} Baths

Sq. Ft {{ property.sqfttotal.toLocaleString() }}

CC/Maint.{{ property.maintenancecommonfee | toCurrency }}

RE Tax {{ property.taxamount | toCurrency }}

Featured OPEN HOUSE:
{{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}
For sale For rent {{ property.price | toCurrency }} NEW RENTED UNDER CONTRACT Expired SOLD

{{ property?.neighbourhood?.name }}

{{ property?.borough?.name }}

{{ property.address }}

{{ property.propertysubtype }}

Building {{ property.buildingwidth }} Ft x {{ property.buildinglength }} Ft

Lot {{ property.lotsizewidth }} Ft x {{ property.lotsizelength }} Ft

{{ property.bedstotal }} Beds | {{ property.bathstotal }} Baths

Sq. Ft {{ property.sqfttotal.toLocaleString() }}

CC/Maint.{{ property.maintenancecommonfee | toCurrency }}

RE Tax {{ property.taxamount | toCurrency }}

Unit History Building History Save Search Map ViewDetailed View

{{ agent?.office?.officeaddress }}

Office {{ formatPhoneString(agent?.office?.phone) }}

Cell. {{ formatPhoneString(agent?.cellphone) }}

Contact

Languages: {{ agent?.languagesNames }}

View my other listings

{{agent?.reviews?.length ?? 0}} Reviews

{{ agent?.firstname }} {{ agent?.lastname }} currently has no active listings.

Little Neck

42-07 247th St, Flushing, NY 11363

This meticulously maintained semi-detached single-family home is situated on a serene street in the charming neighborhood of Little Neck, Queens. The property boasts a harmonious blend of modern upgrades and classic appeal, ensuring both comfort and convenience. Recent enhancements include stylish kitchen countertops, elegant ceramic tiles, and contemporary cabinetry, all complemented by recessed lighting that adds to the inviting atmosphere. The installation of ductless air conditioning enhances climate control throughout the living and dining areas, as well as in two of the bedrooms. Additionally, the home features all new windows, providing ample natural light and energy efficiency. For added convenience, a washer and dryer are conveniently located on the first floor, while generous storage options are available in the basement and throughout the property. This home is an exemplary choice for those seeking a peaceful living environment without sacrificing modern amenities.

Total Units: 1

For Sale: 0

For Rent: 0

Building type: Semi-Detached

Style: Colonial

Residential Features:

Central Air - Split

Parking Attributes:

None

◀

►

MLS #{{ property.mlsnumber }}

OPEN HOUSE: {{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}

Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}

Days on Market: {{ property.dom }}

Expiration Date: {{ property.expireddate }}

Listed Price: {{ property.listprice | toCurrency }}

Sold Price: {{ property.closeprice | toCurrency }}

Days on Market: {{ property.dom }}

Close Date: {{ property.closedate }}

Listed Price: {{ property.listprice | toCurrency }}

Closed Price: {{ property.closeprice | toCurrency }}

Days on Market: {{ property.dom }}

Close Date: {{ property.closedate }}

Under Contract: {{ property.lastchangedate }}

Floor: {{ property.floornumber }}

Year built: {{ property.yearbuilt }}

Period built: {{ property.periodbuilt }}

Building type: {{ property.buildingtype }}

Pets Allowed: {{ property.petsallowed }}

Style: {{ property.style }}

Assessment included

Board approval included

Building amenities:

{{ amenity }}

Residential Features:

{{ feature }}

Commercial Features Interior:

{{ feature }}

Utilities:

{{ utility }}

Parking Attributes:

{{ parkingattribute }}

Parking Features:

{{ property.parkingfeaturesingle }}
{{ parkingfeature }}

Basement amenities:

{{ basementamenity }}

Exterior:

{{ exteriorItem }}

Virtual Tour

Bedrooms:	{{ property.bedstotal }}
Baths Full:	{{ property.bathsfull }}
Baths Half:	{{ property.bathshalf }}
Rooms:	{{ property.roomcount }}
Stories:	{{ property.stories }}
Building Size:	{{ property.buildingwidth }}' x {{ property.buildinglength }}'
Lot:	{{ property.lotsizewidth }}' x {{ property.lotsizelength }}'
Finished Sq. Ft.:	{{ property.sqfttotal \| toLocaleFormat }}
CC/Maintenance:	{{ property.maintenancecommonfee \| toCurrency }}
RE Tax:	{{ property.taxamount \| toCurrency }}
Families #:	{{ property.numberoffamilies }}

Contacts

{{ agent?.officeaddress }}

Office {{ formatPhoneString(agent?.officephone) }}

Cell. {{ formatPhoneString(agent?.cellphone) }}

Languages: {{ agent?.languages }}

View my other listings

Contact

Mortgage Calculator

Number of Years:

Interest Rate:

Amount of loan after down payment:

Monthly Payment:

Little Neck

42-07 247th St, Flushing, NY 11363

Residential Features:

Parking Attributes:

{{ property.neighbourhood?.name }}

{{ property.borough?.name }}

{{ property.projectname }}

{{ property.address }}

{{ property.listprice | toCurrency }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}

Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}

Sold Price: {{ property.closeprice | toCurrency }}

Closed Price: {{ property.closeprice | toCurrency }}

Building amenities:

Residential Features:

Commercial Features Interior:

Utilities:

Parking Attributes:

Parking Features:

Basement amenities:

Exterior:

Virtual Tour

{{ property.propertysubtype }}

Contacts

Mortgage Calculator

{{ calc.monthly }}