meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376880' 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
(
)
)
_yoast_indexnow_last_ping, 1714586128
ffd_listing_title, 168 Juanita Way, San Francisco, CA, 94127
ffd_mls_id, 424019980
ffd_salesforce_id, a0EUd000001bUbGMAU
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 168 Juanita Way, San Francisco, CA, 94127
pba__address_pb__c, 168 Juanita Way, San Francisco, CA, 94127
agent_only_remarks__c, Relocation sale. Disclosures will be emailed with instructions. Please use SFAR Purchase Contract. Relocation addenda will be included and buyers are to perform their own inspections. Escrow to be opened by the Relocation Company. Offer date will be set, please allow two days for response time. Owner occupied, so please try and make Open House Showings. *4th Bedroom is an office with a small closet on main level. Tax records state 2,121 sq. ft. Graphic floor plan sq. ft. 2,365 buyer to verify to their satisfaction.
appliances__c, Dishwasher;Microwave;Built-In Gas Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Spanish;Ranch
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-04-16
ffd_createddate, 2024-03-31T10:46:20.000+0000
days_on_market__c, 32
dom__c, 23
ffd_description_pb, Perfectly located on one of the best blocks in Old Miraloma Park, this Spanish-style, 4BR/3BA home, circa 1926, is filled with modern delights. The detached, two-level residence was extensively renovated and meticulously maintained by its architect owner, who reimagined the floorplan to highlight a seamless indoor-outdoor experience. Classic lines blend with period details, warm woods complement natural stone and gorgeous tile all with every imaginable modern amenity. The light-filled living room has large windows, period details and a cozy fireplace. It joins a DR, and an expansive kitchen with a 12-foot marble entertaining island, family room and an office/4th bedroom and bath on this main level. Step outside to the lovely deck that leads to the modern, low-maintenance yard with tiled and grassy areas. Downstairs are 2BAs and 3BRs, including the primary, a serene retreat with waterfall shower and private deck. 1-car garage+. Located near Glen Park and West Portal, surrounded by nature, yet minutes to shops, restaurants, top schools and public transit. This home offers the best of all worlds: urban/suburban, period/modern, convenient/private, spacious/cozy. An amazing opportunity to live in a tranquil sanctuary, minutes to both nature and everything SF has to offer!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-05-01T17:46:18.000+0000
pba__latitude_pb__c, 37.7424826
pba__latitude_property__c, 37.7424826
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2024-03-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tiffany
pba__listing_agent_lastname__c, Hickenbottom
listing_agent_mls_id__c, 807832
ffd_listingagentname, Tiffany Hickenbottom
listing_agent_number__c, 1027421
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP2
listing_office_name__c, Compass
listing_office_number__c, 27341
pba__listingprice_pb__c, 2098000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/928752421?h=8172b50243
pba__longitude_pb__c, -122.4548041
lower_level__c, Bedroom(s),Full Bath(s),Garage,Primary Bedroom,Retreat,Street Entrance
mls_id__c, 424019980
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Low-Flow Toilet(s);Double Sinks;Tile;Stone;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-30
original_price__c, 2098000
overall_days_on_market__c, -81903
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2024-04-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-01T04:07:55.000+0000
price_per_square_foot__c, 985.2
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001bUbGMAU
road_surface_type__c, Paved
room_type__c, Office;Laundry;Kitchen;Living Room;Dining Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-04-29
sale_price__c, 2330000
selling_agent_mls_id__c, 802394
selling_agent_number__c, 802394
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, JODI Group
pba__status__c, Closed
pba__totalarea_pb__c, 2365
size__c, 2365
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Juanita
subdist__c, Miraloma Park
ffd_name, 168 Juanita Way, San Francisco, CA, 94127
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530753044-1.jpg