ffd_listing_title,139 Marietta Drive, San Francisco, CA, 94127
ffd_mls_id,423907002
ffd_salesforce_id,a0E8W00000dTwwnUAC
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,0
address2__c,139 Marietta Drive, San Francisco, CA, 94127
pba__address_pb__c,139 Marietta Drive, San Francisco, CA, 94127
agent_only_remarks__c,Vacant w/ Supra lockbox. Please call or text Mike or Ly for showing instructions. Pre-escrow opened with Mijael Schmidt at First American Title Company. Please email Mike or Ly for additional information and disclosures. 139Marietta.com
appliances__c,Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Built-In Electric Oven
bath_features__c,Tub w/Shower Over;Dual Flush Toilet;Bidet;Skylight/Solar Tube
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,3
year_build_text__c,1951
pba__city_pb__c,San Francisco
listing_co_agent_name__c,Ly Ly
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-09-29T17:47:19.000+0000
days_on_market__c,2
dom__c,2
ffd_description_pb,Exquisite Miraloma Park view home has been beautifully reimagined through extensive top to bottom, modern renovation. It showcases 3 levels of modern elegance & offers 3BR/2.5BA, open concept living space, chef's kitchen, large family/media rm & 4-level garden oasis. Expansive open floor plan showcases spacious grand living/dining rm w/ soaring high ceilings, fireplace, recessed lighting & bamboo flooring. Room is flooded w/ natural light & has sweeping views of Glen Canyon Park & Sutro Tower. Gourmet kitchen boasts large island, premium s/s appliances, custom cabinets & radiant skylights. Spacious primary suite offers large walk-in closet w/ closet organizer & luxurious en suite bathroom w/ dual vanity, large glass walk-in shower & Toto washlet. 2 add'l BR, one w/custom built office & fully renovated BR w/ soaking tub. Spacious full-floor family/media room featuring custom built-in ent. center, large wet bar w/ wine fridge & half BA. Media room opens onto expansive NE facing walkout deck set against backdrop of serene, enchanting garden. Deck features large fire pit & descends to tiered garden w/ mature foliage & 3 add'l levels of outdoor living. Beautiful bamboo floors w/ radiant heating, laundry rm, freshly painted walls, modern light fixtures. Garage w/ EV charger & storage.
district__c,SF District 4
electric__c,220 Volts
entry_level__c,0
external_listing__c,1
fencing__c,Fenced
pba__floortype_pb__c,Bamboo;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Radiant;Central;Gas
interior_features__c,Skylight(s)
ffd_lastmodifieddate,2023-10-01T10:46:37.000+0000
pba__latitude_pb__c,37.740694
pba__latitude_property__c,37.740694
laundry_features__c,Laundry Closet;Inside Area;Washer Included;Dryer Included
listed_date__c,2023-07-22
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Michael
pba__listing_agent_lastname__c,Lee
listing_agent_mls_id__c,810722
ffd_listingagentname,Mike Lee
listing_agent_number__c,1047611
listing_co_agent_mls_id__c,810590
listing_co_agent_number__c,1047194
listing_co_office_mls_id__c,COMP3
listing_co_office_name__c,Compass
listing_co_office_number__c,27342
listing_office_mls_id__c,COMP41
listing_office_name__c,Compass
listing_office_number__c,27887
pba__listingprice_pb__c,1995000
pba__listingtype__c,Sale
pba__listing_website__c,http://139marietta.com
pba__longitude_pb__c,-122.4475603
mls_id__c,423907002
master_bathroom_features__c,Shower Stall(s);Double Sinks;Bidet;Dual Flush Toilet
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-09-29
open_house_end__c,2023-10-01T16:00:00.000+0000
open_house_start__c,2023-10-01T13:00:00.000+0000
original_price__c,1995000
overall_days_on_market__c,-81720
parking_access__c,Independent
parking_features__c,Attached,Covered,Enclosed,EV Charging,Garage Door Opener,Interior Access,Private
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Uncovered Deck
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,963.77
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000dTwwnUAC
room_type__c,Office;Laundry;Kitchen;Living Room;Family Room;Wine Storage Area;Primary Bathroom;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Security System Leased
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,2070
size__c,2070
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Marietta
subdist__c,Miraloma Park
ffd_name,139 Marietta Drive, San Francisco, CA, 94127
view__c,City;Garden/Greenbelt;San Francisco;Sutro Tower;Canyon
website_property_type__c,Single Family Home
window_features__c,Dual Pane Full
pba__yearbuilt_pb__c,1951
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530684972-1.jpg
_yoast_indexnow_last_ping,1696158688