meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375289' 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-11-11 10:53:21
[post_modified_gmt] => 2024-11-11 18:53:21
[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, 1735680531
ffd_listing_title, 115 Andover Street, San Francisco, CA, 94110
ffd_mls_id, 423920249
ffd_salesforce_id, a0E8W00000dxZpgUAE
num_of_fireplaces__c, 0
num_of_rooms__c, 12
of_units__c, 0
address2__c, 115 Andover Street, San Francisco, CA, 94110
pba__address_pb__c, 115 Andover Street, San Francisco, CA, 94110
agent_only_remarks__c, The 3R states the property is a one family dwelling. 115 Andover Street (main house) is tenant occupied, 115 Andover Street unit #B (lower level unit) is tenant occupied, and 115 Andover Street unit #E (cottage) is tenant occupied, all on month-to-month rental terms. The garage was converted to a living space and will be delivered vacant. The disclosure packet is accessible on homelight/IO and here is the link: https://app.disclosures.io/link/115-Andover-Street-5hi2tapx The tenant in the lower level unit performed and ERMI test of their unit, and the results show some mold samples. The results will be provided to all visitors, and anyone who chooses to enter this unit should follow advised health safety protocols. No personal protective equipment will be provided. There will be NO photographs or videos allowed in the tenant occupied units, per the request of the tenants. Please contact the listing agent with additional questions.---OFFER DATE WEDNESDAY 11/15/23 BY 9:00AM---
architectural_style__c, Victorian;Traditional;Rustic
bath_features__c, Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 7
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-11-03T17:47:37.000+0000
days_on_market__c, 424
dom__c, 18
ffd_description_pb, Spectacular opportunity to own a detached single-family home with an over-sized lot in a stately setting and located in a sensational Bernal Heights location! The main house features a versatile floor plan with four bedrooms, office space, two bathrooms, and a living/dining/kitchen area that overlooks the courtyard. There is a lower-level living space with a spacious bedroom, living/dining/kitchen area, and a bathroom. The colorful courtyard with climbing foliage centers the property offering a peaceful, Zen-like outdoor space, and a charming cottage with vaulted ceilings and a private deck is tucked away at the back of the property. The garage was converted to a living space and interested buyers can research the possibility of converting the garage space back to parking. This is a truly unique property with many possibilities situated in an ideal Bernal Heights location near Bernal Hill, restaurants, cafes, shops, playgrounds, breweries, shopping, public transportation, HWY 101/280 and more!
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;Entry Gate
external_listing__c, 1
fencing__c, Wood;Fenced
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2024-04-04T22:47:18.000+0000
pba__latitude_pb__c, 37.7414244
pba__latitude_property__c, 37.7414244
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2023-11-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Salgado
listing_agent_mls_id__c, 805001
ffd_listingagentname, Jeffrey A Salgado
listing_agent_number__c, 166014760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 959000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4161628
lower_level__c, Full Bath(s),Kitchen,Living Room,Street Entrance
mls_id__c, 423920249
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-11-03
original_price__c, 959000
overall_days_on_market__c, -81755
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-11-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-04T09:44:58.000+0000
price_per_square_foot__c, 354.14
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dxZpgUAE
road_surface_type__c, Paved
room_type__c, Bonus Room;Den;Kitchen;Studio;In Law Apartment;Converted Garage;Family Room
sale_date__c, 2024-04-01
sale_price__c, 942000
security_features__c, Security Gate
selling_agent_mls_id__c, MLSL5098932
selling_agent_number__c, 981397920
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, a1WHt00000Ol8ND
pba__status__c, Closed
pba__totalarea_pb__c, 2660
size__c, 2660
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Andover
subdist__c, Bernal Heights
ffd_name, 115 Andover Street, San Francisco, CA, 94110
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/530700572-1.jpg