meta_query='key:subdist__c;value:Potrero Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235876' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15714
[post_author] => 4
[post_date] => 2018-11-02 19:54:27
[post_date_gmt] => 2018-11-02 19:54:27
[post_content] => Meet Potrero Hill, where you can check out but you can never really leave. Sunny weather, jaw-dropping views of the downtown skyline and San Francisco Bay. Friendly, charming, and filled with more than you'd expect, it's a hill unto itself.
[post_title] => Potrero Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => potrero-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:08:25
[post_modified_gmt] => 2024-03-19 21:08:25
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15714
[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, 319 Texas Street, San Francisco, CA, 94107
ffd_mls_id, 498746
ffd_salesforce_id, a0E1I00000SnWQ2UAN
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 319 Texas Street, San Francisco, CA, 94107
pba__address_pb__c, 319 Texas Street, San Francisco, CA, 94107
agent_only_remarks__c, Pre sale escrow opened with Chris Matthews at ORTC Please follow COVID protocol. Easy to show by apt. pls. contact Claudia. Need PEAD V signed, pre- approval letter, pls view virtual tour @ 319Texas.com Special block with no overhead wires, walk to 18th street. Incredible custom home. Wired for electric car charger in garage. Offers welcomed Thursday June 4th at 2pm. Thank you!
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Ice Maker;Freezer;Self/Cont Clean Oven
architectural_style__c, Contemporary;Marina;Craftsman
bath_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1927
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-05-29T20:45:19.000+0000
days_on_market__c, 1146
dom__c, 7
ffd_description_pb, Paradise on Potrero Hill! Immaculate architect reimagined/ and fully rebuilt home (in 2007-8) with permits, using the finest materials. Panoramic private roof deck w/ majestic views of the city and bay. Luxurious master suite boasts Bay views; view deck, deluxe Spa bath w/soaking tub, dual sinks & radiant heat. Generous kitchen w/expansive Brazilian granite counters, all stainless appliances, abundant custom cabinetry and floating shelves. Main level enjoys 2 spacious bedrooms with water views and easy garden access. Gorgeous sun filled living room w/ wood burning fireplace and surround sound for your movie nights. Every room has built in speakers and controls, choose your whim in any room! Custom made IPE floating staircase anchors the home creating a sun filled atrium w/ luscious light. Lower level has 1-2 car garage & additional 1000 + sq. feet, 8 ft. ceilings, garden access and 1/4 bath. A+ location, 92 Walk score, stroll to coffee, easy fwy access Create your dreams! 319Texas.co
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Wood;Stone
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;Central;Gas
ffd_lastmodifieddate, 2022-05-12T21:47:46.000+0000
pba__latitude_pb__c, 37.76232
pba__latitude_property__c, 37.76232
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-02-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Claudia
pba__listing_agent_lastname__c, Siegel
listing_agent_mls_id__c, 804416
ffd_listingagentname, Claudia L Siegel
listing_agent_number__c, 166013962
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.39522
pba__lotsize_pb__c, 0.06
lower_level__c, Partial Bath(s)
mls_id__c, 498746
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-05-29
original_price__c, 2995000
overall_days_on_market__c, -80502
parking__c, Garage,Interior Access
parking_access__c, Independent
parking_features__c, Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-06-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1306.28
pba__propertytype__c, Single Family Residence
id, a0E1I00000SnWQ2UAN
room_type__c, Storage;Bonus Room
sale_date__c, 2020-06-19
sale_price__c, 3141592
security_features__c, Smoke Detector
selling_agent_mls_id__c, MLSL5062344
selling_agent_number__c, 981216303
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sereno
pba__status__c, Closed
pba__totalarea_pb__c, 2405
size__c, 2405
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Texas
subdist__c, Potrero Hill
ffd_name, 319 Texas Street, San Francisco, CA, 94107
transportation__c, 1 Block
view__c, Panoramic;City Lights;Bay;Water;Downtown;Bay Bridge;San Francisco
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Weather Stripped
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363764-1.jpg
ListingId, a0E1I00000SnWQ2UAN