meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212375' 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, 29 Joy Street, San Francisco, CA, 94110
ffd_mls_id, 498587
ffd_salesforce_id, a0E1I00000Sm4NWUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 29 Joy Street, San Francisco, CA, 94110
pba__address_pb__c, 29 Joy Street, San Francisco, CA, 94110
agent_only_remarks__c, Harcourts Auctions Certified & Transparent Non-Distressed Auction Platform! Live Auction! Bidding to start from $1,800,000! Live Auction June 18, 2020 @ 12pm. No Buyer Premium. All Property, Seller Reports/Disclosures completed. Download at www.tinyurl.com/29JoyStreet All offers encouraged. Submit offer to stop auction -- loan or cash. Easy process to register to bid. Online bidding and streaming available.
appliances__c, Gas Range;Microwave;Refrigerator
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2017
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Glendy M Hsu
pba__contingentdate__c, 2020-06-17
ffd_createddate, 2020-05-23T10:46:41.000+0000
days_on_market__c, 1152
dom__c, 32
ffd_description_pb, Luxury Live Auction! Bidding to start from $1,800,000! Semi-detached, built in 2017, this house is impeccable with its ultra-clean architectural lines and floorplan that flows across 3 levels. Towering ceilings and huge windows produce immense volume and light. Exquisite materials: oak floors, steel railings, glass banisters, stone finishes, etc. Ideal for entertaining with open-concept main level kitchen, dining, and living room. Top-of-the-line chef's kitchen with sleek wood-grained cabinetry, marble counters, unique crystal pendant lighting, and a 6-burner Thermador range, dishwasher, and fridge. Two en-suite bedrooms with stylish baths and California closets. Spectacular master suite with 11-foot ceilings and 2 large walk-in California closets and spa-like bath. High-tech feat. and systems: Nest thermostats, built-in ceiling speakers on each level, radiant heat, and tankless water heater. Large rooftop deck with 360-degree views. 3D Virtual Tour: tinyurl.com/yaynrqtc
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-25T15:23:16.000+0000
pba__latitude_pb__c, 37.743749
pba__latitude_property__c, 37.743749
laundry_features__c, Inside Room;Washer/Dryer Included;Hookups Only
listed_date__c, 2020-05-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alicia
pba__listing_agent_lastname__c, Tam
listing_agent_mls_id__c, 803346
ffd_listingagentname, Alicia Tam
listing_agent_number__c, 803346
listing_co_agent_mls_id__c, 115260
listing_co_agent_number__c, 115260
listing_co_office_mls_id__c, BHHS
listing_co_office_name__c, Berkshire Hathaway HomeServices California Realty
listing_co_office_number__c, 25640
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1800000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=WcZbZopQvSf&brand=0
pba__longitude_pb__c, -122.407119
pba__lotsize_pb__c, 0
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 498587
main_level__c, Kitchen;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-23
original_price__c, 1800000
overall_days_on_market__c, 89
parking__c, Garage,Auto Door,Interior Access
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-06-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 896.13
pba__propertytype__c, Single Family Residence
id, a0E1I00000Sm4NWUAZ
room_type__c, Laundry
sale_date__c, 2020-07-21
sale_price__c, 2200000
security_features__c, Smoke Detector;Fire Alarm;Fire Suppression System
selling_agent_mls_id__c, 800238
selling_agent_name__c, Barbara S. Friedman
selling_agent_number__c, 800238
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2455
size__c, 2455
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Joy
subdist__c, Bernal Heights
ffd_name, 29 Joy Street, San Francisco, CA, 94110
view__c, Panoramic;City Lights;Bay;Water
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
pba__yearbuilt_pb__c, 2017
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363497-1.jpg
ListingId, a0E1I00000Sm4NWUAZ