meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385264' 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
(
)
)
_yoast_indexnow_last_ping, 1725065587
ffd_listing_title, 1515 15th Street #404, San Francisco, CA, 94103
ffd_mls_id, 424042511
ffd_salesforce_id, a0EUd000002YeczMAC
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 40
address2__c, 1515 15th Street #404, San Francisco, CA, 94103
pba__address_pb__c, 1515 15th Street #404, San Francisco, CA, 94103
agent_only_remarks__c, With questions and showing requests, contact BOTH Catherine 415-286-5045 & Nini 650-291-4409, [email protected], [email protected]. OFFERS: Please use SFAR Purchase Agreement and provide pre-approval/POF, and signed disclosures with any offer. Pre-escrow opened with Mijael Mike Schmidt at First American.
appliances__c, Microwave;Disposal;Free Standing Gas Oven;Free Standing Refrigerator;Gas Cook Top
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2014
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Catherine Abalos
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2024-07-12T19:49:54.000+0000
days_on_market__c, 49
dom__c, 21
ffd_description_pb, Welcome to your urban oasis at 1515 15th St. Unit 404, a sun-drenched 2-bedroom, 2-bathroom condo nestled in a sought- after boutique building designed by renowned architect Stanley Saitowitz. This 983 sq. ft. residence in San Francisco's vibrant Inner Mission boasts clean lines, open spaces, and high-end finishes. The open-concept living area flows seamlessly into a modern kitchen equipped with Bosch and Bertazzoni appliances. Expansive windows facing Downtown fill the home with natural light. Both bedrooms offer ample light and feature an en-suite bathroom. In-unit laundry and separate storage unit add convenience to daily living. Enjoy city views from the furnished rooftop deck, a peaceful courtyard, secure parking, and bike storage. With a near-perfect 99 Walk Score, you're steps from the best of the Inner Mission, including the Valencia Corridor, eclectic shops, diverse restaurants, tech shuttle stops, vibrant murals, and less than a mile to Dolores Park. Savor your morning coffee at Four Barrel, indulge in local favorites like Sixth Course, Tartine Manufactory, Gus's Community Market, or catch an avant-garde performance at Z Space. Easy access to BART and MUNI makes commuting a breeze.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance,Maintenance Exterior,Management,Roof,Trash
pba__hoafees__c, 761
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Fifteen Fifteen HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-08-31T00:46:56.000+0000
pba__latitude_pb__c, 37.7665417
pba__latitude_property__c, 37.7665417
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2024-06-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charlene
pba__listing_agent_lastname__c, Gueco
listing_agent_mls_id__c, 812593
ffd_listingagentname, Charlene T Gueco
listing_agent_number__c, 1057212
listing_co_agent_mls_id__c, 815058
listing_co_agent_number__c, 1070430
listing_co_office_mls_id__c, KINOKO
listing_co_office_name__c, Kinoko
listing_co_office_number__c, 27835
listing_office_mls_id__c, KINOKO
listing_office_name__c, Kinoko
listing_office_number__c, 27835
pba__listingprice_pb__c, 899000
pba__listingtype__c, Sale
pba__listing_website__c, https://1515-15th-street-unit-404.kinokorealestate.com/
pba__longitude_pb__c, -122.4179775
mls_id__c, 424042511
master_property__c, a0O1I000001Vi5kUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-07-12
original_price__c, 999000
overall_days_on_market__c, -82007
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-08-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-08-30T11:00:46.000+0000
price_per_square_foot__c, 900.31
pba__propertytype__c, Condominium
ListingId, a0EUd000002YeczMAC
room_type__c, Laundry;Kitchen;Living Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-08-22
sale_price__c, 885000
selling_agent_mls_id__c, MLSL5080477
selling_agent_number__c, 981345292
selling_co_agent_mls_id__c, MLSL5098896
selling_co_agent_number__c, 981397849
selling_co_office_mls_id__c, RISE-1
selling_co_office_name__c, Rise Homes
selling_co_office_number__c, 981084250
selling_office_name__c, Rise Homes
pba__status__c, Closed
pba__totalarea_pb__c, 983
size__c, 983
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 15th
subdist__c, The Mission
ffd_name, 1515 15th Street #404, San Francisco, CA, 94103
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530808989-1.jpg