meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211995' 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, 205 Ripley Street, San Francisco, CA, 94110
ffd_mls_id, 497096
ffd_salesforce_id, a0E1I00000SgCCCUA3
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 205 Ripley Street, San Francisco, CA, 94110
pba__address_pb__c, 205 Ripley Street, San Francisco, CA, 94110
agent_only_remarks__c, NOTE: This property does not have a garage. Sellers have happily parked on the street for 17 years. Please call John at 415-310-0225 or email [email protected] for showing instructions. We are following CAR Guidelines for Real Estate Best Practices. 1. Please review virtual media with your buyers at www.205Ripley.com. 2. Prior to any in-person showings, Agents and pre-approved Buyers must first sign and submit Corona Virus Property Entry and Declaration dated 4/16/20 (PEAD), and review and follow the CAR Guidelines. 3. Property is vacant and staged. Showings may only be attended by 1 Agent and 2 Buyers from the same household. Visitors must follow CDC guidelines, including face covering, gloves and social distancing. PLEASE SEE Attached Documents in MLS for these COVID 19 forms.
appliances__c, Dishwasher;Insulated Water Heater;Gas Range;Disposal;Refrigerator;Hood Over Range;Freezer
architectural_style__c, Contemporary;Victorian
bath_features__c, Tub w/Shower Over;Remodeled;Marble;Tile;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-05-09
ffd_createddate, 2020-04-21T17:45:31.000+0000
days_on_market__c, 1184
dom__c, 25
ffd_description_pb, Proudly perched on Bernal's coveted north slope, 205 Ripley embodies all that urban dwellers desire: Open space, privacy, community. The dramatic great room offers a fantastic open entertaining space bathed in southern light. The enormous kitchen features a 6-burner Thermador range, tons of workspace, and a sunny hang-out lounge for family and friends. A bright and spacious bedroom, freshly remodeled marble bath with huge vanity, and perfect home office niche rounds out the main level. Upstairs are two lofted bedrooms with fabulous views from Twin Peaks to Downtown, and an ingenious sitting area with a custom-made elevated window seat perfect for afternoon naps. The lower level features a vast media room which could also be used as a huge master bedroom or creative studio with its own separate entrance. The 4th bedroom is perfect for guests, while the half-bath/laundry might be built out as a posh master bath. The rear yard is a dream: Patio, REAL grass and mature garden! Magical!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Carpet;Marble;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:21:02.000+0000
pba__latitude_pb__c, 37.74457
pba__latitude_property__c, 37.74457
laundry_features__c, Inside Room;Hookups Only
listed_date__c, 2020-04-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Beeney
listing_agent_mls_id__c, 804880
ffd_listingagentname, John Beeney
listing_agent_number__c, 166014587
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 2200000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.205Ripley.com
pba__longitude_pb__c, -122.40993
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room,Partial Bath(s)
mls_id__c, 497096
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-04-21
original_price__c, 2200000
overall_days_on_market__c, 89
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-05-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 777.78
pba__propertytype__c, Single Family Residence
id, a0E1I00000SgCCCUA3
roof__c, Bitumen;Shingle
room_type__c, Storage;Office;Bonus Room;Sun Room;Laundry;Den;Loft
sale_date__c, 2020-06-09
sale_price__c, 2100000
security_features__c, Smoke Detector;Security Alarm(s)
selling_agent_mls_id__c, 802602
selling_agent_name__c, Mark H. Peschel
selling_agent_number__c, 802602
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 2700
size__c, 2700
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Ripley
subdist__c, Bernal Heights
ffd_name, 205 Ripley Street, San Francisco, CA, 94110
transportation__c, 1 Block
view__c, Park;City Lights;Garden/Greenbelt;Downtown;San Francisco;Golden Gate Bridge;Twin Peaks
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Weather Stripped
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362216-1.jpg
ListingId, a0E1I00000SgCCCUA3