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.
{"_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":"1723006850000"}},"designation":null,"last_seen_in_mls":{"$date":{"$numberLong":"1728297012000"}},"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":""}}