meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213283' 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, 3585 Mission 3587 Street, San Francisco, CA, 94110
ffd_mls_id, 501545
ffd_salesforce_id, a0E1I00000S11XPUAZ
num_of_fireplaces__c, 2
num_of_rooms__c, 10
of_units__c, 0
address2__c, 3585 Mission 3587 Street, San Francisco, CA, 94110
pba__address_pb__c, 3585 Mission 3587 Street, San Francisco, CA, 94110
agent_only_remarks__c, Ready to show! Call or text listing agent Samantha at 415-640-7602 or Jade at 415-405-5737 for questions. Keep escrow with Connie Choy at NAT as seller doing 1031 exchange with no cost to buyers. Disclosures available upon request and call or email agents for offer instructions.
appliances__c, Dishwasher;Electric Range;Refrigerator;Built-In Oven
architectural_style__c, Contemporary;Traditional
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1978
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Samantha J Huang
pba__contingentdate__c, 2020-10-30
ffd_createddate, 2020-08-12T04:09:36.000+0000
days_on_market__c, 1630
dom__c, 104
ffd_description_pb, Vacant Duplex in Bernal Heights / Mission bordering Glen Park and Noe Valley. Just a five minute walk to Bernal Heights Park. Top floor unit is a 2 bedroom 2 bath at almost 1500 ft. . Bottom unit is 2 bedrooms 1 bath at about 1300 ft. . Both units are very spacious, well laid out with bedrooms in the rear and lots of natural light. Both units have been newly refreshed and ready for immediate occupancy by new owner or tenant. Great opportunity with many flexible potential strategies for new buyer depending on chosen approach. FastTrack condo conversion / TIC conversion - resale / private family compound / rental investment property / combination. Large enclosed parking garage with laundry facilities, multi level deck for each unit and nice low maintenance backyard. Great location with easy access freeways and public transportation. Easy to Show.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:27:51.000+0000
pba__latitude_pb__c, 37.739185
pba__latitude_property__c, 37.739185
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-07-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jade
pba__listing_agent_lastname__c, Dou
listing_agent_mls_id__c, 813757
ffd_listingagentname, Jade Dou
listing_agent_number__c, 1062995
listing_co_agent_mls_id__c, 809630
listing_co_agent_number__c, 1042187
listing_co_office_mls_id__c, BHG08
listing_co_office_name__c, Better Homes and Gardens Real Estate Thrive
listing_co_office_number__c, 26743
listing_office_mls_id__c, BHG08
listing_office_name__c, Better Homes and Gardens Real Estate Thrive
listing_office_number__c, 26743
pba__listingprice_pb__c, 1698000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/uhPKOedR9VY
pba__longitude_pb__c, -122.423633
pba__lotsize_pb__c, 0.05
lower_level__c, Bedroom(s),Dining Room,Full Bath(s),Kitchen,Living Room
mls_id__c, 501545
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-07-15
original_price__c, 1800000
overall_days_on_market__c, 169
parking__c, Detached,Garage,Interior Access
parking_access__c, Tandem
parking_features__c, Detached,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-11-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 557.55
pba__propertytype__c, Single Family Residence
id, a0E1I00000S11XPUAZ
sale_date__c, 2020-11-23
sale_price__c, 1550000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 804623
selling_agent_name__c, Joan H. Meyer
selling_agent_number__c, 191006143
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Better Homes and Gardens Real Estate Thrive
pba__status__c, Closed
pba__totalarea_pb__c, 2780
size__c, 2780
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Mission
subdist__c, Bernal Heights
ffd_name, 3585 Mission 3587 Street, San Francisco, CA, 94110
transportation__c, 1 Block
view__c, Park;City Lights;San Francisco;Hills;Woods
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1978
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/366302-1.jpg
ListingId, a0E1I00000S11XPUAZ
_yoast_indexnow_last_ping, 1735656255