meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374983' 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, 1711760186
ffd_listing_title, 5 Joy Street, San Francisco, CA, 94110
ffd_mls_id, 424009197
ffd_salesforce_id, a0EUd000001AyyPMAS
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 5 Joy Street, San Francisco, CA, 94110
pba__address_pb__c, 5 Joy Street, San Francisco, CA, 94110
agent_only_remarks__c, Contact Mike Stack for private showings and offer instructions. [email protected] | 415.580.9095
appliances__c, Dishwasher;Built-In Gas Oven;Wine Refrigerator;Built-In Refrigerator
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, MultiZone
ffd_createddate, 2024-02-16T01:47:55.000+0000
days_on_market__c, 43
dom__c, 26
ffd_description_pb, 5 Joy Street is a thoughtfully designed 3-bedroom, 3.5-bathroom single family home with exceptional natural light and designer finishes. The main level features an open floor plan with spacious living and dining areas and a Chef's kitchen with top-of-the line appliances, quartz countertops, ample storage, and a peninsula. This level also offers direct access to a large patio, perfect for outdoor dining and entertaining. The top floor features a large primary suite with a private deck and verdant outlooks, a second ensuite bedroom, and a beautiful office area with sweeping views. The entry level features the third ensuite bedroom with direct access out to the second private patio, perfect for guests visiting. Additional features include a 1-car garage, built-in speakers, and air conditioning. 5 Joy Street is located on the east slope of Bernal Heights, close to the shopping and dining corridor along Cortland Avenue and around the corner from Bernal Heights and Precita Parks. This premier location offers you access to the best of San Francisco: Oracle Park, Chase Center, and the Peninsula via Interstate 280 & Highway 101.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, MultiZone
ffd_lastmodifieddate, 2024-03-30T00:48:00.000+0000
pba__latitude_pb__c, 37.743637
pba__latitude_property__c, 37.743637
laundry_features__c, Hookups Only
listed_date__c, 2024-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Keane-Stack
listing_agent_mls_id__c, 808954
ffd_listingagentname, Mike R Keane-Stack
listing_agent_number__c, 1038676
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.5joyst.com
pba__longitude_pb__c, -122.406617
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 424009197
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-15
original_price__c, 1695000
overall_days_on_market__c, -81859
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 873.71
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001AyyPMAS
sale_date__c, 2024-03-29
sale_price__c, 1695000
selling_agent_mls_id__c, 814030
selling_agent_number__c, 1064061
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joy
subdist__c, Bernal Heights
ffd_name, 5 Joy Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530732354-1.jpg