meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385791' 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, 1726225014
ffd_listing_title, 803 Shotwell Street, San Francisco, CA, 94110
ffd_mls_id, 424055334
ffd_salesforce_id, a0EUd0000032lFfMAI
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 803 Shotwell Street, San Francisco, CA, 94110
pba__address_pb__c, 803 Shotwell Street, San Francisco, CA, 94110
agent_only_remarks__c, It is not tenancy in common (TIC), it is a condo with its own seperated tax bill and deed. Regular lockbox on site. For showings, text or call (Simon) 415-613-0084 for access information. No inspection report had been done since it is a pretty straightforward condo. Buyer to verify square feet and conduct due diligence. Please contact me for all offer related questions. (Simon) Shiming Li 415-613-0084. Email offers to [email protected]. You can click "Join my Virtual Open House" on the Open house tab and it will direct you to a full youtube video that I've done an overview of the property in great detail. Feel free to send it to your clients since it is a public youtube video https://youtu.be/-P_vakMETE0. Escrow is opened with Fidelity National Title Company, Lynn Chan. Escrow number is FSFM-1072400731. Offer end date set for 09-20 6:00pm, back up offer will be accepted just in case, property will continue to show until escrow is close. Disclosure link: https://app.disclosures.io/link/803-Shotwell-Street-3tdck6zf
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Gas Cook Top
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-06T10:49:37.000+0000
days_on_market__c, 7
dom__c, 7
ffd_description_pb, Charming 2-Bedroom, 2-Bath Home in the Heart of the Mission District.Welcome to your sunny sanctuary in the vibrant Mission District! This beautifully maintained 2-bedroom, 2-bath property offers the perfect blend of comfort and convenience, making it an ideal home for anyone looking to enjoy the best of San Francisco. Nestled in a dog-friendly neighborhood, you'll love the picturesque walks with your furry friend along flower-lined streets that greet you with delightful scents each day. The home is thoughtfully secured with gated doors and windows, providing peace of mind without sacrificing style. Inside, you'll find a spacious open-concept kitchen and living area that's perfect for family gatherings and entertaining friends. The large windows invite an abundance of natural light, creating a warm and inviting atmosphere throughout the day. Location is everything, and this property truly delivers. With the freeway just five minutes away, you're never far from the action. Whether you need to commute or explore the city, getting around is a breeze. San Francisco General Hospital is just three minutes away, ensuring peace of mind for your healthcare needs. Living in the Mission District means being at the epicenter of culture, cuisine, and community. Don't miss this opportunity!!!
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Bamboo;Tile;Wood
hoa_fee_includes__c, Maintenance Exterior,Trash,Water
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Shotwell HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2024-09-13T10:46:50.000+0000
pba__latitude_pb__c, 37.7554279
pba__latitude_property__c, 37.7554279
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included;Gas Hook-Up;Electric
listed_date__c, 2024-08-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shiming
pba__listing_agent_lastname__c, Li
listing_agent_mls_id__c, 818221
ffd_listingagentname, Shiming Li
listing_agent_number__c, 1076989
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PAN
listing_office_name__c, Premier Agent Network
listing_office_number__c, 28566
pba__listingprice_pb__c, 749000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/-P_vakMETE0
pba__longitude_pb__c, -122.4153597
mls_id__c, 424055334
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0OUd00000BhnARMAZ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-09-06
open_house_end__c, 2024-09-13T18:30:00.000+0000
open_house_start__c, 2024-09-13T15:30:00.000+0000
original_price__c, 749000
overall_days_on_market__c, -82063
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, 986.82
pba__propertytype__c, Condominium
ListingId, a0EUd0000032lFfMAI
roof__c, Composition
room_type__c, Storage
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate;Fire Extinguisher;Carbon Mon Detector;Window Security Bars
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, 759
size__c, 759
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Shotwell
subdist__c, The Mission
ffd_name, 803 Shotwell Street, San Francisco, CA, 94110
view__c, City Lights;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530823016-1.jpg
