meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326510' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15735
[post_author] => 4
[post_date] => 2018-11-02 20:00:49
[post_date_gmt] => 2018-11-02 20:00:49
[post_content] => Balboa Park BART. Single-family homeowners shuttling south to Silicon Valley or BARTing to downtown and points east. Balboa Park. An urban delight with an indoor swimming pool, outdoor ball fields, and a great playground. Ocean Avenue boutiques, grocery stores, restaurants, and more are a quick meander away.
[post_title] => Mission Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 20:00:49
[post_modified_gmt] => 2018-11-02 20:00:49
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15735
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 5020 Mission Street #4, San Francisco, CA, 94112
ffd_mls_id, 423723258
ffd_salesforce_id, a0E8W00000bEZIYUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 5020 Mission Street #4, San Francisco, CA, 94112
pba__address_pb__c, 5020 Mission Street #4, San Francisco, CA, 94112
agent_only_remarks__c, Property is eligible for the First Republic Eagle Community Loan Program as of 3/1/23 - $4K credit back, no prepay, and 4.8% on 30 year fixed. Contact Pippy Sou at First Republic for info [email protected] (415) 248-7376.
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 2004
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-24T11:48:46.000+0000
days_on_market__c, 35
dom__c, 35
ffd_description_pb, Mission Terrace contemporary top floor condo boasting 4 BRs & 2 BAs, terrific light, intuitive floor plan, sweet outlooks, a private balcony at the front of the unit, pkg, storage & laundry, on a convenient block close to amenities and transportation. This home is the perfect blend of style, comfort, & convenience w/windows throughout the unit providing great AM light in the front public spaces, & westerly light & views from the rear BRs. The floor plan is intuitive & well thought out, w/an open concept living area that seamlessly flows into the dining & kitchen spaces. The modern kitchen features updated appliances, sleek countertops, & plenty of storage space. The LR is spacious & comfortable, making it the perfect place to relax or entertain guests. The 4 BRs are generously sized including a spacious rear primary suite w/closets outfitted by California closets. Another great feature of this condo is its convenient location close to many amenities, including grocery stores, restaurants, cafes, & shops. Additionally, transportation options are plentiful, w/easy access to buses, BART, 280 and 101 freeways. Finally, the condo comes with a parking space, storage, shared laundry in the garage, along with convenient bike storage. Walkscore: 96, Transit Score: 87
district__c, SF District 10
electric__c, 220 Volts in Kitchen
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Heat,Insurance,Maintenance Exterior,Maintenance Grounds,Trash,Water
pba__hoafees__c, 575
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 5020 Mission St. HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Hot Water
ffd_lastmodifieddate, 2023-03-31T14:48:01.000+0000
pba__latitude_pb__c, 37.718281
pba__latitude_property__c, 37.718281
laundry_features__c, In Garage
listed_date__c, 2023-02-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Naomi
pba__listing_agent_lastname__c, Lempert Lopez
listing_agent_mls_id__c, 800407
ffd_listingagentname, Naomi Lempert Lopez
listing_agent_number__c, 800407
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 895000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=NrDd5R2k3nj&brand=0
pba__longitude_pb__c, -122.440015
mls_id__c, 423723258
master_property__c, a0O8W00000HtBFoUAN
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-24
open_house_end__c, 2023-04-04T16:00:00.000+0000
open_house_start__c, 2023-04-04T14:00:00.000+0000
original_price__c, 995000
overall_days_on_market__c, -81503
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-31T01:26:05.000+0000
price_per_square_foot__c, 590.76
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEZIYUA4
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1515
size__c, 1515
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, Mission Terrace
ffd_name, 5020 Mission Street #4, San Francisco, CA, 94112
view__c, City;San Francisco;Hills;Sutro Tower
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530583232-1.jpg