meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='419234' 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, 1728913939
ffd_listing_title, 26 Hidalgo Terrace, San Francisco, CA, 94103
ffd_mls_id, 424073256
ffd_salesforce_id, a0EUd000003LMwhMAG
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 26 Hidalgo Terrace, San Francisco, CA, 94103
pba__address_pb__c, 26 Hidalgo Terrace, San Francisco, CA, 94103
agent_only_remarks__c, EZ to show.
appliances__c, Dishwasher;Free Standing Gas Range;Built-In Refrigerator
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Christopher V Sharpe
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-10-14T10:47:43.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Discover the epitome of modern luxury in this stunning 4BR, 3BA home nestled in the heart of Mission Dolores. This recently renovated & expanded property spans 3216 square feet of exquisite living space. Step into a home where hardwood and polished concrete floors harmonize effortlessly leading you through the meopen kitchen, dining, and family room. The chef's kitchen is a masterpiece, featuring a butcher block island, built-in subzero refrigerator, 5-burner ILVE range, and marble countertops. Arched patio doors open to a beautifully landscaped backyard with an in-ground hot tub, ideal for indulging in the ultimate indoor/outdoor living experience. Relax in the formal LR, where a gas fireplace and south-facing windows bathe the room in exceptional natural light. Upstairs, find four spacious BR's, two with walk-out balconies, offering a serene retreat. The spa-like bathroom featuring a soaking tub promises relaxation and tranquility. The lower level boasts a massive media room, an office, a laundry room, and a full bath and direct access to a 1-car garage. Located in the vibrant Mission Dolores area this home enjoys a 100 transit score and a 98 walk score. Enjoy walking proximity to Whole Foods, Dolores Park, & the bustling Valencia Corridor and Castro neighborhoods
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Gas Starter
pba__floortype_pb__c, Concrete;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry;Open Beam Ceiling
ffd_lastmodifieddate, 2024-10-14T13:47:17.000+0000
pba__latitude_pb__c, 37.7672202
pba__latitude_property__c, 37.7672202
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2024-10-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, LePage
listing_agent_mls_id__c, 804837
ffd_listingagentname, John L LePage
listing_agent_number__c, 166014530
listing_co_agent_mls_id__c, 805236
listing_co_agent_number__c, 166015077
listing_co_office_mls_id__c, CIP01
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 28939
listing_office_mls_id__c, CIP01
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28939
pba__listingprice_pb__c, 3200000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.26Hidalgo.com
pba__longitude_pb__c, -122.4260474
lower_level__c, Family Room,Full Bath(s),Garage
mls_id__c, 424073256
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-10-14
open_house_end__c, 2024-10-15T14:00:00.000+0000
open_house_start__c, 2024-10-15T12:00:00.000+0000
original_price__c, 3200000
overall_days_on_market__c, -82101
parking_access__c, Independent
parking_features__c, Enclosed,Garage Facing Front,Interior Access,Size Limited
parking_type__c, On Site (Single Family Only)
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, 995.02
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003LMwhMAG
sale_date__c, 1800-01-01
sale_price__c, 0
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, 3216
size__c, 3216
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hidalgo
subdist__c, Mission Dolores
ffd_name, 26 Hidalgo Terrace, San Francisco, CA, 94103
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530868045-1.jpg