meta_query='key:subdist__c;value:Mission Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217660' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15735
[post_author] => 4
[post_date] => 2018-11-02 20:00:49
[post_date_gmt] => 2018-11-02 20:00:49
[post_content] => Balboa Park BART. Single-family homeowners shuttling south to Silicon Valley or BARTing to downtown and points east. Balboa Park. An urban delight with an indoor swimming pool, outdoor ball fields, and a great playground. Ocean Avenue boutiques, grocery stores, restaurants, and more are a quick meander away.
[post_title] => Mission Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:23:14
[post_modified_gmt] => 2024-04-12 19:23:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15735
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 81 Oneida Avenue, San Francisco, CA, 94112
ffd_mls_id, 421526231
ffd_salesforce_id, a0E1I00000TwgOhUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 81 Oneida Avenue, San Francisco, CA, 94112
pba__address_pb__c, 81 Oneida Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Showings by appointment only. Please follow all necessary COVID protocol. Buyers and their agents are responsible for providing their own PPE, complying with Covid showing rules and cleaning/wiping applicable surfaces after showing the property. LINK TO RESERVE AN APPOINTMENT FOR A PRIVATE SHOWING: https://calendly.com/amykong/81-oneida-avenue. DISClOSURE PACKAGE LINK: https://app.disclosures.io/link/81-Oneida-Avenue-9wz7h8cs Buyers to cooperate with seller's 1031 exchange at no cost to buyer.
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over;Dual Flush Toilet;Skylight/Solar Tube;Window;Stone
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-03-24
ffd_createddate, 2021-03-16T01:02:52.000+0000
days_on_market__c, 858
dom__c, 15
ffd_description_pb, Newly renovated designer 3 bedrooms 2 full baths home nestled in a Cul de sac in Mission Terrace where shops, public transportation and park is just around the block. This immaculate house boasts a spacious living room with a picture window that is light filled, wood burning corner fireplace, vaulted ceiling. Entering a beautifully lit skylit brand new designer kitchen, decorated with professionally crafted Brazilian Macaubas Quartzite waterfall island with seamless counter tops. Stylish stainless steel Italian Bertazzoni appliances for an absolute gourmet cooking experience to entertain around the formal dining room. 2 bedrooms overlooking manicured yard and a designer bathroom that completes the top floor. Through a glass door to this 22 feet wide suite (2nd designer bath included) flows into a private Mediteranean garden as part of an indoor outdoor living. Spacious parking garage, washer & dryer hookup and more. Flexible floor plan..Come & feel how your style reflected
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Laminate;Tile
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:47:05.000+0000
pba__latitude_pb__c, 37.7206023
pba__latitude_property__c, 37.7206023
laundry_features__c, In Garage;Hookups Only;Sink
listed_date__c, 2021-03-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Amy
pba__listing_agent_lastname__c, Kong
listing_agent_mls_id__c, 502781
ffd_listingagentname, Amy Y Kong
listing_agent_number__c, 502781
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, TRUSTRE
listing_office_name__c, Trust Real Estate
listing_office_number__c, 28423
pba__listingprice_pb__c, 1493000
pba__listingtype__c, Sale
pba__listing_website__c, http://81Oneida.com
pba__longitude_pb__c, -122.4401369
lower_level__c, Full Bath(s),Garage,Master Bedroom
mls_id__c, 421526231
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Tile;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-13
original_price__c, 1493000
overall_days_on_market__c, 145
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-03-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 939.52
pba__propertytype__c, Single Family Residence
id, a0E1I00000TwgOhUAJ
roof__c, Bitumen;Shingle
room_type__c, Kitchen;Living Room;Dining Room
sale_date__c, 2021-04-23
sale_price__c, 1600000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 808449
selling_agent_number__c, 1035145
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1703
size__c, 1703
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Oneida
subdist__c, Mission Terrace
ffd_name, 81 Oneida Avenue, San Francisco, CA, 94112
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530199426-1.jpg
ListingId, a0E1I00000TwgOhUAJ