meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211042' 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, 359 Lexington 361 Street, San Francisco, CA, 94110
ffd_mls_id, 509292
ffd_salesforce_id, a0E1I00000TvLTfUAN
vacant__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 359 Lexington 361 Street, San Francisco, CA, 94110
pba__address_pb__c, 359 Lexington 361 Street, San Francisco, CA, 94110
agent_only_remarks__c, All reports on file with disclosure package. Home will come on market after photos and floor plans are complete. Can show in advance. Both units can be delivered vacant though owners would be happy with a rent back for 30-60 days if possible for the their unit only. Lower unit was just vacated and was getting $3400 a month in rent.
appliances__c, Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Frank A Nolan
pba__contingentdate__c, 2021-03-02
ffd_createddate, 2021-01-05T18:45:53.000+0000
days_on_market__c, 925
dom__c, 59
ffd_description_pb, This two-unit Victorian residence is located on one of the most coveted tree-lined blocks in the Mission District and is just steps to Valencia Street's shopping, nightlife and restaurants. The building has two charming flats with a small rear yard, two car parking and a new foundation with additional storage, office space behind the garage. The lower flat has one bedroom and one updated bath with the option of being used as a two bedroom. Tall ceilings, a private rear terrace and an abundance of light make this a quintessential San Francisco home. The upper flat has two bedrooms and one bathroom. Built in shelving, tall ceilings, oversized windows and hardwood floors make this comfortable and exceptionally well located home a truly a rare offering on this special block.
district__c, SF District 9
electric__c, 220 Volts
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T13:32:27.000+0000
pba__latitude_pb__c, 37.757613
pba__latitude_property__c, 37.757613
laundry_features__c, Washer/Dryer Owned;Varies by Unit
listed_date__c, 2020-11-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Warren
listing_agent_mls_id__c, 807776
ffd_listingagentname, Andrew J Warren
listing_agent_number__c, 1025907
listing_co_agent_mls_id__c, 803037
listing_co_agent_number__c, 803037
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 1925000
pba__listingtype__c, Sale
pba__listing_website__c, http://LiveOnLexington.com
pba__longitude_pb__c, -122.420202
pba__lotsize_pb__c, 0.04
mls_id__c, 509292
master_property__c, a0O8W00000DaF6FUAV
parkingspaces__c, 2
on_market_date__c, 2021-01-05
original_price__c, 1995000
overall_days_on_market__c, 143
parking__c, Attached,Garage,Auto Door
parking_features__c, Attached,Garage,Garage Door Opener
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 2021-03-05
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 878.08
pba__propertytype__c, Duplex
id, a0E1I00000TvLTfUAN
roof__c, Shingle
sale_date__c, 2021-04-02
sale_price__c, 1852750
selling_agent_mls_id__c, EB332091
selling_agent_number__c, 981344757
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, REAL ESTATE EBROKER, INC.
pba__status__c, Closed
pba__totalarea_pb__c, 2110
size__c, 2110
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lexington
style__c, Victorian
subdist__c, The Mission
ffd_name, 359 Lexington 361 Street, San Francisco, CA, 94110
type__c, Flats,2 Story
website_property_type__c, Duplex
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/373215-1.jpg
ListingId, a0E1I00000TvLTfUAN