meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216606' 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, 116 Burlwood Drive, San Francisco, CA, 94127
ffd_mls_id, 512346
ffd_salesforce_id, a0E1I00000TvYfzUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 116 Burlwood Drive, San Francisco, CA, 94127
pba__address_pb__c, 116 Burlwood Drive, San Francisco, CA, 94127
agent_only_remarks__c, We DO NOT use Showing Time. Please read these remarks for information on requesting a showing. Covid-19 protocols are in place for showings. You and your clients must wear masks to enter the property. We will be doing 30 minute blocks to avoid overlap of showings. Please email a signed PEAD form to both Jon & I when requesting a viewing appointment. The Supra Lockbox is on the front gate. The red key opens security gate. The green key opens deadbolt and door knob on front door. Offers are due on Monday, January 25th by 3 p.m. We invite you to take a 3D Virtual Tour anytime by clicking this link:https://my.matterport.com/show/?m=Xd1rHkDjo1A&mls=1 The downstairs bedroom and bath do not appear on the tax records. Buyers should satisfy themselves as to the legality of these rooms. Disclosures are on IO. If you have difficulty just use this link: https://app.disclosures.io/link/116-Burlwood-Drive-ereu0qob This is a trust sale so there are limited disclosures. Owner did not pass away in the property. Please use pre-sale escrow opened with Connie Choy or North American [email protected] 415-753-3003Escrow #56606-20-02155.
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1959
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jonathan Davis
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-01-16T17:46:09.000+0000
days_on_market__c, 914
dom__c, 9
ffd_description_pb, Marvelous mid-century in Miraloma! This classic 1950s home features a reverse floor plan with the 2 upstairs bedroom facing the quiet street (& lovely hillside) & the living space in the rear to take advantage of the panoramic southern views. From the living & dining rooms you can see the bay to the east, San Bruno Mt. to the south & the Pacific Ocean to the west. The sunset views are glorious! The newlyrefreshed kitchen with a gas stove & brand new dishwasher opens to a generous dining room. The adjacent living room is large with a handsomewood burningfireplace. The bathroom boasts a skylight & stall shower. Downstairs there is a capacious 3rd bedroom with 2 closets, & a separate alcove that would be perfect for a: home office? nursery? dressing area? There is also a 2nd bath en-suite with a very large stall shower. A 1 car garage with laundry rounds out this level of the home. At the back of the garage is the door that leads down to the south facing deck, & an enormous mature garden.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:42:42.000+0000
pba__latitude_pb__c, 37.7350433
pba__latitude_property__c, 37.7350433
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-12-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
ffd_listingagentname, Tim J Gullicksen
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, CGL06
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28275
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Xd1rHkDjo1A&mls=1
pba__longitude_pb__c, -122.4527359
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 512346
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-01-16
original_price__c, 1095000
overall_days_on_market__c, 57
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
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)
pba__pendingdate__c, 2021-01-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1105.19
pba__propertytype__c, Single Family Residence
id, a0E1I00000TvYfzUAF
sale_date__c, 2021-02-26
sale_price__c, 1660000
selling_agent_mls_id__c, MLSL484681
selling_agent_number__c, 981211146
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Green Valley Realty USA
pba__status__c, Closed
pba__totalarea_pb__c, 1502
size__c, 1502
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Burlwood
subdist__c, Miraloma Park
ffd_name, 116 Burlwood Drive, San Francisco, CA, 94127
view__c, Ocean;Panoramic;City Lights;Bay;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 1959
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375775-1.jpg
ListingId, a0E1I00000TvYfzUAF
