meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339606' 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, 1696417748
ffd_listing_title, 2639 22nd Street, San Francisco, CA, 94110
ffd_mls_id, 423905866
ffd_salesforce_id, a0E8W00000cqL4dUAE
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 2
address2__c, 2639 22nd Street, San Francisco, CA, 94110
pba__address_pb__c, 2639 22nd Street, San Francisco, CA, 94110
agent_only_remarks__c, This luxurious and sophisticated Mission district home in a 2-unit building with low HOA dues is not to be missed! Vacant and easy to show by appointment - schedule through ShowingTime. Pre-escrow #02216038243 opened with Old Republic Title. Contact Maria Smith, Escrow Officer, at 415.570.0872 or [email protected]. Pet Restrictions: Up to 2 four-legged pets allowed when owner-occupied (if tenant occupied, only one dog allowed); Dog breeds not permitted include: Mastiff, Rottweiler, Doberman, Presa Canarin & Pit Bull. Rental Restrictions: when whole unit is rented, a copy of the rental agreement must be provided to the HOA (see details in CC&Rs). https://2639-22ndst.com.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Flat
bath_features__c, Tub w/Shower Over;Stone
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1912
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Hayley G Kerstein
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-05T18:46:49.000+0000
days_on_market__c, 29
dom__c, 9
ffd_description_pb, Want luxury and sophistication in the Mission? This top-level, full-floor condo in a 2-unit bldg is the one! The fantastic open-floor plan creates a warm and inviting atmosphere and is perfect for entertaining. The spacious great room features the formal living area w/frplc and brick surround, and family/dining area that seamlessly connects to the updated kitchen. The kitchen is a chef's dream w/stone counters, beautiful new backsplash, stainless appliances, abundant cabinetry and breakfast bar. At the rear of the home is the gracious primary suite and generous guest BD. Both BDs are drenched in natural light from south-facing bay windows. The primary suite boasts a large walk-in closet and updated en-suite spa-like BA w/double vanity, jetted tub and separate stall shower. A second full BA w/shower-over-tub is easily accessed from the hallway. In-unit laundry is also included. Interior stairs lead to the exclusive-use roof deck - perfect for your next Blue Angels or Independence Day fireworks viewing parties! 1-car garage parking w/extra storage completes the unit. Close to everything Mission has to offer with a neighborhood feel/calmer atmosphere. Commuting is easy w/freeway access nearby and public transportation within walking distance. Scores: Walk=96; Bike=100; Transit=78.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance
pba__hoafees__c, 340
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-10-04T10:47:56.000+0000
pba__latitude_pb__c, 37.755898
pba__latitude_property__c, 37.755898
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-08-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Edmond
pba__listing_agent_lastname__c, O'Sullivan
listing_agent_mls_id__c, 804421
ffd_listingagentname, Eddie O'Sullivan
listing_agent_number__c, 166013970
listing_co_agent_mls_id__c, 811741
listing_co_agent_number__c, 1053391
listing_co_office_mls_id__c, ELEVATE
listing_co_office_name__c, Elevation Real Estate
listing_co_office_number__c, 27424
listing_office_mls_id__c, ELEVATE
listing_office_name__c, Elevation Real Estate
listing_office_number__c, 27424
pba__listingprice_pb__c, 1575000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.zillow.com/view-3d-home/2b65666c-0486-4491-8ed7-76057418e8f6?setAttribution=mls&wl=true&utm_source=dashboard
pba__longitude_pb__c, -122.407346
lower_level__c, Garage,Street Entrance
mls_id__c, 423905866
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Double Sinks;Soaking Tub;Jetted Tub;Stone
master_property__c, a0O8W00000KSgxjUAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-09-05
original_price__c, 1575000
overall_days_on_market__c, -81696
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 2023-09-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-10-03T13:53:01.000+0000
price_per_square_foot__c, 904.07
pba__propertytype__c, Condominium
ListingId, a0E8W00000cqL4dUAE
road_surface_type__c, Asphalt
room_type__c, Kitchen;Living Room;Guest Quarters;Baths Other;Dining Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-10-03
sale_price__c, 1555000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, A402979
selling_agent_number__c, 981019431
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1720
size__c, 1720
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 22nd
subdist__c, The Mission
ffd_name, 2639 22nd Street, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530671194-1.jpg