meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218419' 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, 207 Ripley Street, San Francisco, CA, 94110
ffd_mls_id, 421538601
ffd_salesforce_id, a0E1I00000USDqsUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 207 Ripley Street, San Francisco, CA, 94110
pba__address_pb__c, 207 Ripley Street, San Francisco, CA, 94110
agent_only_remarks__c, full disclosures packages complete with pest and contractors inspection is available as well as floor plans and aerial canvas photography, Please use calendly link to schedule showing and forward PEAD prior to showing: https://calendly.com/cassidya1/207-ripley-street. Disclosures available at: https://app.disclosures.io/link/207-Ripley-Street-w7ly33v7. Transparent pricing offers reviewed as they are submitted Property shows beautifully, show and sell On Supra lock box One of the best values in Bernal
appliances__c, Dishwasher;Free Standing Gas Oven;Free Standing Refrigerator;Ice Maker
architectural_style__c, Marina
bath_features__c, Tub w/Shower Over;Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-26
ffd_createddate, 2021-04-24T10:47:30.000+0000
days_on_market__c, 816
dom__c, 34
ffd_description_pb, Bernal Heights with views, this single family residence is located on one of the most coveted block in Bernal Heights. There are beautiful wood floors contiguous throughout the entire property. There are 3 generous levels of living space, with two gorgeous wood decks overlooking the San Francisco skyline as well as the beautiful landscaped garden complete with tall bamboo plants around the perimeter. This very special property enjoys wonderful natural light and the unique and warm climate of Bernal Heights. The home shows beautifully with high ceilings on the main floor and loft like space. The location is the most convenient in Bernal Heights with the 280/101 interchange minutes away yet far enough away to have the peace and quiet of a very hip and sought after location. Bernal Hill is 1 block away and features the most amazing city views. This home is the ultimate urban dwelling ready to move in, parking, yard, and VIEWS and in the most prime Bernal Heights location
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:50:23.000+0000
pba__latitude_pb__c, 37.744577
pba__latitude_property__c, 37.744577
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-04-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sharon
pba__listing_agent_lastname__c, Cassidy
listing_agent_mls_id__c, 385273
ffd_listingagentname, Sharon M Cassidy
listing_agent_number__c, 385273
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CASS
listing_office_name__c, Cassidy Real Estate
listing_office_number__c, 797
pba__listingprice_pb__c, 2195000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.207ripley.com/
pba__longitude_pb__c, -122.409844
lower_level__c, Family Room,Full Bath(s),Garage,Living Room,Master Bedroom,Street Entrance
mls_id__c, 421538601
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Low-Flow Toilet(s);Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-24
original_price__c, 2200000
overall_days_on_market__c, 172
parking_access__c, Independent
parking_features__c, Enclosed,Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-05-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1015.9
pba__propertytype__c, Single Family Residence
id, a0E1I00000USDqsUAH
road_surface_type__c, Paved
roof__c, Composition;Shingle
room_type__c, Office;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-06-16
sale_price__c, 2300000
security_features__c, Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 803874
selling_agent_number__c, 166013223
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 2264
size__c, 2264
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Ripley
subdist__c, Bernal Heights
ffd_name, 207 Ripley Street, San Francisco, CA, 94110
view__c, City;Panoramic;City Lights;Downtown;San Francisco;Golden Gate Bridge;Twin Peaks;Sutro Tower;Bridges
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens;Caulked/Sealed
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530223488-1.jpg
ListingId, a0E1I00000USDqsUAH