meta_query='key:subdist__c;value:Cole Valley;Parnassus Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='227510' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 449 Frederick Street #, San Francisco, CA, 94117
ffd_mls_id, 487795
ffd_salesforce_id, a0E1I00000H0pNzUAJ
address2__c, 449 Frederick Street #, San Francisco, CA, 94117
pba__address_pb__c, 449 Frederick Street #, San Francisco, CA, 94117
agent_only_remarks__c, Downstairs is in escrow. We are looking for a TIC Partner. Motivated Seller says Bring me an offer!!! Transparent pricing. We will review offers as received. Disclosures are in Disclosures IO under the listing for the whole building - MLS # 459505. Seller's attorney advised them that this building is eligible for fast track condo conversion, but all prospective Buyers and their agents should seek their own legal counsel on this matter. Neither Seller nor listing agent can guarantee fast track condo convertibility. The Lockbox is located on the gas meters in the front garden. A note about keys - The key with the red dot opens the tradesman's door the key with the yellow dot Opens 449 the top floor.The key with the green dot opens 451 the lower unit. Both unit front door locks require you to turn the key to the left to open, and to the right to close. The asking price is for the TIC interest which would occupy top 2 floors of the building. In addition this interest would have exclusive use of the deck of its kitchen, the roof top greenhouse, and the middle ground floor storage room.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
ffd_createddate, 2019-09-03T22:46:59.000+0000
days_on_market__c, 1449
dom__c, 151
ffd_description_pb, This TIC interest occupies the top 2 floors of the building with exclusive use of the middle storage room on the ground floor. It has a huge parlor with a decorative fireplace, bay & bow windows. Through the pocket door there's a bedroom with a fireplace. Down the hall you'll find an updated full bath & a gracious formal dining room with a beautifully restored built-in & a charming decorative fireplace. At the rear of this level is the updated kitchen, with windows on all 3 sides & high end appliances. Beyond the breakfast area are french doors leading to a south facing deck. The interior stairs lead to the massive master suite level. From the foyer at the top of the stairs you'll find a walk-in closet & washer/dryer closet on one side with the capacious solarium beyond. On the other side is an enormous master suite with sitting area, a brand new bathroom with huge skylights, soaking tub, double sinks & walk in shower, & a bedroom so enormous it makes the king-size bed look tiny.
district__c, SF District 5
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 0
hoa__c, No
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-10-17T13:50:24.000+0000
pba__latitude_pb__c, 37.766291
pba__latitude_property__c, 37.766291
laundry_appliances__c, Washer/Dryer,In Closet
listed_date__c, 2019-07-23
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, ZEPH06
listing_co_office_name__c, Zephyr Real Estate
listing_co_office_number__c, 166014343
listing_office_mls_id__c, ZEPH06
listing_office_name__c, Zephyr Real Estate
listing_office_number__c, 166014343
pba__listingprice_pb__c, 1600000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=R3XDWnh69H8&mls=1
pba__longitude_pb__c, -122.451362
pba__lotsize_pb__c, 0
mls_id__c, 487795
master_property__c, a0O1I000005juz6UAA
monthly_parking_fees__c, 0
parkingspaces__c, 0
on_market_date__c, 2019-07-31
original_price__c, 2099000
overall_days_on_market__c, 1449
parking_type__c, None
price_per_square_foot__c, 615.38
pba__propertytype__c, Tenancy In Common
id, a0E1I00000H0pNzUAJ
sale_date__c, 2020-01-24
sale_price__c, 1600000
selling_agent_number__c, 980011334
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2600
size__c, 2600
pba__state_pb__c, CA
pba__street_pb__c, Frederick
subdist__c, Cole Valley;Parnassus Heights
ffd_name, 449 Frederick Street #, San Francisco, CA, 94117
transportation__c, 1 Block
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/353987-1.jpg
ListingId, a0E1I00000H0pNzUAJ