ffd_listing_title,151 Marietta Drive, San Francisco, CA, 94127
ffd_mls_id,423717328
ffd_salesforce_id,a0E8W00000a84ekUAA
num_of_fireplaces__c,0
num_of_rooms__c,0
of_units__c,0
address2__c,151 Marietta Drive, San Francisco, CA, 94127
pba__address_pb__c,151 Marietta Drive, San Francisco, CA, 94127
agent_only_remarks__c,Offers as they come. Please text or contact Bill Kitchen at 415-309-7279. Please, no emails. Thanks. Excellent opportunity to own a view home in Miraloma Park. Many of the homes on the street have been remodeled and have taken advantage of the ability to build down. Seller and seller's agent cannot confirm legality of the rooms and baths on the lower levels. Tax records show square footage as 1093 and a 2 bedroom/1 bath. Square footage source for the MLS and marketing is for the main level and entry level rooms and the source is from graphic artist floor plans. Home next door under renovation. Seller has the right to accept or reject any and/or all offers.
appliances__c,Free Standing Gas Oven
bath_features__c,Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,3
year_build_text__c,0
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-01-26T20:46:21.000+0000
days_on_market__c,7
dom__c,7
ffd_description_pb,Located in desirable Miraloma Park this cosmetic fixer offers unobstructed views and an abundance of potential. The main living area boasts a spacious living room and dining area with amazing views of Twin Peaks, Glen Canyon Park, and beyond. The original kitchen, two bedrooms, and a full bath complete this level. The entry level contains a formal foyer, a third bedroom, office, and bath. The staircase down leads to the lower level which is currently staged as a family room with an additional bonus room, a 1/2 bath, and direct access to a small deck and a large backyard. Located on a desirable street in Miraloma Park this home has amazing potential. Lots of natural light, hardwood floors, 1 car garage parking, and storage. Minutes from transportation, including Glen Park BART, Muni, 101 and 280, shopping and West Portal, Noe, Glen Park, and Eureka Valley. Excellent opportunity for a developer or end user.
district__c,SF District 4
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard
pba__floortype_pb__c,Tile;Vinyl;Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2023-02-02T11:48:15.000+0000
pba__latitude_pb__c,37.7405871
pba__latitude_property__c,37.7405871
laundry_features__c,Hookups Only
listed_date__c,2022-12-07
pba__listing_agent_email__c,bill.kitchen@compass.com
pba__listing_agent_firstname__c,William
pba__listing_agent_lastname__c,Kitchen
listing_agent_mls_id__c,803707
ffd_listingagentname,William J Kitchen Jr.
listing_agent_number__c,803707
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,COMP
listing_office_name__c,Compass
listing_office_number__c,26293
pba__listingprice_pb__c,1228000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.4472967
lower_level__c,Family Room
mls_id__c,423717328
main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-01-26
open_house_end__c,2023-02-05T16:00:00.000+0000
open_house_start__c,2023-02-05T14:00:00.000+0000
original_price__c,1228000
overall_days_on_market__c,-81474
parking_access__c,Independent
parking_features__c,Enclosed,Garage Facing Front,Interior Access
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,841.1
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000a84ekUAA
road_surface_type__c,Paved
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Security Gate
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,1460
size__c,1460
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Marietta
subdist__c,Miraloma Park
ffd_name,151 Marietta Drive, San Francisco, CA, 94127
view__c,Garden/Greenbelt;Twin Peaks;Hills;Sutro Tower;Canyon
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,0
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530572840-1.jpg