meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212058' 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, 28 Winfield Street, San Francisco, CA, 94110
ffd_mls_id, 497486
ffd_salesforce_id, a0E1I00000SlTDPUA3
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 28 Winfield Street, San Francisco, CA, 94110
pba__address_pb__c, 28 Winfield Street, San Francisco, CA, 94110
agent_only_remarks__c, Matterport 3D Tour and floorplans available on request. Property is on lockbox and easy to show with notice. Signed PEAD form and Pre-Approval must be received by LA / Seller prior to confirmation of property access. Garage fits max car size of Honda CRV. Property yielded significant rental income to Seller during occupancy. There is no yard or interior access to bonus two-level guest suite. Square footage listed includes the guest suite - does not include bonus attic space. Pre-escrow opened with Steve Salviejo at North American Title. Offers as they come. Please submit on SFAR Purchase Agreement. Lower level in-law suite was drafted as the remaining 870 sq ft.
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Disposal
architectural_style__c, Art Deco
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Tile;Skylight/Solar Tube
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, 2020-04-30T23:45:38.000+0000
days_on_market__c, 1175
dom__c, 2
ffd_description_pb, A picture-perfect white picket fence enclosed patio with custom living wall is the first of many inviting features of 28 Winfield St. A cheerful yellow front door opens into the gorgeous living area featuring beautiful hardwood floors, large windows, and an abundance of natural light. A thoughtful floorplan offers three sizable bedrooms and one renovated full bathroom, each with lovely outlooks and privacy. The open kitchen-to-dining area features new stone countertops, custom cabinetry, bar seating, formal dining, and full wall of windows w/ sweeping views of the hillside and downtown skyline - perfect for indoor/outdoor living. The 1 car garage features a finished laundry room usable as art studio, workspace, or storage. Bonus spaces include large finished attic and income potential via a renovated two-level 1bd/1ba guest suite (unwarranted) with expansive views, beamed ceilings and private outdoor space. A perfect option for any Buyer, this is truly a one-of-a-kind opportunity!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:21:23.000+0000
pba__latitude_pb__c, 37.744904
pba__latitude_property__c, 37.744904
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-04-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Justina
pba__listing_agent_lastname__c, Colunga
listing_agent_mls_id__c, 808179
ffd_listingagentname, Justina M Colunga
listing_agent_number__c, 1031719
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG06
listing_office_name__c, Vanguard Properties
listing_office_number__c, 25987
pba__listingprice_pb__c, 1675000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.41725
pba__lotsize_pb__c, 0.04
lower_level__c, Bedroom(s),Full Bath(s),Kitchen,Living Room
mls_id__c, 497486
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-04-30
original_price__c, 1675000
overall_days_on_market__c, 123
parking__c, Garage
parking_access__c, Independent
parking_features__c, Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Deck(s)
pba__pendingdate__c, 2020-05-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1493.33
pba__propertytype__c, Single Family Residence
id, a0E1I00000SlTDPUA3
room_type__c, Laundry;In Law Apartment
sale_date__c, 2020-05-29
sale_price__c, 1680000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 808098
selling_agent_name__c, Joseph J. Hittinger
selling_agent_number__c, 1030746
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1125
size__c, 1125
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Winfield
subdist__c, Bernal Heights
ffd_name, 28 Winfield Street, San Francisco, CA, 94110
view__c, Panoramic;City Lights;Downtown;San Francisco;Twin Peaks;Hills
website_property_type__c, Single Family Home
window_features__c, Window Screens
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/362528-1.jpg
ListingId, a0E1I00000SlTDPUA3