meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219015' 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, 247 Gates Street, San Francisco, CA, 94110
ffd_mls_id, 421553948
ffd_salesforce_id, a0E1I00000UTVFjUAP
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 247 Gates Street, San Francisco, CA, 94110
pba__address_pb__c, 247 Gates Street, San Francisco, CA, 94110
agent_only_remarks__c, Showings allowed w/PEAD-V form submitted prior and following current SIP protocol & proper PPE when showing. Please text or email for the fastest response to arrange showing/get instructions from my showing associate, JC Sosa (925) 200-6641 or me at (415) 515-2361 (cell)/email [email protected] or my. Please allow 24 hours to confirm showing. Disclosures io link, inspections due back this weekend: https://app.disclosures.io/link/247-Gates-St-4oid4fpp. Offers will be reviewed, WED 6/2 at 1pm. Please submit any offers on SFAR contract & include POF, Pre-Approval Letter and signed disclosure cover sheet. Pre-escrow opened at Old Republic Title Company w/Nate Scharton. Square footage on tax records, shows only top floor level square footage (1,000 Sq. Ft). Clients have original deed dating back to 1876. Year on tax records of build, also incorrect.
appliances__c, Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Victorian;Spanish
bath_features__c, Shower Stall(s);Tub;Tile;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1876
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-20T22:48:47.000+0000
days_on_market__c, 1322
dom__c, 14
ffd_description_pb, In the same family for 100+ yrs, on a highly-sought after Bernal Heights street, sits this historically charming Victorian home. Original details throughout including parquet wood floors, cove ceiling, fireplace and bay window in the formal living room which flows through the a beautiful archway leading to the spacious dining room. Steps away, a large eat in-kitchen w/breakfast area filled w/natural sunlight and peeking views of the bay. A guest bedroom/office sits adjacent, w/even better south-eastern views of our gorgeous SF Bay! A bright full bath w/shower & tub plus 2nd bedroom down the hall. Lower level, a sizeable primary bedroom w/en suite bath and private office/4th bed or guest quarters w/storage & separate entry! English-cottage inspired garden w/flower beds & patio/yard. Huge 2-car garage w/laundry + tons of storage space, additional basement level (expansion potential). A truly rare home ready to make your own. Prime location, walk to Cortland shops & dining, MUNI + parks!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Linoleum;Wood;Parquet
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:53:00.000+0000
pba__latitude_pb__c, 37.739603
pba__latitude_property__c, 37.739603
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-05-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joanna
pba__listing_agent_lastname__c, Rose
listing_agent_mls_id__c, 810961
ffd_listingagentname, Joanna Rose
listing_agent_number__c, 1048852
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REDF
listing_office_name__c, Redfin
listing_office_number__c, 64045
pba__listingprice_pb__c, 1198000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=wQWZUaNcm2W
pba__longitude_pb__c, -122.413794
lower_level__c, Master Bedroom
mls_id__c, 421553948
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-05-19
original_price__c, 1198000
overall_days_on_market__c, 105
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-06-02
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, a0E1I00000UTVFjUAP
room_type__c, Storage;Office;Bonus Room;Studio;Master Bedroom;Other
sale_date__c, 2021-07-06
sale_price__c, 1400000
selling_agent_mls_id__c, 805634
selling_agent_number__c, 206524902
selling_co_agent_mls_id__c, 807673
selling_co_agent_number__c, 1023668
selling_co_office_mls_id__c, COLD02
selling_co_office_name__c, Coldwell Banker Realty
selling_co_office_number__c, 874
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Gates
subdist__c, Bernal Heights
ffd_name, 247 Gates Street, San Francisco, CA, 94110
view__c, City;City Lights;Bay;Water;San Francisco;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1876
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530246263-1.jpg
ListingId, a0E1I00000UTVFjUAP
_yoast_indexnow_last_ping, 1735668548