Central air conditioningFive spacious bedroomsEfficient gas heatDetached three-car garageSoaring high ceilingsBuilt-in espresso machineProfessional masonry
Welcome to 138 Cambon Avenue: A Masterpiece of Custom Luxury and Efficiency Nestled in the heart of St. James, this custom-designed 5-bedroom, 3 Full / 2 Half bathroom residence at 138 Cambon Avenue offers a rare "move-in and unpack" opportunity, perfectly blending luxury with modern efficiency at $1,399,000. The grand interior features soaring high ceilings, efficient gas heat, central air conditioning, and a stunning designer kitchen equipped with premium granite countertops, a built-in espresso machine, and a specialized slow cooker steamer. The home's layout is uniquely versatile, boasting a fully finished basement with a separate entrance, kitchen, and bedroom—creating potential for a mother-daughter setup or accessory apartment with proper permits. A major financial asset to this property is the fully owned solar panel system, which ensures exceptionally low utility costs. Each bathroom has been reimagined with a modern, spa-inspired aesthetic, while the five spacious bedrooms provide ample room for all. The exterior is a true private oasis, meticulously finished with new pavers and professional masonry, featuring a full outdoor kitchen for premier entertaining and a detached three-car garage. Experience a resort-style lifestyle in this masterfully crafted home that balances high-end custom finishes with significant long-term energy savings.
96 days
|
236
|
4
|
Zillow last checked:
Listing updated:
Listed by:
Azure Realty Group NY LLC347-484-9965,
Steven J. Tavarez516-417-6207
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 991522
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 5
Full bathrooms: 3
1/2 bathrooms: 2
Heating
Natural Gas
Cooling
Central Air
Appliances
Included: Cooktop, Dishwasher, Exhaust Fan, Gas Cooktop, Gas Oven, Microwave, Oven, Refrigerator, Stainless Steel Appliance(s), Gas Water Heater, Solar Hot Water
Laundry: Inside
Features
First Floor Full Bath, Chefs Kitchen, Kitchen Island, Open Kitchen, Quartz/Quartzite Counters, Walk-In Closet(s)
Flooring: Wood
Basement: Finished,Full,Walk-Out Access
Attic: None
Interior area
Total structure area: 3,490
Total interior livable area: 3,490 sqft
Property
Parking
Total spaces: 3
Parking features: Garage
Garage spaces: 3
Features
Has private pool: Yes
Pool features: In Ground, Salt Water
Lot
Size: 0.59 Acres
Details
Parcel number: 0800087000100043000
Special conditions: None
Construction
Type & style
Home type: SingleFamily
Architectural style: Colonial
Property subtype: Single Family Residence, Residential
Materials
Frame
Condition
Updated/Remodeled
Year built: 2007
Utilities & green energy
Sewer: Cesspool
Water: Public
Utilities for property: Cable Available, Electricity Connected, Natural Gas Connected, Phone Connected, See Remarks, Sewer Connected, Trash Collection Public, Water Connected
Green energy
Energy generation: Solar
Community & HOA
HOA
Has HOA: No
Location
Region: Saint James
Financial & listing details
Price per square foot: $401/sqft
Tax assessed value: $1,242,750
Annual tax amount: $27,205
Date on market: 4/29/2026
Cumulative days on market: 95 days
Listing agreement: Exclusive Right To Sell
Electric utility on property: Yes
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
5/28/2026
Pending sale
$1,399,000$401/sqft
Source: OneKey® MLS as distributed by MLS GRID #991522Report a problem
4/29/2026
Listed for sale
$1,399,000+59.9%$401/sqft
Source: OneKey® MLS as distributed by MLS GRID #991522Report a problem
2/12/2020
Sold
$875,000-2.7%$251/sqft
Source: OneKey® MLS as distributed by MLS GRID #L3168902Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.