meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235441' 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-04-11 08:39:15
[post_modified_gmt] => 2024-04-11 15:39:15
[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
(
)
)
ffd_listing_title, 3583 Mission Street #A, San Francisco, CA, 94110
ffd_mls_id, 422632889
ffd_salesforce_id, a0E8W00000VsxX5UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 2
address2__c, 3583 Mission Street #A, San Francisco, CA, 94110
pba__address_pb__c, 3583 Mission Street #A, San Francisco, CA, 94110
agent_only_remarks__c, The disclosure packet is available on homelight/IO and here is the link: https://app.disclosures.io/link/3583A-Mission-Street-8dvh0ubp Please email the listing agent to schedule appointments and follow advised health safety protocols.
appliances__c, Dishwasher;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Contemporary;Flat
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1998
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-02-25T17:47:43.000+0000
days_on_market__c, 509
dom__c, 26
ffd_description_pb, Impressive three-bedroom, two-bath updated home with an inviting open floor plan, intimate outdoor space, and located in an ideal Bernal Heights location! This modern flat opens to a large and open living area with gorgeous wood floors, fireplace, and an elegantly updated gourmet eat-in kitchen with tasteful finishes, adjacent to the dining area all awash natural light. The first of three bedrooms is in the middle of the flat near the updated bathroom and in-unit laundry. The back of the flat has two spacious bedrooms, one with an en-suite bathroom, and both nestled in a peaceful setting that opens directly to the serene private patio and tranquil backyard/garden setting. There are two parking spaces and a garage with plenty of space for storage that finish the modern flat that is truly move-in ready. Do not miss this special home that is close to shopping, restaurants, cafes, playgrounds, parks, MUNI, BART, HWY 101/280 and more!
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Maintenance Grounds,Trash,Water
pba__hoafees__c, 200
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 3583 Mission Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-04-22T11:45:59.000+0000
pba__latitude_pb__c, 37.73925
pba__latitude_property__c, 37.73925
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2022-02-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeffrey
pba__listing_agent_lastname__c, Salgado
listing_agent_mls_id__c, 805001
ffd_listingagentname, Jeffrey A Salgado
listing_agent_number__c, 166014760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=UX9rYHv5dii&mls=1
pba__longitude_pb__c, -122.423598
mls_id__c, 422632889
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s)
master_property__c, a0O8W00000EUDEsUAP
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-02-25
original_price__c, 1159000
overall_days_on_market__c, -81139
parking_access__c, Tandem
parking_features__c, Assigned,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Tandem Garage
parking_type__c, On Site - Assigned (Condo Only);On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2022-03-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-21T22:16:26.000+0000
price_per_square_foot__c, 1027.45
pba__propertytype__c, Condominium
id, a0E8W00000VsxX5UAJ
room_type__c, Office;Den;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2022-04-20
sale_price__c, 1310000
security_features__c, Security Gate
selling_agent_mls_id__c, 800265
selling_agent_number__c, 800265
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, W Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1275
size__c, 1275
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, Bernal Heights
ffd_name, 3583 Mission Street #A, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1998
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530408511-1.jpg
ListingId, a0E8W00000VsxX5UAJ