meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236165' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15717
[post_author] => 4
[post_date] => 2018-11-02 19:54:32
[post_date_gmt] => 2018-11-02 19:54:32
[post_content] => Once a San Francisco skunkworks flying pirate flags filled with humble Victorian cottages owned by ladies who loved ladies and looked forward to long dog walks. Then it gentrified. Silicon Valley stock options splurged on homes here. Dwell magazine arrived next to document the results. While it might be one Bernal, the neighborhood has several distinct geographic vibes and styles. It's not complicated, perhaps recently algorithmically optimized?
[post_title] => Bernal Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bernal-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:39:15
[post_modified_gmt] => 2024-04-11 15:39:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15717
[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, 39 Santa Marina Street, San Francisco, CA, 94110
ffd_mls_id, 422620457
ffd_salesforce_id, a0E8W00000V2xmgUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 39 Santa Marina Street, San Francisco, CA, 94110
pba__address_pb__c, 39 Santa Marina Street, San Francisco, CA, 94110
agent_only_remarks__c, Offers welcome as they come. Easy to show. Just call for combo lock box code. For disclosures: https://app.disclosures.io/link/39-Santa-Marina-Street-bvvs4xcq. Please open escrow with Chris Matthews at Old Republic Title Company, Noe Valley Office.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Built-In Gas Oven;Free Standing Refrigerator
architectural_style__c, Cottage
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Carren S Shagley
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-01-13T21:47:06.000+0000
days_on_market__c, 552
dom__c, 50
ffd_description_pb, Steeped in history & steps from Bernal village. Thoughtfully redesigned over 2 levels, this home offers the very best in SF living. Close to Bernal, Mission, Noe Valley & Glen Park centers. Enter on street level into living room complete with period details & decorative fireplace. Large, eat-in sunny kitchen with high ceilings, skylight & nice outlooks. Flexible floor plan-staged as 2 bedrooms on the main level. However, one of the bedrooms could be a formal dining room. A full bathroom completes the main level. Lower level has spacious family room & small bedroom & 2nd bathroom. Family room opens to comfortable, level backyard that is perfect for relaxing or hanging out with friends. Small bedroom can be used as home office or nursery & family room could be used as a luxurious primary bedroom. Options abound. Walk score of 97. Close to public transportation, 101, 280 & tech shuttles. Just a short stroll to shops, restaurants & parks.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2022-05-27T01:47:49.000+0000
pba__latitude_pb__c, 37.740407
pba__latitude_property__c, 37.740407
laundry_features__c, In Kitchen;Washer Included;Dryer Included;Stacked Only
listed_date__c, 2022-01-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jennifer
pba__listing_agent_lastname__c, Burden
listing_agent_mls_id__c, 804035
ffd_listingagentname, Jennifer C Burden
listing_agent_number__c, 166013451
listing_co_agent_mls_id__c, 113506
listing_co_agent_number__c, 113506
listing_co_office_mls_id__c, LEGACY
listing_co_office_name__c, Legacy Real Estate
listing_co_office_number__c, 27760
listing_office_mls_id__c, LEGACY
listing_office_name__c, Legacy Real Estate
listing_office_number__c, 27760
pba__listingprice_pb__c, 1238000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/665490170
pba__longitude_pb__c, -122.42214
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 422620457
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance
master_bathroom_features__c, Tub w/Shower Over;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-01-13
original_price__c, 1238000
overall_days_on_market__c, -81096
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2022-03-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1083.14
pba__propertytype__c, Single Family Residence
id, a0E8W00000V2xmgUAB
road_surface_type__c, Asphalt
room_type__c, Storage;Office;Kitchen;Living Room;Family Room;Possible Guest;Primary Bedroom
sale_date__c, 2022-03-18
sale_price__c, 1420000
security_features__c, Security Gate
selling_agent_mls_id__c, 812220
selling_agent_number__c, 1055597
selling_co_agent_mls_id__c, 816690
selling_co_agent_number__c, 1075641
selling_co_office_mls_id__c, BERRI
selling_co_office_name__c, Berri Real Estate
selling_co_office_number__c, 26699
selling_office_name__c, Berri Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1311
size__c, 1311
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Santa Marina
subdist__c, Bernal Heights
ffd_name, 39 Santa Marina Street, San Francisco, CA, 94110
view__c, Hills;Other
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530385891-1.jpg
ListingId, a0E8W00000V2xmgUAB