This rare Flushing gem is a semi-detached, lot size 4240 and building size 22x48, legal two-family home that offers an exceptional blend of suburban comfort and urban convenience. The versatile dual-layout features a spacious three-bedroom, one-bath unit on the first floor, while the second floor expands into a generous three-bedroom, two-full-bath retreat, with dedicated washers and dryers on both levels for effortless living. Beyond the interior, the property boasts an extraordinary footprint—highlighted by a private 40x50 parking lot that comfortably accommodates five or more vehicles, alongside a 25x35 backyard ideal for a lush garden or outdoor entertaining. Located just steps from the Q25 and Q26 bus lines for a quick ride to Main Street’s 7 train, this turn-key multi-family delivers unbeatable space, accessibility, and high-value potential.
For sale
$1,190,000
2518 123rd Street, Flushing, NY 11354
--beds
--baths
2,052sqft
Duplex, Multi Family
Built in 1950
-- sqft lot
$-- Zestimate®
$580/sqft
$-- HOA
What's special
Generous three-bedroom two-full-bath retreatSpacious three-bedroom one-bath unit
- 13 hours
- 181
- 19
Zillow last checked:
Listing updated:
Listed by:
City Realty Group 718-888-9005,
Emmy D. Cai CBR 646-805-8688
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1053246
Facts & features
Interior
Heating
- Baseboard
Cooling
- Ductless
Features
- First Floor Bedroom
Interior area
- Total structure area: 2,052
- Total interior livable area: 2,052 sqft
Property
Parking
- Total spaces: 5
- Parking features: Driveway
- Carport spaces: 5
- Has uncovered spaces: Yes
Lot
- Size: 4,240 Square Feet
Details
- Parcel number: 042590018
- Special conditions: None
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Duplex, Multi Family
Materials
- Brick
Condition
- Year built: 1950
Utilities & green energy
- Gas: Separate Gas Meters: 2
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Trash Collection Public, Water Connected
Community & HOA
Location
- Region: Flushing
Financial & listing details
- Price per square foot: $580/sqft
- Tax assessed value: $75,660
- Annual tax amount: $9,954
- Date on market: 9/21/2026
- Listing agreement: Exclusive Right To Sell
- Electric utility on property: Yes
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 9/21/2026 | Listed for sale | $1,190,000+40.8%$580/sqft |
Source:  OneKey® MLS as distributed by MLS GRID #1053246 Report a problem | ||
| 1/3/2015 | Sold | $845,000$412/sqft |
Source: Public Record Report a problem | ||
| 8/1/2014 | Sold | $845,000-6%$412/sqft |
Source: Agent Provided Report a problem | ||
| 5/15/2014 | Price change | $898,888-7.3%$438/sqft |
Source: Exit Kingdom Realty Report a problem | ||
| 2/20/2014 | Price change | $970,000-15.7%$473/sqft |
Source: Exit Kingdom Realty Report a problem | ||
| 1/3/2014 | Listed for sale | $1,150,000+283.3%$560/sqft |
Source: Exit Kingdom Realty #2637757 Report a problem | ||
| 9/26/2006 | Sold | $300,000$146/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $67,320 -6.1% |
| 2024 | -- | $71,700 +9.9% |
| 2023 | -- | $65,220 -4.8% |
| 2022 | -- | $68,520 +12.4% |
| 2021 | -- | $60,960 +1.2% |
| 2020 | $8,411 +6% | $60,240 +11.1% |
| 2019 | $7,936 +2.7% | $54,240 +46.9% |
| 2018 | $7,724 +8.8% | $36,924 +6% |
| 2017 | $7,101 +4.3% | $34,836 |
| 2016 | $6,812 | $34,836 +5.2% |
| 2015 | $6,812 | $33,114 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: College Point
Nearby schools
Schools provided by the listing agent
- Elementary: Ps 29
- Middle: Jhs 185 Edward Bleeker
- High: Flushing 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.
Similar homes
- $1,183,0006 bd5 ba1.9k sqft1532 124th Street, College Point, NY 11356For Sale
MLS ID #1052286, Ding Yu, Listing by: B Square Realty. OneKey® MLS as distributed by MLS GRID - $1,183,0006 bd5 ba1.9k sqft15-32 124th St, College Pt, NY 11356Active
MLS ID #S1848600, Ding Yu, Listing by: B Square Realty. StreetEasy - $1,229,8884 bd2 ba1.5k sqft12520 22nd Avenue, College Point, NY 11356For Sale
MLS ID #1048086, Anthony Skoros, Listing by: Suydam Agency Inc. OneKey® MLS as distributed by MLS GRID - $1,358,8885 bd2 ba1.8k sqft2347 125th St, Flushing, NY 11356Active
MLS ID #S1846284, Andrea Sorrentino, Listing by: Douglas Elliman. StreetEasy - $1,190,0007 bd4 ba2.1k sqft14-18 114th Street, College Point, NY 11356For SaleMLS ID #1031472, Emmy D. Cai CBR, Listing by: City Realty Group. OneKey® MLS as distributed by MLS GRID
- $1,399,0006 bd2 ba1.6k sqft2310 102nd Street, East Elmhurst, NY 11369For SaleMLS ID #1052735, Leandro A. Martinez Cardozo, Listing by: LIR NY LLC. OneKey® MLS as distributed by MLS GRID
- $1,399,0004 bd6 ba2.2k sqft2219 120th Street, College Point, NY 11356For SaleMLS ID #1047832, Elsa N. Seguinot, Listing by: Coldwell Banker Realty. OneKey® MLS as distributed by MLS GRID
- $1,199,5003 bd3 ba1.7k sqft123-09 20th Avenue, College Point, NY 11356For SaleMLS ID #990731, Gavesh Meghan, Listing by: Coldwell Banker American Homes. OneKey® MLS as distributed by MLS GRID
- $1,180,0005 bd3 ba2.6k sqft18-38 120th Street, College Point, NY 11356For SaleMLS ID #828099, Alan Z. Mei, Listing by: SpaceMax Realty Inc. OneKey® MLS as distributed by MLS GRID
- $1,288,0004 bd3 ba1.8k sqft1107 137th Street, College Point, NY 11356For SaleMLS ID #1051380, XinXin Lin, Listing by: Compass Greater NY LLC. OneKey® MLS as distributed by MLS GRID
- $1,190,0002 bd2 ba1.1k sqft39-16 Prince Street #5A, Flushing, NY 11354For SaleMLS ID #1008940, Jianing Carlisle, Listing by: Fultonex Realty LLC. OneKey® MLS as distributed by MLS GRID
- $925,0004 bd2 ba1.3k sqft15-32 125th Street, College Point, NY 11356For SaleMLS ID #1051657, Agata Landa, Listing by: Capri Jet Realty Corp. OneKey® MLS as distributed by MLS GRID
- $1,298,0004 bd2 ba1.9k sqft921 127th Street, College Point, NY 11356For SaleMLS ID #1009728, Ling Ling Wu, Listing by: H N L Realty Inc. OneKey® MLS as distributed by MLS GRID
- $1,075,0004 bd4 ba1.8k sqft125-12 18th Avenue, College Point, NY 11356For SaleMLS ID #1004178, Hope V. Grouzis CBR, Listing by: Keller Williams Rlty Landmark. OneKey® MLS as distributed by MLS GRID
- $1,288,0002 bd2 ba1k sqft131-01 40th Road #PH3D, Flushing, NY 11354For SaleMLS ID #1051921, Nanfen Zhang, Listing by: E Realty International Corp. OneKey® MLS as distributed by MLS GRID
- $1,498,0006 bd4 ba2.9k sqft144-44 27th Avenue, Flushing, NY 11354For SaleMLS ID #1042935, Edna Mashaal, Listing by: Edna Mashaal Realty LLC. OneKey® MLS as distributed by MLS GRID
- $1,298,0006 bd4 ba2.4k sqft13-05 128th Street, College Point, NY 11356For SaleMLS ID #1001872, Dan Dan Tian, Listing by: Century Homes Realty Group LLC. OneKey® MLS as distributed by MLS GRID
- $1,290,0004 bd3 ba1.8k sqft11-63 129th Street, College Point, NY 11356For SaleMLS ID #1021927, Susan Sanchez CBR SRES, Listing by: Signature Premier Properties. OneKey® MLS as distributed by MLS GRID
