meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375577' 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, 1712660309
ffd_listing_title, 262 Shotwell Street, San Francisco, CA, 94110
ffd_mls_id, 424011297
ffd_salesforce_id, a0EUd000001OJ2eMAG
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 262 Shotwell Street, San Francisco, CA, 94110
pba__address_pb__c, 262 Shotwell Street, San Francisco, CA, 94110
agent_only_remarks__c, Offers welcome March 18 at 12pm. Request disclosures here ... https://app.disclosures.io/link/262-Shotwell-Street-fz2iyogx . Please email [email protected] to schedule a showing and/or questions. Escrow opened with Michelle Patterson at WFG. Please DO NOT text agents. Call Alla at 415.748.2550 for more information.
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alla Gershberg
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-08T19:47:08.000+0000
days_on_market__c, 32
dom__c, 10
ffd_description_pb, Open the door to this gorgeous, one-of-a-kind Victorian home nestled in the vibrant Mission District & you will be enveloped into a world of seclusion & peacefulness amidst a hip, eclectic urban scene. Exuding period charm, this 2++ bd/2 ba home features an inspiring lower-level space & an incredible OUTDOOR OASIS that invites endless possibilities. As you ascend to the main lvl, you are welcomed into a bright, airy living space w/ classic architectural details - from intricate moldings & lofty cove ceilings to wainscoting & picture rails. The spacious LR & adjacent light-filled DR flow effortlessly into the kitchen, making entertaining a breeze. The eat-in farm-style kitchen features butcher block countertops & new stainless-steel appliances & opens to an expansive deck overlooking the lush yard complete w/ sauna, koi pond & sitting area. 2 bds & a full ba complete this lvl. Downstairs is an enormous multi-purpose area w/a private entrance that can be used as an office, artist studio, guest room, music/performance space & workout area. The area is completed by a full bathroom, laundry, ample storage & parking with interior access. Where every corner offers inspiration, live amidst the vibrant tapestry of shops, restaurants & cultural attractions with easy transportation options!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-04-09T10:48:11.000+0000
pba__latitude_pb__c, 37.7642742
pba__latitude_property__c, 37.7642742
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2024-03-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dale
pba__listing_agent_lastname__c, Boutiette
listing_agent_mls_id__c, 806303
ffd_listingagentname, Dale T Boutiette
listing_agent_number__c, 166016715
listing_co_agent_mls_id__c, 803120
listing_co_agent_number__c, 803120
listing_co_office_mls_id__c, COMP90
listing_co_office_name__c, Compass
listing_co_office_number__c, 29048
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.UrbanMissionVictorian.com/mls/130193336
pba__longitude_pb__c, -122.4164659
lower_level__c, Family Room,Full Bath(s),Loft
mls_id__c, 424011297
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-08
original_price__c, 1295000
overall_days_on_market__c, -81881
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 2024-03-18
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-08T14:22:44.000+0000
price_per_square_foot__c, 744.63
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001OJ2eMAG
room_type__c, Living Room;Dining Room;Possible Guest;Great Room;Primary Bedroom
sale_date__c, 2024-04-05
sale_price__c, 1630000
selling_agent_mls_id__c, 115218
selling_agent_number__c, 115218
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2189
size__c, 2189
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Shotwell
subdist__c, The Mission
ffd_name, 262 Shotwell Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530742018-1.jpg