meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235920' 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, 744 Potrero Avenue, San Francisco, CA, 94110
ffd_mls_id, 422639784
ffd_salesforce_id, a0E8W00000VvH9JUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 744 Potrero Avenue, San Francisco, CA, 94110
pba__address_pb__c, 744 Potrero Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Property Website: https://www.744potrero.com/unbranded Please contact [email protected] for questions, showings and disclosure requests.
appliances__c, Dishwasher;Microwave;Hood Over Range;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-03-21T16:47:41.000+0000
days_on_market__c, 485
dom__c, 18
ffd_description_pb, Space and style in sunny Inner Mission! Contemporary 3-level home with 4 bedrooms, 2 family rooms, 3.5 bathrooms, and a sun-drenched yard. Extensively renovated in 2015, this residence has been meticulously maintained and updated since. The layout is perfect for entertaining, with an open floorplan on the main level, including an expansive living/dining room, a beautiful kitchen with pantry, a home office nook, and a deck overlooking the backyard. Upstairs are 3 beds and 2 baths, including a generous primary suite with a sleek bathroom ensuite. The 2 front bedrooms have wonderful city views. On the lower level are a 4th bedroom and bath, laundry room, add'l storage, and a fabulous family room with a wet bar and walk-out access to a deck and the yard. The west-facing backyard features a paved seating area and a lush lawn surrounded by landscaping. 1-car garage. Easy access to downtown & freeways, just blocks from 20th St hub and walkable to incredible restaurants and nightlife.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-05-14T10:50:28.000+0000
pba__latitude_pb__c, 37.760026
pba__latitude_property__c, 37.760026
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2022-03-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nina
pba__listing_agent_lastname__c, Hatvany
listing_agent_mls_id__c, 372883
ffd_listingagentname, Nina Hatvany
listing_agent_number__c, 372883
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.744potrero.com/unbranded
pba__longitude_pb__c, -122.407349
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Street Entrance
mls_id__c, 422639784
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-03-21
original_price__c, 2495000
overall_days_on_market__c, -81163
parking_access__c, Independent
parking_features__c, Attached,Garage Facing Front,Interior Access,Private
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-04-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1004.83
pba__propertytype__c, Single Family Residence
id, a0E8W00000VvH9JUAV
room_type__c, Laundry;Kitchen;Living Room;Master Bathroom;Baths Other;Family Room;Master Bedroom;Possible Guest
sale_date__c, 2022-05-13
sale_price__c, 2495000
selling_agent_mls_id__c, 803507
selling_agent_number__c, 803507
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Polaris Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2483
size__c, 2483
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Potrero
subdist__c, The Mission
ffd_name, 744 Potrero Avenue, San Francisco, CA, 94110
view__c, City;City Lights;San Francisco;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530422606-1.jpg
ListingId, a0E8W00000VvH9JUAV