Property Id: 5970182
Price: $ 474,900
Property Size: 2,940 ft2
Property Lot Size: 0 ft2
Rooms: 0
Bedrooms: 4
Bathrooms: 2.5
ArchitecturalStyle: Detached, Two Story
AssociationFee: 325
AssociationFeeFrequency: Monthly
BathroomsFull: 2
BathroomsHalf: 1
BathroomsTotalDecimal: 2.5
BridgeModificationTimestamp: 2026-07-10T16:02:42.323Z
BuilderModel: HUGE
BuildingAreaSource: Owner
BuildingAreaUnits: Square Feet
BuildingName: MANDARIN LAKES
CommunityFeatures: Clubhouse, Pool, Security Patrol
ConstructionMaterials: CBS Construction
ContractStatusChangeDate: 2026-05-15
Cooling: Ceiling Fan(s), Central Air
CoveredSpaces: 2
DaysOnMarket: 56
DirectionFaces: East
Directions: From 137 AVE and 272 ST, go west into the Mandarin Lakes area. 272 ST will turn into 140 AVE as it curves south. Once you pass 274 TER, make the next right and park in the first driveway on the right side in front of the two-car garage.
DoorFeatures: French Doors
Electric: Circuit Breakers
EntryLocation: Foyer
ExpirationDate: 2026-11-14
Flooring: Tile
Furnished: Unfurnished
GarageSpaces: 2
Heating: Central
IDXParticipationYN: 1
InternetAddressDisplayYN: 1
InternetEntireListingDisplayYN: 1
LaundryFeatures: Utility Room/Laundry
ListAOR: A-Miami Association of REALTORS
ListAgentDirectPhone: 786-344-9992
ListAgentFullName: JamesAnthony Campo
ListAgentKey: a1cf60bcc92aa90904c2bff4045e366a
ListAgentMlsId: 0613540
ListAgentOfficePhone: 786-344-9992
ListAgentStateLicense: 0613540
ListOfficeKey: 0df5eda69637b3966b4ef780dda4063c
ListOfficeMlsId: MRSI01
ListOfficeName: My Realty Services Inc
ListOfficePhone: 786-344-9992
ListOfficeURL: TonyCampo.com
ListingAgreement: Exclusive Right To Sell
ListingContractDate: 2026-05-15
ListingId: A12019854
ListingKeyNumeric: 476555228
ListingTerms: All Cash, Conventional, FHA
LivingAreaUnits: Square Feet
LotFeatures: Less Than 1/4 Acre Lot
LotSizeSquareFeet: 4487
LotSizeUnits: Square Feet
MIAMIRE_LPAmtSqFt: 161.5306
MIAMIRE_PetsAllowedYN: 1
MIAMIRE_RATIO_CurrentPrice_By_SQFT: 161.53
MIAMIRE_Style: R30-No Pool/No Water
MIAMIRE_SubdivisionInformation: Clubhouse, Community Pool, Security Patrol
MIAMIRE_TypeofAssociation: Homeowners
MLSAreaMajor: Mandarin Lakes
MajorChangeTimestamp: 2026-07-10T15:58:05.233Z
MajorChangeType: Price Decrease
MlsStatus: Active
Model: HUGE
ModificationTimestamp: 2026-07-10T15:58:05.233Z
OnMarketDate: 2026-05-15
OriginalEntryTimestamp: 2026-05-15T17:30:24.657Z
OriginalListPrice: 499900
OriginatingSystemID: miamire
OriginatingSystemKey: miamire
OriginatingSystemName: Miami Association of REALTORS®
OtherEquipment: Automatic Garage Door Opener
OtherExpense: 0
ParcelNumber: 30-69-34-021-1200
ParkingFeatures: Slab/Strip
PetsAllowed: Yes
PhotosChangeTimestamp: 2026-05-15T17:34:40.855Z
PhotosCount: 78
Possession: Funding
PostalCodePlus4: 8811
PreviousListPrice: 499900
PriceChangeTimestamp: 2026-07-10T15:58:05.233Z
PublicSurveyRange: 69
PublicSurveySection: 34
PublicSurveyTownship: 69
Roof: Curved/S-Tile Roof
SecurityFeatures: Smoke Detector
Sewer: Public Sewer
ShowingInstructions: Lockbox-No Appointment, Showing Assist
SourceSystemKey: 476555228
StateOrProvince: FL
StatusChangeTimestamp: 2026-05-15T17:30:24.657Z
StreetDirPrefix: SW
StreetName: 274 TER
StreetNumber: 14008
StreetNumberNumeric: 14008
StructureType: R30-No Pool/No Water, House
SyndicationRemarks: This pristine, spacious corner-unit home is a rare find, boasting an impressive 3, 642 sq ft under roof (as per tax roll) and designed for modern family living. Featuring 4 bedrooms, 2 1/2 baths, and a 2-car garage, this property welcomes you with a long ranch-style covered front porch and a huge front yard, perfect for outdoor relaxation. Step through the foyer and enjoy an airy, 180-degree view of the open-concept living area and staircase. The heart of the home is a chef-friendly kitchen, complete with solid wood cabinets, granite countertops, a central island, and stainless-steel appliances. Flooded with natural light from numerous windows, the residence feels bright and inviting throughout. All four large bedrooms are conveniently located upstairs, including a massive master suite with a walk-in closet and a private, luxurious bath featuring double sinks, a Roman tub, and a separate shower. This "move-in-ready" property is in perfect condition, offering the space and quality your family deserves. Find the virtual tour on YouTube by searching for the MLS number.
TaxAnnualAmount: 6646
TaxLegalDescription: MANDARIN LAKES PB 163-40 T-21633 LOT 11 BLK 16 LOT SIZE 4487 SQ FT FAU 30-6934-008-0010 & 0050 COC 25223-1679 12 2006 1
TaxYear: 2025
View: Garden
WaterSource: Municipal Water
WindowFeatures: Bay Window(s), Blinds, Drapes
YearBuilt: 2006
YearBuiltDetails: Resale
Zoning: 4802