meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238692' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 645 Capp Street, San Francisco, CA, 94110
ffd_mls_id, 422696944
ffd_salesforce_id, a0E8W00000ZKJ77UAH
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 645 Capp Street, San Francisco, CA, 94110
pba__address_pb__c, 645 Capp Street, San Francisco, CA, 94110
agent_only_remarks__c, GIANT leased 2 car parking in place. Two car tandem at 649-647 Capp (directly in front of 645 Capp). Lease has 5 year option to extend on or before March 2024. Current rate is $611/month for parking/entirety of the garage, and large storage room. Exclusive use. Please contact me directly for private showings and more information by Text/Call/email 415.298.9173 [email protected] www.bestcappsecret.com
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Victorian
bath_features__c, Dual Flush Toilet;Radiant Heat
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1879
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central,Other
ffd_createddate, 2022-09-23T10:48:34.000+0000
days_on_market__c, 300
dom__c, 39
ffd_description_pb, Price Reduced!! Giant, leased 2 car parking/entire garage and storage room directly in front of home! Tucked nearly 80 feet back from the street is a sunny oasis with a historic 1800's facade, heritage rose bushes and a luxurious modern interior. While the house was built in 1879, it was almost entirely rebuilt in 2015 and updated again in 2021. Open modern design that retains a historic grace is finished with real stone, walnut floors, dual zone AC and more. The kitchen was designed for serious cooking and hosting, with luxury appliances and finishes, tons of storage and a backsplash made for the space by a local artist. A large second story deck makes al fresco dining just a step away from the main kitchen and living areas. Climate aware landscaping complete with a fruiting avocado tree rounds out this quiet sunny oasis - all just a block or two from the best art and food in the city!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Starter
pba__floortype_pb__c, Other
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor;Central
ffd_lastmodifieddate, 2023-07-13T17:48:50.000+0000
pba__latitude_pb__c, 37.756389
pba__latitude_property__c, 37.756389
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-08-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Osman
pba__listing_agent_lastname__c, Dost
listing_agent_mls_id__c, 808902
ffd_listingagentname, Osman A Dost
listing_agent_number__c, 1038449
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2095000
pba__listingtype__c, Sale
pba__listing_website__c, http://my.matterport.com/show/?m=dT4B8m1jyBr
pba__longitude_pb__c, -122.41731
mls_id__c, 422696944
master_bathroom_features__c, Radiant Heat;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-09-22
original_price__c, 2295000
overall_days_on_market__c, -81348
pba__pendingdate__c, 2022-10-31
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 987.28
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZKJ77UAH
sale_date__c, 2022-11-18
sale_price__c, 2095000
selling_agent_mls_id__c, 812994
selling_agent_number__c, 1058930
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2122
size__c, 2122
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Capp
subdist__c, The Mission
ffd_name, 645 Capp Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1879
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530532734-1.jpg