meta_query='key:subdist__c;value:Marina|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='372164' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15725
[post_author] => 4
[post_date] => 2018-11-02 19:54:46
[post_date_gmt] => 2018-11-02 19:54:46
[post_content] => Where Biff met Buffy and they rented their first apartment so they could jog to Crossfit together. Marina Green, yacht clubs, Ft. Mason, and front-row views from the Golden Gate Bridge to Alcatraz and the East Bay. This is as north as San Francisco goes.
[post_title] => Marina
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => marina-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 08:36:17
[post_modified_gmt] => 2024-03-28 15:36:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15725
[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, 1724813718
ffd_listing_title, 3623 Buchanan Street, San Francisco, CA, 94123
ffd_mls_id, 423926402
ffd_salesforce_id, a0EUd0000015tBNMAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 3623 Buchanan Street, San Francisco, CA, 94123
pba__address_pb__c, 3623 Buchanan Street, San Francisco, CA, 94123
agent_only_remarks__c, https://app.disclosures.io/link/36233625-Buchanan-Street-mrbybw3z
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator;Warming Drawer
architectural_style__c, Modern/High Tech;Traditional
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Steven L Minchen
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-10T11:47:19.000+0000
days_on_market__c, 199
dom__c, 199
ffd_description_pb, Welcome to an unparalleled recent construction in San Francisco's Marina District, where luxury meets sophistication. This remarkable residence offers three bedrooms, two full bathrooms, and two half bathrooms, all designed with an exceptional attention to detail. From the moment you enter, you'll notice the pristine hardwood floors and imported marble, creating an atmosphere of refined elegance. The kitchen is a chef's dream, featuring top-of-the-line appliances that combine style with functionality. Custom closets throughout the home add both convenience and a touch of luxury. This property is uniquely zoned for live/work use, offering versatility to suit your lifestyle. The private rooftop access provides a tranquil retreat with stunning views of the surrounding area. With high-end finishes and thoughtful design, this residence redefines contemporary living. Embrace the exceptional and make this one-of-a-kind home your own, where every detail reflects a commitment to quality and luxury.
district__c, SF District 7
driveway_sidewalks__c, Gated,Paved Driveway,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-08-28T02:47:09.000+0000
pba__latitude_pb__c, 37.803471
pba__latitude_property__c, 37.803471
laundry_features__c, Inside Room;Ground Floor;Cabinets;Space For Frzr/Refr
listed_date__c, 2024-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kelly
pba__listing_agent_lastname__c, Minchen
listing_agent_mls_id__c, 812301
ffd_listingagentname, Kelly D Minchen
listing_agent_number__c, 1056113
listing_co_agent_mls_id__c, 804514
listing_co_agent_number__c, 159505319
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=mUYksSZ4V1M
pba__longitude_pb__c, -122.433716
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 423926402
main_level__c, Kitchen;Living Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-02-10
original_price__c, 3295000
overall_days_on_market__c, -81854
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
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, 1220.37
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000015tBNMAY
road_surface_type__c, Paved
roof__c, Tar/Gravel;Composition;Flat
room_type__c, Storage;Laundry;Kitchen;Living Room;Dining Room;Wine Storage Area;Primary Bathroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Fire Alarm;Security Fence;Secured Access;Carbon Mon Detector;Video System
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, 2700
size__c, 2700
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Buchanan
subdist__c, Marina
ffd_name, 3623 Buchanan Street, San Francisco, CA, 94123
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530729353-1.jpg