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, 1709380568
ffd_listing_title, 3574 19th Street, San Francisco, CA, 94110
ffd_mls_id, 424004119
ffd_salesforce_id, a0EUd0000011CbJMAU
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 3574 19th Street, San Francisco, CA, 94110
pba__address_pb__c, 3574 19th Street, San Francisco, CA, 94110
agent_only_remarks__c, Easy to show call Josh Burns at 415-307-2463.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Built-In Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-02-02T18:46:44.000+0000
days_on_market__c, 29
dom__c, 14
ffd_description_pb, This luxury top-floor 2BR/2BA condo designed by an award-winning architect is located in the highly coveted Mission Dolores neighborhood. In a well-maintained boutique 2-unit building, this turnkey home is filled with natural light and features extensive renovations with timeless finishes and superior craftsmanship. Perfect for comfortable living, the spacious living room and dining room provide an inviting open layout concept overlooking the scenic park across the street. The stunning gourmet kitchen features walnut cabinetry, quartz countertops, walk-in pantry, and stainless-steel appliances including gas range. Both bedrooms boast built-in custom closets, while the primary suite offers a spa-like bathroom for added luxury. A private patio directly accessible off the home leads to a special premier private rooftop deck with panoramic city views and is ideal for outdoor entertaining. Additional amenities include in-unit laundry, hardwood floors, dual-pane windows and 1-car garage parking. Conveniently situated near Dolores Park, upscale shops, renowned restaurants, public transit and shuttles, this home has a Walk Score of 98. Whether you're enjoying the renovated home or the private rooftop deck, this residence offers an unparalleled living experience in the heart of the city.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Electricity,Insurance,Trash
3574 19th Street, San Francisco, CA, 94110 - Property Description
This luxury top-floor 2BR/2BA condo designed by an award-winning architect is located in the highly coveted Mission Dolores neighborhood. In a well-maintained boutique 2-unit building, this turnkey home is filled with natural light and features extensive renovations with timeless finishes and superior craftsmanship. Perfect for comfortable living, the spacious living room and dining room provide an inviting open layout concept overlooking the scenic park across the street. The stunning gourmet kitchen features walnut cabinetry, quartz countertops, walk-in pantry, and stainless-steel appliances including gas range. Both bedrooms boast built-in custom closets, while the primary suite offers a spa-like bathroom for added luxury. A private patio directly accessible off the home leads to a special premier private rooftop deck with panoramic city views and is ideal for outdoor entertaining. Additional amenities include in-unit laundry, hardwood floors, dual-pane windows and 1-car garage parking. Conveniently situated near Dolores Park, upscale shops, renowned restaurants, public transit and shuttles, this home has a Walk Score of 98. Whether you're enjoying the renovated home or the private rooftop deck, this residence offers an unparalleled living experience in the heart of the city.
