meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='381304' 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, 1721440519
ffd_listing_title, 3321 17th Street #7, San Francisco, CA, 94110
ffd_mls_id, 424037077
ffd_salesforce_id, a0EUd000002ETH7MAO
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 21
address2__c, 3321 17th Street #7, San Francisco, CA, 94110
pba__address_pb__c, 3321 17th Street #7, San Francisco, CA, 94110
agent_only_remarks__c, Offer date is Weds, July 17th at 12noon. Please contact Listing Agents for private showings. Do not schedule via Showing Time. Contact Janet Ra, 415-867-4029, [email protected], or Gina Blancarte, 415-879-8690, or [email protected]. Disclosure package available.
appliances__c, Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Gina G Blancarte
pba__contingentdate__c, 2024-07-18
cooling__c, None
ffd_createddate, 2024-06-06T10:48:58.000+0000
days_on_market__c, 43
dom__c, 43
ffd_description_pb, Buy a city condo at an incredible price! This well maintained corner unit is flooded with natural light and awaits your arrival. Step into the inviting living room adorned with a gracefully arched ceiling, exquisite crown molding, and gleaming hardwood floors. Enjoy the charming window seat nestled within a bay window, complemented by a spacious closet featuring elegant French doors. The bedroom boasts the same hardwood floors, crown molding, and another delightful bay window with its own cozy window seat. The kitchen, perfect for casual dining, showcases original wooden cabinets and sleek granite countertops. This also includes deeded storage for your added convenience. Situated in the Inner Mission, this distinctive condo with a 100 Walk Score & 100 Bike Score is just steps from the lively Valencia Street corridor, featuring trendy retail shops and restaurants. Public transportation is conveniently located one block away along with easy access to freeways, enhancing the accessibility of this prime location.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior,Management,Trash,Water
pba__hoafees__c, 389
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3321 17th Street Condominiums Owners Assoc
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2024-07-20T01:49:56.000+0000
pba__latitude_pb__c, 37.7632003
pba__latitude_property__c, 37.7632003
laundry_features__c, In Garage
listed_date__c, 2024-04-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Janet
pba__listing_agent_lastname__c, Ra
listing_agent_mls_id__c, 813420
ffd_listingagentname, Janet Ra
listing_agent_number__c, 1061180
listing_co_agent_mls_id__c, 813228
listing_co_agent_number__c, 1060322
listing_co_office_mls_id__c, COMP50
listing_co_office_name__c, Compass
listing_co_office_number__c, 28741
listing_office_mls_id__c, COMP50
listing_office_name__c, Compass
listing_office_number__c, 28741
pba__listingprice_pb__c, 520000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4200575
mls_id__c, 424037077
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0OUd0000083GZvMAM
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-06-06
original_price__c, 520000
overall_days_on_market__c, -81971
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, 1040
pba__propertytype__c, Condominium
ListingId, a0EUd000002ETH7MAO
room_type__c, Kitchen;Living Room;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 500
size__c, 500
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 17th
subdist__c, The Mission
ffd_name, 3321 17th Street #7, San Francisco, CA, 94110
view__c, City
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530785815-1.jpg
