meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237450' 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, 37 Winfield Street, San Francisco, CA, 94110
ffd_mls_id, 422657206
ffd_salesforce_id, a0E8W00000Xi5EnUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 37 Winfield Street, San Francisco, CA, 94110
pba__address_pb__c, 37 Winfield Street, San Francisco, CA, 94110
agent_only_remarks__c, Please use latest SFAR PC with Contingency Removal Form, and include PoF, Pre-Approval letter and Signed DP with offer. Email Listing Agent - pls do NOT text.
appliances__c, Dishwasher;Hood Over Range;Electric Cook Top;Free Standing Refrigerator;Free Standing Electric Oven
architectural_style__c, Contemporary;Craftsman
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-10T15:46:29.000+0000
days_on_market__c, 432
dom__c, 27
ffd_description_pb, Adorable vintage craftsman style meets modern contemporary mindset. Stunning GrtRm w view infused open Liv/Din/Kit experience, big volume & walkout deck, offers stunning 1-of-a-kind living perched on Bernal's prime Northwest slope! Super-sized LivRm w hi ceilings, recessed lighting control & indr/outdr living, has beautiful craftsman details h/w flrs & large en-suite DinRm area, perfect for entertaining & family gatherings - all w spectacular City views. Modern Kit sports gleaming quartz cntrs, new SS apps & new designer tile flring. Mstr Bed @ back boasts big walk-in closet, large 2nd closet. Sparkling recently remod designer tile Bath w Euro style fixt. Sliding Frnch doors to back yard patio oasis. Lwr lvl WFH office & private bed/bath suite have separate access, great for guests/in-laws, or profess work services. Side path also gives access to gorgeous back yard patio w built-in seating & firepit. 2car garage w interior access workshop & storage. A+ location!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:09:57.000+0000
pba__latitude_pb__c, 37.744642
pba__latitude_property__c, 37.744642
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shelley
pba__listing_agent_lastname__c, Trew
listing_agent_mls_id__c, 802542
ffd_listingagentname, Shelley D Trew
listing_agent_number__c, 802542
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.37Winfield.com
pba__longitude_pb__c, -122.416988
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 422657206
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-05-13
original_price__c, 1495000
overall_days_on_market__c, -81216
parking_access__c, Tandem
parking_features__c, Attached,Covered,Garage Facing Front,Interior Access,Tandem Garage,Workshop in Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2022-06-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1227.48
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000Xi5EnUAJ
room_type__c, Office;Kitchen;Living Room;Dining Room;Great Room
sale_date__c, 2022-07-25
sale_price__c, 1635000
selling_agent_mls_id__c, 802803
selling_agent_number__c, 802803
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, 1332
size__c, 1332
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Winfield
subdist__c, Bernal Heights
ffd_name, 37 Winfield Street, San Francisco, CA, 94110
view__c, City;City Lights;San Francisco
website_property_type__c, Single Family Home
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/530457546-1.jpg
ListingId, a0E8W00000Xi5EnUAJ