ffd_listing_title 457 Tehama Street, San Francisco, CA, 94103
ffd_mls_id 423717792
ffd_salesforce_id a0E8W00000a87z4UAA
num_of_fireplaces__c 1
num_of_rooms__c 0
of_units__c 0
address2__c 457 Tehama Street, San Francisco, CA, 94103
pba__address_pb__c 457 Tehama Street, San Francisco, CA, 94103
agent_only_remarks__c For a private appointment, please call Jean-Paul 415-279-0997 or Ed at 415-350-9083. Thank you
appliances__c Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Double Oven;Built-In Refrigerator;Built-In Freezer
architectural_style__c Contemporary
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 4
year_build_text__c 2022
pba__city_pb__c San Francisco
listing_co_agent_name__c Edward R Deleski
pba__contingentdate__c 1800-01-01
ffd_createddate 2023-01-28T19:45:38.000+0000
days_on_market__c 0
dom__c 0
ffd_description_pb Modern. Magnificent. Inviting. Luxurious. Welcome to 457 Tehama, a rarely available, architecturally significant, brand new construction single family home, an urban oasis in the heart of the City. The interior space spans 3 magnificent living levels, featuring a 30'+ entry glass atrium, heated lap pool and spa areas, with multiple outdoor spaces for seamless indoor-outdoor living. Main level reveals a tremendous chef's kitchen, dining and living areas for large scale dining and entertaining. Sleeping areas boast 4 luxurious bedrooms with spa-inspired baths and finishes. Home offers Savant integrated smart home technology + in floor radiant heat. Expansive roof-top terraces offer panoramic views of downtown and the hills of San Francisco. Close proximity to Yerba Buena gardens, MOMA + Union Square + Waterfront shopping and restaurants, the financial district, the Transbay Terminal and other regional transportation hubs and area freeways.
district__c SF District 9
entry_level__c 0
external_listing__c 1
fireplace_features__c Living Room;Decorative Only
pba__floortype_pb__c Tile;Wood
pba__hoafees__c 0
hoa__c No
pba__halfbathrooms_pb__c 1
pba__heatingtype_pb__c Radiant Floor
ffd_lastmodifieddate 2023-01-28T21:45:34.000+0000
pba__latitude_pb__c 37.779944
pba__latitude_property__c 37.779944
laundry_features__c Inside Room;Upper Floor;Washer Included;Dryer Included
listed_date__c 2023-01-08
pba__listing_agent_email__c jps@vanguardsf.com
pba__listing_agent_firstname__c Jean-Paul
pba__listing_agent_lastname__c Samaha
listing_agent_mls_id__c 804997
ffd_listingagentname Jean-Paul Samaha
listing_agent_number__c 166014752
listing_co_agent_mls_id__c 807512
listing_co_agent_number__c 1020319
listing_co_office_mls_id__c VANG02
listing_co_office_name__c Vanguard Properties
listing_co_office_number__c 166013449
listing_office_mls_id__c VANG02
listing_office_name__c Vanguard Properties
listing_office_number__c 166013449
pba__listingprice_pb__c 7888000
pba__listingtype__c Sale
pba__longitude_pb__c -122.405539
lower_level__c Bedroom(s),Full Bath(s),Garage
mls_id__c 423717792
main_level__c Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c Shower Stall(s);Tub;Double Sinks
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 2
on_market_date__c 2023-01-28
open_house_end__c 2023-01-31T11:00:00.000+0000
open_house_start__c 2023-01-31T09:00:00.000+0000
original_price__c 7888000
overall_days_on_market__c -81476
parking_access__c Side by Side
parking_features__c Garage Door Opener,Garage Facing Front,Side-by-Side
parking_type__c On Site (Single Family Only)
pba__pendingdate__c 1800-01-01
pba__pool_pb__c 1
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 1504.77
pba__propertytype__c Single Family Residence
ListingId a0E8W00000a87z4UAA
room_type__c Office;Laundry;Kitchen;Atrium;Living Room;Dining Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c 1800-01-01
sale_price__c 0
security_features__c Security Gate;Video System;Security System Prewired
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 5242
size__c 5242
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Tehama
subdist__c South of Market
ffd_name 457 Tehama Street, San Francisco, CA, 94103
website_property_type__c Single Family Home
pba__yearbuilt_pb__c 2022
pba__postalcode_pb__c 94103
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530572876-1.jpg
New
Open 01/31 09:00am till 11:00am