meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='322328' 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] => 2023-10-31 09:46:12
[post_modified_gmt] => 2023-10-31 16:46:12
[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, 254 Page Street, San Francisco, CA, 94102
ffd_mls_id, 422700672
ffd_salesforce_id, a0E8W00000ZLYo7UAH
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 3
address2__c, 254 Page Street, San Francisco, CA, 94102
pba__address_pb__c, 254 Page Street, San Francisco, CA, 94102
agent_only_remarks__c, Please contact either Mark Shumway or Marc Dickow for showing appointments. No private showings until after the first open house. Escrow opened with Janette Marcelo at Old Republic Title. All offers to be submitted on SFAR purchase contract. Note: Substantial foundation upgrades and full exterior repaint recently completed. Buyer to test their car in the garage.
appliances__c, Dishwasher;Free Standing Refrigerator;Compactor;Built-In Electric Range
architectural_style__c, Victorian
bath_features__c, Split Bath
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1885
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Marc Dickow
pba__contingentdate__c, 2022-11-29
ffd_createddate, 2022-10-14T19:47:09.000+0000
days_on_market__c, 278
dom__c, 53
ffd_description_pb, Welcome to this gorgeous and extra spacious Hayes Valley Victorian condo. Nestled on a beautiful tree lined street, you can't be more centrally located! The home boasts a large double front living room with a beautiful tiled fireplace and plenty of room for your home office. There are two large bedrooms, an expansive dining room, and second potential space for another home office or relaxing sitting area. High ceilings and original Victorian details throughout. Updated Kitchen that includes all newer Stainless Steel appliances. Fresh paint and new flooring throughout. Not to be missed is the shared large outdoor fully rebuilt deck that is just steps from your back door. This home is completed with luxurious bathroom updates, separate laundry room, large kitchen pantry, and an abundance of closet space. And with the beautiful Page & Laguna mini-park just across the street. Walkable to Lower Haight, Hayes Valley and Duboce Triangle restaurants and boutiques. Walk-score of 99. Easy freeway access. A must see!
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__hoafees__c, 340
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T17:58:39.000+0000
pba__latitude_pb__c, 37.774015
pba__latitude_property__c, 37.774015
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2022-07-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mark
pba__listing_agent_lastname__c, Shumway
listing_agent_mls_id__c, 811167
ffd_listingagentname, Mark N Shumway
listing_agent_number__c, 1050184
listing_co_agent_mls_id__c, 807516
listing_co_agent_number__c, 1020348
listing_co_office_mls_id__c, CORE7
listing_co_office_name__c, Core7 Real Estate
listing_co_office_number__c, 25190
listing_office_mls_id__c, CORE7
listing_office_name__c, Core7 Real Estate
listing_office_number__c, 25190
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.mpowerpropertiessellshayes.com/
pba__longitude_pb__c, -122.425018
mls_id__c, 422700672
master_bathroom_features__c, Quartz
master_property__c, a0O8W00000Fs4cjUAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-10-14
original_price__c, 1495000
overall_days_on_market__c, -81370
parking_access__c, Independent
parking_features__c, Detached,Enclosed,Garage Door Opener,Garage Facing Rear,Private,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-12-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 765.69
pba__propertytype__c, Condominium
ListingId, a0E8W00000ZLYo7UAH
room_type__c, Laundry;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-01-06
sale_price__c, 1439500
security_features__c, Window Security Bars
selling_agent_mls_id__c, 803139
selling_agent_number__c, 803139
selling_co_agent_mls_id__c, 811258
selling_co_agent_number__c, 1050698
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1880
size__c, 1880
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Page
subdist__c, Hayes Valley
ffd_name, 254 Page Street, San Francisco, CA, 94102
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1885
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530542850-1.jpg