meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218766' 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, 771 Treat Avenue #2, San Francisco, CA, 94110
ffd_mls_id, 421546111
ffd_salesforce_id, a0E1I00000USbn7UAD
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 3
address2__c, 771 Treat Avenue #2, San Francisco, CA, 94110
pba__address_pb__c, 771 Treat Avenue #2, San Francisco, CA, 94110
agent_only_remarks__c, This property is a PUD in a 3 unit condominium building. For appointments and any questions please text/call Alina at 415.744.4844. Appointment slots and windows will be arranged individually, no lockbox for the moment! PEAD to: [email protected]. Offers on Thursday, 5/13 by 3 pm, through Disclosures. IO please.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Contemporary;Victorian
bath_features__c, Shower Stall(s);Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-06T20:48:12.000+0000
days_on_market__c, 804
dom__c, 7
ffd_description_pb, A real Treat in the Mission: location, modern amenities, views, parking and impressive outdoors space! This top floor residence in a 3-unit building offers a modern and well-appointed floor plan: flexible living/dining area with a gas fireplace, a gourmet, spacious kitchen with high-end appliances, washer/dryer, 2 bedrooms, 2 baths. There is ample outdoor spaces with a deeded, impressive size terrace with Twin Peaks and downtown views and an East facing views deck, overlooking palm trees, ideal for entertaining and an outdoor/indoors lifestyle. The city views from the rooftop are also spectacular. There is a constant flow of light throughout the day, coming from the skylights and the East and West facing windows. One parking space & low HOA dues: $175.62/month. Few blocks away from great restaurants and entertainment such as Flour +Water, Urban Put, Tartine Manufactory, shuttles, parks, public transit, 24th St, Mission and Valencia corridors.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Starter;Gas Log
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance on Structure,Trash,Water
pba__hoafees__c, 175
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 669-771 Treat Ave
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:51:46.000+0000
pba__latitude_pb__c, 37.757914
pba__latitude_property__c, 37.757914
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-04-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alina
pba__listing_agent_lastname__c, Aeby
listing_agent_mls_id__c, 805617
ffd_listingagentname, Alina M Aeby
listing_agent_number__c, 166015608
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=tt5CREYdCKC&mls=1
pba__longitude_pb__c, -122.413183
mls_id__c, 421546111
master_bathroom_features__c, Tub w/Shower Over;Jetted Tub
master_property__c, a0O1I000004VYTNUA4
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-05-06
original_price__c, 1295000
overall_days_on_market__c, 137
parking_access__c, Side by Side
parking_features__c, Covered,Enclosed,Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2021-05-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000USbn7UAD
roof__c, Bitumen
room_type__c, Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2021-05-25
sale_price__c, 1508000
security_features__c, Fire Alarm;Carbon Mon Detector
selling_agent_mls_id__c, 807044
selling_agent_number__c, 166018105
selling_co_agent_mls_id__c, 284109
selling_co_agent_number__c, 284109
selling_co_office_mls_id__c, COMP7PAR
selling_co_office_name__c, Compass SF
selling_co_office_number__c, 27677
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Treat
subdist__c, The Mission
ffd_name, 771 Treat Avenue #2, San Francisco, CA, 94110
view__c, City;Downtown;San Francisco;Twin Peaks
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530233275-1.jpg
ListingId, a0E1I00000USbn7UAD
