meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='377362' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15726
[post_author] => 4
[post_date] => 2018-11-02 19:54:49
[post_date_gmt] => 2018-11-02 19:54:49
[post_content] => Once a dairy farm. Now it's where global day-traders and future financiers in training come to rest their spreadsheet-weary eyes at night. Home to Union Street shops and restaurants, as well as classic north end style, served in slightly smaller sizes than the estates of Pacific Heights.
[post_title] => Cow Hollow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cow-hollow
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:58:51
[post_modified_gmt] => 2024-04-09 17:58:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15726
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1715252333
ffd_listing_title, 3038 Steiner Street, San Francisco, CA, 94123
ffd_mls_id, 424019412
ffd_salesforce_id, a0EUd000001dvlqMAA
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 3038 Steiner Street, San Francisco, CA, 94123
pba__address_pb__c, 3038 Steiner Street, San Francisco, CA, 94123
agent_only_remarks__c, Disclosure package available by request. Square footage numbers vary significantly. Our graphic artist measured the unit at 1759 square feet and the tax records show 2310 square feet. Buyers are advised to verify square footage to their own satisfaction. Garden is deeded to this unit. HOA is informal and does not collect dues monthly but they average out to about $175/month based on shared costs for building insurance and garbage. https://vimeo.com/930444663
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1915
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-04-24
ffd_createddate, 2024-04-03T20:48:16.000+0000
days_on_market__c, 36
dom__c, 23
ffd_description_pb, This inviting Cow Hollow 2-level condominium is ideally located near the bustling shops and restaurants of Union, Fillmore, and Chestnut streets. Featuring 3 bedrooms and 2.5 baths, this home showcases contemporary elegance with thoughtful design elements. Upon entering the main level, you'll find a spacious living room with a stone surround fireplace, large windows for lots of natural light, a cozy bench seat, and elegant cabinetry. The formal dining room seamlessly connects to the kitchen which has been beautifully remodeled with Calacatta gold marble countertops and tile backsplash, stainless-steel appliances, built-in laundry closet, and a wine fridge. The fully renovated bathroom on this level features quartz countertops and a spacious shower, serving the two light-filled bedrooms and integrated sunroom that is ideal for use as a home office. There is also a large storage closet and a convenient powder room in the hallway for guest use. Moving to the lower level, the luxurious primary bedroom awaits with an elegant dual vanity bathroom, two walk-in closets and French doors opening to a charming and deeded garden. Additional amenities include one-car independent parking and ample storage in several locations.
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
pba__hoafrequency_pb__c, See Remarks
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-05-09T10:47:53.000+0000
pba__latitude_pb__c, 37.797481
pba__latitude_property__c, 37.797481
laundry_features__c, In Kitchen;Washer/Dryer Stacked Included
listed_date__c, 2024-04-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Scott
pba__listing_agent_lastname__c, Brittain
listing_agent_mls_id__c, 400402
ffd_listingagentname, Scott Brittain
listing_agent_number__c, 400402
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, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/930444663
pba__longitude_pb__c, -122.436984
lower_level__c, Full Bath(s),Primary Bedroom
mls_id__c, 424019412
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Double Sinks;Soaking Tub
master_property__c, a0OUd000005bI6MMAU
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-03
original_price__c, 2495000
overall_days_on_market__c, -81907
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2024-04-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-08T17:14:01.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
ListingId, a0EUd000001dvlqMAA
roof__c, Bitumen
sale_date__c, 2024-05-08
sale_price__c, 2505000
selling_agent_mls_id__c, 804695
selling_agent_number__c, 166014347
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Steiner
subdist__c, Cow Hollow
ffd_name, 3038 Steiner Street, San Francisco, CA, 94123
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1915
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530754696-1.jpg