meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385596' 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
(
)
)
_yoast_indexnow_last_ping, 1725501221
ffd_listing_title, 159 Faith Street, San Francisco, CA, 94110
ffd_mls_id, 424052025
ffd_salesforce_id, a0EUd000002orw4MAA
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 159 Faith Street, San Francisco, CA, 94110
pba__address_pb__c, 159 Faith Street, San Francisco, CA, 94110
agent_only_remarks__c, Use 151 Brewster for your GPS! Home entrance is NOT on Faith, and as such is beautifully shielded from the outlooks and sound of the highway. Lower level is not included in square footage, and presents incredible upside. Home is successor trustee sale, no probate confirmation. Adjacent lot (155 Faith) owned by same trustee; sale includes both parcels in purchase agreement and to close concurrently. Seller willing to consider Buyer concessions.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional;Cottage
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-08-09T22:48:17.000+0000
days_on_market__c, 26
dom__c, 6
ffd_description_pb, A San Francisco fairytale home: floating among the canopy of mature eucalyptus trees and set on a Double Lot in prime Bernal Heights. Flooded in light, the home immediately captivates and inspires with 10' ceilings and classic original detailing that showcase scale and volume. Just-remodeled eat-in kitchen w/ floating vintage walnut shelves, sunny skylight, all new appliances and cabinetry, and opens to the sunny south facing walk-out entertaining deck and zen gardens. The primary suite, on the upper level of the home, is surrounded in sunny windows with extraordinary privacy and built in cabinetry. On the main level, two bedrooms and a newly remodeled bath offer added flexibility for guest bedrooms, office space, or a library. Extraordinary upside potential with an unfinished 800 sqft basement that would have immediate value add as a separate office, play room, wine cellar, or gym. Listing also includes the neighboring vacant parcel, allowing this true double-lot to act as a full-sized yard for garden parties, children's play, or future development, or lot split. One car garage with interior access, laundry, off-street parking area, and immense privacy. ***GPS to 151 Brewster for home, garage, and street parking**
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Balcony;Dog Run
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2024-09-05T01:46:51.000+0000
pba__latitude_pb__c, 37.7442315
pba__latitude_property__c, 37.7442315
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2024-08-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Neal
pba__listing_agent_lastname__c, Ward
listing_agent_mls_id__c, 308772
ffd_listingagentname, Neal A Ward
listing_agent_number__c, 308772
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1650000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/997958358?share=copy
pba__longitude_pb__c, -122.4070613
lower_level__c, Garage,Street Entrance
mls_id__c, 424052025
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-08-09
original_price__c, 1650000
overall_days_on_market__c, -82035
parking_access__c, Side by Side
parking_features__c, Garage Facing Front,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-08-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-09-04T12:32:41.000+0000
price_per_square_foot__c, 1134.93
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002orw4MAA
road_surface_type__c, Asphalt
room_type__c, Storage;Bonus Room
sale_date__c, 2024-09-04
sale_price__c, 1800000
selling_agent_mls_id__c, 810722
selling_agent_number__c, 1047611
selling_co_agent_mls_id__c, 810590
selling_co_agent_number__c, 1047194
selling_co_office_mls_id__c, COMP90
selling_co_office_name__c, Compass
selling_co_office_number__c, 29048
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1586
size__c, 1586
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Faith
subdist__c, Bernal Heights
ffd_name, 159 Faith Street, San Francisco, CA, 94110
view__c, City;Panoramic;Garden/Greenbelt;Bay;Valley
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530824051-1.jpg
