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-11-15 12:13:19
[post_modified_gmt] => 2024-11-15 20:13:19
[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, 1744543038
ffd_listing_title, 25 Hidalgo Terrace, San Francisco, CA, 94103
ffd_mls_id, 425018894
ffd_salesforce_id, a0EUd000004YJNiMAO
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
pba__address_pb__c, 25 Hidalgo Terrace, San Francisco, CA, 94103
address2__c, 25 Hidalgo Terrace, San Francisco, CA, 94103
agent_only_remarks__c, Offers will be reviewed Tuesday 4/1 at 1pm.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Ice Maker;Built-In Refrigerator;Plumbed For Ice Maker;Gas Plumbed
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Dual Flush Toilet
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-03-19T19:47:30.000+0000
days_on_market__c, 25
dom__c, 13
ffd_description_pb, This beautifully renovated, modern 5 bed 3.5 bath home has undergone major updates and modernization. Secluded on a quiet cul-de-sac, you enter from a sheltered porch. The open plan living space offers indoor-outdoor living from the entire main floor. The stylish kitchen, with a large island and dining area, open directly to the backyard and deck. From the adjacent living area there is access to a second private deck. A half-bath and mudroom are conveniently tucked off the entry. The well laid out top floor offers tremendous flexibility. The primary suite with spa-like bath and large closet also has a separate sitting area. Two spacious bedrooms, one with an ensuite bath, overlook the garden and share access to the sunroom. The sunroom is an ideal space to devote to children. The 4th and 5th bedrooms, off the hall, are ideal for guests or as a home office. Laundry and an additional full bath are conveniently located off the central hall. The home has modern amenities, full seismic upgrades and numerous important system upgrades. With a Walk Score of 98, proximity to transit, restaurants and shopping, and a uniquely private location, this home offers an opportunity to live in one of San Francisco's most coveted and vibrant neighborhoods.
25 Hidalgo Terrace, San Francisco, CA, 94103 - Property Description
This beautifully renovated, modern 5 bed 3.5 bath home has undergone major updates and modernization. Secluded on a quiet cul-de-sac, you enter from a sheltered porch. The open plan living space offers indoor-outdoor living from the entire main floor. The stylish kitchen, with a large island and dining area, open directly to the backyard and deck. From the adjacent living area there is access to a second private deck. A half-bath and mudroom are conveniently tucked off the entry. The well laid out top floor offers tremendous flexibility. The primary suite with spa-like bath and large closet also has a separate sitting area. Two spacious bedrooms, one with an ensuite bath, overlook the garden and share access to the sunroom. The sunroom is an ideal space to devote to children. The 4th and 5th bedrooms, off the hall, are ideal for guests or as a home office. Laundry and an additional full bath are conveniently located off the central hall. The home has modern amenities, full seismic upgrades and numerous important system upgrades. With a Walk Score of 98, proximity to transit, restaurants and shopping, and a uniquely private location, this home offers an opportunity to live in one of San Francisco's most coveted and vibrant neighborhoods.
Appliances: Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Ice Maker;Built-In Refrigerator;Plumbed For Ice Maker;Gas Plumbed
Laundry Features: Laundry Closet;Washer/Dryer Stacked Included;Upper Floor;Stacked Only
Bath Features: Tub w/Shower Over;Shower Stall(s);Dual Flush Toilet
