meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='371952' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15110
[post_author] => 4
[post_date] => 2018-10-31 19:36:27
[post_date_gmt] => 2018-10-31 19:36:27
[post_content] => Not quite the Mission, not quite the Castro, Mission Dolores is a bustling, centrally located neighborhood with some iconic San Francisco attractions. The crown jewels of the neighborhood are Dolores Park and Mission Dolores, the oldest Spanish Mission church in San Francisco. Sun worshippers flock to Dolores Park on warm and cool days alike, and the church welcomes worshippers for regular services.
[post_title] => Mission Dolores
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-dolores
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:57:22
[post_modified_gmt] => 2024-03-19 19:57:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15110
[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, 1707360959
ffd_listing_title, 673 Guerrero Street, San Francisco, CA, 94110
ffd_mls_id, 424001583
ffd_salesforce_id, a0EUd000000r2IMMAY
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 673 Guerrero Street, San Francisco, CA, 94110
pba__address_pb__c, 673 Guerrero Street, San Francisco, CA, 94110
agent_only_remarks__c, Easy to show by appointment. Call or text Petra Langer 415.407.6895 to arrange. Prelim courtesy of Gerrie Brindley at Chicago Title. Disclosures ready.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Plumbed For Ice Maker
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1956
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Petra Langer
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-01-18T11:47:32.000+0000
days_on_market__c, 20
dom__c, 6
ffd_description_pb, Live steps from Dolores Park and the Valencia Corridor in this bright, remodeled, mid-century condominium. This full-floor renovated flat has it all: 2 bedrooms (one master suite), 2 bathrooms, bonus room, deeded parking, in-unit laundry, abundant storage, a lovely backyard and low HOA dues. The thoughtful layout features a sun-drenched living room, full-sized dining area and large kitchen towards the front of the unit with both generously sized bedrooms overlooking the tranquil landscaped backyard. On the ground level you'll find side-by-side garage parking along with a bonus room perfect for a home office or gym. Meticulously renovated, this condominium boasts wide plank hardwood floors throughout, new kitchen appliances, remodeled bathrooms, quartz kitchen and bath countertops, full-size washer and dryer, custom closets and top-down/bottom-up roman shades in the living room and blackout shades in the bedrooms. Spend your free time relaxing in Dolores Park, snacking on treats from Tartine Bakery, grocery shopping at Bi-Rite and exploring the many nearby restaurants. This picture-perfect home in a quiet two-unit building checks all the boxes while offering its new owner unparalleled access to one of the most dynamic and desirable San Francisco neighborhoods.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance,Maintenance Grounds,Trash
pba__hoafees__c, 291
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-02-08T02:46:50.000+0000
pba__latitude_pb__c, 37.74885785
pba__latitude_property__c, 37.74885785
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-11-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brendon
pba__listing_agent_lastname__c, Kearney
listing_agent_mls_id__c, 802979
ffd_listingagentname, Brendon Kearney
listing_agent_number__c, 802979
listing_co_agent_mls_id__c, 816725
listing_co_agent_number__c, 1075671
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/903882150
pba__longitude_pb__c, -122.4225273
mls_id__c, 424001583
master_bathroom_features__c, Double Sinks
master_property__c, a0O8W00000EV3bvUAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-18
original_price__c, 1295000
overall_days_on_market__c, -81831
parking_access__c, Independent
parking_features__c, Covered,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2024-01-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-02-07T11:18:44.000+0000
price_per_square_foot__c, 1063.43
pba__propertytype__c, Condominium
ListingId, a0EUd000000r2IMMAY
sale_date__c, 2024-02-07
sale_price__c, 1425000
selling_agent_mls_id__c, 803117
selling_agent_number__c, 803117
selling_co_agent_mls_id__c, 809927
selling_co_agent_number__c, 1044191
selling_co_office_mls_id__c, VIVRE
selling_co_office_name__c, Vivre Real Estate
selling_co_office_number__c, 28694
selling_office_name__c, Vivre Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1340
size__c, 1340
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Guerrero
subdist__c, Mission Dolores
ffd_name, 673 Guerrero Street, San Francisco, CA, 94110
view__c, City;Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1956
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530720552-1.jpg