ffd_listing_title,2535 Union Street, San Francisco, CA, 94123
ffd_mls_id,423910092
ffd_salesforce_id,a0E8W00000dSXIwUAO
num_of_fireplaces__c,1
num_of_rooms__c,0
of_units__c,0
address2__c,2535 Union Street, San Francisco, CA, 94123
pba__address_pb__c,2535 Union Street, San Francisco, CA, 94123
agent_only_remarks__c,Exceptional home and gardens on a wide lot! Call Pattie to show: 415-309-7836. Financing: Current $5.2M 10/1 ARM loan at 2.75% interest rate fixed until 2030 may be assigned to qualified buyer by existing lender.
appliances__c,Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c,Contemporary;Edwardian
bath_features__c,Sunken Tub;Stone
pba__fullbathrooms_pb__c,4
pba__bedrooms_pb__c,4
year_build_text__c,1906
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-09-16T01:47:24.000+0000
days_on_market__c,8
dom__c,8
ffd_description_pb,Artfully remodeled with a perfectionist's attention to detail and style, this exquisite home has been fully re-designed to achieve a seamless balance between its classical architecture and a modern indoor/outdoor lifestyle. Just completed, the renovation is impeccable with top-of-the-line finishes, fixtures, and systems, including expanded and beautifully appointed outdoor spaces both in front and back. Fully detached with a commanding presence on four levels and with its wide and deep lot, the home sits majestically on a tree-lined block in Cow Hollow, one of the City's most desirable neighborhoods, and is near the popular shops and dining of Union, Chestnut and Fillmore Streets, and the parks and open spaces afforded by Pacific Heights, the Presidio and the Marina. Built with an exceptional floor plan created especially for the contemporary lifestyle, this bright and airy home has expansive indoor and outdoor spaces for entertaining and casual living. A four bedroom, four and a half bath home, three bedrooms grace the upper level with guest and office spaces on the lower level, and indoor/outdoor entertainment spaces on all three levels. Two garages with Tesla charging sit at street level for easy access along with a private gated entrance to the home.
district__c,SF District 7
driveway_sidewalks__c,Paved Driveway,Paved Sidewalk
entry_level__c,0
exterior_features__c,Fireplace;BBQ Built-In
external_listing__c,1
fencing__c,Back Yard;Fenced;Front Yard
fireplace_features__c,Living Room
pba__floortype_pb__c,Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
pba__heatingtype_pb__c,Central
interior_features__c,Skylight(s)
ffd_lastmodifieddate,2023-09-23T20:47:18.000+0000
pba__latitude_pb__c,37.7961855
pba__latitude_property__c,37.7961855
laundry_features__c,Inside Room;Washer Included;Dryer Included;Cabinets
listed_date__c,2023-09-15
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Patricia
pba__listing_agent_lastname__c,Lawton
listing_agent_mls_id__c,800774
ffd_listingagentname,Patricia A Lawton
listing_agent_number__c,800774
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,STHB
listing_office_name__c,Sotheby's International Realty
listing_office_number__c,2050
pba__listingprice_pb__c,8990000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.441015
lower_level__c,Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c,423910092
main_level__c,Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c,Shower Stall(s);Double Sinks;Tile;Soaking Tub;Stone;Skylight/Solar Tube
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2023-09-15
open_house_end__c,2023-09-24T16:00:00.000+0000
open_house_start__c,2023-09-24T14:00:00.000+0000
original_price__c,8990000
overall_days_on_market__c,-81706
parking_access__c,Independent
parking_features__c,Attached,Enclosed,EV Charging,Garage Door Opener,Garage Facing Front
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,Uncovered Deck
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,2211.56
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000dSXIwUAO
road_surface_type__c,Asphalt
room_type__c,Storage;Office;Laundry;Den;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Security Gate;Carbon Mon Detector
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,4065
size__c,4065
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Union
subdist__c,Cow Hollow
ffd_name,2535 Union Street, San Francisco, CA, 94123
view__c,City;City Lights;Garden/Greenbelt;Bay;San Francisco
website_property_type__c,Single Family Home
window_features__c,Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c,1906
pba__postalcode_pb__c,94123
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530678038-1.jpg
