meta_query='key:subdist__c;value:Twin Peaks|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216110' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15732
[post_author] => 4
[post_date] => 2018-11-02 19:54:57
[post_date_gmt] => 2018-11-02 19:54:57
[post_content] => San Francisco's highest point was developed beginning in the 1960s. Mid-century construction, utilitarian buildings, and jaw-dropping views of downtown and the East Bay when the wind and fog relent.
[post_title] => Twin Peaks
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => twin-peaks
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-15 08:07:47
[post_modified_gmt] => 2024-04-15 15:07:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15732
[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, 242 Romain Street, San Francisco, CA, 94131
ffd_mls_id, 510165
ffd_salesforce_id, a0E1I00000TjRmXUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 242 Romain Street, San Francisco, CA, 94131
pba__address_pb__c, 242 Romain Street, San Francisco, CA, 94131
agent_only_remarks__c, This is Trust Sale, not subject to court confirmation. The property is sold in as-is condition with no warranties expressed or implied. Buyer to pay the San Francisco City & County transfer tax and be responsible for any required energy/water, smoke, CO and water heater strapping ordinances. Offers due Wednesday, December 2nd by 12 Noon. Shown by appointment only with signed PEAD. Email agent for explicit instructions for offers and disclosures, (available no later 11/25) Seller reserves right to accept or reject any & all offers. No preemptive offers! Please call/ text listing Agent for viewing instructions and lockbox code. Tara Robello- 415-879-0581 [email protected]
appliances__c, Refrigerator;Built-In Oven
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1936
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2020-11-21T21:46:02.000+0000
days_on_market__c, 970
dom__c, 13
ffd_description_pb, Great opportunity to make this twin peaks home your own. This spacious 3 bedroom one bath home is located on a quaint little street overlooking the city skyline and Marin. The terracotta steps lead to your oasis with spectacular views. This one of a kind Romain street home has a great flowing floor plan and ready for someone to enjoy. Spacious living room with a unique curved fireplace and large front windows. High ceilings and newly refinished hard wood floors throughout. Bright eat-in kitchen, dining room, 2 big bedrooms upstairs and a bathroom with both a bathtub/shower stall and a duel flushing toilet. One large bedroom/ play room (warrant unknown) located on the lower level with a walk-in closet. This exceptionally big garage extends back to one of two work areas that look out towards the backyard. This home has endless potential for the right buyer. Come see for yourself before it's gone!
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:40:26.000+0000
pba__latitude_pb__c, 37.756137
pba__latitude_property__c, 37.756137
listed_date__c, 2020-11-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tara
pba__listing_agent_lastname__c, Robello
listing_agent_mls_id__c, 814485
ffd_listingagentname, Tara Robello
listing_agent_number__c, 1066404
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, KWRSF
listing_office_name__c, Keller Williams San Francisco
listing_office_number__c, 26158
pba__listingprice_pb__c, 1349000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.442071
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room
mls_id__c, 510165
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-11-21
original_price__c, 1349000
overall_days_on_market__c, 92
parking__c, Attached,Garage,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-12-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1254.9
pba__propertytype__c, Single Family Residence
id, a0E1I00000TjRmXUAV
room_type__c, Bonus Room;Game Room
sale_date__c, 2020-12-30
sale_price__c, 1728000
selling_agent_mls_id__c, 802477
selling_agent_name__c, Joost A. Van de Water
selling_agent_number__c, 802477
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1377
size__c, 1377
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Romain
subdist__c, Twin Peaks
ffd_name, 242 Romain Street, San Francisco, CA, 94131
transportation__c, 2 Blocks
view__c, Panoramic;City Lights;Downtown;San Francisco;Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1936
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/374064-1.jpg
ListingId, a0E1I00000TjRmXUAV