meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211290' 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, 1332 South Van Ness 1334 South Avenue, San Francisco, CA, 94110
ffd_mls_id, 421539499
ffd_salesforce_id, a0E1I00000USBnHUAX
num_of_rooms__c, 11
of_units__c, 2
address2__c, 1332 South Van Ness 1334 South Avenue, San Francisco, CA, 94110
pba__address_pb__c, 1332 South Van Ness 1334 South Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Please send signed PEAD to [email protected] For showings Please use below Calendly Link: https://calendly.com/schedule-42/1332-1334 For questions please email: [email protected]
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 6
year_build_text__c, 1895
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kira K Mead
pba__contingentdate__c, 2021-04-23
ffd_createddate, 2021-04-23T10:47:16.000+0000
days_on_market__c, 817
dom__c, 39
ffd_description_pb, Two unit building with period detailing and massive expansion potential in the heart of the Mission. Just steps to incredible dining, retail, BART and MUNI, this two unit building is bursting with charm and opportunity. Each unit features a flexible floorplan and boasts soaring ceilings, period details throughout the units, beautiful fir floors and a shared yard with brick patio and mature plantings. Kitchens have been updated with new cabinetry, countertops and appliances and baths are also remodeled. Upper unit is flooded with light and offers 3 bedrooms, living and dining room with decorative fireplaces and a detached, private garage accessed from the alley. The lower unit also has 3 bedrooms and direct access to an enormous lower floor that could be used as a huge artist studio, workshop, storage or parking. Unique opportunity to own a historic building with unlimited potential! Will also be offered as two TIC units at $1,095,000/each.
district__c, SF District 9
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T13:33:29.000+0000
pba__latitude_pb__c, 37.751782
pba__latitude_property__c, 37.751782
listed_date__c, 2021-04-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Daniel
pba__listing_agent_lastname__c, Fernandez
listing_agent_mls_id__c, 803897
ffd_listingagentname, Daniel R Fernandez
listing_agent_number__c, 166013258
listing_co_agent_mls_id__c, 808110
listing_co_agent_number__c, 1030846
listing_co_office_mls_id__c, CGL
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28240
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 2190000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.416546
mls_id__c, 421539499
master_property__c, a0O8W00000DaFB1UAN
parkingspaces__c, 4
on_market_date__c, 2021-04-23
original_price__c, 2190000
overall_days_on_market__c, 90
parking_features__c, Garage,Interior Access
pba__pendingdate__c, 2021-06-01
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 836.86
pba__propertytype__c, Duplex
id, a0E1I00000USBnHUAX
sale_date__c, 2021-06-02
sale_price__c, 2175000
selling_agent_mls_id__c, 400612
selling_agent_number__c, 1023994
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Ascend Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2599
size__c, 2599
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, South Van Ness
subdist__c, The Mission
ffd_name, 1332 South Van Ness 1334 South Avenue, San Francisco, CA, 94110
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1895
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530220862-1.jpg
ListingId, a0E1I00000USBnHUAX