meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211012' 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] => 2024-04-12 12:20:55
[post_modified_gmt] => 2024-04-12 19:20:55
[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, 107 Majestic 107 1/2 Avenue, San Francisco, CA, 94112
ffd_mls_id, 508748
ffd_salesforce_id, a0E1I00000TTQIWUA5
vacant__c, 2
num_of_rooms__c, 0
of_units__c, 2
address2__c, 107 Majestic 107 1/2 Avenue, San Francisco, CA, 94112
pba__address_pb__c, 107 Majestic 107 1/2 Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Please email PEAD for appointment confirmation, and use COVID-19 showing protocols. Duplex based on tax record. Buyer to verify conformity.Please email to request disclosures. Listing agent is owner. All keys are in SupraBox. Garage opener is in lower unit's kitchen drawer next to range. Offers will be reviewed upon receipt.
appliances__c, Dishwasher;Disposal;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Free Standing Oven/Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 2
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-11-09
ffd_createddate, 2020-10-23T10:48:29.000+0000
days_on_market__c, 1000
dom__c, 49
ffd_description_pb, Rare opportunity! Two vacant units for a condo price! Live in one and rent out the other. Bright with natural light and nice views. Featured with new energy efficient appliances and lights, double pane windows and newer rooftop solar PV system for lower unit. Interior has been freshly painted. Move in ready. Conveniently located close to City College, State University, Whole Foods store, Stonestown Mall and restaurants. Walking distance to BART station, Muni light rail/bus stops, and easy access to freeway 280 and 101.
district__c, SF District 3
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Simulated Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T13:32:18.000+0000
pba__latitude_pb__c, 37.71667
pba__latitude_property__c, 37.71667
laundry_features__c, Washer/Dryer;In Each Unit
listed_date__c, 2020-10-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, April
pba__listing_agent_lastname__c, Li
listing_agent_mls_id__c, 807519
ffd_listingagentname, April L Li
listing_agent_number__c, 1020398
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MXRE
listing_office_name__c, MaxReal
listing_office_number__c, 166014386
pba__listingprice_pb__c, 699000
pba__listingtype__c, Sale
pba__listing_website__c, https://virtualtourcafe.com/mls/4684788
pba__longitude_pb__c, -122.4521433
pba__lotsize_pb__c, 0.02
mls_id__c, 508748
master_property__c, a0O8W00000DaF5rUAF
parkingspaces__c, 1
on_market_date__c, 2020-10-22
original_price__c, 789000
overall_days_on_market__c, 181
parking__c, Garage
parking_features__c, Garage
pba__pendingdate__c, 2020-12-10
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 833.33
pba__propertytype__c, Duplex
id, a0E1I00000TTQIWUA5
roof__c, Shingle
sale_date__c, 2020-12-23
sale_price__c, 750000
security_features__c, Smoke Detector
selling_agent_mls_id__c, EB149024
selling_agent_number__c, 981310125
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams
pba__status__c, Closed
pba__totalarea_pb__c, 900
size__c, 900
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Majestic
style__c, Contemporary
subdist__c, Oceanview
ffd_name, 107 Majestic 107 1/2 Avenue, San Francisco, CA, 94112
type__c, Duplex,2 Story
view__c, City Lights;Partial;Hills
website_property_type__c, Duplex
window_features__c, Dual Pane;Window Screens;Weather Stripped
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/372709-1.jpg
ListingId, a0E1I00000TTQIWUA5