The page is useful for research, but the status and price should be verified before acting.
140-04 123rd Ave
Listing Notes
Two-bedroom colonial on a corner parcel with a full basement and great potential. This unique opportunity boasts close proximity to parks, parkways, schools, stores, and other area conveniences. The home is being sold in its current condition with occupants. The sale is subject to third-party approval (short sale).
Market Insights
$448/sqft vs a nearby median of $501/sqft.
- -11% versus the nearby median price per square foot.
- Price history is limited, so current comps matter more than trend alone.
- 890 sqft creates a usable price-per-square-foot read.
Pricing Read
Asking price is about 4.5% below the fair value — likely to draw competing offers if it's still on market.
- Transit access−$13k −3.0%
- Days-on-market gravity−$13k −3.0%
- Pre-war character+$11k +2.5%
- Sparse street life−$7k −1.5%
- Visible condition issues−$7k −1.5%
Property Read
The asking price per square foot is below the nearby median, which can be worth a closer comp check.
Price history is still limited; review again as more market activity becomes available.
Generate a buyer-agent read of this listing — pricing, risks, comp check, and negotiation leverage. Takes a few seconds.
Generated from the facts shown on this page and nearby market data. Not a professional appraisal.
Listing Details
- Days on market
- 146 days
- Last price change
- No change recorded
- Listed
- Dec 17, 2025
- Photos
- 6 photos
- Property type
- single family
- Status
- for sale