meta_query='key:subdist__c;value:Silver Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337008' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70687
[post_author] => 4
[post_date] => 2018-11-30 20:41:49
[post_date_gmt] => 2018-11-30 20:41:49
[post_content] => Silver Terrace is very central yet oddly aloof thanks to geographical fate. Bordered to the north, south, and east by freeway and industrial park, it perches above the Bayview, and select homes offer stunning bridge views.
[post_title] => Silver Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => silver-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-22 10:36:43
[post_modified_gmt] => 2023-06-22 17:36:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70687
[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, 2 Maddux Avenue, San Francisco, CA, 94124
ffd_mls_id, 423900376
ffd_salesforce_id, a0E8W00000cpetgUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2 Maddux Avenue, San Francisco, CA, 94124
pba__address_pb__c, 2 Maddux Avenue, San Francisco, CA, 94124
agent_only_remarks__c, Turn key beauty. Vacant and staged. Lockbox on front door.BofA has promotional program-up to 17,500 towards closing costs for qualified Buyers. No garage. Bedrooms and bathroom atgarage level are unwarranted. Driveway or street parking only. Please text/voice Paula at 415-724-3424. For fastest repsonse please email at [email protected]. Disclosure link at: https://app.disclosures.io/link/2-Maddux-Avenue-hrmu2mst
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Built-In Gas Oven;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Tile;Stone
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1942
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:53:26.000+0000
days_on_market__c, 29
dom__c, 29
ffd_description_pb, Welcome home to 2 Maddux. This exquisitely remodeled single-family home boasts luxury and comfort, offering an unparalleled living experience. With 4 bedrooms, 3 bathrooms, and breathtaking views of downtown San Francisco, this residence is the epitome of modern elegance. Step inside and be greeted by an open-concept living space that seamlessly blends contemporary design with functionality. Hardwood floors, high ceilings, featuring top-of-the-line stainless steel appliances, sleek granite countertops. Cooking in the kitchen will inspire your inner chef. The home has 3 levels of living space. Main level is the living room, dining area and kitchen. Upper level is 2 bedrooms with garden and downtown views and a bath. On the lower level are two suites with garden access and laundry This home offers an outdoor oasis for entertainment and relaxation. The thoughtfully designed 2 level outdoor entertainment space is perfect for hosting gatherings or enjoying a quiet evening under the stars. Whether it's a summer barbecue with friends or a tranquil morning cup of coffee, this space has it all. Your new chapter begins here - where luxury, comfort, and style converge in perfect harmony. BofA has promotional program-up to 17,500 towards closing costs for qualified Buyers.
district__c, SF District 10
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fencing__c, Back Yard;Fenced;Full
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Cathedral Ceiling
ffd_lastmodifieddate, 2023-09-23T20:47:18.000+0000
pba__latitude_pb__c, 37.7351
pba__latitude_property__c, 37.7351
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2023-08-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paula
pba__listing_agent_lastname__c, Rose
listing_agent_mls_id__c, 802963
ffd_listingagentname, Paula Y Rose
listing_agent_number__c, 802963
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://real.vision/2-maddux-avenue
pba__longitude_pb__c, -122.3984
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 423900376
main_level__c, Kitchen;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-08-25
open_house_end__c, 2023-09-24T16:00:00.000+0000
open_house_start__c, 2023-09-24T14:00:00.000+0000
original_price__c, 995000
overall_days_on_market__c, -81685
patio_and_porch_features__c, Uncovered Deck;Uncovered 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, a0E8W00000cpetgUAA
road_surface_type__c, Asphalt
room_type__c, Office;Kitchen;Converted Garage;Living Room;Guest Quarters;Baths Other;Dining Room;Primary Bedroom 2+
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, Maddux
subdist__c, Silver Terrace
ffd_name, 2 Maddux Avenue, San Francisco, CA, 94124
view__c, Downtown;Bay Bridge;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1942
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530661665-1.jpg
