_yoast_indexnow_last_ping,1715911271
ffd_listing_title,278 Juanita Way, San Francisco, CA, 94127
ffd_mls_id,424029539
ffd_salesforce_id,a0EUd000001zrlCMAQ
num_of_fireplaces__c,1
num_of_rooms__c,0
of_units__c,0
address2__c,278 Juanita Way, San Francisco, CA, 94127
pba__address_pb__c,278 Juanita Way, San Francisco, CA, 94127
agent_only_remarks__c,Offers, if any, are due on Thursday, May 23 at 9am. Staged and owner occupied but easy to show. In addition to open houses, private showings are available by appointment with some advance notice. Contact Judson at 415.722.5515 or [email protected] to schedule a showing. Pre-sale escrow has been opened with Liz Paglinawan at First American Title Company, Escrow #7118836. More information at 278Juanita.com.
appliances__c,Dishwasher;Microwave;Free Standing Refrigerator;Gas Cook Top;Built-In Electric Oven
architectural_style__c,Traditional
bath_features__c,Shower Stall(s);Tile;Window;Steam
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,3
year_build_text__c,1937
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2024-05-11T16:47:20.000+0000
days_on_market__c,5
dom__c,5
ffd_description_pb,This expansive, grand view home on a large lot underwent a complete transformation w/ a high-end rebuild. With refined finishes & thoughtful upgrades, this private sanctuary features impressive views, ample space & a rejuvenating setting near Mt. Davidson. Light-filled open living/dining/kitchen w/ west-facing views, gas fplc w/ black granite surround & hardwood floors, half BA & closets. Chef's kit w/ gorgeous white oak cabinets, island, quartzite counters, pantry, top-line ssl appls, incl Wolf range, Miele ovens, Sub-Zero fridge & deck for al fresco dining. All 3 BDs on one level incl primary ensuite w/ 2 WICs & BA w/ deep tub & quartzite tile. Full BA w/ steam shower, w/d & linen closet. Interior access to 2 car garage & lower level room ideal for multiple uses. Significant upgrades include foundation/structural, electrical/plumbing, slate roof, radiant floor heat, on-demand water heater, wood-clad windows, Klipsch speakers, fire suppression sprinklers, hardwired internet & more. Tranquil location across from Mt. Davidson hiking & close to shops, restaurants & transit in West Portal. This impressive home offers an exceptional lifestyle, combining privacy, natural beauty, well-appointed finishes & ample space with city life moments away.
district__c,SF District 4
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard
fireplace_features__c,Living Room;Gas Starter
pba__floortype_pb__c,Tile;Wood;Stone
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Radiant Floor;Fireplace(s);MultiZone
ffd_lastmodifieddate,2024-05-17T01:46:40.000+0000
pba__latitude_pb__c,37.7396023
pba__latitude_property__c,37.7396023
laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included
listed_date__c,2024-05-01
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Judson
pba__listing_agent_lastname__c,Gregory
listing_agent_mls_id__c,809119
ffd_listingagentname,Judson Gregory
listing_agent_number__c,1040495
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,2995000
pba__listingtype__c,Sale
pba__listing_website__c,https://www.278juanita.com/mls
pba__longitude_pb__c,-122.4579864
lower_level__c,Family Room,Garage
mls_id__c,424029539
main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c,Tub w/Shower Over;Soaking Tub;Closet;Window;Stone
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2024-05-11
open_house_end__c,2024-05-18T16:00:00.000+0000
open_house_start__c,2024-05-18T14:00:00.000+0000
original_price__c,2995000
overall_days_on_market__c,-81945
parking_access__c,Side by Side
parking_features__c,Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Side-by-Side
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Uncovered Deck;Uncovered Patio
pba__pendingdate__c,1800-01-01
possible_bedrooms__c,0
pba__pricechangedat__c,1800-01-01T00:00:00.000+0000
price_per_square_foot__c,925.81
pba__propertytype__c,Single Family Residence
ListingId,a0EUd000001zrlCMAQ
roof__c,Slate
room_type__c,Storage;Den;Kitchen;Living Room;Baths Other;Dining Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Fire Suppression System
selling_agent_number__c,0
selling_co_agent_number__c,0
selling_co_office_number__c,0
pba__status__c,Active
pba__totalarea_pb__c,3235
size__c,3235
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Juanita
subdist__c,Miraloma Park
ffd_name,278 Juanita Way, San Francisco, CA, 94127
view__c,Ocean;Panoramic;San Francisco;Hills;Mountains;Woods;Sutro Tower;Forest
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,1937
pba__postalcode_pb__c,94127
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530776699-1.jpg