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, 2923 23rd Street #1, San Francisco, CA, 94110
ffd_mls_id, 507417
ffd_salesforce_id, a0E1I00000TRgoRUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 2
address2__c, 2923 23rd Street #1, San Francisco, CA, 94110
pba__address_pb__c, 2923 23rd Street #1, San Francisco, CA, 94110
agent_only_remarks__c, Please visit Sunny23rd.com for full property detail.*Please request Appointment here: https://calendly.com/jasonhoffman/2923-23rd-st *In-person showings permitted after the following conditions have been met: (1) Provide updated pre-approval letter on behalf of the buyers (2) PEAD - Buyer completed.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2001
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-02T16:46:49.000+0000
days_on_market__c, 1020
dom__c, 31
ffd_description_pb, Sunny 3BD/3BA house-like condo in vibrant Inner Mission for dreamy indoor-outdoor lifestyle! The upper-level entrance welcomes you with a generous open floor plan, warm hardwood floors, crown molding, recessed lighting, bay windows & gas fireplace. The living and dining rooms and open chef's kitchen flow effortlessly together with the abundance of space, natural light. The primary bedroom offers two closets & ensuite bath w/dual-shower heads and walk-in steam shower, while the second bedroom boasts a walk-in closet and vibrant outlooks over the yard. Completing this level is a side-by-side W/D, and walk-in storage closet. The lower level boasts a generous third bedroom equipped with a walk-in closet & ensuite bath, plus French doors leading to the deeded south-facing backyard w/fruit trees, walkway & large patio. 2 Car parking, storage and an incredible location on a quiet street close to 24th St, BART, freeways, and biking routes.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped;Stone
2923 23rd Street #1, San Francisco, CA, 94110 - Property Description
Sunny 3BD/3BA house-like condo in vibrant Inner Mission for dreamy indoor-outdoor lifestyle! The upper-level entrance welcomes you with a generous open floor plan, warm hardwood floors, crown molding, recessed lighting, bay windows & gas fireplace. The living and dining rooms and open chef's kitchen flow effortlessly together with the abundance of space, natural light. The primary bedroom offers two closets & ensuite bath w/dual-shower heads and walk-in steam shower, while the second bedroom boasts a walk-in closet and vibrant outlooks over the yard. Completing this level is a side-by-side W/D, and walk-in storage closet. The lower level boasts a generous third bedroom equipped with a walk-in closet & ensuite bath, plus French doors leading to the deeded south-facing backyard w/fruit trees, walkway & large patio. 2 Car parking, storage and an incredible location on a quiet street close to 24th St, BART, freeways, and biking routes.
