meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218345' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70665
[post_author] => 4
[post_date] => 2018-11-30 20:30:39
[post_date_gmt] => 2018-11-30 20:30:39
[post_content] => Storybook stucco charmers and mid-century modern masterpieces meander through this semi-circular neighborhood that fans out to the northeast, east, and southeast from the base of Mt. Davidson before coming to an abrupt stop at the top of Glen Canyon Park.
[post_title] => Miraloma Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => miraloma-park
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:26:13
[post_modified_gmt] => 2024-04-11 15:26:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70665
[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, 881 Foerster Street, San Francisco, CA, 94127
ffd_mls_id, 421539047
ffd_salesforce_id, a0E1I00000US9kaUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 881 Foerster Street, San Francisco, CA, 94127
pba__address_pb__c, 881 Foerster Street, San Francisco, CA, 94127
agent_only_remarks__c, A rare find in Miraloma Park. Private road with 3 homes total. Prob the best views in the neighborhood. COVID compliant showings available. Please contact Bill Kitchen directly at 415-309-7279 for all showings. Text is great but please no emails for showings. Thanks.
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Contemporary;Mid-Century
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-22T21:32:27.000+0000
days_on_market__c, 823
dom__c, 19
ffd_description_pb, Enjoy wonderful southwest views from this one of a kind, midcentury modern home in Miraloma Park. Far from the madding crowd, this completely private house is one of only three homes that sit at the top of a private drive. Enter through a garden setting to the front door that opens to an open floor plan with a spacious living room with fireplace and a wall of windows that provide expansive views of the Pacific Ocean, Southern Hills and all in between. Step out onto the wrap around deck to take it all in. Adjacent to the living room is the formal dining room and kitchen with abundant cabinets and granite counters. The open floor plan allows one to take in the views even from the kitchen. The private wing offers three, large bedrooms with custom closets and two full baths. One of the bedrooms has its own adjacent office space that opens to the private garden. Don't miss.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:50:00.000+0000
pba__latitude_pb__c, 37.7362699
pba__latitude_property__c, 37.7362699
laundry_features__c, Laundry Closet;Hookups Only
listed_date__c, 2021-03-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Kitchen
listing_agent_mls_id__c, 803707
ffd_listingagentname, William J Kitchen Jr.
listing_agent_number__c, 803707
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1775000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.881foerster.com
pba__longitude_pb__c, -122.4472038
mls_id__c, 421539047
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-17
original_price__c, 1775000
overall_days_on_market__c, 29
parking_access__c, Independent
parking_features__c, Covered,Garage Door Opener,Guest Parking Available
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-05-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1194.97
pba__propertytype__c, Single Family Residence
id, a0E1I00000US9kaUAD
road_surface_type__c, Paved
room_type__c, Office;Kitchen;Living Room;Master Bathroom
sale_date__c, 2021-06-04
sale_price__c, 1900000
selling_agent_mls_id__c, 810575
selling_agent_number__c, 1047084
selling_co_agent_mls_id__c, 805322
selling_co_agent_number__c, 166015212
selling_co_office_mls_id__c, MOSAIK
selling_co_office_name__c, Mosaik Real Estate
selling_co_office_number__c, 27803
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1590
size__c, 1590
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Foerster
subdist__c, Miraloma Park
ffd_name, 881 Foerster Street, San Francisco, CA, 94127
view__c, Ocean;Panoramic;Bay;Mountains;Other;Ridge
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530221172-1.jpg
ListingId, a0E1I00000US9kaUAD