ffd_listing_title,659 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id,423743772
ffd_salesforce_id,a0E8W00000awPTsUAM
num_of_fireplaces__c,0
num_of_rooms__c,8
of_units__c,0
address2__c,659 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c,659 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c,AGENTS: Use SF S&P agreement ONLY. Offer date not determined but maybe Wednesday, May 31st 2:00pm. All are welcome. Txt Paul or Rafe for private tours. Not on lockbox. Seller prefers to remain Escrow with DOMA as they have other business. Sr.Escrow Officer, Mary Ann Bunnell (708)362-0104 e: [email protected] 689 Portola Drive, San Francisco, CA 94127
appliances__c,Dishwasher;Insulated Water Heater;Gas Water Heater;Microwave;Disposal;Hood Over Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Ice Maker;Gas Cook Top;Plumbed For Ice Maker;Built-In Electric Oven;Gas Plumbed
architectural_style__c,Mid-Century
bath_features__c,Tub w/Shower Over;Tile;Low-Flow Toilet(s);Skylight/Solar Tube;Low-Flow Shower(s);Stone
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,4
year_build_text__c,1950
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
cooling__c,None
ffd_createddate,2023-05-21T10:50:50.000+0000
days_on_market__c,20
dom__c,18
ffd_description_pb,Miraloma Park of San Francisco.It's the place to be seen. We reflect the very feel of this neighborhood. Move-in as-is makes this mid-modern lovely. A soft White and Teal-Gray exterior & translucent colored paneled entry make this a FEEL- GOOD home. The great-room on the 2nd level bursts with skylights and East bay views that go forever. Miraloma Park is known for its views. Stunning Oak hardwood floors, New Berber' carpeting, and new fixtures welcome you. Interior is freshly painted in Sherwin Williams, Pure White flat/satin finishes. A brand-spankin' NEW bath too. Parking for 1car gar+1in dr'y on the Ground level with laundry, storage and a work bench for Dad. Bottom level below is a playroom/office/or whatever you wish. A captain's bed too. A 4th bedroom or use it as a family room allows access to deck and yard. A security monitoring system in utility room. We're just up or down the whimsical, winding hill on Teresita off Forester. Molly Stones, java spots, houses of faith, schools, Glen Park P&R, freeways, & MUNI a stone's throw
district__c,SF District 4
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
electric__c,220 Volts in Laundry
entry_level__c,0
exterior_features__c,Balcony
external_listing__c,1
fencing__c,Back Yard;Wood;Fenced
pba__floortype_pb__c,Carpet;Wood;Stone
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Gas;Fireplace(s)
height_limit__c,24
interior_features__c,Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate,2023-06-08T20:48:58.000+0000
pba__latitude_pb__c,37.7362905
pba__latitude_property__c,37.7362905
laundry_features__c,In Garage;Ground Floor;Washer Included;Dryer Included;Electric;Cabinets;Sink
listed_date__c,2023-02-01
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Paul
pba__listing_agent_lastname__c,Andreini
listing_agent_mls_id__c,807385
ffd_listingagentname,Paul J Andreini
listing_agent_number__c,1017078
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,AVNU
listing_office_name__c,Avenue 8 Inc.
listing_office_number__c,28244
pba__listingprice_pb__c,1868000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.4456572
lower_level__c,Family Room,Loft,Retreat
mls_id__c,423743772
main_level__c,Full Bath(s);Garage;Street Entrance;Primary Bedroom
master_bathroom_features__c,Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Tile;Low-Flow Shower(s);Window
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-05-20
original_price__c,1868000
overall_days_on_market__c,-81588
parking_access__c,Tandem
parking_features__c,24'+ Deep Garage,Garage Door Opener,Garage Facing Front,Interior Access,Private,Tandem Garage,Uncovered Parking Spaces 2+,Workshop in Garage
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,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,934
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000awPTsUAM
road_surface_type__c,Asphalt
roof__c,Bitumen;Composition
room_type__c,Storage;Office;Den;Family Room;Possible Guest;Great Room;Workshop;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
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,2000
size__c,2000
pba__state_pb__c,CA
stories__c,3
pba__street_pb__c,Teresita
subdist__c,Miraloma Park
ffd_name,659 Teresita Boulevard, San Francisco, CA, 94127
view__c,City;Park;Panoramic;City Lights;Bay;Downtown;San Francisco;Mountains;Mt Diablo;Bridges
website_property_type__c,Single Family Home
window_features__c,Dual Pane Full;Window Screens;Weather Stripped;Caulked/Sealed
pba__yearbuilt_pb__c,1950
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530622049-1.jpg