ffd_listing_title,8 Hidalgo Terrace, San Francisco, CA, 94103
ffd_mls_id,423728516
ffd_salesforce_id,a0E8W00000bFydIUAS
num_of_fireplaces__c,1
num_of_rooms__c,8
of_units__c,0
address2__c,8 Hidalgo Terrace, San Francisco, CA, 94103
pba__address_pb__c,8 Hidalgo Terrace, San Francisco, CA, 94103
agent_only_remarks__c,Please text or email for the fastest response to arrange showing/get instructions at (415) 515-2361 (cell) or email [email protected] Ok to go directly but please confirm with some notice so I can advise for access. Disclosures io link: Coming Soon - Home & Pest inspections Thursday 3/23. Offer date: after 1st open house weekend 3/25-3/26 will be announced. Please submit any offers on SFAR contract & include POF, Pre-Approval Letter and signed disclosure cover sheet. Pre-escrow opened at Old Republic Title Company w/Nate Scharton.
appliances__c,Dishwasher;Disposal;Free Standing Refrigerator;Wine Refrigerator;Double Oven;Ice Maker;Gas Cook Top
architectural_style__c,Edwardian
bath_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Dual Flush Toilet;Skylight/Solar Tube;Low-Flow Shower(s)
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,3
year_build_text__c,1920
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-03-20T18:48:36.000+0000
days_on_market__c,4
dom__c,4
ffd_description_pb,Situated on the end of a quiet cul-de-sac, sits this well-appointed Mission Dolores Edwardian home, a few blocks from Dolores Park. The main level features newly refinished wood floors throughout & formal living room boasting a wall of south-facing windows & wood-burning fireplace w/built-in cabinets. Beautiful archways lead to an Art Deco inspired dining room steps away, a freshly remodeled kitchen w/quartz counters, center island w/bar seating, gas cooktop + new SS appliances & sleek cabinets w/stylish finishes. A casual additional dining space/family room sits off kit w/steps leading down to the permitted addition (built for sound-proof music studio) featuring double-height windows & raised ceiling, makes an excellent media room or guest quarters -flex space! An ideal floor plan offering 3 well-sized bedrooms on upper level (new carpet), updated guest bath + huge primary suite w/sitting area & walk-in closet. French doors open to the upper deck w/jetted spa & cityscape/Salesforce views & overlooking the giant, mature Palm in rear yard. Backyard is low maintenance w/outdoor lounge area - great for entertaining! A massive garage w/tons of storage + NEW W/D, furnace & water heater. Ultra central location steps to Whole Foods, Bi-Rite, Dolores Park Cafe w/98WalkScore/99 RideScore!
district__c,SF District 5
entry_level__c,0
exterior_features__c,Entry Gate
external_listing__c,1
fireplace_features__c,Living Room;Wood Burning;Brick
pba__floortype_pb__c,Carpet;Tile;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
has_3d_tour__c,1
pba__heatingtype_pb__c,Central
interior_features__c,Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate,2023-03-24T10:49:11.000+0000
pba__latitude_pb__c,37.76728
pba__latitude_property__c,37.76728
laundry_features__c,In Garage;Washer Included;Dryer Included;Chute;Space For Frzr/Refr
listed_date__c,2022-09-14
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Joanna
pba__listing_agent_lastname__c,Rose
listing_agent_mls_id__c,810961
ffd_listingagentname,Joanna Rose
listing_agent_number__c,1048852
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,REDF
listing_office_name__c,Redfin
listing_office_number__c,64045
pba__listingprice_pb__c,2998000
pba__listingtype__c,Sale
pba__listing_website__c,https://my.matterport.com/show/?m=nHUGaxSvWrJ
pba__longitude_pb__c,-122.425766
lower_level__c,Garage,Retreat,Street Entrance
mls_id__c,423728516
main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Tile;Low-Flow Shower(s);Skylight/Solar Tube
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2023-03-20
open_house_end__c,2023-03-25T13:00:00.000+0000
open_house_start__c,2023-03-25T11:00:00.000+0000
original_price__c,2998000
overall_days_on_market__c,-81527
parking_access__c,Independent
parking_features__c,Attached,Enclosed,Garage Door Opener,Interior Access,Tandem Garage,Workshop in Garage,See Remarks
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,1028.47
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000bFydIUAS
room_type__c,Kitchen;Studio;Living Room;Baths Other;Dining Room;Family Room;Great Room;Media Room;Primary Bathroom;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Security Gate;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
spa__c,1
pba__state_pb__c,CA
stories__c,3
pba__street_pb__c,Hidalgo
subdist__c,Mission Dolores
ffd_name,8 Hidalgo Terrace, San Francisco, CA, 94103
view__c,City;Downtown;San Francisco
website_property_type__c,Single Family Home
window_features__c,Dual Pane Partial;Triple Pane Partial
pba__yearbuilt_pb__c,1920
pba__postalcode_pb__c,94103
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530592866-1.jpg