_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