meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='239447' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15736
[post_author] => 4
[post_date] => 2018-11-02 20:00:55
[post_date_gmt] => 2018-11-02 20:00:55
[post_content] => Cultural haven. Home to that high-rise. If any SF neighborhood comes remotely close to vaguely feeling like Manhattan, the hustle and bustle of Yerba Buena probably comes closest. Yes, you are south of Market. But this is Yerba Buena.
[post_title] => Yerba Buena
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => yerba-buena
[to_ping] =>
[pinged] =>
[post_modified] => 2023-10-31 11:02:07
[post_modified_gmt] => 2023-10-31 18:02:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15736
[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, 301 Mission Street #47F, San Francisco, CA, 94105
ffd_mls_id, 422697543
ffd_salesforce_id, a0E8W00000ZMoy2UAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 419
address2__c, 301 Mission Street #47F, San Francisco, CA, 94105
pba__address_pb__c, 301 Mission Street #47F, San Francisco, CA, 94105
agent_only_remarks__c, Motivated Seller | Seller Financing OR Rate Buy Down Available | Lender Options Available | MG Estates Presents | All virtual media/video available @ www.grandresidencesviews.com | SHOWINGS Anytime Call/Text/Email Malin P. Kansal, MBA Director MG Estates 650.219.4725 [email protected] | Disclosures Available | Inquire about LENDING options. LENDER AVAILABLE. HOME FEATURES: Wooden Floors, Electronic Shades Throughout, Large Closets, Sub Zero | Wolfe Appliances, U Line Wine Fridge, Marble Counter Tops, Soaking Tub, New Electrolux Washer/Dryer, AC/Heating, New Paint, 1 Car Valet Parking, XL Storage, 20 Bottle Wine Storage BUILDING FEATURES: 24/7 security/concierge services, Indoor heated pool/spa w/Sun deck, Fitness center, Yoga studio, Pilates room, Treatment room, His/Hers luxurious locker rooms w/steam Room, Private dining room w/kitchen, Wine storage, Oak barrel room, Fireside lounge, Outdoor fire pit, Children's play room, Prive social program, International Smoke Restaurant
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Electric Range;Built-In Electric Oven
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Tub;Tile;Stone
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2009
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central,MultiZone,Window Unit(s)
ffd_createddate, 2022-11-09T22:46:54.000+0000
days_on_market__c, 358
dom__c, 342
ffd_description_pb, Grand Residences Ultra Luxury High Floor | Views, Bespoke Styling, Phenomenal Location abound. Possibilities exist customized to your lifestyle. Engaging views: city, hills, water along with iconic buildings like the Transamerica Building are seen thru XL windows; either floor to ceiling or dramatic window seats. 3rd bedroom offers flexibility (library, office, media room, etc). Fine finishes, upgrades, electric shades, rustic hardwood flooring, new bedroom carpets, bold lighting & storage throughout. Vast kitchen w/Studio Becker cabinets & pull-out pantry featuring ULine Wine Fridge, cabinet face Subzero|Wolfe appliances, accented with marble counters. Unique dining area. XL open view primary suite w/large walk-in closet. Primary spa bath w/large soaking tub & stand-in shower. 2nd bedroom w/well organized closet & adjoining bathroom w/ shower over tub.New Electrolux washer/dryer. Ultra luxurious building amenities, services & Prive Social Program. Valet & XL Storage. Opportunity!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Fire Pit
external_listing__c, 1
pba__floortype_pb__c, Carpet;Marble;Tile;Wood;Stone
hoa_fee_includes__c, Common Areas,Door Person,Maintenance Exterior,Maintenance Grounds,Management,Organized Activities,Pool,Recreation Facility,Security,Sewer,Trash,Water,Other
pba__hoafees__c, 2634
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Millennium Tower HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central;MultiZone
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2023-09-17T20:46:08.000+0000
pba__latitude_pb__c, 37.790389
pba__latitude_property__c, 37.790389
laundry_features__c, Inside Room;Washer/Dryer Stacked Included;Washer Included;Dryer Included;Stacked Only
listed_date__c, 2022-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Malin
pba__listing_agent_lastname__c, Kansal
listing_agent_mls_id__c, 808404
ffd_listingagentname, Malin P Kansal
listing_agent_number__c, 1034507
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG
listing_office_name__c, Vanguard Properties
listing_office_number__c, 2172
pba__listingprice_pb__c, 1748888
pba__listingtype__c, Sale
pba__listing_website__c, http://www.grandresidencesviews.com
pba__longitude_pb__c, -122.396155
mls_id__c, 422697543
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks;Soaking Tub;Stone
master_property__c, a0O1I000001VhhvUAC
monthly_parking_fees__c, 308
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-24
original_price__c, 2198888
overall_days_on_market__c, -81350
parking_access__c, Side by Side
parking_features__c, Covered,Enclosed,Guest Parking Available,Private,Underground Parking,Valet
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1092.37
pba__propertytype__c, Condominium
ListingId, a0E8W00000ZMoy2UAD
room_type__c, Storage;Office;Laundry;Den;Kitchen;Library;Media Room;Wine Storage Area;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Secured Access;Carbon Mon Detector;Security Patrol
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, 1601
size__c, 1601
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mission
subdist__c, Yerba Buena
ffd_name, 301 Mission Street #47F, San Francisco, CA, 94105
view__c, City;City Lights;Bay;Downtown;San Francisco;Hills;Mountains;Other
website_property_type__c, Condominium
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 2009
pba__postalcode_pb__c, 94105
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530533549-1.jpg