
$519,900
402 N Front St #4, Philadelphia, PA 19123
Listed by TCS Management, LLC
A picture-perfect 2026 remodel of a two-bedroom, two-and-a-half-bathroom home at Waterfront Square, with GARAGE parking included. Quality finishes throughout, highlighted by a large, open living and dining room with floor-to-ceiling windows overlooking the Delaware River. The river views are a must-see! The kitchen was completely renovated top to bottom, with 42-inch cabinets for maximum storage, brand-new, never-used Frigidaire Gallery appliances, quartz countertops and backsplash, and a redesigned entryway closet and island for improved flow. This layout is unique to this unit within Waterfront Square. Both bathrooms were also completely renovated, featuring high-end Delta fixtures, marble floor tile, marble shower tile (Africa Tempesta in the second bathroom), Volakas marble skirting, and brand-new Gerber toilets. Waterfront Square is a gated, 9.5-acre riverfront community at 901 N. Penn Street in Northern Liberties. Amenities include a 12,000 sq ft fitness center and spa, a year-round 25-meter indoor lap pool with riverfront sundeck, hot tub, sauna, steam room, optional yoga and Pilates classes, landscaped grounds with walking and jogging trails, two fenced dog parks, ample unassigned resident parking, and on-site guest parking. A new Sprouts market is steps away, and a weekday shuttle runs to Center City with multiple stops. This unit is located in The Regatta, a 29-story tower completed in 2006 with views of the Delaware River, the Ben Franklin Bridge, and the Center City skyline — one of three luxury towers within the gated community. Northern Liberties offers easy access to Center City dining, shopping, and entertainment, as well as major highways and bridges.
| Date | Event | Price |
|---|---|---|
| Jul 4, 2026 | Listed for sale | $685,000 |
Price changes are tracked from when NookLocal first indexed this listing; earlier history may not appear. Tax & assessment details are in the section below.
$603,000
Below the asking price by 12%.
Automated estimate, not an appraisal.
This home's sale history
Recorded property taxes: $7,796 (2025 bill as recorded in the MLS).
Loan term
Estimated monthly payment
$4,288/mo
Taxes use the amount recorded on the MLS. The default rate is the average 30-year rate as of July 2026; insurance is estimated at 0.35% of the price per year. Below 20% down, lenders usually add mortgage insurance, which this estimate doesn't include. Estimate only; verify before relying on it.
School district
The School District Of Philadelphia
2025 PA state assessments (PSSA / Keystone) and graduation data. The index measures student outcomes, not school effectiveness, and is not adjusted for demographics. Districts serve all residents; verify enrollment boundaries with the district.
Safety data
Philadelphia County crime & safety numbers →
FBI and Pennsylvania source data, presented without spin.
Property taxes
Philadelphia County taxes, explained →
Millage, the Common Level Ratio, and what changes after you buy.
© BRIGHT, All Rights Reserved
Information Deemed Reliable But Not Guaranteed
The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms in which United Real Estate Strive 212 participates, and is provided by BRIGHT through a licensing agreement.
IDX listings are displayed pursuant to broker of record United Real Estate Strive 212, Frank Ramos, Broker/Owner, PA Broker License RM424345, 1220 Broadcasting Rd, Suite 201, Wyomissing, PA 19610, (610) 372-0212.
The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some properties which appear for sale on this website may no longer be available because they are under contract, have Closed or are no longer being offered for sale.
Data last updated: July 8, 2026 at 2:49 PM EDT
Our concierge desk does a 1-on-1 needs analysis with you, then hand-picks a vetted Philadelphia agent or lender, not whoever paid for your ZIP. Free, no obligation. If you work with a partner we introduce, NookLocal may earn a referral fee from their broker.