meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218195' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15733
[post_author] => 4
[post_date] => 2018-11-02 19:54:58
[post_date_gmt] => 2018-11-02 19:54:58
[post_content] => Sunny, sedate, central, strollers, and tech-centric. Once upon a time home searches began in Pacific Heights and settled for Noe Valley. Now home searches begin here and settle for Pacific Heights.
Connect with a Jackson Fuller Real Estate agent today and explore the diverse range of homes for sale in Noe Valley.
[post_title] => Noe Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => noe-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-05-08 08:45:37
[post_modified_gmt] => 2024-05-08 15:45:37
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15733
[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, 200 29th Street #5, San Francisco, CA, 94131
ffd_mls_id, 421536834
ffd_salesforce_id, a0E1I00000Ty8CPUAZ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 13
address2__c, 200 29th Street #5, San Francisco, CA, 94131
pba__address_pb__c, 200 29th Street #5, San Francisco, CA, 94131
agent_only_remarks__c, Offer date - Thursday 4/15 at noon. More info at http://www.ExpansiveNoeCondo.com Showings by appointment. Please do NOT use ShowingTime. Schedule with Calendly at https://calendly.com/domicile/20029th and then send signed PEAD form to [email protected]. Escrow with Michael Gatti at Old Republic Title. For questions or more info call, email or text Julie (415.730.6387) or Shane (415.225.5990) - [email protected]
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Range
architectural_style__c, Contemporary
bath_features__c, Tub;Tile;Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2004
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Shane R Ray
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-11T02:15:07.000+0000
days_on_market__c, 831
dom__c, 6
ffd_description_pb, House-like, expansive, beautiful 2-level luxury condo. This is the prime top-floor/end-unit in this building. Main level is almost completely open, creating a true great room. Living rm w/ bay windows, built-in window seat, gas fireplace, & enormous dining area. Enough wall space for the most enthusiastic art collector. Updated, highly stylish kitchen. Ideal configuration for serious dinner parties. Large gracious bedrm on this level that walks out to small patio. Washer/dryer + powder rm on this level as well. Staircase to the 2nd level is unusually wide & gracious for a modern condo. 2nd level is comprised of a luxurious hotel-sized primary en-suite bdrm - lg enough for king bed + huge sitting rm that walks out to a view deck that wraps around entire level. It feels like a vacation everyday. 2nd lg bdrm is en-suite as well. Deeded roof deck with killer views. Shared garden,2-car pkg + storage. Great walkability to Noe, Bernal, Mission & public/private transport. Easy freeway access.
district__c, SF District 5
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 549
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:49:20.000+0000
pba__latitude_pb__c, 37.743955
pba__latitude_property__c, 37.743955
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-04-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Julie
pba__listing_agent_lastname__c, Rogers
listing_agent_mls_id__c, 803159
ffd_listingagentname, Julie F Rogers
listing_agent_number__c, 803159
listing_co_agent_mls_id__c, 807674
listing_co_agent_number__c, 1023667
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, 1750000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=KcuQVj5NtQN&brand=0
pba__longitude_pb__c, -122.4248473
mls_id__c, 421536834
main_level__c, Partial Bath(s);Bedroom(s);Living Room;Dining Room
master_property__c, a0O8W00000Dagv6UAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-09
original_price__c, 1750000
overall_days_on_market__c, 113
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Underground Parking
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Roof Deck;Back Porch;Uncovered Patio;Wrap Around Porch
pba__pendingdate__c, 2021-04-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1071.43
pba__propertytype__c, Condominium
id, a0E1I00000Ty8CPUAZ
sale_date__c, 2021-05-14
sale_price__c, 2025000
security_features__c, Secured Access;Video System
selling_agent_mls_id__c, 802979
selling_agent_number__c, 802979
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1890
size__c, 1890
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 29th
subdist__c, Noe Valley
ffd_name, 200 29th Street #5, San Francisco, CA, 94131
view__c, San Francisco;Twin Peaks;Hills;Valley
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2004
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530216058-1.jpg
ListingId, a0E1I00000Ty8CPUAZ