meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215713' 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, 508736
ffd_salesforce_id, a0E1I00000TTQIKUA5
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
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;Gas Water Heater;Disposal;Freestanding Range;ENERGY STAR Qualified Appliances
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Dual Flush Toilet
pba__fullbathrooms_pb__c, 2
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:45:51.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
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Simulated Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:38:31.000+0000
pba__latitude_pb__c, 37.71667
pba__latitude_property__c, 37.71667
laundry_features__c, Inside Room;Washer/Dryer Included
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
lower_level__c, Bedroom(s),Full Bath(s),Kitchen
mls_id__c, 508736
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-22
original_price__c, 769000
overall_days_on_market__c, 181
parking__c, Garage
parking_access__c, Tandem
parking_features__c, Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-12-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 833.33
pba__propertytype__c, Single Family Residence
id, a0E1I00000TTQIKUA5
roof__c, Shingle
room_type__c, Storage
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, 2
pba__street_pb__c, Majestic
subdist__c, Oceanview
ffd_name, 107 Majestic 107 1/2 Avenue, San Francisco, CA, 94112
transportation__c, 2 Blocks
view__c, City Lights;Partial;Hills
website_property_type__c, Single Family Home
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/372707-1.jpg
ListingId, a0E1I00000TTQIKUA5