meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340081' 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] => 2023-10-31 11:02:44
[post_modified_gmt] => 2023-10-31 18:02:44
[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, 1701742421
ffd_listing_title, 3135 24th Street #9, San Francisco, CA, 94110
ffd_mls_id, 423913731
ffd_salesforce_id, a0E8W00000dUTCQUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 9
address2__c, 3135 24th Street #9, San Francisco, CA, 94110
pba__address_pb__c, 3135 24th Street #9, San Francisco, CA, 94110
agent_only_remarks__c, Easy to show prior to going active. Special seller-credit 2/1 financing package - rate in the 4% will be made available for qualifying offers, subject to terms and conditions. Seller reserves the right to accept. counter or reject any and all offers. Please call/text Stephanie House 619.964.4709 or Jean-Paul Samaha 415.279.0997 for showings.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Gas Plumbed
architectural_style__c, Contemporary
bath_features__c, Tub
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, Edward R Deleski
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-13T10:50:52.000+0000
days_on_market__c, 52
dom__c, 52
ffd_description_pb, Residence 9 at 3135 24th Street is a stunning two-level condominium offering seamless indoor-outdoor grand-scale living, boasting 370+ sq. ft. of private deck space and breathtaking downtown views. Home sits atop a boutique 9-unit historic building, recently constructed in 2014, and a highly coveted address in the heart of the vibrant Mission District. The great room features soaring ceilings, skylights, a chef's kitchen with Viking appliances + an open floor plan leading to the expansive deck for grand-scale dining and entertaining. Two spacious bedrooms, including a top-floor primary suite with downtown views and a private deck, offer ideal retreats. The 2nd bedroom opens directly to the main-level deck. Spa-like bathrooms feature Kohler and Grohe fixtures, designer tiles, soaking tubs, and a walk-in shower in the primary bathroom. Additional features include a loft-den for a home office, radiant floor heating, recessed lighting, in-unit washer/dryer, and 1-car deeded garage parking. Building amenities comprise professional management, a bike room, intercom system, and video cameras in lobby/common areas. Ideally located on vibrant 24th Street, the residence is surrounded by local restaurants, eateries, shops, cafes, BART, and parks, presenting a prime urban living experience.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 671
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry;Skylight(s);Cathedral Ceiling
ffd_lastmodifieddate, 2023-12-05T01:46:59.000+0000
pba__latitude_pb__c, 37.752235
pba__latitude_property__c, 37.752235
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2023-08-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jean-Paul
pba__listing_agent_lastname__c, Samaha
listing_agent_mls_id__c, 804997
ffd_listingagentname, Jean-Paul Samaha
listing_agent_number__c, 166014752
listing_co_agent_mls_id__c, 807512
listing_co_agent_number__c, 1020319
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, 1295000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.414706
mls_id__c, 423913731
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
master_property__c, a0O8W00000EWo3hUAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-10-13
open_house_end__c, 2023-12-05T16:00:00.000+0000
open_house_start__c, 2023-12-05T14:00:00.000+0000
original_price__c, 1350000
overall_days_on_market__c, -81734
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio;Enclosed Deck
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000dUTCQUA4
room_type__c, Office;Den;Kitchen;Possible Guest;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Video System
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, The Mission
ffd_name, 3135 24th Street #9, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530689823-1.jpg