meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219301' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-25 11:19:58
[post_modified_gmt] => 2024-11-25 19:19:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 231 Scott Street #1, San Francisco, CA, 94117
ffd_mls_id, 421557619
ffd_salesforce_id, a0E1I00000UTvPPUA1
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 231 Scott Street #1, San Francisco, CA, 94117
pba__address_pb__c, 231 Scott Street #1, San Francisco, CA, 94117
agent_only_remarks__c, Property has ratified, broker's tour has been canceled. Agents, please note that the 3rd bedroom does not have a window egress, therefore may not be considered a bedroom by DBI standards. Buyer to investigate. Seller to do 1031 exchange at no cost to buyer. We will be setting an offer date on this property and reach out to all Interested parties with an offer date after the weekend. Please DO NOT text or use Showingtime for showings. Showing instructions can be found here: https://calendly.com/231scottst/showings . Please send your PEAD to [email protected] prior to your showing. Please review disclosures in advance: https://app.glide.com/share/5b7NZ5LARMJOgQa1VA6XRk/ All COVID documents, as well as our detailed showing instructions, are available in the disclosure packet. Escrow is opened with [email protected]. All buyers to use the most current 7-page SFAR contract. If needed, one will be provided. *All info herein is not guaranteed. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.*
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Tile;Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1998
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-04T01:48:13.000+0000
days_on_market__c, 1307
dom__c, 4
ffd_description_pb, Centrally located between four parks, this pet friendly, 3bd/2ba Hayes Valley condo is a retreat unto itself. Natural light cascades through the home, lending a fresh, airy feel. A spacious backyard serves as a welcome respite. Social spaces are sunny and open, generously sized w/ easy flow for entertaining or everyday living. The huge front window maximizes daylight and a decorative fireplace sets a cozy scene after dark. A chef's kitchen offers plenty of worktop space, ample cabinetry, and S/S appliances. Two bedrooms are tucked at the rear of the home, brightened by west-facing windows. The primary en suite bedroom boasts double closets, full bath, & direct backyard access. The third bedroom, adjacent to the living area, can also function as a large office or den. In-unit W/D, linen closet, & hall bath complete the full-level flat. The backyard is deeded to this unit, a tranquil stretch freshly landscaped w/ areas for lounging & a hot tub. Abundant storage. 1-car garage parking.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced;Full
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Homeowners Insurance,Insurance on Structure,Maintenance Exterior,Trash
pba__hoafees__c, 400
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:54:14.000+0000
pba__latitude_pb__c, 37.771979
pba__latitude_property__c, 37.771979
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2021-06-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ruth
pba__listing_agent_lastname__c, Krishnan
listing_agent_mls_id__c, 400593
ffd_listingagentname, Ruth Krishnan
listing_agent_number__c, 1019790
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=b7ccy7nixEA
pba__longitude_pb__c, -122.435751
mls_id__c, 421557619
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0O1I000004VW1tUAG
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-06-03
original_price__c, 1495000
overall_days_on_market__c, 154
parking_access__c, Tandem
parking_features__c, Assigned,Attached,Garage Facing Front,Size Limited
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-06-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1253.92
pba__propertytype__c, Condominium
id, a0E1I00000UTvPPUA1
road_surface_type__c, Asphalt
room_type__c, Office;Living Room;Master Bathroom;Master Bedroom
sale_date__c, 2021-07-12
sale_price__c, 2000000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, MLSL481818
selling_agent_number__c, 981209835
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Realty World Milestone
pba__status__c, Closed
pba__totalarea_pb__c, 1595
size__c, 1595
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Scott
subdist__c, Hayes Valley
ffd_name, 231 Scott Street #1, San Francisco, CA, 94117
website_property_type__c, Condominium
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1998
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530255775-1.jpg
ListingId, a0E1I00000UTvPPUA1
_yoast_indexnow_last_ping, 1735669048