176 Merced Avenue, San Francisco, CA, 94127 - Property Description

_yoast_indexnow_last_ping,1713495456

ffd_listing_title,469 Ulloa Street, San Francisco, CA, 94127

ffd_mls_id,424025137

ffd_salesforce_id,a0EUd000001lmQQMAY

num_of_fireplaces__c,1

num_of_rooms__c,6

of_units__c,0

address2__c,469 Ulloa Street, San Francisco, CA, 94127

pba__address_pb__c,469 Ulloa Street, San Francisco, CA, 94127

agent_only_remarks__c,Trust sale, property to be sold as-is; no warranties expressed or implied. Koi pond and all equipment will remain as part of the sale. If buyers do not want fish, sellers will relocate prior to close of escrow. Disclosure package available on Disclosures.IO or copy and paste this link in browser: https://app.disclosures.io/link/469-Ulloa-Street-ezse3wlm Pre-escrow opened with Joy Fogarty, First American Title; [email protected]; Escrow #7070844.

appliances__c,Dishwasher;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Traditional;Craftsman

bath_features__c,Tub w/Shower Over;Shower Stall(s)

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,1924

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-04-18T02:46:44.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,This 1920s-era Craftsman-inspired home is being offered for the first time in over 57 years! Fantastic West Portal area, close to shops, restaurants, cafs, Metro station. Beautiful architectural details, gracious foyer w/original stained-glass window, welcoming living room w/rich wood accents, French windows, center fireplace w/built-in bookshelves. Dining room is an entertainer's delight, showcasing original built-in buffet. Kitchen is wrapped w/multiple windows, bringing in lots of natural light and offers great counter & cabinet space, direct access to large back deck ideal for lounging/BBQs. Main level w/2 beds + full bath off hall. Top floor has cozy bedroom w/nice neighborhood views & direct access to huge, finished attic space w/great potential. Lower level has 2nd full bath w/large stall shower, kitchenette, laundry, family room. This finished space is perfect for guests or extended family with entry from side door. 2-car garage + 1 in driveway, workshop, & wine cellar. Backyard features beautifully maintained one-of-a-kind koi pond, side yard with spacious lawn and planting areas. This location also has nearby access to Mt. Davidson hiking trails, Ulloa dog park, Miraloma shops, easy access to major freeways and downtown SF.

district__c,SF District 4

entry_level__c,0

external_listing__c,1

fireplace_features__c,Living Room;Wood Burning;Brick

pba__floortype_pb__c,Linoleum;Tile;Wood;Simulated Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-04-19T02:46:52.000+0000

pba__latitude_pb__c,37.74082

pba__latitude_property__c,37.74082

laundry_features__c,Laundry Closet;Ground Floor;Washer Included;Dryer Included

listed_date__c,2024-01-19

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Paul

pba__listing_agent_lastname__c,Barbagelata

listing_agent_mls_id__c,342615

ffd_listingagentname,Paul Barbagelata

listing_agent_number__c,342615

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,BARBCO

listing_office_name__c,BarbCo

listing_office_number__c,28297

pba__listingprice_pb__c,1795000

pba__listingtype__c,Sale

pba__listing_website__c,https://vimeo.com/935856557

pba__longitude_pb__c,-122.458953

lower_level__c,Family Room,Full Bath(s),Garage,Street Entrance

mls_id__c,424025137

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,3

on_market_date__c,2024-04-17

open_house_end__c,2024-04-18T18:00:00.000+0000

open_house_start__c,2024-04-18T16:30:00.000+0000

original_price__c,1795000

overall_days_on_market__c,-81921

parking_access__c,Tandem

parking_features__c,Attached,Enclosed,Interior Access,Workshop in Garage

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,798.13

pba__propertytype__c,Single Family Residence

ListingId,a0EUd000001lmQQMAY

room_type__c,Kitchen;Living Room;Dining Room;Attic;Family Room

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,2249

size__c,2249

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Ulloa

subdist__c,Laguna Honda - Forest Hill Extension

ffd_name,469 Ulloa Street, San Francisco, CA, 94127

website_property_type__c,Single Family Home

pba__yearbuilt_pb__c,1924

pba__postalcode_pb__c,94127

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530762868-1.jpg