meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327158' 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
(
)
)
ffd_listing_title, 376 San Carlos Street #B, San Francisco, CA, 94110
ffd_mls_id, 423717682
ffd_salesforce_id, a0E8W00000a8NcHUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 2
address2__c, 376 San Carlos Street #B, San Francisco, CA, 94110
pba__address_pb__c, 376 San Carlos Street #B, San Francisco, CA, 94110
agent_only_remarks__c, More details and video at www.376SanCarlosB.com Please call/text Ron at 415-279-4579 with questions or to request a showing. Short walk to Mission Bartlett Garage for full size vehicles. Seller to pre-pay parking for 6 months.
appliances__c, Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Shower Stall(s);Dual Flush Toilet;Quartz
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-02-13
ffd_createddate, 2023-02-03T03:47:30.000+0000
days_on_market__c, 167
dom__c, 19
ffd_description_pb, Welcome home to 376 San Carlos St Unit B! This completely renovated, Italianate Victorian condominium is located on a tree-lined street in the coveted Liberty Hill Historic District just steps to the many cafes, restaurants and boutique shops on Valencia and Mission Streets. The luxe property features designer finishes and a state-of-the-art chef's kitchen opening to a spacious living room. The large bedroom with ample closet space is adjacent to the spa-like full bathroom with Grohe plumbing fixtures and a stone walk-in shower. A built-in home office overlooks the verdant rear patio that is an urban oasis -- perfect for relaxing, entertaining, bbq'ing and al-fresco dining. Close to zero net energy, the building features a photovoltaic solar system, a gray water system in addition to in-unit laundry, radiant heat, recessed lighting and Sonos speakers, Nest thermostat, Ring security cameras, August Smartlock and much more... Low monthly HOA's $150 and healthy financial reserves! Leased parking nearby pre-paid for six months by seller. Come experience San Francisco living at it's finest!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Concrete;Slate
hoa_fee_includes__c, Common Areas,Homeowners Insurance,Sewer,Water
pba__hoafees__c, 150
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Vermillion Doors HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2023-07-13T18:22:21.000+0000
pba__latitude_pb__c, 37.757387
pba__latitude_property__c, 37.757387
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-01-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ronald
pba__listing_agent_lastname__c, Sebahar
listing_agent_mls_id__c, 803012
ffd_listingagentname, Ronald Sebahar
listing_agent_number__c, 803012
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 699000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=RTwfp2j6ocT&mls=1
pba__longitude_pb__c, -122.419924
mls_id__c, 423717682
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O8W00000HrsEUUAZ
monthly_parking_fees__c, 365
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-02
original_price__c, 699000
overall_days_on_market__c, -81481
parking_access__c, Independent
parking_features__c, Side-by-Side
parking_type__c, Other
pba__pendingdate__c, 2023-02-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000a8NcHUAU
road_surface_type__c, Paved
room_type__c, Office
sale_date__c, 2023-03-03
sale_price__c, 763000
security_features__c, Smoke Detector;Carbon Mon Detector;Video System
selling_agent_mls_id__c, MLSL307499
selling_agent_number__c, 981151423
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Carlos
subdist__c, The Mission
ffd_name, 376 San Carlos Street #B, San Francisco, CA, 94110
website_property_type__c, Condominium
window_features__c, Dual Pane Full
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/530575722-1.jpg