ffd_listing_title,25 Hidalgo Terrace, San Francisco, CA, 94103
ffd_mls_id,423744653
ffd_salesforce_id,a0E8W00000cJ0m6UAC
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,0
address2__c,25 Hidalgo Terrace, San Francisco, CA, 94103
pba__address_pb__c,25 Hidalgo Terrace, San Francisco, CA, 94103
agent_only_remarks__c,Contact Massimo LoPorto for showings and information, [email protected], 415.572.6508. www.25HidalgoTerrace.com
appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c,Edwardian;Modern/High Tech
bath_features__c,Tub w/Shower Over;Shower Stall(s)
pba__fullbathrooms_pb__c,3
pba__bedrooms_pb__c,5
year_build_text__c,1922
pba__city_pb__c,San Francisco
listing_co_agent_name__c,Massimo Loporto
pba__contingentdate__c,1800-01-01
cooling__c,None
ffd_createddate,2023-06-02T00:49:55.000+0000
days_on_market__c,1
dom__c,1
ffd_description_pb,Extensively renovated and expanded, the modern home at 25 Hidalgo Terrace is tucked away off of Dolores St. on a quiet cul-de-sac in highly desirable Mission Dolores. The 2,915 sqft. home boasts five spacious bedrooms plus an office, all on one level! Upon entering the home through the landscaped front garden, you are greeted with a formal foyer adorned with European concrete floors that leads to the open main living area. Featuring tall ceilings and light from three sides, the great room includes a professional kitchen with Thermador appliances and tons of closet and pantry storage. Floor to ceiling folding glass doors at the living room lead to the lush landscaped garden with Ipe decking. The upper bedroom level includes a spacious primary suite with a large bonus sitting area and spa-like bathroom with a large window. The home is completed with 3.5 bathrooms, 3 car parking with EV outlet, and LG washer & dryer. This tranquil home has incredible curb appeal and privacy while being in the center of it all. Walk to Whole Foods, Dolores Park, MUNI, and the myriad of shops and restaurants on Valencia St. 98 Walk Score!
district__c,SF District 5
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard
pba__floortype_pb__c,Tile;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Central
interior_features__c,Formal Entry
ffd_lastmodifieddate,2023-06-02T10:49:52.000+0000
pba__latitude_pb__c,37.766859
pba__latitude_property__c,37.766859
laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included;Upper Floor
listed_date__c,2023-05-25
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Frank
pba__listing_agent_lastname__c,Nolan
listing_agent_mls_id__c,803037
ffd_listingagentname,Frank A Nolan
listing_agent_number__c,803037
listing_co_agent_mls_id__c,807921
listing_co_agent_number__c,1028628
listing_co_office_mls_id__c,VANG02
listing_co_office_name__c,Vanguard Properties
listing_co_office_number__c,166013449
listing_office_mls_id__c,VANG02
listing_office_name__c,Vanguard Properties
listing_office_number__c,166013449
pba__listingprice_pb__c,3695000
pba__listingtype__c,Sale
pba__listing_website__c,https://www.25hidalgoterrace.com/
pba__longitude_pb__c,-122.425897
mls_id__c,423744653
main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c,Shower Stall(s);Double Sinks;Tile;Soaking Tub
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,3
on_market_date__c,2023-06-01
open_house_end__c,2023-06-04T15:00:00.000+0000
open_house_start__c,2023-06-04T13:00:00.000+0000
original_price__c,3695000
overall_days_on_market__c,-81600
parking_access__c,Side by Side
parking_features__c,EV Charging,Garage Door Opener,Garage Facing Front
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Covered Patio
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,1267.58
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000cJ0m6UAC
room_type__c,Office
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;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,2915
size__c,2915
pba__state_pb__c,CA
stories__c,2
pba__street_pb__c,Hidalgo
subdist__c,Mission Dolores
ffd_name,25 Hidalgo Terrace, San Francisco, CA, 94103
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,1922
pba__postalcode_pb__c,94103
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530623875-1.jpg