meta_query='key:subdist__c;value:Central Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='419547' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70208
[post_author] => 4
[post_date] => 2018-11-30 20:29:21
[post_date_gmt] => 2018-11-30 20:29:21
[post_content] => What used to be rolling sand dunes as far as the eye can see is now an orderly neighborhood of tidy homes. Views of the Golden Gate Bridge are a welcome surprise from the lucky parts. Proximity to the park appeals to those with canines and kids.
[post_title] => Central Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:27:28
[post_modified_gmt] => 2024-04-09 17:27:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70208
[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, 1729205602
ffd_listing_title, 471 22nd Avenue, San Francisco, CA, 94121
ffd_mls_id, 424074207
ffd_salesforce_id, a0EUd000003NTpBMAW
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 471 22nd Avenue, San Francisco, CA, 94121
pba__address_pb__c, 471 22nd Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Ground up renovation with new foundation and seismic upgrades, new physical systems, including radiant heat flooring, new plumbing and electrical, new exterior paint and marble staircase, Marvin windows and doors, blue tooth entertainment/sound system and beautiful custom finishes. Very special home, must see!
appliances__c, Dishwasher;Microwave;Built-In Gas Range;Wine Refrigerator;Built-In Refrigerator
bath_features__c, Tub w/Shower Over;Marble;Radiant Heat
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1914
pba__city_pb__c, San Francisco
listing_co_agent_name__c, John C Farnham
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-10-17T15:47:01.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Behind the handsome Edwardian facade is a fully modern, reimagined 5BD/3.5BA home. Walk up the marble staircase and enter the light filled, open concept living area featuring soaring ceilings, gas fireplace and dramatic stone surround. Next you'll find a gorgeous Chef's kitchen w/Calcutta marble stonework center island, custom cabinetry, and high end stainless steel appliances. The dedicated dining area is adjacent to the kitchen and has two large sliding glass doors that flood the space w/natural light and open on to a large deck, creating the perfect indoor/outdoor flow - ideal for entertaining. The deck overlooks the beautifully landscaped rear garden with high design and lush mature plants. A spacious powder room completes this level. Continue on to the upper floor and you'll find three bedrooms and baths on one level, including primary suite with large walk in closet and luxe bath. There are two additional bedrooms, one with large, attached deck. Finally, the first floor level can be internally accessed from the one car garage and includes a flexible living space with either two additional bedrooms, laundry room and a full bath accessible by both bedrooms. This level would make an ideal guest suite could be used as an office and family room with direct garden access.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Concrete;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant Floor
ffd_lastmodifieddate, 2024-10-17T22:48:38.000+0000
pba__latitude_pb__c, 37.7788509
pba__latitude_property__c, 37.7788509
laundry_features__c, Washer/Dryer Stacked Included;Ground Floor;Washer Included;Dryer Included;Cabinets
listed_date__c, 2024-09-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Laura
pba__listing_agent_lastname__c, Rogers
listing_agent_mls_id__c, 803793
ffd_listingagentname, Laura A Rogers
listing_agent_number__c, 803793
listing_co_agent_mls_id__c, 802874
listing_co_agent_number__c, 802874
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__listing_website__c, http://redesignedrichmondhome.com/mls
pba__longitude_pb__c, -122.4816483
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 424074207
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Marble
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-10-17
open_house_end__c, 2024-10-17T19:00:00.000+0000
open_house_start__c, 2024-10-17T17:30:00.000+0000
original_price__c, 2995000
overall_days_on_market__c, -82104
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Covered Patio
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, 0
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003NTpBMAW
sale_date__c, 1800-01-01
sale_price__c, 0
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 22nd
subdist__c, Central Richmond
ffd_name, 471 22nd Avenue, San Francisco, CA, 94121
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1914
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530873009-1.jpg