meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='383189' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15717
[post_author] => 4
[post_date] => 2018-11-02 19:54:32
[post_date_gmt] => 2018-11-02 19:54:32
[post_content] => Once a San Francisco skunkworks flying pirate flags filled with humble Victorian cottages owned by ladies who loved ladies and looked forward to long dog walks. Then it gentrified. Silicon Valley stock options splurged on homes here. Dwell magazine arrived next to document the results. While it might be one Bernal, the neighborhood has several distinct geographic vibes and styles. It's not complicated, perhaps recently algorithmically optimized?
[post_title] => Bernal Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bernal-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-11 10:53:21
[post_modified_gmt] => 2024-11-11 18:53:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15717
[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, 1735681850
ffd_listing_title, 3241 Mission Street #4, San Francisco, CA, 94110
ffd_mls_id, 424046050
ffd_salesforce_id, a0EUd000002SojtMAC
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 9
address2__c, 3241 Mission Street #4, San Francisco, CA, 94110
pba__address_pb__c, 3241 Mission Street #4, San Francisco, CA, 94110
agent_only_remarks__c, SFAR Supra Lockbox on Front Gate labeled Unit 4. There are four keys in it. One for the front doors, one for the unit front door, one for the laundry room and one for the storage room. Door to the right of Unit Front Door leads to walkway - laundry room is just a few steps on the left. Storage Room is in the garage. Parking Spot for Unit 4 is the one diagonal space (labeled 4). It is for a Compact sized Car only. Please please make sure all lights are turned off and all doors are locked when you leave. Thanks!
appliances__c, Dishwasher;Microwave;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1980
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-07-17
cooling__c, Ceiling Fan(s)
ffd_createddate, 2024-07-02T01:47:51.000+0000
days_on_market__c, 183
dom__c, 21
ffd_description_pb, Welcome to 3241 Mission Street, Unit 4, a modern and chic urban retreat in the heart of San Francisco! This stylish 1-bedroom, 1-bathroom home offers 572 square feet of functional living space, perfect for those seeking a contemporary city lifestyle. The interior features sleek finishes, private outdoor space, and a well-appointed kitchen. The convenience of a garage adds to the appeal, providing secure parking and storage in this bustling neighborhood. Situated in a prime location, this remodeled residence offers easy access to the vibrant culture, dining, and entertainment options that San Francisco has to offer. Don't miss the opportunity to own this sophisticated urban oasis in one of the city's most sought-after neighborhoods.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
hoa_fee_includes__c, Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Roof,Trash,Water
pba__hoafees__c, 275
hoa_name__c, 3241-3243 Mission St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-08-01T11:47:25.000+0000
pba__latitude_pb__c, 37.744802
pba__latitude_property__c, 37.744802
laundry_features__c, Other
listed_date__c, 2024-05-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nana
pba__listing_agent_lastname__c, Meyer
listing_agent_mls_id__c, 271100
ffd_listingagentname, Nana Meyer
listing_agent_number__c, 271100
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 460000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.3241mission4.com/mls/146369116
pba__longitude_pb__c, -122.4199728
mls_id__c, 424046050
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0OUd0000091k6sMAA
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-07-01
original_price__c, 460000
overall_days_on_market__c, -81996
parking_access__c, Side by Side
parking_features__c, Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2024-07-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-07-31T22:30:05.000+0000
price_per_square_foot__c, 795.45
pba__propertytype__c, Condominium
ListingId, a0EUd000002SojtMAC
sale_date__c, 2024-07-31
sale_price__c, 455000
selling_agent_mls_id__c, 813228
selling_agent_number__c, 1060322
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, 572
size__c, 572
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, Bernal Heights
ffd_name, 3241 Mission Street #4, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1980
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530803742-1.jpg