meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212124' 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, 46 El Sereno Court, San Francisco, CA, 94127
ffd_mls_id, 497449
ffd_salesforce_id, a0E1I00000Slc2pUAB
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 46 El Sereno Court, San Francisco, CA, 94127
pba__address_pb__c, 46 El Sereno Court, San Francisco, CA, 94127
agent_only_remarks__c, Virtual tour available at https://my.matterport.com/show/?m=smhRKBWrsni. Contact Bill Kitchen at 415-309-7279 for showings. Showing agent and the prospective buyers should sign and email to the listing agent the PEAD form in advance of an in-person showing. In-person showing is limited to 2 prospective buyers and 1 agent. Disclosures available. Very low pest and home is in pristine condition.Square footage provided by EGB Drafting and Design Specialist. Buyer can confirm square footage if desired.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Self/Cont Clean Oven
architectural_style__c, Art Deco
bath_features__c, Shower Stall(s);Tub;Marble
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-05-11T18:46:09.000+0000
days_on_market__c, 1164
dom__c, 0
ffd_description_pb, Beautiful remodeled 4 bedroom/3 bath art deco home located on one of the best locations in lovely Miraloma Park. Formal entry leads to a light filled living room with a fireplace and a spacious formal dining room, both with beautiful parquet floors. The chef's kitchen boasts quartz counters,Thermador appliances, including a 48-inch Thermador range, a banquette and center island. Three secondary bedrooms feature large closets, fantastic light and access to two full bathrooms. On the lower floor, the master suite opens to the lovely deck and features an en suite bathroom with marble floors and oversized double shower and a massive walk-in custom closet opening to a large laundry room. The adjacent bright office/family room offers custom built-ins and a sliding glass door that opens to the large deck and terraced backyard. Located on a terrific cul-de-sac in Miraloma Park this home is close to Mt. Davidson, Glen Park Canyon, Muni and Gourmet shopping. A beautiful home not to be missed.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Marble;Tile;Wood;Parquet
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:21:45.000+0000
pba__latitude_pb__c, 37.738896
pba__latitude_property__c, 37.738896
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2019-09-02
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, 1999000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=smhRKBWrsni
pba__longitude_pb__c, -122.445132
pba__lotsize_pb__c, 0.08
lower_level__c, Family Room,Full Bath(s),Master Bedroom
mls_id__c, 497449
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-11
original_price__c, 1999000
overall_days_on_market__c, 50
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-05-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 815.02
pba__propertytype__c, Single Family Residence
id, a0E1I00000Slc2pUAB
room_type__c, Laundry;Den
sale_date__c, 2020-06-12
sale_price__c, 2300000
selling_agent_mls_id__c, 803729
selling_agent_name__c, Becky Layton
selling_agent_number__c, 803729
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2822
size__c, 2822
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, El Sereno
subdist__c, Miraloma Park
ffd_name, 46 El Sereno Court, San Francisco, CA, 94127
transportation__c, 1 Block
view__c, Garden/Greenbelt;Downtown;Twin Peaks;Mountains;Canyon
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362737-1.jpg
ListingId, a0E1I00000Slc2pUAB