meta_query='key:subdist__c;value:Oceanview|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212401' 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-11-18 23:07:35
[post_modified_gmt] => 2024-11-19 07:07:35
[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, 181 Majestic Avenue, San Francisco, CA, 94112
ffd_mls_id, 498782
ffd_salesforce_id, a0E1I00000SKYp3UAH
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 181 Majestic Avenue, San Francisco, CA, 94112
pba__address_pb__c, 181 Majestic Avenue, San Francisco, CA, 94112
agent_only_remarks__c, Virtual Tours and additional info at www.181MajesticAve.com Custom Built upholstered bench in dining room is available for purchase. Pre-escrow opened with Jennifer Bratko, Fidelity National Title #FSFM-0062000534 Disclosures available in Disclosures.io For Private Covid19 Compliant showing please:1) Review images, floor plans, virtual tours, and disclosures prior to requesting an in-person showing. 2) Download required PEAD-V form here to sign and return prior to showing:https://drive.google.com/drive/folders/1PXAsu99b8jUkdwZC3pR9G2IrqeQVJMIW?usp=sharing 3) Email pre-approval or proof of funds with Signed PEAD-V to [email protected] 4) Schedule your showing here:https://calendly.com/vanessa-gamp/181-majestic
appliances__c, Dishwasher;Microwave;Disposal;Refrigerator;Cooktop Stove;Built-In Oven
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1980
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-06-12
ffd_createddate, 2020-06-05T18:46:21.000+0000
days_on_market__c, 1670
dom__c, 18
ffd_description_pb, Transparently Priced! Majestic views, expansive rooms, flexible floorplan, outdoor space and a quiet cul de sac street. This 3-level home checks all the boxes! As you walk upstairs to the top floor you're greeted by a huge sunlight drenched living room with walk out balcony, separate dining room, and recently updated eat in kitchen. An expansive master suite with remodeled bath and additional bath in the hall complete the upper level. The middle level reveals 2 additional bedrooms, and a full bathroom newly remodeled to ensure plenty of space for family and friends. On the lower level, the 4th bedroom with its own view deck and access to the terraced backyard could become a luxurious home office away from all the hustle and bustle of the main rooms above. The Garage has 2 car parking, laundry, and storage space with Room for 2 more cars in the Driveway. 10min walk to BART, 3 mins from 280, 10 mins from Whole Foods,Target,and Philz make this home the height of privacy and convenience.
district__c, SF District 3
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Baseboard;Central
ffd_lastmodifieddate, 2022-01-25T15:23:25.000+0000
pba__latitude_pb__c, 37.71555
pba__latitude_property__c, 37.71555
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-05-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Vanessa
pba__listing_agent_lastname__c, Gamp
listing_agent_mls_id__c, 807170
ffd_listingagentname, Vanessa R Gamp
listing_agent_number__c, 166018350
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CGL03
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28281
pba__listingprice_pb__c, 1525000
pba__listingtype__c, Sale
pba__listing_website__c, http://vimeo.com/426050244
pba__longitude_pb__c, -122.45278
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s)
mls_id__c, 498782
main_level__c, Full Bath(s);Bedroom(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-06-05
original_price__c, 1525000
overall_days_on_market__c, 209
parking__c, Attached,Garage
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-06-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 676.28
pba__propertytype__c, Single Family Residence
id, a0E1I00000SKYp3UAH
sale_date__c, 2020-06-30
sale_price__c, 1500000
security_features__c, Security Gate;Security Alarm(s)
selling_agent_mls_id__c, 800347
selling_agent_name__c, Beverly K Savelli
selling_agent_number__c, 800347
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2218
size__c, 2218
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Majestic
subdist__c, Oceanview
ffd_name, 181 Majestic Avenue, San Francisco, CA, 94112
transportation__c, 2 Blocks
view__c, Panoramic;San Francisco
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Dual Pane
pba__yearbuilt_pb__c, 1980
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363648-1.jpg
ListingId, a0E1I00000SKYp3UAH
_yoast_indexnow_last_ping, 1735651864