meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222394' 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, 57 Norwich Street, San Francisco, CA, 94110
ffd_mls_id, 422622068
ffd_salesforce_id, a0E8W00000V3BP7UAN
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 3
address2__c, 57 Norwich Street, San Francisco, CA, 94110
pba__address_pb__c, 57 Norwich Street, San Francisco, CA, 94110
agent_only_remarks__c, The patio off the bedroom was build by previous sellers on city land. Land is maintained by HOA. It is not deeded to this unit. Buyer to investigate. Please open escrow with Chris Matthews at Old Republic Title Company, Noe Valley. Offers due Tuesday, Feb 1st 10:00 am.
appliances__c, Dishwasher;Disposal;Free Standing Gas Oven;Free Standing Refrigerator;Electric Water Heater
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Carren S Shagley
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-01-20T23:48:05.000+0000
days_on_market__c, 1076
dom__c, 13
ffd_description_pb, Tech-Enabled Condo On Bernal's Coveted North Slope. Contemporary design & modern smart home amenities magically meet. Enjoy cityscape vistas while relaxing in the living room or serve up culinary delights entertaining in the open kitchen/dining areas. Sleek modern kitchen is fitted with steel appliances, hood over range, fridge and dishwasher. Revel in the high-speed optic internet connection. From Nest smart home amenities to the walk-in storage closet, contemporary bath, and combo washer/dryer; every detail has been thoughtfully considered. Retreat to the sizeable bedroom with large side-by-side closets for storage. Off the bedroom is a wonderful covered patio retreat to be enjoyed rain or shine. Located just one block from Precita Park and its surrounding cafe, restaurants, and corner stores mean you may never want to leave. Walking distance to parks, restaurants, shops and transportation. Close to 101 and 280 too.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Homeowners Insurance,Insurance,Maintenance Exterior,Trash,Water
pba__hoafees__c, 210
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T17:05:31.000+0000
pba__latitude_pb__c, 37.745039
pba__latitude_property__c, 37.745039
laundry_features__c, Inside Area;See Remarks
listed_date__c, 2022-01-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jennifer
pba__listing_agent_lastname__c, Burden
listing_agent_mls_id__c, 804035
ffd_listingagentname, Jennifer C Burden
listing_agent_number__c, 166013451
listing_co_agent_mls_id__c, 113506
listing_co_agent_number__c, 113506
listing_co_office_mls_id__c, LEGACY
listing_co_office_name__c, Legacy Real Estate
listing_co_office_number__c, 27760
listing_office_mls_id__c, LEGACY
listing_office_name__c, Legacy Real Estate
listing_office_number__c, 27760
pba__listingprice_pb__c, 779000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/668065369
pba__longitude_pb__c, -122.411568
mls_id__c, 422622068
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_property__c, a0O1I000001y7WxUAI
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-01-20
original_price__c, 779000
overall_days_on_market__c, -81103
pba__pendingdate__c, 2022-02-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1268.57
pba__propertytype__c, Condominium
id, a0E8W00000V3BP7UAN
road_surface_type__c, Asphalt
room_type__c, Storage;Kitchen;Primary Bedroom
sale_date__c, 2022-02-17
sale_price__c, 888000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, A402783
selling_agent_number__c, 981093470
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Adaire Keigwin, Broker
pba__status__c, Closed
pba__totalarea_pb__c, 700
size__c, 700
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Norwich
subdist__c, Bernal Heights
ffd_name, 57 Norwich Street, San Francisco, CA, 94110
view__c, City;City Lights;Downtown
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530389191_13292d4a-4360-44f0-800a-c1f60d409442.jpg
ListingId, a0E8W00000V3BP7UAN
_yoast_indexnow_last_ping, 1735676513