meta_query='key:subdist__c;value:Crocker Amazon|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220059' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 384922
[post_author] => 1554
[post_date] => 2018-11-30 20:31:17
[post_date_gmt] => 2018-12-01 04:31:17
[post_content] => South of the Excelsior, north of Daly City. Classic single-family San Francisco homes in a historically working-class neighborhood with a county line running across it from east to west. A little more spacious than the Excelsior, but not so spacious that you'll think you've left the city.
[post_title] => Crocker Amazon
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => crocker-amazon
[to_ping] =>
[pinged] =>
[post_modified] => 2024-10-31 12:38:07
[post_modified_gmt] => 2024-10-31 19:38:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://jacksonfuller.com/sf/crocker-amazon/
[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, 12 Brumiss Terrace, San Francisco, CA, 94112
ffd_mls_id, 421574788
ffd_salesforce_id, a0E1I00000UVDQCUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 12 Brumiss Terrace, San Francisco, CA, 94112
pba__address_pb__c, 12 Brumiss Terrace, San Francisco, CA, 94112
agent_only_remarks__c, Please Keep social distance while showing. Call or Text L/A 6504558878 for any question(s). Motivated Seller! Disclosures Link: https://app.disclosures.io/link/12-Brumiss-Terrace-gmt9rsoe
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-07-21T10:49:17.000+0000
days_on_market__c, 1259
dom__c, 36
ffd_description_pb, A clean classic and spacious property in a nice neighborhood. Currently use as three bedrooms and two baths on the main floor with lots of natural light and beautiful hardwood floor. Legal two bedrooms, one office den and one bath on lower level with separate main entrance. Storage room situated on the low maintenance yard. Conveniently located within walking distance to shops, eateries and public transportation to City College of San Francisco and State University! Home has much of original charm, it is a rare opportunity for first home buyers and investors!
district__c, SF District 10
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Den;Dining Room;Kitchen
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:57:37.000+0000
pba__latitude_pb__c, 37.708527
pba__latitude_property__c, 37.708527
laundry_features__c, Hookups Only
listed_date__c, 2021-07-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Victoria
pba__listing_agent_lastname__c, Lam
listing_agent_mls_id__c, 981326
ffd_listingagentname, Victoria C Lam
listing_agent_number__c, 981326
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1250000
pba__listingtype__c, Sale
pba__listing_website__c, https://focusedaerial.gofullframe.com/ut/12_Brumiss_Ter.html
pba__longitude_pb__c, -122.451968
mls_id__c, 421574788
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-07-21
original_price__c, 1250000
overall_days_on_market__c, 102
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-08-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 604.45
pba__propertytype__c, Single Family Residence
id, a0E1I00000UVDQCUA5
roof__c, Tar/Gravel
room_type__c, Storage;Den;Kitchen;Master Bathroom;Family Room
sale_date__c, 2021-10-05
sale_price__c, 1250000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 981326
selling_agent_number__c, 981326
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, 2068
size__c, 2068
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Brumiss
subdist__c, Crocker Amazon
ffd_name, 12 Brumiss Terrace, San Francisco, CA, 94112
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530284863-1.jpg
ListingId, a0E1I00000UVDQCUA5
_yoast_indexnow_last_ping, 1735670651