meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216405' 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] => 2024-04-12 12:23:14
[post_modified_gmt] => 2024-04-12 19:23:14
[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, 305 Santa Rosa 315 Avenue #9, San Francisco, CA, 94112
ffd_mls_id, 511045
ffd_salesforce_id, a0E1I00000TvOSwUAN
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 9
address2__c, 305 Santa Rosa 315 Avenue #9, San Francisco, CA, 94112
pba__address_pb__c, 305 Santa Rosa 315 Avenue #9, San Francisco, CA, 94112
agent_only_remarks__c, Showings subject to COVID-19 SIP guidelines. Pre-escrow opened with Kristin Therre at Old Republic. Please submit offers on 7 page SFAR contact, with POF/lender approval letter and signed disclosures. Please contact Evan Bliss at 415-816-9225/[email protected] or Michelle Balog at 415-810-7890/[email protected] with any questions or showing requests. Supra lockbox with additional code. See disclosures. Please schedule your showing here: https://calendly.com/michelle-balog-bayregroup/305-315-santa-rosa-avenue-9
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2003
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Michelle L Balog
pba__contingentdate__c, 2021-02-28
ffd_createddate, 2021-01-08T01:48:13.000+0000
days_on_market__c, 923
dom__c, 62
ffd_description_pb, Welcome home to this great top floor condo! A fantastic 2 bedroom/2 bathroom corner unit in the desirable Mission Terrace neighborhood. Once inside you will find a spacious open floor plan including a large living room with a gas burning fireplace. Stepping through the patio doors you will find a large outdoor space for your enjoyment. The dining area is just past the living room and a great space to accommodate your next dinner party. Just off the dining area is the well appointed kitchen featuring stainless steel appliances and granite countertops. Nestled in the back of the home are two large bedrooms; one with en suite and dual closets. Both have brand new carpet! A freshly painted interior, crown molding, skylights, in unit laundry hook-ups, 2 outdoor spaces and 1 parking space complete this home. *Some Photos are virtually staged
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floor__c, 0
hoa_dues__c, 593
pba__hoafees__c, 593
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:41:52.000+0000
pba__latitude_pb__c, 37.72889
pba__latitude_property__c, 37.72889
laundry_appliances__c, Hookups Only,In Closet
laundry_features__c, Laundry Closet;Hookups Only
listed_date__c, 2020-09-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Richard Evan
pba__listing_agent_lastname__c, Bliss
listing_agent_mls_id__c, 808381
ffd_listingagentname, Evan Bliss
listing_agent_number__c, 1034267
listing_co_agent_mls_id__c, 803379
listing_co_agent_number__c, 803379
listing_co_office_mls_id__c, BAYRE
listing_co_office_name__c, Bay Real Estate Group
listing_co_office_number__c, 28186
listing_office_mls_id__c, BAYRE
listing_office_name__c, Bay Real Estate Group
listing_office_number__c, 28186
pba__listingprice_pb__c, 879000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=SRcoTHdxRFK
pba__longitude_pb__c, -122.440469
pba__lotsize_pb__c, 0
mls_id__c, 511045
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I00000BpR0mUAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-01-07
original_price__c, 879000
overall_days_on_market__c, 83
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-03-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 612.83
pba__propertytype__c, Condominium
id, a0E1I00000TvOSwUAN
sale_date__c, 2021-03-19
sale_price__c, 850000
selling_agent_mls_id__c, 811989
selling_agent_number__c, 1054273
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1387
size__c, 1387
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Santa Rosa
subdist__c, Mission Terrace
ffd_name, 305 Santa Rosa 315 Avenue #9, San Francisco, CA, 94112
transportation__c, 1 Block
unit_number__c, 9
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2003
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375340-1.jpg
ListingId, a0E1I00000TvOSwUAN