ffd_listing_title,590 Melrose Avenue, San Francisco, CA, 94127
ffd_mls_id,423907772
ffd_salesforce_id,a0E8W00000dTPFEUA4
num_of_fireplaces__c,1
num_of_rooms__c,8
of_units__c,0
address2__c,590 Melrose Avenue, San Francisco, CA, 94127
pba__address_pb__c,590 Melrose Avenue, San Francisco, CA, 94127
agent_only_remarks__c,Please email [email protected] for all showings (phone # listed does not take text messages). Please use a SFAR Purchase Contract & stipulate that buyer's initial deposit will be in escrow within 1 business day of acceptance. Escrow opened with WFG National Title Insurance Company, escrow officer Katerina Rosignuolo 415-919-9853.
appliances__c,Dishwasher;Built-In Gas Range;Free Standing Refrigerator;Gas Plumbed
architectural_style__c,Mediterranean;French;See Remarks
bath_features__c,Shower Stall(s);Tile;Window;Closet
pba__fullbathrooms_pb__c,1
pba__bedrooms_pb__c,3
year_build_text__c,1940
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-09-21T18:46:47.000+0000
days_on_market__c,0
dom__c,0
ffd_description_pb,Majestic French Mediterranean 'Art Deco' view home proudly situated on an impressive knoll w/terrific pass-through driveway! The classic residence w/decorative tile facade & arched entry leads to a notable front door & into a delightful foyer w/coat closet. Magnificent formal living rm w/vaulted ceiling boasts a fireplace w/handsome mantel & brick surround, parquet hardwood floors, gorgeous arched picture windows w/stained-glass panels & sweeping vistas from the Bay to the southern hills. The light-filled formal dining rm w/crown moldings & striking chandelier is perfect for entertaining! Nicely updated kitchen w/skylight showcases a time-honored Wedgewood four-burner gas range w/separate baking oven & broiler, Bosch dishwasher, granite counters w/tile backsplash, wood cabinets, pantry & a fabulous adjacent study/menu planning breakfast rm w/built-in bookshelves. Split-level staircase ascends to the sumptuous master bedroom w/dressing rm, built-in secretary/vanity, walk-in closet & views to the garden oasis. Huge laundry rm w/utility sink, workroom w/expansive workbench, artist studio loft, great built-in storage. Magical park-like landscaped backyard w/tradesman's entrance, spacious patio & spectacular terraced garden w/birdbath & a variety of mature, colorful plants & trees!
district__c,SF District 4
driveway_sidewalks__c,Paved Driveway,Sidewalk/Curb/Gutter
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard;Fenced
fireplace_features__c,Living Room;Gas Piped
pba__floortype_pb__c,Carpet;Tile;Wood
pba__hoafees__c,25
pba__hoafrequency_pb__c,Annually
hoa_name__c,Westwood Highlands HOA
hoa__c,Yes
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Central;Gas
interior_features__c,Formal Entry;Skylight(s);Storage Area(s);Cathedral Ceiling
ffd_lastmodifieddate,2023-09-21T19:46:39.000+0000
pba__latitude_pb__c,37.7333048
pba__latitude_property__c,37.7333048
laundry_features__c,Inside Room;Washer Included;Dryer Included
listed_date__c,2023-09-21
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Andrew
pba__listing_agent_lastname__c,Herrera II
listing_agent_mls_id__c,404547
ffd_listingagentname,Andrew Herrera II
listing_agent_number__c,404547
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,BHFP
listing_office_name__c,Berkshire Hathaway-Franciscan
listing_office_number__c,1665
pba__listingprice_pb__c,1495000
pba__listingtype__c,Sale
pba__listing_website__c,https://click.pstmrk.it/3s/https-www-spotlighthomephotos-com.aryeo.com%2Fsites%2Fdnoxwmm%2Funbranded/cUpU/ExuwAQ/BA/3da8d0f3-de07-4149-8c4c-dff38544f9a3/15/q37HvFfW5n
pba__longitude_pb__c,-122.4538435
lower_level__c,Bedroom(s),Garage,Partial Bath(s),Street Entrance
mls_id__c,423907772
main_level__c,Kitchen;Living Room;Dining Room;Street Entrance
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2023-09-21
original_price__c,1495000
overall_days_on_market__c,-81712
parking_access__c,Tandem
parking_features__c,Attached,Covered,Garage Facing Front,Interior Access,Tandem Garage,Workshop in Garage,See Remarks
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Uncovered Patio;Front Porch
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,767.45
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000dTPFEUA4
road_surface_type__c,Paved
roof__c,Composition;Shingle;Other
room_type__c,Office;Laundry;Kitchen;Living Room;Baths Other;Dining Room;Workshop;Primary Bedroom
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,1948
size__c,1948
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Melrose
subdist__c,Westwood Highlands
ffd_name,590 Melrose Avenue, San Francisco, CA, 94127
view__c,Panoramic;City Lights;Bay;Water;Hills;Mountains
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,1940
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530680760-1.jpg
