meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338168' 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] => 2023-06-23 09:06:17
[post_modified_gmt] => 2023-06-23 16:06:17
[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
(
)
)
ffd_listing_title, 279 Clinton Park #B, San Francisco, CA, 94103
ffd_mls_id, 423907388
ffd_salesforce_id, a0E8W00000dSGFBUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 6
address2__c, 279 Clinton Park #B, San Francisco, CA, 94103
pba__address_pb__c, 279 Clinton Park #B, San Francisco, CA, 94103
agent_only_remarks__c, Easy to show - call Brendon at 415-640-4757. Prelim courtesy of Gerrie Brindley at Chicago Title. Disclosure package available upon request. Property is commonly known as 279B Clinton Park (even by USPS), however the MLS will not allow this entry.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Ice Maker;Built-In Refrigerator
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-09-08T22:47:06.000+0000
days_on_market__c, 10
dom__c, 10
ffd_description_pb, Timeless Elegance in the Heart of San Francisco: Top-Floor Edwardian Gem This top-floor Edwardian condominium in San Francisco seamlessly combines historic charm with modern comforts. It boasts a meticulously remodeled kitchen and bath, soft wood floors, in-unit laundry, and a versatile work area. The bedroom is bathed in natural light and features a walk-in closet. Southern exposure floods the space with light, and a shared common garden offers a tranquil escape. Additional storage is available on-site. Located in a boutique building, this condo is perfectly situated for exploring the vibrant Castro, eclectic Mission, and trendy Hayes Valley. For commuters, it's a dream come true with easy access to public transit and freeways. This condo epitomizes the idea that big things come in small packages. Don't miss the chance to own a piece of San Francisco's vibrant lifestyle, where history and modernity coexist seamlessly.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Roof,Sewer,Trash,Water
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 277 - 279 Clinton Park HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2023-09-19T00:46:13.000+0000
pba__latitude_pb__c, 37.768862
pba__latitude_property__c, 37.768862
laundry_features__c, Washer/Dryer Stacked Included;Inside Area
listed_date__c, 2023-06-22
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_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 675000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.279clintonpark.com/mls/113917511
pba__longitude_pb__c, -122.426173
mls_id__c, 423907388
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tile;Window
master_property__c, a0O8W00000KSvkgUAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-09-08
open_house_end__c, 2023-09-19T13:30:00.000+0000
open_house_start__c, 2023-09-19T12:00:00.000+0000
original_price__c, 675000
overall_days_on_market__c, -81699
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, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000dSGFBUA4
room_type__c, Storage;Office
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clinton Park
subdist__c, Mission Dolores
ffd_name, 279 Clinton Park #B, San Francisco, CA, 94103
view__c, City Lights;Garden/Greenbelt;Hills
website_property_type__c, Condominium
window_features__c, Window Screens
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530673926-1.jpg
