Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1651 S 23rd Street
Philadelphia, PA 19145

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,900
Beds: 4
Baths: 2
Status: Active
SqFt: 1980
Agency: Carrington Real Estate Sevices (US), LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1925
Notes: This beautiful well-thought out 4 bed 2 bath home in Point Breeze, one of Philadelphia's rapidly developing neighborhoods, has old world charm with all the modern amenities! Designed and staged by acclaimed design firm Acomodo, you feel like you are living in a boutique hotel. This home has all the features & amenities you'd expect from new construction! Open your keyless front door or answer your front door thru Ring and walk into a light filled foyer/mudroom. The bright foyer features an unexpected whimsical industrial inspired full bath. Walk through original French double doors that lead to the semi-open concept 1st floor living space. The large living room is furnished with a faux fireplace flanked by custom craftsman designed built-in bookcases. The living room, dining room & kitchen flow into each other for seamless interaction & enjoyment. Next walk into a boutique hotel inspired dining room that can sit 8-10 people with ease. The dining room features a beautiful green wall & industrial chandelier with hanging plants. In the rear of the main level, you will step into the beautiful high-design kitchen with Spanish Mediterranean style backsplash! The elegant white Shaker soft-closing kitchen cabinet doors & drawers have the feel of luxury & are complemented by granite & waterfall butcher block countertops and wood herringbone tile floors. This kitchen is outfitted with a stainless steel oven, microwave, refrigerator & dishwasher. This kitchen is beyond perfect for entertaining. Just off the kitchen is a backyard ready for gatherings, storytelling or party just add string lighting to light up your night. It does not stop there. Upstairs, you will find the master bedroom featuring a black and white plaid feature wall, a large closet with sliding glass paneled doors, contemporary ceiling fan/light. Down the hall open the custom craftsman designed barn door and enter a magical bedroom with a hanging plant and flower light fixture. Further down the hall are 2 other bedrooms. One is staged with a bunk bed that converts into a sofa and an adorable custom built shiplap closet! The 4th bedroom has a feature themed tree wallpapered wall. There is a spacious hall bath with a tub, vanity with large drawers & dual flush toilet. Downstairs the lower level is finished with beautiful luxury waterproof wood laminate flooring, custom craftsman designed utility doors. This not-so-typical finished basement even has a bar with fridge and walkout DOOR to your backyard. It can be a comfortable 5th bedroom/a cozy hangout/entertainment area. There is a Ring doorbell security system installed in the front and back. Minutes to Center City or University City via bike or a short bus ride. It is walk-able, accessible to public transportation & accessible to The Schuylkill Expressway. Down the street on Morris Street or 23rd Street you can hop on SEPTA's 29 Bus Route to get around Philly. This home is also less than 5 minutes to Center City, Rittenhouse Square & Passyunk Square, local restaurants and cafes. Don’t miss this opportunity; schedule your showing today!
MlsNumber: PAPH2330618


Listing Provided By: Carrington Real Estate Sevices (US), LLC, original listing
Name: Carrington Real Estate Sevices (US), LLC
Phone: (877) 330-2773
Office Name: Vylla Home
Office Phone: (877) 330-2773
Agent Name: Regina Ravasco
Disclaimer: Copyright © 2024 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Shantel Williams
ASCIILOAN DEPOT
Call Today!: (520) 954-2275

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App