meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217743' 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, 296 Santa Rosa Avenue, San Francisco, CA, 94112
ffd_mls_id, 421529526
ffd_salesforce_id, a0E1I00000TwyDiUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 296 Santa Rosa Avenue, San Francisco, CA, 94112
pba__address_pb__c, 296 Santa Rosa Avenue, San Francisco, CA, 94112
agent_only_remarks__c, https://calendly.com/samantha-huang/showing_296santa_rosa_ave Presale Escrow opened with Connie Choy at North American Title. Call / text Samantha @ 415-640-7602 for Questions. Disclosures available upon request and offer date TBD. Seller reserves the right to accept, reject or counter any offers.
appliances__c, Free Standing Gas Oven;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-03-26
ffd_createddate, 2021-03-20T21:49:24.000+0000
days_on_market__c, 853
dom__c, 25
ffd_description_pb, Welcome to Mission Terrace! A fabulous, detached, Four-bedroom, One bath home on the border of four desirable neighborhoods: Sunnyside, Bernal Heights, Glen Park, and Excelsior! The classic formal entryway opens to a large open formal living room, a formal dining room with period details, and view windows that showers the home with lots of natural sunlight. There are 3 large bedrooms and a bathroom in the upper level. The largest bedroom even has a private patio! The lower level has a bonus room and lots of potential to expand as your family needs. TWO car garage. Low maintenance backyard. Do not miss this special home that is close to shopping, restaurants, cafes, the newly renovated Balboa park, tennis courts, playground, dog park and skate board park. BART, MUNI, easy access to 101 & 280 freeways, Whole Foods, Canyon Market and Mission Street bodegas.
district__c, SF District 10
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Front Yard
pba__floortype_pb__c, Laminate
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:47:26.000+0000
pba__latitude_pb__c, 37.7289654
pba__latitude_property__c, 37.7289654
laundry_features__c, In Garage
listed_date__c, 2021-03-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Samantha
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 809630
ffd_listingagentname, Samantha J Huang
listing_agent_number__c, 1042187
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHG08
listing_office_name__c, Better Homes and Gardens Real Estate Thrive
listing_office_number__c, 26743
pba__listingprice_pb__c, 1098888
pba__listingtype__c, Sale
pba__listing_website__c, http://www.296santarosa.com/
pba__longitude_pb__c, -122.4397013
lower_level__c, Family Room
mls_id__c, 421529526
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-03-18
original_price__c, 1098888
overall_days_on_market__c, 104
parking_access__c, Side by Side
parking_features__c, Attached,Garage Facing Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-04-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 854.14
pba__propertytype__c, Single Family Residence
id, a0E1I00000TwyDiUAJ
sale_date__c, 2021-04-23
sale_price__c, 1300000
selling_agent_mls_id__c, 813225
selling_agent_number__c, 1060315
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1522
size__c, 1522
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Santa Rosa
subdist__c, Mission Terrace
ffd_name, 296 Santa Rosa Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530201646-2.jpg
ListingId, a0E1I00000TwyDiUAJ
