meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215814' 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, 28 El Sereno Court, San Francisco, CA, 94127
ffd_mls_id, 509146
ffd_salesforce_id, a0E1I00000TV8ZTUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 28 El Sereno Court, San Francisco, CA, 94127
pba__address_pb__c, 28 El Sereno Court, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Thursday Nov.19th at 1PM. Trust Sale-As is. No death in the home. No court/straight successor trustee sale. Excellent condition home with all inspections in disc io attached. Measured living square footage is 1692 per floor plan measurements. See floor plan in photos here. Note: We do not have permit history on the downstairs rooms. The deceased owner lived there for decades. Floor has been replaced with engineered Oak. Tax record square footage do not include the downstairs rooms. The successor trustee is court appointed and knows nothing about the property. Complete disclosure package on file including Reports. Buyer should do their own investigations regarding permits & condition.Trustee assumes no liabilty and is exempt from TDS. EZ Showing with PEAD on Lockbox, follow SFAR Covid regulations please. Call or text for appt. Front Gate opens Outwards, so please watch your footing on staircase! See website: www.28elsereno.com. Schedule appts with me via text or phone. Please do not use Showingti.me Offers due 11/19 1pm
appliances__c, Insulated Water Heater;Refrigerator;Freestanding Range;Hood Over Range
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Low-Flow Toilet(s);Skylight/Solar Tube;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-11-04T11:46:48.000+0000
days_on_market__c, 987
dom__c, 16
ffd_description_pb, Rare and Fabulous. Very good condition,all reports in the disc.io attached.Expansive Center Patio Home with Westerly and Downtown Views on a most serene Cul de Sac.2 VU bedrooms/1 Bath, plus Breakfast Nook/office-Center Patio-Formal Dining Rm & Huge Living Room Upstairs. Stunnng Parquet floors. Dwnstrs a generous sized Master En Suite with Walk-in closet, and direct access to the back yard Patio and Garden. Room for 2 cars plus mega-storage space in the extra large garage, offering more expansion possibilities. The highlights of this charmer are gorgeous parquet hardwood floors, Lovely Fireplace, Coved ceilings and trim, Center Patio, and a great street-Super Quiet, and neighbor friendly.EZ showings with PEAD. This is a terrific large home on a Desirable Cul de Sac, so hard to find! Walk to Mollie Stones and parks& schools. Website: www.28elsereno.com
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Wood;Parquet
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:39:04.000+0000
pba__latitude_pb__c, 37.7388562
pba__latitude_property__c, 37.7388562
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2020-08-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Florence
pba__listing_agent_lastname__c, Monzasch
listing_agent_mls_id__c, 223760
ffd_listingagentname, Florence J Monzasch
listing_agent_number__c, 223760
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 1325000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.28ElSereno.com
pba__longitude_pb__c, -122.4447929
pba__lotsize_pb__c, 0.06
lower_level__c, Master Bedroom
mls_id__c, 509146
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-11-04
original_price__c, 1325000
overall_days_on_market__c, 57
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, Enclosed Patio;Patio(s)
pba__pendingdate__c, 2020-11-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 886.52
pba__propertytype__c, Single Family Residence
id, a0E1I00000TV8ZTUA1
roof__c, Tar/Gravel
room_type__c, Storage;Den
sale_date__c, 2020-12-23
sale_price__c, 1500000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 807683
selling_agent_name__c, Kevin K. Ho
selling_agent_number__c, 1023884
selling_co_agent_mls_id__c, 809929
selling_co_agent_name__c, Jonathan B. McNarry
selling_co_agent_number__c, 1044211
selling_co_office_mls_id__c, VANG02
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 166013449
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1692
size__c, 1692
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, El Sereno
subdist__c, Miraloma Park
ffd_name, 28 El Sereno Court, San Francisco, CA, 94127
transportation__c, 1 Block
view__c, City Lights;Partial;Downtown;San Francisco;Twin Peaks
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane;Window Screens;Weather Stripped
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/373067-1.jpg
ListingId, a0E1I00000TV8ZTUA1
