meta_query='key:subdist__c;value:Ashbury Heights;Buena Vista Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210810' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 888 Waller Street, San Francisco, CA, 94117
ffd_mls_id, 500543
ffd_salesforce_id, a0E1I00000SxrinUAB
num_of_rooms__c, 24
of_units__c, 6
address2__c, 888 Waller Street, San Francisco, CA, 94117
pba__address_pb__c, 888 Waller Street, San Francisco, CA, 94117
agent_only_remarks__c, Buyout Completed 9/23/2020; metrics improved! See Offering Memorandum attached.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 0
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Brad Lagomarsino
pba__contingentdate__c, 2020-10-21
ffd_createddate, 2020-06-26T21:49:21.000+0000
days_on_market__c, 1118
dom__c, 145
ffd_description_pb, 888 Waller Street is a 6-unit apartment building located in the Buena Vista/Asbury Heights neighborhood of San Francisco. This property is extremely well located between Duboce Park and Buena Vista Park, the oldest official park in San Francisco. This mid-block building has been well-preserved and possess' many of the quality finishes from its era of construction. The building is comprised of six 2 bedroom 1 bath apartments that are of substantial size and benefit from tremendous natural light. The top two floors enjoy city views. There is an occupied unwarranted unit that is approximately 525 square feet (per owner) with tall ceilings and garden access - great ADU potential. There is a two car tandem garage and six storage spaces. The units have working fireplaces, separate water heaters, electric baseboard heaters and are separately metered for gas and electricity. The building has updated electrical with 400 amps, a washer and dryer, sprinklers and copper pipes.
888 Waller Street, San Francisco, CA, 94117 - Property Description
888 Waller Street is a 6-unit apartment building located in the Buena Vista/Asbury Heights neighborhood of San Francisco. This property is extremely well located between Duboce Park and Buena Vista Park, the oldest official park in San Francisco. This mid-block building has been well-preserved and possess' many of the quality finishes from its era of construction. The building is comprised of six 2 bedroom 1 bath apartments that are of substantial size and benefit from tremendous natural light. The top two floors enjoy city views. There is an occupied unwarranted unit that is approximately 525 square feet (per owner) with tall ceilings and garden access - great ADU potential. There is a two car tandem garage and six storage spaces. The units have working fireplaces, separate water heaters, electric baseboard heaters and are separately metered for gas and electricity. The building has updated electrical with 400 amps, a washer and dryer, sprinklers and copper pipes.
