ffd_listing_title,627 Fell 629 Street, San Francisco, CA, 94102
ffd_mls_id,423748471
ffd_salesforce_id,a0E8W00000cJKNEUA4
num_of_fireplaces__c,1
num_of_rooms__c,10
of_units__c,0
address2__c,627 Fell 629 Street, San Francisco, CA, 94102
pba__address_pb__c,627 Fell 629 Street, San Francisco, CA, 94102
agent_only_remarks__c,Property is really a 2-unit building with TIC agreement in place, it shows as a single family home with income unit. Unique property in great condition. Please note and exclude from the sale the following items - wooden chandelier in living room, wall lamp in living room and wall lamp in primary bedroom. Please use open escrow with Chicago Title Company, Gerrie Brindley, escrow #FWPN-3652300364-GB.
appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Gas Plumbed
architectural_style__c,Edwardian
bath_features__c,Tub w/Shower Over;Tub;Skylight/Solar Tube
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,2
year_build_text__c,1900
pba__city_pb__c,San Francisco
pba__contingentdate__c,1800-01-01
ffd_createddate,2023-06-10T00:48:29.000+0000
days_on_market__c,1
dom__c,1
ffd_description_pb,Impeccably updated Hayes Valley Edwardian with spacious 2 level upper unit and 1BR, 1BA income unit below. The first level of the main home has a double parlor, updated kitchen overlooking the yard, a half bath and direct access to the yard. The second level of the main home has 2 large bedrooms and 1 full bath. This unit has been tastefully updated with gleaming hardwood floors, kitchen with stainless steel appliances including gas cooking and French door refrigerator plus corian countertops. The powder room has stacking washer and dryer. Period details mixed with modern touches include soaring ceilings, period moldings and ornate details. Downstairs is a functional 1 bedroom, 1 bathroom unit with access both to the front of the home and the backyard. This home has 2 car garage parking accessed on Hickory with a large functional yard between the home and the garages. Prime Hayes Valley location, walk to the fabulous shopping on Hayes St or SF Jazz, the Opera, the Symphony or jump on MUNI and get anywhere. This is a rare find and not to be missed.
district__c,SF District 6
entry_level__c,0
external_listing__c,1
fencing__c,Back Yard
fireplace_features__c,Decorative Only
pba__floortype_pb__c,Wood
pba__hoafees__c,0
hoa__c,No
pba__halfbathrooms_pb__c,1
has_3d_tour__c,1
pba__heatingtype_pb__c,Baseboard;Central
interior_features__c,Formal Entry;Skylight(s)
ffd_lastmodifieddate,2023-06-10T10:49:07.000+0000
pba__latitude_pb__c,37.774972
pba__latitude_property__c,37.774972
laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included
listed_date__c,2023-05-15
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Dan
pba__listing_agent_lastname__c,Dodd
listing_agent_mls_id__c,804303
ffd_listingagentname,Dan Dodd
listing_agent_number__c,166013815
listing_co_agent_number__c,0
listing_co_office_number__c,0
listing_office_mls_id__c,INSPIRE
listing_office_name__c,Inspire Real Estate
listing_office_number__c,28583
pba__listingprice_pb__c,1350000
pba__listingtype__c,Sale
pba__listing_website__c,https://my.matterport.com/show/?m=gsRwGyVSSXa&mls=1 (Lower Unit) https://my.matterport.com/show/?m=Rt7PVzcHRTz&mls=1 (Upper Unit)
pba__longitude_pb__c,-122.428414
lower_level__c,Bedroom(s),Full Bath(s),Living Room
mls_id__c,423748471
main_level__c,Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2023-06-09
open_house_end__c,2023-06-11T16:00:00.000+0000
open_house_start__c,2023-06-11T14:00:00.000+0000
original_price__c,1350000
overall_days_on_market__c,-81608
parking_access__c,Side by Side
parking_features__c,Alley Access,Enclosed,Garage Door Opener,Garage Facing Rear,Side-by-Side
parking_type__c,On Site (Single Family Only)
patio_and_porch_features__c,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,666.34
pba__propertytype__c,Single Family Residence
ListingId,a0E8W00000cJKNEUA4
room_type__c,Kitchen;Living Room;Dining Room;Attic;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
security_features__c,Smoke Detector;Security Fence;Carbon Mon Detector;Double Strapped Water Heater;Window Security Bars
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,2026
size__c,2026
pba__state_pb__c,CA
stories__c,2
pba__street_pb__c,Fell
subdist__c,Hayes Valley
ffd_name,627 Fell 629 Street, San Francisco, CA, 94102
view__c,City Lights;San Francisco
website_property_type__c,Single Family Home
pba__yearbuilt_pb__c,1900
pba__postalcode_pb__c,94102
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530631492-1.jpg