meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216481' 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, 1385 Hampshire 1387 Street #1385B, San Francisco, CA, 94110
ffd_mls_id, 512055
ffd_salesforce_id, a0E1I00000TvSTtUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 1385 Hampshire 1387 Street #1385B, San Francisco, CA, 94110
pba__address_pb__c, 1385 Hampshire 1387 Street #1385B, San Francisco, CA, 94110
agent_only_remarks__c, Please call agents for showings: Renee 41502605805 | Frances: 415-377-7535. Frances or I would like to meet you there. Please adhere to COVID-19 safety protocol & provide your own PPE. Please confirm your client understands TIC ownership and has spoken to a lender prior to making an appointment. We recommend Samuel Clonmell at Bank of SF. COPA Compliant. Unit 1385A (MLS 512046)is also for sale and will need to close simultaneously. The sellers are doing a reverse exchange. Sellers already purchased their replacement property. Disclosures will be available soon. There is a discrepancy b/w 3R (stating 2-unit dwelling) and tax records (usage is an apartment bldg). It is unknown when the 2 units were converted into 4. Neither sellers or agent have researched this matter.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Frances Ferry
pba__contingentdate__c, 2021-01-18
ffd_createddate, 2021-01-12T17:45:34.000+0000
days_on_market__c, 918
dom__c, 66
ffd_description_pb, Top floor sunny unit in a Marina style 4-unit building in the Mission, tucked away from the bustle of the commercial blocks. This convenient location provides easy access to Bart, 101, 280 and MUNI, close to Rolph play fields and 1.5 blocks to 24th St corridor with eclectic options for shopping and dining. **1385B Hampshire is top floor rear unit flooded with light, overlooks the yard with views to Potrero & Bernal Hills. This home has an updated eat-in kitchen with stainless steel appliances. Off the kitchen is a laundry room with a w/d combo unit and the rear access to the yard and garage area. The bedroom has 2 closets, the living room has a lot of natural light coming from the south and east windows. The bathroom in this home is a sleek remodel with a shower over tub and a skylight. This home is a 25% TIC ownership in 1385-1387 Hamphshire. A parking space in the garage is available and can be purchased for 75k The sunny backyard and w/d in garage is available to be enjoyed
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Wood
hoa_dues__c, 250
pba__hoafees__c, 250
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:42:14.000+0000
pba__latitude_pb__c, 37.75025
pba__latitude_property__c, 37.75025
listed_date__c, 2021-01-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Renee
pba__listing_agent_lastname__c, Gonsalves
listing_agent_mls_id__c, 803247
ffd_listingagentname, Renee M Gonsalves
listing_agent_number__c, 803247
listing_co_agent_mls_id__c, 378389
listing_co_agent_number__c, 378389
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 520000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.406795
pba__lotsize_pb__c, 0
mls_id__c, 512055
master_property__c, a0O1I00000BpRd0UAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-01-12
original_price__c, 520000
overall_days_on_market__c, 78
parking_access__c, Side by Side
parking_features__c, Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-03-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1220
pba__propertytype__c, Tenancy In Common
id, a0E1I00000TvSTtUAN
sale_date__c, 2021-03-29
sale_price__c, 610000
selling_agent_mls_id__c, 812207
selling_agent_number__c, 1055536
selling_co_agent_mls_id__c, 808482
selling_co_agent_number__c, 1035858
selling_co_office_mls_id__c, KWRSF
selling_co_office_name__c, Keller Williams San Francisco
selling_co_office_number__c, 26158
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 500
size__c, 500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hampshire
subdist__c, The Mission
ffd_name, 1385 Hampshire 1387 Street #1385B, San Francisco, CA, 94110
unit_number__c, 1385B
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375534-1.jpg
ListingId, a0E1I00000TvSTtUAN