South Philadelphia - Queen Village

790 S Front Street

Philadelphia, PA 19147
MLS# PAPH2297128
$900,000
4 BEDS
New Listing
DAYS ON MARKET: 1

Listing provided courtesy of: BHHS Fox & Roach-Center City Walnut

Property Description

Here is your golden opportunity to own a piece of real estate with extra income and situated on a beautiful tree line street in the heart of Queen Village Meredith School Catchment. Welcome to 790 S Front Street. A single-family home plus 3 attached trinities and a beautiful and sizable landscaped garden -WOW. This parcel spans over 100 feet and all units have separate entrances. The Main House: Wide 2.5 story 2 bedroom plus den – 1 full bath with an open floor plan, massive amounts of natural light, sizable bedrooms with great closet and storage space, 2 original & beautiful fireplaces with lots of exposed brick, many built ins and a full basement allowing lots of extra storage space. The Trinities: Side breezeway with a secure gate leads to 3 fabulous trinities all in nice condition. Rear 1 is a one bedroom, R- 2 is a 2 bedroom and R- 3 is a 2 bedroom. All units are self-contained with central air and produce great rental income. The upper floors of these units have really nice views of neighboring gardens with lots of greenery. Just beyond the trinities is a gorgeous, landscaped garden area with a tranquil setting. This is a fabulous parcel in one of Philadelphia’s finest neighborhoods and was built in the late 1800’s. Currently zoned RSA 5 – Residential – Single-family dwelling. All units have been incredibly maintained throughout the years by the current owners and the HVAC systems and hot water heaters have recently been replaced. Don’t miss your opportunity to own this rarely offered property in a very convenient area. Within walking distance to many restaurants, cafes, farmer’s market, parks, dog walks and playgrounds. There is easy access to major highways and bridges. Need Parking? We have you covered a stone throw away at the very affordable Queen Village parking lot. Make your appointment today and don’t let this one slip away.

  • Features:

    Central Air On Street

{"_id":{"$oid":"5e690df395eed7d2e28350e1"},"id":"B3179603","email":"[email protected]","first_name":"Patrick","full_name":"Patrick M Conway","internal_id":"3179603","last_name":"Conway","middle_name":"","mls":"bright_mls","office_id":"B61039","phone":"(215) 440-8172","slug":"patrick-conway","slug2":"patrick-m-conway","blog_url":"","cell_phone":"(215) 266-1537","date_modified":{"$date":{"$numberLong":"1690469167000"}},"designation":null,"last_seen_in_mls":{"$date":{"$numberLong":"1700073020000"}},"license_number":"","middle_initial":"M","office_name":"BHHS Fox & Roach-Center City Walnut","phone_ext":null,"social_links":[],"website_url":"","is_custom_agent":true,"last_updated":{"$date":{"$numberLong":"1583943640809"}},"sites":["5e67b6c495eed7d2e27d6a4e"],"association_id":null,"languages":null,"preferred_phone":null,"description":"I have the greatest job in the world!\n\nFinding homes, researching market stats, negotiating contracts, and helping clients find a home that meets their expectations is what I do and I am passionate about it! Whether you are buying or selling, or just want some information before you even start that process, you have come to the right place!\n\n \n\nPatrick Conway","image":"https:\/\/conwayteam.com\/app\/uploads\/sites\/conwayteam\/2022\/12\/Pat-long-cropped.jpg","post_id":18233,"site_id":"5e67b6c495eed7d2e27d6a4e","background_image":false,"title_over_background_image":"","description_over_background_image":"","license_prefix":"","fax":"","about_text":"I have the greatest job in the world! Researching market stats, negotiating contracts, and helping my clients sell their home or find a home that meets their expectations is what I do, and I am passionate about it. I started my real estate career in college, working for a privately owned company in their rental department for five years. I now have 25 years of loyal experience at Berkshire Hathaway HomeServices Fox & Roach, REALTORS\u00ae. I am the team leader of The Conway Team and a consistent top producer, with transactions averaging over $50M per year. I have been around the real estate business my entire life. My mother, Kathy Conway, founded this team on principles of hard work and caring deeply for each and every client. I am proud to have been her business partner and son. The best advice I ever received was from my mom. \u201cTreat everyone as you would want to be treated,\u201d she said. \u201cAlways be kind, honest, and smart.\u201d With this in mind, I will continue her legacy of providing top notch service to my clients and my community.\nAwards:\n\n\nChairman\u2019s Circle Diamond Award – Top Half of 1% of the entire Berkshire Hathaway HomeServices network\n\n\n25 Year Legend Award – 25 years in the Chairman\u2019s Circle\n\n\nRealTrends America\u2019s Best Real Estate Professionals 2022 – named among the top 1.5% of the country\u2019s 1.6M real estate agents\n\n\nElite Circle 2021\n\n\nPREA 100 – top 100 agents in the United States\n\n\nTop of the Rock\n\n\nRanked Top 1% Realtors Nationwide Par Excellence\n\n\nMulti-Million Dollar Club\n\n\n","title":"","area_of_expertise":"Realtor, Team Leader","team":false,"office_cpt":false,"awards":false,"languages_spoken":[],"facebook":"https:\/\/www.facebook.com\/BHHSTheConwayTeam\/","twitter":"","instagram":"","pinterest":"","google_plus":"","linkedin":"","youtube":"","region_heading":"","region_description":"","agent_regions":false,"neighborhoods_heading":"","neighborhoods_description":"","agent_neighborhoods":false,"hide_properties_section":false,"agent_properties_section_heading":"","agent_properties_section_description":"","use_default_settings_for_agent_listings":true,"agent_featured_properties_settings":{"display_listings_in_tabs":false,"show_sales_tab":false,"show_sold_tab":false,"show_rentals_tab":false,"show_rented_tab":false,"show_commercial_sales_tab":false,"show_commercial_rental_tab":false,"show_commercial_sold_tab":false,"listing_type":["residential_sales"],"listing_status":["Active"],"limit":10,"must_have_photo":false,"min_bedrooms":"","min_bathrooms":"","min_price":"","show_only_my_properties":false,"office_ids":false,"ids":false,"sort_by":["listing_date_desc"],"backfill_properties_settings":{"agent_properties_count_less":"","show_only_exclusive":false,"es_filter_properties_by_teams":false,"more_backfill_criteria":{"listing_type":[],"listing_status":[],"must_have_photo":false,"min_bedrooms":"","min_bathrooms":"","min_price":"","sort_by":[]}}},"disable_search_with_me":false,"testimonial_section_title":"","testimonial_section_description":"","testimonials_data_source":"testimonials-cpt","testimonial_data":false,"enable_agent_press_section":false,"press_section_title":"","press_section_description":"","agent_primary_menu_id":"","agent_footer_menu_id":"","agent_custom_logo":false,"agent_multiple_mls_association":false,"custom_html":"","office_address":"","zillow":"","yelp":"","realtor":"","disable_listings_slider":false,"featured_listings_short_code":"","scripts":{"header_scripts":""}}

Listing provided courtesy of: BHHS Fox & Roach-Center City Walnut. The information included in this listing is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information on each listing is furnished by the owner and deemed reliable to the best of his/her knowledge, but should be verified by the purchaser. BRIGHT MLS assumes no responsibility for typographical errors, misprints or misinformation. This property is offered without respect to any protected classes in accordance with the law. Some real estate firms do not participate in IDX and their listings do not appear on this website. Some properties listed with participating firms do not appear on this website at the request of the seller. Information is deemed reliable but not guaranteed. © 2023 by BRIGHT MLS. All rights reserved. Listing last updated on 11/13/2023 10:27:56

bright_mls

Queen Village

Queen Village is a residential neighborhood of Philadelphia, Pennsylvania that lies along the eastern edge of the city, immediately south of Center City. It shares boundaries with Society Hill to the north, Bella Vista to the west and Pennsport to the south.

Visit

Get Your Instant Home Value…