meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212763' 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
(
)
)
ffd_listing_title, 236 Holladay Avenue, San Francisco, CA, 94110
ffd_mls_id, 499702
ffd_salesforce_id, a0E1I00000Sy3OQUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 236 Holladay Avenue, San Francisco, CA, 94110
pba__address_pb__c, 236 Holladay Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Online virtual tour (pre-staged) available at https://my.matterport.com/show/?m=nHePFYQ1kHd. Live virtual tours available via Facebook/Facetime by appointment. Property website with floor plan here: www.236Holladay.com. Email [email protected] for more information. Showings by appointment under state and local guidelines for qualified prospects. Contact listing agent for showing protocol. All visitors to execute the PEAD addendum. Compass Shown Property COVID-19 Plan: https://drive.google.com/file/d/1KOevjT-8R-lvBdn79akm1p0DMhBIHvrY/view
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Double Oven;Built-In Oven
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1965
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Todd Montgomery
pba__contingentdate__c, 2020-08-03
ffd_createddate, 2020-07-17T18:45:23.000+0000
days_on_market__c, 1097
dom__c, 39
ffd_description_pb, Modernized Bernal Heights mid-century home exudes all the hallmarks of a newer construction space with a functional 3 BD 2 BA layout. 236 Holladay's desirable open floor plan is perfect for living, working, and studying from home with great light, a lush private rear garden, and an incredible location. The home we through a recent 'down-to-the-studs' update with a renovated gourmet kitchen, an open-concept living area with a broad window-line and wide plank hardwood floors, three efficient bedrooms, and two well updated baths on the mezzanine level. Features ample storage space, 2-car garage parking with an electric car charger, and amazing flexibility with outdoor space in a convenient location. Easily access any destination in the city or peninsula with an array of shopping and dining along the Cortland commercial corridor and the Alemany Farmer's Market is always at your disposal.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:25:03.000+0000
pba__latitude_pb__c, 37.745869
pba__latitude_property__c, 37.745869
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-06-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marcus
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 804756
ffd_listingagentname, Marcus A Lee
listing_agent_number__c, 166014430
listing_co_agent_mls_id__c, 807753
listing_co_agent_number__c, 1025356
listing_co_office_mls_id__c, COMP47
listing_co_office_name__c, Compass
listing_co_office_number__c, 28243
listing_office_mls_id__c, COMP47
listing_office_name__c, Compass
listing_office_number__c, 28243
pba__listingprice_pb__c, 1475000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=nHePFYQ1kHd
pba__longitude_pb__c, -122.405559
pba__lotsize_pb__c, 0.04
mls_id__c, 499702
main_level__c, Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-07-17
original_price__c, 1475000
overall_days_on_market__c, 106
parking__c, Attached,Garage,Interior Access
parking_features__c, Attached,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-08-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000Sy3OQUAZ
room_type__c, Storage
sale_date__c, 2020-09-17
sale_price__c, 1475000
selling_agent_mls_id__c, A323904
selling_agent_number__c, 981096361
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Holladay
subdist__c, Bernal Heights
ffd_name, 236 Holladay Avenue, San Francisco, CA, 94110
transportation__c, 4+ Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1965
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364804-1.jpg
ListingId, a0E1I00000Sy3OQUAZ