meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236862' 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] => 2022-12-05 06:31:31
[post_modified_gmt] => 2022-12-05 14:31:31
[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, 198 Bradford Street, San Francisco, CA, 94110
ffd_mls_id, 422662967
ffd_salesforce_id, a0E8W00000WkRQeUAN
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 198 Bradford Street, San Francisco, CA, 94110
pba__address_pb__c, 198 Bradford Street, San Francisco, CA, 94110
agent_only_remarks__c, Book a private showing here: https://calendly.com/bellingsbrothers/198-bradford?month=2022-05 Access instructions will be in your Calendly confirmation email. Contact Aaron Bellings for more info. 415.601.3000 or [email protected]ngsBrothers.com Access disclosures here: https://app.disclosures.io/link/198-Bradford-Street-zsxmnaoe
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Double Oven;Built-In Electric Oven
architectural_style__c, Contemporary;Mid-Century
bath_features__c, Tub w/Shower Over;Shower Stall(s);Double Sinks;Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1971
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Michael L Bellings
pba__contingentdate__c, 2022-06-09
cooling__c, Ceiling Fan(s),Central
ffd_createddate, 2022-06-02T00:47:38.000+0000
days_on_market__c, 180
dom__c, 15
ffd_description_pb, 198 Bradford St. is a stylishly renovated 4 bedroom, 2 bathroom, partially detached SFH in one of SF's most coveted neighborhoods - Bernal Heights. This grand, mid-century home boasts an ideal floor plan with 3 bedrooms upstairs, and a permitted lower level which flows seamlessly from upstairs, and into the lovely backyard. The main living area boasts beautiful city & mountain views, opening into the dining room and meticulously renovated chef's kitchen with a multitude of upgrades, new countertops, custom backsplash, and high-end SS appliances. The lower level boasts soaring ceilings, and offers endless possibilities: a family room, in-law suite, or primary retreat with access to a two-tiered backyard. Enjoy beautiful hardwood floors, newly renovated baths, A/C, and high-end, custom finishes. Complete with a 2 car, side-by-side garage. A+ Bernal Heights location with easy access to Cortland Village, Bare Bottle, Bernal Farmer's market, freeways, and the best micro climate in the city.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-10-28T10:48:06.000+0000
pba__latitude_pb__c, 37.739855
pba__latitude_property__c, 37.739855
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-05-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Aaron
pba__listing_agent_lastname__c, Bellings
listing_agent_mls_id__c, 808937
ffd_listingagentname, Aaron M Bellings
listing_agent_number__c, 1038623
listing_co_agent_mls_id__c, 808971
listing_co_agent_number__c, 1038794
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, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ooYEG4CSsPd
pba__longitude_pb__c, -122.40983
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Primary Bedroom,Retreat,Street Entrance
mls_id__c, 422662967
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Walk-In Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-06-01
original_price__c, 1695000
overall_days_on_market__c, -81235
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-06-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 940.72
pba__propertytype__c, Single Family Residence
id, a0E8W00000WkRQeUAN
room_type__c, In Law Apartment
sale_date__c, 2022-06-30
sale_price__c, 1825000
selling_agent_mls_id__c, 308732
selling_agent_number__c, 308732
selling_co_agent_mls_id__c, 215754
selling_co_agent_number__c, 215754
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bradford
subdist__c, Bernal Heights
ffd_name, 198 Bradford Street, San Francisco, CA, 94110
view__c, Water;San Francisco;Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1971
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530466402-1.jpg
ListingId, a0E8W00000WkRQeUAN