meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='335485' 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] => 2023-09-21 11:43:21
[post_modified_gmt] => 2023-09-21 18:43: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, 456 Ellsworth Street, San Francisco, CA, 94110
ffd_mls_id, 423734963
ffd_salesforce_id, a0E8W00000cJWGzUAO
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 456 Ellsworth Street, San Francisco, CA, 94110
pba__address_pb__c, 456 Ellsworth Street, San Francisco, CA, 94110
agent_only_remarks__c, Received 4 offers. NO Preemptive offers per seller instruction. Offer Date, Wednesday, June 21st @ 10am. Pre-Escrow opened with Barbara Jimenez, Chicago Title, #3652300213. Questions, TEXT Charles Loiacono at 732-670-6860. Property Sold "AS-IS.''
appliances__c, Gas Water Heater;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Cottage
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sabrina Gee-Shin
pba__contingentdate__c, 2023-06-21
ffd_createddate, 2023-06-15T19:48:29.000+0000
days_on_market__c, 34
dom__c, 12
ffd_description_pb, 456 Ellsworth is magical. Walking up to her, you know that there's a rich history. This charming 2 bed, 1 bath home was lovingly renovated, restored and updated to become an organic and dependable retreat. The woodwork provides a warmth that is perfectly Bernal. The layout has great flow with living, dining, kitchen, office area and bathroom on the main level and the two bedrooms upstairs. In 1999, major remodel included new electrical, heating installed, dual pane Pella windows put in, roof timbers structurally strengthened, and more! This home gets great natural light and the kitchen window overlooks the rear fenced yard. She's a beauty on a wonderful Bernal block with lovely neighbors. Only one block to Cortland Avenue's shopping district, including Bernal Public Library, The Good Life Grocery, Martha & Bros Coffee Co, Piqueos. Near Holly Park, Bernal Heights Park, St. Mary's Recreation Center, and Precita Park. Easy access to 101, 280, BART and MUNI.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced;Front Yard;Masonry
pba__floortype_pb__c, Laminate;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-18T02:47:35.000+0000
pba__latitude_pb__c, 37.73768
pba__latitude_property__c, 37.73768
laundry_features__c, Other;Washer Included;Dryer Included
listed_date__c, 2023-04-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charles
pba__listing_agent_lastname__c, Loiacono
listing_agent_mls_id__c, 811340
ffd_listingagentname, Charles Loiacono
listing_agent_number__c, 1050901
listing_co_agent_mls_id__c, 804986
listing_co_agent_number__c, 166014733
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.embracebernal.com/mls/103762321
pba__longitude_pb__c, -122.414864
mls_id__c, 423734963
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-06-15
original_price__c, 998000
overall_days_on_market__c, -81614
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-06-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-07-17T13:12:13.000+0000
price_per_square_foot__c, 1288.89
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJWGzUAO
roof__c, Other
room_type__c, Kitchen;Living Room;Dining Room
sale_date__c, 2023-07-17
sale_price__c, 1160000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 817049
selling_agent_number__c, 1075957
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 900
size__c, 900
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Ellsworth
subdist__c, Bernal Heights
ffd_name, 456 Ellsworth Street, San Francisco, CA, 94110
view__c, Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530633688-1.jpg