meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='335915' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70661
[post_author] => 4
[post_date] => 2018-11-30 20:30:35
[post_date_gmt] => 2018-11-30 20:30:35
[post_content] => East of Orizaba, but northwest of I-280 and south of Lakeside, the Oceanview slopes gently down to the Outer Mission where I-280 snakes along the neighborhood border to Daly City and points south. There's good access to I-280 from the entire neighborhood, and Balboa Park BART is just a few blocks from the northeast side of the neighborhood.
[post_title] => Oceanview
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => oceanview
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-22 12:53:43
[post_modified_gmt] => 2023-06-22 19:53:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70661
[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, 279 Minerva Street, San Francisco, CA, 94112
ffd_mls_id, 423749579
ffd_salesforce_id, a0E8W00000cJWVPUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 279 Minerva Street, San Francisco, CA, 94112
pba__address_pb__c, 279 Minerva Street, San Francisco, CA, 94112
agent_only_remarks__c, Text Samantha for showing 415-640-7602. Pre-Sale escrow opened with Lynn Chan - Fidelity National Title. No pre-emptive offer, please. Offers due Tuesday 6/27 by 11am. Disclosures - https://app.disclosures.io/link/279-Minerva-Street-xxqzn5s1
appliances__c, Dishwasher;Hood Over Range;Free Standing Refrigerator;Built-In Electric Range;Free Standing Electric Range
architectural_style__c, Spanish
bath_features__c, Tub w/Shower Over;Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1929
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-06-15T21:48:59.000+0000
days_on_market__c, 42
dom__c, 13
ffd_description_pb, Beautiful Views, Convenient Location, Classic Marina Style Architechure, this is home! Detached on 3 sides, this home boasts lots of natural sunlight. Flexible floorplan, offering 2 bedrooms & 2 baths plus wide open finished space downstairs for office, familyroom or guest room! On the main floor, enter into the living room with bay window, cozy fireplace & formal dining room. The kitchen is spacious & faces beautiful view of San Bruno mountains. Downstairs, a wide open finished space for your imagination. Enjoy the extra large lot, spacious backyard on warm Bay Area days, perfect for family BBQs, kids and pets! Centrally Located in Oceanview, you are close to many conveniences like H Mart Supermarket, Wholefoods, CCSF and SFSU, BART, the M train, Stonestown, parks and just too many others to list. Beautiful Minerva is ready for you to call home and host friends and family!
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-27T12:47:12.000+0000
pba__latitude_pb__c, 37.7155561
pba__latitude_property__c, 37.7155561
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2023-06-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Samantha
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 809630
ffd_listingagentname, Samantha J Huang
listing_agent_number__c, 1042187
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP01
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28939
pba__listingprice_pb__c, 998888
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=azPRGvVhh4Y&mls=1
pba__longitude_pb__c, -122.4618042
lower_level__c, Family Room,Full Bath(s)
mls_id__c, 423749579
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-15
original_price__c, 998888
overall_days_on_market__c, -81614
parking_access__c, Tandem
parking_features__c, Attached,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-06-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-07-26T23:18:54.000+0000
price_per_square_foot__c, 772.76
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJWVPUA4
roof__c, Other
room_type__c, Kitchen;Living Room;Dining Room
sale_date__c, 2023-07-26
sale_price__c, 1010000
security_features__c, Security Gate
selling_agent_mls_id__c, 816433
selling_agent_number__c, 1075389
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1307
size__c, 1307
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Minerva
subdist__c, Oceanview
ffd_name, 279 Minerva Street, San Francisco, CA, 94112
view__c, Mountains
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530633730-1.jpg