meta_query='key:subdist__c;value:Cole Valley;Parnassus Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='227509' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title, 451 Frederick Street #, San Francisco, CA, 94117
ffd_mls_id, 487796
ffd_salesforce_id, a0E1I00000H0pO0UAJ
address2__c, 451 Frederick Street #, San Francisco, CA, 94117
pba__address_pb__c, 451 Frederick Street #, San Francisco, CA, 94117
agent_only_remarks__c, BOM no fault of the property! 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.
pba__fullbathrooms_pb__c, 1
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, 146
ffd_description_pb, Vacant 2 unit Victorian is ready to convert. TIC Partners are in place for the upstairs unit. This unit is the first floor flat. Enter into an elegant parlor with high ceilings, a decorative fireplace with marble surround & brand new hard wood floors.The new, oversized windows invite in the sunshine, but keep out the noise. Through the french doors there is a large bedroom with a closet, 2 off street windows, & a door to the hall. In the hall you'll find a brand new full bath with deep soaking tub, & a brand new powder room. There's a gracious formal dining room with built-in hutch, & charming decorative fireplace that opens up to the kitchen behind. This kitchen is brand new; never been used. It boasts a gas cook top, double ovens & generous amounts of counter & cabinet space. The 2nd, smaller bedroom is located off the dining room. This unit gets exclusive us of: the south facing deck & backyard, downstairs storage room with exclusive use W/D & a bonus guest suite with full bath.
district__c, SF District 5
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-10-17T13:50:24.000+0000
pba__latitude_pb__c, 37.7664838
pba__latitude_property__c, 37.7664838
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, 1499000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=R3XDWnh69H8&mls=1
pba__longitude_pb__c, -122.4514433
pba__lotsize_pb__c, 0
mls_id__c, 487796
master_property__c, a0O1I000005jv15UAA
monthly_parking_fees__c, 0
parkingspaces__c, 0
on_market_date__c, 2019-07-31
original_price__c, 1249000
overall_days_on_market__c, 1449
parking_type__c, None
price_per_square_foot__c, 905.91
pba__propertytype__c, Tenancy In Common
id, a0E1I00000H0pO0UAJ
sale_date__c, 2020-01-24
sale_price__c, 1425000
selling_agent_mls_id__c, 813075
selling_agent_name__c, Anna Coles
selling_agent_number__c, 1059340
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1573
size__c, 1573
pba__state_pb__c, CA
pba__street_pb__c, Frederick
subdist__c, Cole Valley;Parnassus Heights
ffd_name, 451 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/353988-1.jpg
ListingId, a0E1I00000H0pO0UAJ