Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:58:54.000' ,`MLSNumber` = '71508679' ,`ListAgentFullName` = 'Rae Hoffman' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.785828' ,`Longitude` = '-95.638906' ,`PhotoCount` = '6' ,`PostalCode` = '77414' ,`RoomCount` = '2' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Barracuda' ,`StreetNumber` = '14566' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special with tons of potential! Come complete this 1,864 SF waterfront project sitting on 1.5 lots totaling 7,500 SF. 75\' of water frontage. Fantastic location in Sargent sitting on a fishing canal. Only minutes from the beach by car and to the ICW by boat. Being sold as-is. Survey available.' ,`Acres` = '0.121' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DOWNEY CANEY CREEK SEC 14, LOT 566' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Downey Caney Creek Sec 14' ,`TaxAmount` = '1655' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042236' WHERE `Matrix_Unique_ID` = '205215564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:06.223' ,`MLSNumber` = '65542622' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435496' ,`Longitude` = '-95.441360' ,`PhotoCount` = '9' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '305990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1406' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This ONE-STORY new construction home with no back neighbors features 3 spacious bedrooms, 2 bathrooms, a covered patio, 2-car garage situated on a premium lot w/ a POND and walking trail behind. Built by D.R Horton, the Diana floor plan features an open concept living and dining space w/ spacious rooms. Granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher are included in the kitchen. The Primary bathroom has dual sinks, shower and/or soaking tub and a large walk-in closet! Smart tech features, brick on all four sides, vinyl flooring, & tankless water heater- ALL COME STANDARD in this community! Conveniently located off of Hwy 288, Sierra Vista offers easy access to downtown, med center and Pearland Town Center. Residents can enjoy upcoming resort-style amenities including pools, amenities center and more! Schedule a showing today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 22 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7172' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042236' WHERE `Matrix_Unique_ID` = '208227225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '41029012' ,`ListAgentFullName` = 'Amy Larner' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.144856' ,`Longitude` = '-95.049312' ,`PhotoCount` = '43' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Frio' ,`StreetNumber` = '21812' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1881' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This nicely updated 4 bedroom 3.5 bath home features floor to ceiling windows, skylights, and fireplace. As you enter the home, you step down into the open concept family room surrounded by natural light. You have an open concept kitchen/dining area that overlooks the new deck. There are two bedrooms each with access to a private balcony, and full bath on the main level. The primary suite is located on the second floor. You have two walk in closets, and a private balcony perfect for catching Galveston\'s famous West Bay Sunsets. The forth bedroom has private access with its own en-suite. The lower level was designed with entertaining in mind. Hang out at your own tiki-bar! Enjoy fishing off your private dock, or lower your boat in the water, and head out to the bay. Amenities include a pool, fishing pier, tennis/pickle ball courts, boat launch & restaurant. The beach is just a short golf cart ride away! Island life is calling!' ,`Acres` = '0.1421' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 15 LOT 1655 SEA ISLE 11TH EXTENSION' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 11' ,`TaxAmount` = '12267' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042236' WHERE `Matrix_Unique_ID` = '208260231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '25108659' ,`ListAgentFullName` = 'Armando Espinosa Jr' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797777' ,`Longitude` = '-95.384671' ,`PhotoCount` = '29' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '544000.00' ,`Status` = 'Active' ,`StreetName` = 'Michaux' ,`StreetNumber` = '4617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE! Beautifully remodeled bungalow in the Norhill Historic District! From the perfectly updated front porch to the designer finishes, this home has been thoughtfully redesigned with today\'s buyer and trends in mind. The newly crafted open floorplan allows for an easy flow from one room to the next with generous space in each living area. The living room is light & bright with the plenty of room for oversized furniture & guests. The updated kitchen includes a stainless steel stove, rows of counter space and ample storage with plenty of room for multiple cooks. The dining area includes a gorgeous hanging lamp to showcase the best of meals & marvelous full paned French Doors overlooking the backyard. Both bedrooms are equally delightful and the fully remodeled bath is extraordinary with it\'s oversized tiled shower and designer touches. Don\'t miss the designer flooring throughout the house! Step outside onto the oversized back patio and lush lawn, ready for summer parties!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 115 NORTH NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Norhill' ,`TaxAmount` = '8522' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042237' WHERE `Matrix_Unique_ID` = '208327912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:06.037' ,`MLSNumber` = '56988995' ,`ListAgentFullName` = 'Ronald Clary' ,`ListOfficeName` = 'Prescott Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243438' ,`Longitude` = '-95.890398' ,`PhotoCount` = '50' ,`PostalCode` = '77484' ,`RoomCount` = '5' ,`ListPrice` = '639900.00' ,`Status` = 'Active' ,`StreetName` = 'Derby' ,`StreetNumber` = '17753' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS TRANQUIL- 4 BEDROOM 2 AND A HALF BATHROOM TRADITIONAL HOME IS ON 1.50 ACRES WITH A BEAUTIFUL WOODED AREA IN THE BACKYARD WITH A STONE PATIIO AND A ROCK TRAIL PATH THROUGH THE WOODS FOR A QUITE STROLL AND PRIVACY. THIS BEAUTIFUL TRADITIONAL HOME HAS A LARGE KITCHEN WITH GRANITE COUNTER TOPS AND A OVESIZED ISLAND, IT OPENS UP TO THE LIVING ROOM WITH A GRAND STONE FIRE PLACE, THAT YOU CAN USE AS WOOD BURNING OR GAS AND ALSO OPENS UP TO THE FORMAL DINING ROOM WITH A BEAUTIFUL CRYSTAL CHANDALIER FOR ALL YOUR ENTERTAINMENT NEEDS. ALSO HAS LARGE LAUNDRY ROOM WITH SINK. PRIMARY BATHROOM HAS DOUBLE SINKS AND LARGE SHOWER.' ,`Acres` = '1.5' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S7644 - SADDLE CREEK FOREST SEC. 4, BLOCK 4, LOT 6, ACRES 1.' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '65340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Saddle Creek Forest Sec 4' ,`TaxAmount` = '6873' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042237' WHERE `Matrix_Unique_ID` = '208969269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '92109269' ,`ListAgentFullName` = 'Sonia Trevino' ,`ListOfficeName` = 'Houston Homes Legacy Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709342' ,`Longitude` = '-95.379307' ,`PhotoCount` = '47' ,`PostalCode` = '77021' ,`RoomCount` = '6' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Charleston' ,`StreetNumber` = '2440' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2440 Charleston St Unit C. An inner city home for sale near Houston Medical Center with a quiet neighborhood feel. This gated community is conveniently located with easy access to the Texas Medical Center, Houston Zoo, and Hermann Park! Great floorplan, well maintained, high-end finishes, modern interior, quality constructed home! This amazing home offers high ceilings, kitchen open to family room and plenty of natural light throughout. Call today to request a private tour' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 CHARLESTON CREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1875' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Crest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042237' WHERE `Matrix_Unique_ID` = '209273194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '33190253' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405771' ,`Longitude` = '-95.508276' ,`PhotoCount` = '50' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Winged Elm' ,`StreetNumber` = '155' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Thornleigh combines easy elegance with the streamlined versatility to adapt to your family’s lifestyle changes through the years. Escape to the everyday vacation of your Owner’s Retreat, which includes a delightful bathroom and a deluxe walk-in closet. Your open-concept living space awaits your interior design style to create the ultimate atmosphere for special occasions and daily life. The streamlined kitchen is optimized to support solo chefs and family cooking adventures. Unique decorative flair and growing minds are equally at home in the lovely spare bedrooms. Craft the perfect specialty rooms for you and yours in the incredible downstairs sunlit study and the cheerful upstairs retreat. Experience the benefits of living in an award winning urban planned development of The Woodlands Hills with miles of hiking and biking trails. Resort style amenities include adult lap pool, full size gym, splash pad and lazy river. Home is situated on oversize corner cul-de-sac homesite.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042237' WHERE `Matrix_Unique_ID` = '209602766' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:05.177' ,`MLSNumber` = '18335068' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Natalie Tye' ,`SellingOfficeName` = 'Monarch Real Estate & Ranch' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '367990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bradford' ,`StreetNumber` = '6702' ,`StreetSuffix` = 'Terrace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Ranch Home on Large Cul De Sac Lot by D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco W/Brick Elevation! Gorgeous Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Quartz Countertops, Tile Back-splash, Large Eat-in Working Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Room with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with His & Her Sink Smooth Top Vanity, Massive Shower & Walk-in Closet! Energy Efficient Home: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 87 /Block: 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042237' WHERE `Matrix_Unique_ID` = '209632402' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:05.100' ,`MLSNumber` = '12514546' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701848' ,`Longitude` = '-95.706490' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '338990.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '6810' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home under Construction - This Harris! Stunning Entry! This lovely home you are greeted with High Ceilings, extended hallway and Beautiful Carefree Vinyl Plank Wood Flooring throughout! Luxurious Carpeting in all bedrooms! Two Full Baths plus Half Bath! The Family Room features Walls of Windows projecting abundance of natural light inside! Your Casual Dining area flows gracefully into your Gourmet Kitchen which features Quartz Counters, lots of Tall Shaker Cabinets for storage space, Stainless Appliances, Large Eat-in & Working Island with Under-mount Stainless Sink & more! Private Owner\'s Suite features Luxurious bathroom Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 18 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042237' WHERE `Matrix_Unique_ID` = '209646887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:05.053' ,`MLSNumber` = '57198017' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701865' ,`Longitude` = '-95.706406' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '338990.00' ,`Status` = 'Active' ,`StreetName` = 'Fleetwood Crescent' ,`StreetNumber` = '7011' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move In Ready New Home -Grant Plan by D.R. Horton has everything you could ever want in a home! Amazing Elevation! This open floor plan features an abundance of natural light inside, high ceilings, Upgraded Vinyl Plank Flooring throughout, Tile in all wet areas & Plush Carpeting in all bedrooms! Your Casual Dining area & Family Room flows gracefully into the Gourmet Kitchen w/Upgraded Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in & Working Island w/Undermount Stainless Sink, Stainless Steel Appliances, Tall Shaker Cabinets, Walk In Pantry & more! The Owner\'s Suite features Tall Ceilings, Luxurious Bath w/Dual Sink Vanity, Separate Shower, Deep Soaker Tub & Walk-in Closet! HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & more! Outstanding Smart Home Automation System allowing you to control your home from anywhere, Lights, Thermostat & more! Covered Rear Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more! 20 minutes to The Galleria! More!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 3 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042238' WHERE `Matrix_Unique_ID` = '209682375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.960' ,`MLSNumber` = '69632588' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701869' ,`Longitude` = '-95.706565' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '331990.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '7011' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction-The Caden Plan by D.R. Horton! Dramatic Chic Elevation! Lovely Backyard Lake View! Upon Entry of this lovely 3 Bedroom 2 Full Bathroom home w/ Upgraded Luxurious Wood Vinyl Plank Flooring which leads into the Casual Dining Room & the Gourmet Kitchen with Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Working Island w/Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets, Subway Tile Glass Backsplash & more! Amazing Family Room w/Wall of Windows overlooking Covered Patio! The Private Owner\'s Suite with Luxurious Bath featuring Dual Sink Vanity, Huge Separate Shower, Deep Soaker Tub & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allowing you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & more from anywhere!! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 101 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042238' WHERE `Matrix_Unique_ID` = '209705981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.867' ,`MLSNumber` = '80231873' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701869' ,`Longitude` = '-95.706565' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '318990.00' ,`Status` = 'Active' ,`StreetName` = 'Fleetwood Crescent' ,`StreetNumber` = '7015' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction-The Caden Plan by D.R. Horton! Dramatic Chic Elevation! Upon Entry of this lovely 3 Bedroom 2 Full Bathroom home you are greeted with Upgraded Luxurious Wood Vinyl Plank Flooring which leads the path into the Casual Dining Room & the Gourmet Kitchen with Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Working Island w/Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets, Subway Tile Glass Backsplash & more! Amazing Family Room w/Wall of Windows overlooking Covered Patio! The Private Owner\'s Suite with Luxurious Bath featuring Dual Sink Vanity, Huge Separate Shower, Deep Soaker Tub & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allowing you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & more from anywhere!! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 2 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042238' WHERE `Matrix_Unique_ID` = '209707700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.803' ,`MLSNumber` = '60275642' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701850' ,`Longitude` = '-95.706387' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Bradford' ,`StreetNumber` = '6822' ,`StreetSuffix` = 'Terrace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! The Easton by D.R.Horton has so much to offer! Upon entering your home, you are greeted with High Ceilings, Extended Foyer & Upgraded Vinyl Wood Plank Flooring that leads the way into your Casual Dining Room & Amazing Family Room with Wall of Windows overlooking your Covered Rear Patio! Family Room flows gracefully into the Casual Dining & Gourmet Kitchen with Upgraded Quartz Counters, Tile Back-splash, Large Eat-in & Working Island w/Under-mount Stainless Sink, Stainless Steel Appliances, Tall Beautiful Shaker Cabinets & Walk In Spacious Pantry! The Owner\'s Suite features Plush Carpeting & Luxurious Bath w/Dual Sink Vanity, Oversized Shower & Walk-in Closet! 3 Secondary Bedrooms & 1 Full Bath! Energy Efficient Home Rated HERS Energy, Tankless/On-Demand H2O Heater! \"Smart Home Automation allows you to control lighting, deadbolt locks, thermostat & Control from anywhere! NO FLOODING! Wonderful Amenities! Just 20mins to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 75 / Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042238' WHERE `Matrix_Unique_ID` = '209725181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.740' ,`MLSNumber` = '87309282' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702047' ,`Longitude` = '-95.706261' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '318990.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '7023' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes under Construction! This beautiful Chic one story home features High Ceilings, Gorgeous Vinyl Wood Plank Floors throughout, Tile in all Bathrooms, Laundry Room & Plush Carpeting in Bedrooms! Amazing Open Floor Plan w/Huge Family Room that Opens into the Gourmet Kitchen w/Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Island w/Under-mount Stainless Sink, Stainless Steel Appliances, Tall Shaker Cabinets & more! The Private Primary Suite has a Luxurious Bathroom featuring His & Her Sink Vanity, \"Massive\" Shower with Tile Surroundings(room for 2) & Walk-in Closet! 2 Guest Bedrooms & Full Bathrooms! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Rinnai Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING ! Amenities include: Pool, Splash Pad & More! No Flooding! Make that call' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 104 /Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042238' WHERE `Matrix_Unique_ID` = '209732346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.677' ,`MLSNumber` = '88733042' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702043' ,`Longitude` = '-95.706274' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '322990.00' ,`Status` = 'Active' ,`StreetName` = 'Bradford' ,`StreetNumber` = '6818' ,`StreetSuffix` = 'Terrace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New One story Ranch Style home-The Foster by D.R. Horton! Grand Entry with Beautiful Vinyl Wood Large Plank Flooring throughout the high traffic areas, Tile in all Wet Areas & Luxurious Carpeting in Bedrooms! The Casual Dining Room & Family Room flows gracefully into the Gourmet Kitchen! Gourmet Kitchen is a Chef\'s dream with Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Working Island with Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets & more! The Primary Private Suite with Luxurious Bathroom/Spa featuring Double Sink Vanity, Massive Shower with Seamless Glass Door, Walk-in Closet! 3 Secondary Bedrooms & 1 Full Bath! Covered Patio! LOW Utility Cost with the outstanding Energy Features including: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home Automation\" Control your home from anywhere w/Echo & Dot! NO FLOODING! Amenities include: Pool, & Splash Pad! Just 20 minutes to The Galleria' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 76/ Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042239' WHERE `Matrix_Unique_ID` = '209745274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.617' ,`MLSNumber` = '95451201' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '33' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '295990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14807' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes! Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story Ranch home features Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Amazing Open Floor Plan Features Huge Family Area that Flows into the Gourmet Kitchen With Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Beautiful Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio & Large Backyard! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING! Low, Low Tax Rates!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 34 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042239' WHERE `Matrix_Unique_ID` = '210306412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.570' ,`MLSNumber` = '42171712' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '317990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14811' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home Ready! Best Schools! The Harris! Chic Stucco & Brick Elevation, Covered Patio, Large Backyard & Sprinkler System! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! 2 Full Baths & a Half Guest Bathroom! Huge Family Rm features Walls of Windows projecting abundance of natural light inside! Casual Dining flows gracefully into your Gourmet Kitchen features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Stainless Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom with His & Her Undermount Sinks Vanity W/Cultured Marble Counters, deep Soaker Tub, Large Seamless Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 33 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042239' WHERE `Matrix_Unique_ID` = '210326509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.507' ,`MLSNumber` = '54737527' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '23' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '6807' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The 1 Story The Gaven Plan by D.R.Horton Under Construction! Ultra Modern & Chic Elevation! Outstanding Floor Plan with so much to offer! Beautiful Upgraded Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining as your Gourmet Kitchen with Stunning Quartz Countertops, Tile Back-splash, Large Eat-in Working Island w/Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Rm with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 w/His & Her Sink Vanity, Massive Shower W/Seamless Glass Door & Walk-in Closet! Energy Efficient Home: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home System, which allows you to control lights, locks, & thermostat! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 16 /Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042239' WHERE `Matrix_Unique_ID` = '210370540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.430' ,`MLSNumber` = '10435104' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701865' ,`Longitude` = '-95.706406' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '333990.00' ,`Status` = 'Active' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '7003' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The New Construction-Grant Plan by D.R.Horton! This Dramatic open floor plan features an abundance of natural light inside, high ceilings, Upgraded Vinyl Plank Flooring throughout, Tile in all wet areas and Plush Carpeting in all bedrooms! Your Casual Dining area & Family Room flows gracefully into the Gourmet Kitchen w/Upgraded Quartz Counters, Tile Back-splash, Large Eat-in & Working Island w/Under-mount Stainless Sink & plenty of room for extra seating if needed, Stainless Steel Appliances, Tall Shaker Cabinets & more! The Private Owner\'s Suite with High Ceilings, Sleek Ceiling Fan, Luxurious Bath W/Double Undermount Sinks Cultural Vanity, Massive (room for 2) Seamless Glass Shower & Walk-in Closet! HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & more! Outstanding Smart Home Automation System allowing you to control your home from anywhere, Lights, Thermostat & more! Covered Rear Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more! 20 minutes to Galleria' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 30/Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042239' WHERE `Matrix_Unique_ID` = '210373372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.333' ,`MLSNumber` = '76919232' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '23' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '365990.00' ,`Status` = 'Active' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Under Construction! Ultra Modern & Chic Elevation! Gorgeous Upgraded Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Quartz Countertops, Tile Back-splash, Large Eat-in Working Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Rm with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with His & Her Sink Vanity, Deep Soaker Tub, Shower W/Seamless Glass Door & Walk-in Closet! Energy Efficient Home: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 2 /Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042239' WHERE `Matrix_Unique_ID` = '210375191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '76047741' ,`ListAgentFullName` = 'Malik Riles' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.413144' ,`Longitude` = '-95.009623' ,`PhotoCount` = '29' ,`PostalCode` = '77591' ,`RoomCount` = '10' ,`ListPrice` = '269500.00' ,`Status` = 'Active' ,`StreetName` = 'Voyager' ,`StreetNumber` = '8923' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 8923 Voyager Drive! This home was built to maximize connectivity without sacrificing functionality. The open concept allows you to cook, entertain, and interact with everyone from the kitchen to the family room. The office in the front of the home features double doors that are great for a little privacy. Your primary suite has spectacular windows, a double vanity, and a large walk-in closet. The backyard is incredibly roomy. It features an extended patio that is perfect for entertaining your guests and a dog run to keep your puppies from free ranging throughout your yard. Truly the ideal home for any buyer!' ,`Acres` = '0.1503' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 MARLOW LAKE SEC 1B (2019) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6548' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Final Plat/Marlow Lake Sec 1b' ,`TaxAmount` = '7645' ,`TaxRate` = '3.3628' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042240' WHERE `Matrix_Unique_ID` = '210398695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '27315880' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.404658' ,`Longitude` = '-95.057978' ,`PhotoCount` = '23' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Anchor Bay' ,`StreetNumber` = '13206' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Madison plan was a model home and is a two-story home featuring 5 bedrooms; one located downstairs, 3 baths, and 3 car garage. The gourmet kitchen includes silestone counter tops, stainless steel appliances, and open concept floorplan with the kitchen opening to the dining room and family room. The upstairs primary suite features an attractive primary bath and large walk-in closet. The upstairs loft is built standard and are perfect for entertaining. The rear covered patio is located off the family room and secondary bedroom. Come see the amazing 12-acre Lago Mar crystal clear lagoon that is the largest in Texas and a unique staycation destination. The lagoon features multiple beaches, a floating obstacle course, a swim-up bar, a 10,000-square-foot beach club with cabana pool and so much more. Swim, paddle, play and then end the day with drinks and dinner on our beautiful Breezeway Boardwalk. *Representational photos only, finishes may vary*' ,`Acres` = '0.1578' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 47 BLK 1 LAGO MAR POD 4 SEC 3 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6917' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 4 Sec 3' ,`TaxAmount` = '8290' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042240' WHERE `Matrix_Unique_ID` = '210638414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:04.070' ,`MLSNumber` = '82322313' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435496' ,`Longitude` = '-95.441360' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1235' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'POPULAR TWO-STORY with 2 BEDROOMS DOWN featuring 4 spacious bedrooms, 3 bathrooms, game room, a covered patio, 2-car garage is for sale in Sierra Vista. Built by D.R Horton, the OZARK floor plan features an open concept living and dining space w/ spacious rooms. Granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher are included in the kitchen. The Primary bathroom has dual sinks, soaking tub and/or oversized shower and a large walk-in closet! Smart tech features, brick on all four sides, vinyl flooring, & tankless water heater- ALL COME STANDARD in this community! Conveniently located off of Hwy 288, Sierra Vista offers easy access to downtown, med center and Pearland Town Center. Residents can enjoy upcoming resort-style amenities including pools, amenities center and more! Schedule a showing today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7172' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042240' WHERE `Matrix_Unique_ID` = '211400987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '43496930' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856993' ,`Longitude` = '-95.776676' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '391555.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5727' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stratford offers the following features: Granite countertops at Kitchen and baths, 42\" Graphite Kitchen Cabinets, Stainless Steel Appliances that include Whirlpool 5 burner gas range, microwave oven that is vented outside and dishwasher, 6\"x24\" wood tile throughout except for bedrooms,Stairs and gameroom, 2\" Blinds, Elongated toilets, tankless water heater, Mahogany front door, Garage Door Opener, Covered Patio that includes gas stub out, and TV outlet, freezer plug at garage, full sod front and back, Sprinkler System, Front gutters, Home automation powered by Google, and much more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5160' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042240' WHERE `Matrix_Unique_ID` = '211530165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '64013963' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855653' ,`Longitude` = '-95.775646' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '325950.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Vista' ,`StreetNumber` = '5714' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With over 1,500 square feet, the Barton boasts abundant space for private living and entertaining. This plan welcomes you with a charming front porch, leading you into a welcoming foyer. Beyond the foyer, you\'ll love an open-concept living area that features an inviting kitchen—boasting a center island and wide pantry—an elegant dining area, and a spacious great room. Additional main-floor highlights include an Owner\'s Entry off the 2-bay garage and a covered patio off the dining area. Elevation: D5 Interior Color Package: 3 Exterior Color Scheme: Brick - Denali + Stone - Blanco Chopped Structural Options: Rear Covered Patio, 3 Sides Brick 1st Fl, Separate Tub&Shower Lot Specifics: Close to Amenities' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042240' WHERE `Matrix_Unique_ID` = '211539928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '46358094' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856742' ,`Longitude` = '-95.775699' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '308807.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5742' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Navarro plan is efficiently designed for your convenience and comfort. Upon entering this single-story home, you\'ll find a generous family room, flowing into an open-concept dining area and well-appointed kitchen. Additional highlights include two secondary bedrooms—sharing a full hall bath—and a spacious primary bedroom with a walk-in closet and en-suite bath, home features a covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5058' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042241' WHERE `Matrix_Unique_ID` = '211540029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '79789526' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855951' ,`Longitude` = '-95.775989' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '331265.00' ,`Status` = 'Active' ,`StreetName` = 'Undertaken Path' ,`StreetNumber` = '23022' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Navarro plan is efficiently designed for your convenience and comfort. Upon entering this single-story home, you\'ll find a generous family room, flowing into an open-concept dining area and well-appointed kitchen. Additional highlights include two secondary bedrooms—sharing a full hall bath—and a spacious primary bedroom with a walk-in closet and en-suite bath home features a covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5058' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042241' WHERE `Matrix_Unique_ID` = '211540156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '9624518' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856100' ,`Longitude` = '-95.775646' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '288932.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5630' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offering comfort and livability, the Huxley maximizes space in every room to best suit your needs. This single-story floor plan is anchored by a spacious open-concept living room, adjacent to a well-appointed kitchen and dining area. Secluded at the back of the home, the primary suite boasts a walk-in-closet and attached bath. And toward the front of the home, two secondary bedrooms share access to a full hall bath. Options may include a kitchen island and double sinks in the primary bath.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042241' WHERE `Matrix_Unique_ID` = '211540996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '23081956' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855013' ,`Longitude` = '-95.776783' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '273885.00' ,`Status` = 'Active' ,`StreetName` = 'True Fortune' ,`StreetNumber` = '23114' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With 1205 square feet, the Huxley includes the following features: 3 sides brick, granite countertops at Kitchen and baths, 42\" Light Gray Kitchen Cabinets, Stainless Steel Appliances that include Whirlpool 5 burner gas range, microwave oven that is vented outside and dishwasher, 13\"x13\" Tile throughout except for bedrooms, 2\" Blinds, Elongated toilets, tankless water heater, Mahogany Full Lite front door, Garage Door Opener, Covered Patio, full sod front and back, Sprinkler System, Front gutters, Home automation powered by Google, and more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5199' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042241' WHERE `Matrix_Unique_ID` = '211541564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.990' ,`MLSNumber` = '57313895' ,`ListAgentFullName` = 'Yasmin Ramsey' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.135995' ,`Longitude` = '-95.049421' ,`PhotoCount` = '31' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '798000.00' ,`Status` = 'Active' ,`StreetName` = 'Palapa' ,`StreetNumber` = '4310' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1739' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the opportunity you were waiting for, this is a great potential income property ready to lease, or it could be your dream vacation or residential home with beach views. New construction home move in ready, completely furnished and decorating by professional interior designer. This home has so much to offer, and not detail was overlooked:2 large primary bedrooms with private decks, & baths, 2 spacious secondary bedrooms. Primary master bath has floor to ceiling tile, huge shower, and dual vanities. Beautiful kitchen equipped with stainless steel appliances, quartz counter tops, plenty storage spaces and breakfast island. Refrigerator, washer-dryer included. This home also features open concept living-dining area, blinds, tile flooring throughout, outdoor shower, storage, and completely fence. Conveniently located, beach access, few minutes walking to beach, grocery, restaurants, golf carts rentals. Community offers swimming pool, fishing pier, tennis court, park and pavilion' ,`Acres` = '0.0948' ,`Area` = '33' ,`BuilderName` = 'GalvestonBeach House' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEA ISLE SEC 24 (2006), ABST 121, BLOCK 3, LOT 11, ACRES 0.0' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '4128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '231' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Sec 24 2006,' ,`TaxAmount` = '646' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666042241' WHERE `Matrix_Unique_ID` = '211615233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '25237303' ,`ListAgentFullName` = 'Jason Gutierrez' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = 'Jauhar Mahmood' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.550646' ,`Longitude` = '-95.340429' ,`PhotoCount` = '26' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cloverfield' ,`StreetNumber` = '2611' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bedroom, 2 bathroom house has a new driveway that leads up to a freshly painted exterior. Inside you will find many new updates including both bathrooms, new tile through the house, and freshly painted walls. Pearland ISD. Book your appointment today.' ,`Acres` = '0.2112' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHWYCK, BLOCK 4, LOT 19 SEC 1-REPLAT, A0242 HT&BRR' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwyck' ,`TaxAmount` = '5253' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042242' WHERE `Matrix_Unique_ID` = '211671388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.930' ,`MLSNumber` = '20838647' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820263' ,`Longitude` = '-94.818848' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '13' ,`ListPrice` = '353990.00' ,`Status` = 'Active' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14911' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell Plan by D.R. Horton! New 2 Story Home! Outstanding Schools! Ready for Move In! Grand 2 Story Entry! Private Owner\'s Suite W/Luxurious Bathroom & Guest Suite with Full Bathroom Downstairs! Beautiful Vinyl Wood Like Carefree Flooring Throughout! Casual Dining & Amazing Family Room that flows gracefully into the Gourmet Kitchen W/Upgraded Quartz Counters, Tile Back-splash, Large Eat-in Working Island, Deep Under-mount Stainless Sink, Tall gorgeous Grey Cabinets & more! The Private Owner\'s Suite features High Ceilings, Luxurious Bath W/Cultured Marble Vanity, Deep Undermount Dual Sinks, Deep Soaker Tub, Separate Shower & Walk-in Closet! Upstairs discover a Game Room, 2 Secondary Bedrooms & 1 Full Bath W/Cultural Marble Vanity with Undermount Sink! Covered Patio, Sprinkler System! HERS Energy Rated, Tankless Gas Water Heater & \"Smart Home Automation System W/Amazon Echo allowing you to control your home for anywhere! NO FLOODING! LOW TAXES!! Not in Flood Zone at this time!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 RAINTREE SEC 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6620' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042242' WHERE `Matrix_Unique_ID` = '211682420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '2618428' ,`ListAgentFullName` = 'Natalie Glass' ,`ListOfficeName` = 'Natalie Glass Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.725443' ,`Longitude` = '-95.591502' ,`PhotoCount` = '24' ,`PostalCode` = '77082' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Oaks Run Drive' ,`StreetNumber` = '12014' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2247' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offer accepted Waiting for final signatures. Jefferson Plan. First floor features family room, dining room with dual sliders leading to fenced yard with turf and fountain, and island kitchen with large walk in pantry. Second floor offers 2 secondary bedrooms with full bath, laundry room, and luxurious primary suite with oversized shower with bench, two closets and separate vanities. Super convenient Westchase location is just 20 minutes from the Texas Medical Center and 10 minutes from the Galleria Area and Energy Corridor. Close-in location in a brand new, small gated community with a community pool, restrooms and central greenspace!' ,`Acres` = '' ,`Area` = '31' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1 Royal Oaks Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3030' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042242' WHERE `Matrix_Unique_ID` = '212215035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:26:06.753' ,`MLSNumber` = '4502177' ,`ListAgentFullName` = 'Shanni Lo' ,`ListOfficeName` = 'Shanni Lo' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780087' ,`Longitude` = '-95.585706' ,`PhotoCount` = '41' ,`PostalCode` = '77079' ,`RoomCount` = '10' ,`ListPrice` = '939800.00' ,`Status` = 'Active' ,`StreetName` = 'Forest' ,`StreetNumber` = '850' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A one story,4 bedrooms,2.5 baths w/ a study and a game room located in the sought after neighborhood of Nottingham.Open floorplan features formal dining room, living room,and kitchen w/ breakfast room.Flex room is tucked away next to the formal dining room for a wine room, bar, or an additional home office.Oversized game room showcases walls of windows and provides additional entertaining space.Primary suit is located at the end of the hallway with a huge walk-in closet and double sinks in the primary bath.This home has 3 spacious secondary bedrooms plus an office.Enjoy the privacy of your backyard with NO back neighbors and access the open field using the back gate.Numerous upgrades and improvements:such as 2022 roof and siding, some updated plumbing/electrical,freshly painted interior/exterior,just to name a few.Memorial West Community Club membership is included w/pools,3 tennis courts,clubhouse,and playground.Zoned to exemplary schools in Spring Branch ISD.Per Seller:did not flood' ,`Acres` = '0.2204' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 15 NOTTINGHAM SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WILCHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nottingham Sec 02' ,`TaxAmount` = '17876' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042242' WHERE `Matrix_Unique_ID` = '212230484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.837' ,`MLSNumber` = '70157257' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.429425' ,`Longitude` = '-95.457689' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Kings River' ,`StreetNumber` = '10622' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**ONE STORY NEW CONSTRUCTION ** Cali Plan features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes granite countertops, 42\" cabinets, and stainless & steel appliances. Retreat in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes), and a large walk-in closet! Located in Houston’s newest D.R. Horton Community known as Sierra Vista that ideally located off of Hwy 288 and near the upcoming Manvel Town Center! Schedule a showing to see this home in person or visit the onsite sales office today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042242' WHERE `Matrix_Unique_ID` = '212307145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.727' ,`MLSNumber` = '3385382' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.429425' ,`Longitude` = '-95.457689' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '311990.00' ,`Status` = 'Active' ,`StreetName` = 'Kings River' ,`StreetNumber` = '10626' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**ONE-STORY HOME*** Easton Plan features 4 bedrooms, 2 full baths, oversized patio and 2 car garage. Kitchen includes breakfast bar with beautiful granite countertops and stainless steel appliances. Open concept floorplan boasts large family room and separate dining/breakfast area. Two additional bedrooms and baths are situated just off the common living area. Private primary suite with attractive primary bath features dual vanities and walk-in closet. The standard rear covered patio is located off the family room. Located in Houston’s newest D.R. Horton Community known as Sierra Vista that ideally located off of Hwy 288 and near the upcoming Manvel Town Center! Schedule a showing to see this home in person!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042243' WHERE `Matrix_Unique_ID` = '212307468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.663' ,`MLSNumber` = '38862122' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Gayla Gayden' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '36' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '315990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '626' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home Ready! Best Schools! Dramatic Chic Stucco & Brick Elevation! Sprinkler System! Huge Backyard & Covered Patio! Dramatic Entry W/High Ceilings! Luxury Vinyl Wood Flooring! 2 Full Baths & a Half Guest Bathroom! Large Family Rm features Walls of Windows projecting abundance of natural light inside! Casual Dining flows gracefully into your Gourmet Kitchen features Beautiful Quartz Counters, White Tall Gorgeous Shaker Cabinets, Stainless Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity W/Cultured Marble Counters, Deep Soaker Tub, Large Seamless Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '0.15' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 21 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6663' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042243' WHERE `Matrix_Unique_ID` = '212369831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.617' ,`MLSNumber` = '49549562' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '315990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweetwater' ,`StreetNumber` = '14502' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Ready for move in! Ultra Modern & Chic Elevation! Sprinkler System! Stunning Entry W/High Ceilings! Gorgeous Carefree Luxury Vinyl Wood Flooring! Huge Family Room features Walls of Windows projecting abundance of natural light inside & Looks out to your Huge Backyard & Covered Patio! Casual Dining flows gracefully into Gourmet Kitchen W/Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom with His & Her Undermount Sinks Vanity W/Cultured Marble Counters, Deep Soaker Tub, Large Glass Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time' ,`Acres` = '0.19' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 13 /Block: 5' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8134' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042243' WHERE `Matrix_Unique_ID` = '212371334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.523' ,`MLSNumber` = '54701053' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482459' ,`Longitude` = '-95.415496' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '331990.00' ,`Status` = 'Active' ,`StreetName` = 'Kings River' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to D.R. Horton\'s one-story Kingston Plan! This model home plan features 4 bedrooms, 2 baths, an oversized covered patio and 2 car garage. The Kitchen is a chef\'s dream with a LARGE breakfast bar, ample cabinets, beautiful GRANITE counter tops and stainless steel appliances. The open concept floorplan boasts a large family room and separate dining/breakfast area. Two additional bedrooms and baths are situated just off the common living area. The primary suite is equally spacious and overlooks the backyard. The ensuite primary bath features dual vanities, an oversized shower, and a large walk-in closet. The standard rear-covered patio is located off the family room. Located in Houston’s newest D.R. Horton Community known as Sierra Vista. Schedule a showing to learn more!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sierra Vista Lot 19 Block 03 Section 04' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7183' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042243' WHERE `Matrix_Unique_ID` = '212375261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.460' ,`MLSNumber` = '66458844' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '29' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14826' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning One Story Home By D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco & Brick Elevation! Stunning Entry W/High Ceilings! Luxury Vinyl Wood Flooring! Dramatic Family Rm features Walls of Windows for natural lightning & Looks out to your Huge Backyard & Covered Patio! Sprinkler System! Casual Dining flows into Gourmet Kitchen that Features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity, Deep Soaker Tub, Large Glass Shower & Huge Walk-in Closet. 2 Inches Blinds! Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time! Outstanding Schools for all Ages! More' ,`Acres` = '0.18' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 7 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7804' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042243' WHERE `Matrix_Unique_ID` = '212464255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.413' ,`MLSNumber` = '2660302' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '36' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '304990.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Ready for Move In! Dramatic Chic Elevation W/Stucco & Brick! Covered Patio & Sprinkler System! Stunning Entry W/Gorgeous Luxurious Wood Vinyl Floors leading the path into the Huge Family & Casual Dining Area! Gourmet Kitchen Boast Gorgeous Quartz Countertops, Tile Back-splash, Large Eat-in Working Island w/Undermount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Stunning Tall Shaker Cabinets! Gourmet Kitchen open to the Amazing Family Rm W/High Ceilings & Wall of Windows overlooking Huge Backyard! Private Owner\'s Suite W/Luxurious Bath featuring Huge Vanity W/Cultural Marble Counters, Deep Undermount Sinks, Massive Shower & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allows you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & almost from anywhere!! 2 Inches White Blinds! NO FLOODING! LOW PROPERTY TAXES, OUTSTANDING SCHOOLS & MORE!' ,`Acres` = '0.16' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 18 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6821' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042244' WHERE `Matrix_Unique_ID` = '212465677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '41383557' ,`ListAgentFullName` = 'LaToya Freeman' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.413222' ,`Longitude` = '-95.005916' ,`PhotoCount` = '42' ,`PostalCode` = '77591' ,`RoomCount` = '4' ,`ListPrice` = '274999.00' ,`Status` = 'Active' ,`StreetName` = 'Explorer' ,`StreetNumber` = '3301' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Now presenting 3301 Explorer Drive!!!\r\n\r\nThis beautiful 4 bedroom/2 bathroom home is located in Marlow Lake. The opeen concept flow is perfect for entertaining. Rooms are sizeable. Conveniently access I-45 from HWY 3, which makes your commute fast and easy for work and all of your shopping needs. Zoned to Dickinson ISD. Low HOA fee. Schedule your appointment today!!!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 25 MARLOW LAKE SEC 2 (2020) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marlow Lk-Sec 2' ,`TaxAmount` = '1739' ,`TaxRate` = '3.3628' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042244' WHERE `Matrix_Unique_ID` = '212598964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.350' ,`MLSNumber` = '17712400' ,`ListAgentFullName` = 'William Horn' ,`ListOfficeName` = 'Divvy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.907833' ,`Longitude` = '-95.462061' ,`PhotoCount` = '31' ,`PostalCode` = '77038' ,`RoomCount` = '10' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Audubon Hill' ,`StreetNumber` = '12007' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING opportunity to own this beautifully maintained 3-bedroom 2.5 bath cul-de-sac home in Willow Springs! The 1st floor features all laminate flooring, a huge eat-in kitchen with brand-new stainless-steel appliances, fireplace and dedicated office space, perfect for working from home. Upstairs you will find all 3 bedrooms, a convenient laundry area and a very spacious 2nd living area or game room. The home has been recently updated with brand new carpet, ceiling fans, light fixtures, plumbing fixtures and beautiful custom paint! The seller has taken care of everything! All you have to do is move in and enjoy!' ,`Acres` = '0.0799' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 WILLOW SPRINGS SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '3479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARTER ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Springs' ,`TaxAmount` = '5548' ,`TaxRate` = '3.4553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042244' WHERE `Matrix_Unique_ID` = '212632346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:29:30.970' ,`MLSNumber` = '16392804' ,`ListAgentFullName` = 'Kadijah Cohen' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.184400' ,`Longitude` = '-95.799728' ,`PhotoCount` = '20' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '271000.00' ,`Status` = 'Active' ,`StreetName` = 'Raphael' ,`StreetNumber` = '26229' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING AND SPACIOUS NEW HOME This two-story home features an open floor plan with three bedrooms two full bathrooms plus a powder bath. The chef-ready kitchen includes a full suite of appliances by Whirlpool, including a built-in microwave, granite counter-tops and espresso-stained wood cabinets topped with crown molding. Windows in the spacious family room and dining room overlook the back patio and fenced back yard with no backyard neighbors. Owners will enjoy the luxuriously large owner’s suite upstairs with two walk-in closets and a spa-like bathroom with step-in shower, soaker tub, spacious vanity and linen storage. The two secondary bedrooms are generously sized and include desirable closet space, providing plenty of room for your family, work and hobbies. Tour this home and the incredible Williams Trace community today! (Location, Location, Location!)' ,`Acres` = '0.1145' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S955202 - WILLIAMS TRACE 02, BLOCK 1, LOT 77' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace 02' ,`TaxAmount` = '382' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042244' WHERE `Matrix_Unique_ID` = '212746407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:48:17.480' ,`MLSNumber` = '59384370' ,`ListAgentFullName` = 'Crystal Krivacka' ,`ListOfficeName` = 'Fife Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162375' ,`Longitude` = '-96.016794' ,`PhotoCount` = '47' ,`PostalCode` = '77445' ,`RoomCount` = '9' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Shannon' ,`StreetNumber` = '24549' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ADDITIONAL LOT NEXT DOOR AVAILABLE for $45,000. S75500 Rolling Hills 5, Block 6, Lot N 90’ 6 Acres .4\r\n\r\nBeautiful Home! Large rooms, Master Bedroom is located on the other side of the house from the other two bedrooms. The room used as an office and also be used as a 3rd bedroom. Living Room is large with a cozy feeling. Backyard is completed fenced in. Nice size covered patio in the backyard. Beautiful garden, fruit and citrus trees.\r\n\r\nOffice can be used as a 4th bedroom, property has both a well, and septic system.\r\n\r\n\r\nMust see…..Nice Home!!!' ,`Acres` = '0.75' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S755500 ROLLING HILLS 5 BLK 6 LOT 5 ACRES .75' ,`LotDesciption` = 'Cleared' ,`LotSize` = '32670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rolling Hills 5' ,`TaxAmount` = '4906' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042244' WHERE `Matrix_Unique_ID` = '212792400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.273' ,`MLSNumber` = '77560233' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435496' ,`Longitude` = '-95.441360' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '352990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This TWO-STORY new construction home with 2 BEDROOMS DOWN features 4 spacious bedrooms, 3 bathrooms, game room, a covered patio, 2-car garage. Built by D.R Horton, the Midland floor plan features an open concept living and dining space w/ spacious rooms. Granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher are included in the kitchen. The Primary bathroom has dual sinks, soaking tub and/or oversized shower and a large walk-in closet! Smart tech features, brick on all four sides, vinyl flooring, & tankless water heater- ALL COME STANDARD in this community! Conveniently located off of Hwy 288, Sierra Vista offers easy access to downtown, med center and Pearland Town Center. Residents can enjoy upcoming resort-style amenities including pools, amenities center and more! Schedule a showing today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7172' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042245' WHERE `Matrix_Unique_ID` = '212794920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.180' ,`MLSNumber` = '18916270' ,`ListAgentFullName` = 'Nina Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435496' ,`Longitude` = '-95.441360' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '377990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10622' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'POPULAR TWO-STORY with 2 BEDROOMS DOWN featuring 4 spacious bedrooms, 3 bathrooms, game room, a covered patio, 2-car garage is for sale in Sierra Vista. Built by D.R Horton, the OZARK floor plan features an open concept living and dining space w/ spacious rooms. Granite countertops, 42\" cabinets, large breakfast bar and stainless steel appliances including gas range, canopy vent hood, microwave and dishwasher are included in the kitchen. The Primary bathroom has dual sinks, soaking tub and/or oversized shower and a large walk-in closet! Smart tech features, brick on all four sides, vinyl flooring, & tankless water heater- ALL COME STANDARD in this community! Conveniently located off of Hwy 288, Sierra Vista offers easy access to downtown, med center and Pearland Town Center. Residents can enjoy upcoming resort-style amenities including pools, amenities center and more! Schedule a showing today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7172' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042245' WHERE `Matrix_Unique_ID` = '212795273' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212866662','1666042245','212866662','2022-10-17T00:21:02.400','40571632','Corin Gascon','INNOVA Realty','','','29.594039','-95.215562','35','77089','6','289900.00','Active','Sagedowne','11218','Lane','Houston','2','0','4','1880','Single-Family','Welcome home! Come check out this fabulous 4 bedroom 2 bath home! Completely renovated. This beautiful home features an open concept, new windows, all new electrical wiring, new gas water heater, granite countertops and new cabinets. Beyond a functional entryway space, the home flows into a luminous, open- concept dining, kitchen area and a nice sized living room. Enjoy the Spacious Backyard perfect for Kids & Pets.','0.2938','3','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Southbelt/Ellington','Central Gas','1','LT 5 BLK 18 SAGEMONT SEC 5','Subdivision Lot','12800','Appraisal District','','174','0','','0','Gas Oven','0','','','Gas Range','','Composition','41 - Pasadena','STUCHBERY ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Vacant/Unoccupied','Appraisal District','1','Traditional','Sagemont','2467','2.6863','Public Sewer,Public Water','1966','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:03.087' ,`MLSNumber` = '87212824' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '295900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Stylish Timeless Chic 1 story home with Amazing Stucco & Brick Elevation! Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Lush Carpeting in all the Bedrms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Move-in Pkg! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 17 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042245' WHERE `Matrix_Unique_ID` = '212958850' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:05:38.360' ,`MLSNumber` = '84737651' ,`ListAgentFullName` = 'Shannon Gao' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717443' ,`Longitude` = '-95.600532' ,`PhotoCount` = '50' ,`PostalCode` = '77082' ,`RoomCount` = '10' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Island' ,`StreetNumber` = '12354' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE FIND, LAKE-VIEW 2 story Perry Home is located in Shadow Lake GATED community. Home has been UPDATED from Head to Toe. NEW Roof, NEW A/C units, NEW Water Heaters, NEW Fences. Home features front foyer W/soaring ceiling. Fresh paint, double crown molding and STYLISH Woven Wood blinds thr-out. Two bdrm downstairs. New wood floor in dining, study/bdrm, living & primary suite. Travertine floor in front entry, kitchen and all bathrooms. Formal living W/2 story open ceiling, cozy fireplace. A wall of Elongated windows allowing nature lights to shine through. Kitchen W/GE Profile Built-in appliances, walk-in pantry, eat-in breakfast room is the place where you enjoy STUNNING Lake-views when you sip morning coffee. Large primary suite W/his & her walk-in closets. Hardwood floor staircases lead you to 2nd floor, Ample game-room, 3 generous size bdrm are all W/NEW Carpets, ceiling fans and wall-in closets. FULLY sprinklered. Extended sun room is a PLUS! Home has NEVER been flooded!' ,`Acres` = '0.1909' ,`Area` = '28' ,`BuilderName` = 'Perry Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 SHADOWLAKE SEC 10' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '8317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadowlake Sec 10' ,`TaxAmount` = '10414' ,`TaxRate` = '2.5611' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042245' WHERE `Matrix_Unique_ID` = '212991002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '96940725' ,`ListAgentFullName` = 'Tamarah Curtis' ,`ListOfficeName` = 'Creighton Realty Partners, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400493' ,`Longitude` = '-95.603464' ,`PhotoCount` = '28' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '885000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden Estates' ,`StreetNumber` = '3714' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking and wide open views of Lake Conroe! Situated on a .337 acre lot with 110 feet on Lake Conroe, concrete bulkheading, boat slip and pool/spa! North/South facing lot in Walden on Lake Conroe the offers a World-class Golf Course, Yacht Club, Marina, hiking/biking trails, parks, pools, tennis/racquet ball, workout facility, boat ramps and so much more! This 4 bedroom, 3.5 bathroom home has TWO Primary bedrooms (one downstairs and the other upstairs) with spectacular Lake views, walkout porches, double sinks, walk-in showers, soak tubs and large closets. Two secondary bedrooms; both with Lake views and great closet space. Spacious game room upstairs separate one of the primary bedrooms and the guest rooms allowing for privacy on both floors.' ,`Acres` = '0.3779' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 07, BLOCK 1, LOT 4, SECTION 7A' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '16461' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 07' ,`TaxAmount` = '15873' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042245' WHERE `Matrix_Unique_ID` = '213067765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:02.963' ,`MLSNumber` = '77219830' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '322990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Texas Cali plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/5/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042246' WHERE `Matrix_Unique_ID` = '213120287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:02.260' ,`MLSNumber` = '30297772' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '336990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '33/3/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042246' WHERE `Matrix_Unique_ID` = '213120494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:02.090' ,`MLSNumber` = '22517717' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '20' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '305990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10603' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Diana Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '000-000-na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042246' WHERE `Matrix_Unique_ID` = '213120771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:01.293' ,`MLSNumber` = '17003669' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701848' ,`Longitude` = '-95.706490' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '333990.00' ,`Status` = 'Active' ,`StreetName` = 'Bradford' ,`StreetNumber` = '6915' ,`StreetSuffix` = 'Terrace' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home under Construction - This Harris! Stunning Entry! This lovely home you are greeted with High Ceilings, extended hallway and Beautiful Vinyl Plank Wood Flooring throughout! Luxurious Carpeting in all bedrooms! Two Full Baths plus Half Bath! The Family Room features Walls of Windows projecting abundance of natural light inside! Your Casual Dining area flows gracefully into your Gourmet Kitchen which features Quartz Counters, lots of Tall Shaker Cabinets for storage space, Stainless Appliances, Large Eat-in & Working Island w/Under-mount Stainless Sink & more! Private Owner\'s Suite features Luxurious bathroom w/Soaker Tub & Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 96 /Block: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042246' WHERE `Matrix_Unique_ID` = '213205472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:01.200' ,`MLSNumber` = '53595157' ,`ListAgentFullName` = 'DeAnna Green' ,`ListOfficeName` = 'Nydan Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794748' ,`Longitude` = '-95.559183' ,`PhotoCount` = '25' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Northbrook' ,`StreetNumber` = '10658' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home with new custom design finishes! Completely re-imagined home featuring many upgrades w/ open concept living/kitchen. Huge multi-purpose room that can be an office, study, formal living room! Kitchen has designer 42\" cabinets with gold finishing\'s. Granite countertop and tiled backsplash, SS appliances, gas cooktop w/built in oven, built-in microwave, dishwasher. New light fixtures, ceiling fans (w/remotes), and interior doors. Fresh paint inside & out, hardware, baseboards. New flooring throughout-NO carpet! Primary retreat with walk in closet. Primary bath has gorgeous vanity w/granite counter, marble finishes & seamless stand up shower! Hall bath also completely remodeled w/subway tile tub surround, vanity w/marble counter & lots of cabinetry. Close to Memorial Area and Town Center! NO FLOOD-not in floodplain!' ,`Acres` = '0.1653' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 4 SPRING LEA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHADOW OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lea Sec 01' ,`TaxAmount` = '6174' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042246' WHERE `Matrix_Unique_ID` = '213260177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:19:47.787' ,`MLSNumber` = '31272790' ,`ListAgentFullName` = 'Bradley Upshaw' ,`ListOfficeName` = 'Haven Realty International' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.165651' ,`Longitude` = '-95.545906' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '610000.00' ,`Status` = 'Active' ,`StreetName` = 'SUNDOWN RIDGE PLACE' ,`StreetNumber` = '113' ,`StreetSuffix` = '' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE GORGEOUS ONE-STORY HOME YOU\'VE BEEN WAITING FOR in the private, gated enclave of Timarron Lakes-The Woodlands. The STUNNING STUCCO ELEVATION with castle-like turret is just the beginning...a wrought-iron gate opens to the covered entrance leading to an elegant leaded-glass front door PLUS a second private casita/guest entrance. The main living space in this wonderful open plan features a cathedral ceiling accentuated by wood beams, wood floors & abundant natural light streaming through a wall of glass doors & windows. The TEXAS-SIZE KITCHEN features a huge island, custom soft-close cabinets, huge walk-in pantry & gas cooking...the Study has French doors, hardwoods and octagonal tray ceiling...the PRIVATE MASTER RETREAT offers a flex space and LUXURIOUS MASTER BATH with oversized jetted tub & shower. Spacious bedrooms all with private baths & walk-in closets. Outside: a covered patio with romantic fireplace. BACKS TO A RESERVE. Take the 3D Video Tour! Schedule a private tour today!' ,`Acres` = '0.1905' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST 16' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'The Woodlands Creekside Park West 16' ,`TaxAmount` = '9714' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042247' WHERE `Matrix_Unique_ID` = '213292469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T00:21:01.107' ,`MLSNumber` = '2600540' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819798' ,`Longitude` = '-94.820789' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '11' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14926' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story Home The Forest Plan by D.R. Horton! Ready for move in! Ultra Modern & Chic Stucco & Brick Elevation! Stunning Entry W/High Ceilings! Luxury Carefree Vinyl Wood Floors! Lush Carpeting in all bedrooms! Huge Family Rm features Walls of Windows to bring that natural light inside & Looks out to your Huge Backyard! Casual Dining flows into your Gourmet Kitchen that Features Beautiful Quartz Counters, Tall Gorgeous Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Large Eat-in & Working Island, Under-mount Stainless Sink & more! Private Owner\'s Suite W/High Tray Ceilings & features Luxurious bathroom W/His & Her Undermount Sinks Vanity, Large Glass Shower & Huge Walk-in Closet! 2\" Inches Blinds! Energy Efficient Home(HERS Rated),Tankless Water Heater! \"Smart Home Automation System\" where you are able to control your home anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & More! NO FLOODING! Not In Flood Zone at this time! AMAZING LOW Property Taxes!' ,`Acres` = '0.18' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 15 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042247' WHERE `Matrix_Unique_ID` = '213313188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:22:00.983' ,`MLSNumber` = '68120226' ,`ListAgentFullName` = 'Stephanie Childress' ,`ListOfficeName` = 'Rockin 4C Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480131' ,`Longitude` = '-95.223549' ,`PhotoCount` = '6' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '569990.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '2553' ,`StreetSuffix` = 'Trail' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The DR Horton Henderson Plan is a 3 bedroom, 3.5 bath and 2 car Garage. This open floor plan is perfect for entertaining and has so much natural Light. The tile floors extend throughout the entry, dining, Kitchen and Living area. Stainless Appliances in the kitchen and plenty of storage. Sprinkler System front and back, full gutters, garage door opener, and on demand tankless water heater are just some of the upgrades. Enjoy the large backyard with a covered patio. Come see this home today! Home is currently under construction' ,`Acres` = '0.2082' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT25 BLK 2 FRIENDSWOOD TRAILS SEC 1, 2 & COMM (2020) ABST 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Friendswood Trails' ,`TaxAmount` = '1162' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042247' WHERE `Matrix_Unique_ID` = '213406022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:11:09.267' ,`MLSNumber` = '41793281' ,`ListAgentFullName` = 'Andres Jones' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693991' ,`Longitude` = '-95.796804' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Bludana' ,`StreetNumber` = '24327' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Ashton Woods Single Story home on Premium Corner Homesite! 4 Bedrooms including Mother-In-Law Suite, Huge Primary Bedroom PLUS a Primary Bathroom With Dual Vanities and Separate Tub and Shower. Spacious Study. Soaring 12 ft Ceilings, Upgraded Vinyl Plank Flooring Throughout Most of The Home, Highly Sought After White Cabinets and Silestone Countertops, Reverse Osmosis, Custom Backsplash, and Premium Whirlpool Stainless Steel Kitchen Appliances. Tremendous Island Perfect for Preparing and Entertaining All Open To Your Great Room. Gorgeous Silestone in Bathrooms, Oversized Primary Walk-in Closet. Covered Back Patio With a Jacuzzi Tub, Full Sprinkler System, and Super Clean Garage with Epoxy Coating and Cabinets. House Has Plumbing Set Up For a Water Softener. Call Today For Your Private Tour!' ,`Acres` = '0.1842' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKES OF BELLA TERRA WEST SEC 1, BLOCK 3, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUBENAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Bella Terra West Sec 1' ,`TaxAmount` = '10461' ,`TaxRate` = '3.0848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042247' WHERE `Matrix_Unique_ID` = '213459065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:42:00.250' ,`MLSNumber` = '63226573' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086170' ,`Longitude` = '-95.952830' ,`PhotoCount` = '7' ,`PostalCode` = '77484' ,`RoomCount` = '15' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Shining Point' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.58' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042247' WHERE `Matrix_Unique_ID` = '213587260' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:40:55.450' ,`MLSNumber` = '43848140' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086170' ,`Longitude` = '-95.952830' ,`PhotoCount` = '7' ,`PostalCode` = '77484' ,`RoomCount` = '14' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Shining Point' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.58' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042248' WHERE `Matrix_Unique_ID` = '213588287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:40:26.107' ,`MLSNumber` = '67095646' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086170' ,`Longitude` = '-95.952830' ,`PhotoCount` = '7' ,`PostalCode` = '77484' ,`RoomCount` = '13' ,`ListPrice` = '376000.00' ,`Status` = 'Active' ,`StreetName` = 'Shallow Creek' ,`StreetNumber` = '112' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.58' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042248' WHERE `Matrix_Unique_ID` = '213589436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:39:27.043' ,`MLSNumber` = '63631722' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086170' ,`Longitude` = '-95.952830' ,`PhotoCount` = '7' ,`PostalCode` = '77484' ,`RoomCount` = '11' ,`ListPrice` = '442000.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Bluff' ,`StreetNumber` = '200' ,`StreetSuffix` = 'Circle' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.58' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042248' WHERE `Matrix_Unique_ID` = '213590892' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213592584','1666042248','213592584','2022-10-17T00:01:07.377','72659453','Effram Barrett','Hardee & Company Real Estate','','','29.728809','-95.535918','18','77063','8','365000.00','Active','Richmond','9606','Avenue','Houston','3','0','3','1591','Single-Family','Welcome to this newly renovated 3 bed 3 bath home located in the TANGLEWILDE subdivision! Home features an open concept great for hosting or lounging. Home upgrades include new luxury vinyl plank flooring, new quartz countertops, new backsplash, new cabinets, new kitchen appliances, bathroom flooring with vanities, recessed lighting throughout, and PEX piping throughout the house. Spacious backyard includes a new pergola and an area great for gardening! Great dining and shopping minutes away! Schedule your appointment today!','0.198','22','','','Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Briarmeadow/Tanglewilde','Central Gas','0','LT 18 BLK 18 TANGLEWILDE SEC 5','Subdivision Lot','8625','Appraisal District','','','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','27 - Houston','EMERSON ELEMENTARY SCHOOL (HOUSTON)','WISDOM HIGH SCHOOL','REVERE MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Tanglewilde Sec 05','4521','2.3307','Public Sewer,Public Water','1965','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:39:56.653' ,`MLSNumber` = '26861998' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084768' ,`Longitude` = '-95.948608' ,`PhotoCount` = '6' ,`PostalCode` = '77484' ,`RoomCount` = '15' ,`ListPrice` = '457000.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Bluff' ,`StreetNumber` = '205' ,`StreetSuffix` = 'Circle' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.58' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042248' WHERE `Matrix_Unique_ID` = '213612210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T01:42:32.620' ,`MLSNumber` = '75321587' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836233' ,`Longitude` = '-95.727791' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '16' ,`ListPrice` = '499955.00' ,`Status` = 'Active' ,`StreetName` = 'Hronas' ,`StreetNumber` = '4603' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Postwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042248' WHERE `Matrix_Unique_ID` = '213635424' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213691026','1666042249','213691026','2022-10-17T00:42:01.010','50238909','Wan Yi','W Realty & Investment Group','','','29.850263','-95.591623','39','77041','10','425000.00','Active','Laguna Pointe','12126','Lane','Houston','2','0','4','2345','Single-Family','Gorgeous rare 1 story stone/brick home offers 4 bedrooms, 2 bathrooms, and study. Located in Cul-de-sac, the resort-like living man Gated Community in Lakes on Eldridge South. The high ceilings in the home allow for openness and with the abundance of windows bring the natural light into the home. Split floor plan between bedrooms, living room, formal dining room, breakfast room, private home office. This home is open concept with beautiful wood floors and tile throughout (no carpet) and sprinkler system. The chef’s kitchen with a prep island & sink facing the living room with relaxing views of the backyard with covered Patio. The kitchen offers KitchenAid a wall microwave & oven, matching stainless steel appliances, vented out range hood, walk-in pantry, breakfast bar for seating, granite counter top space & spacious cabinetry.','0.1708','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Eldridge North','Central Gas','1','LT 5 BLK 1 LAKES ON ELDRIDGE SEC 14','Cul-De-Sac','7440','Appraisal District','','1670','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Lakes On Eldridge Sec 14','8135','2.471','Public Sewer,Public Water,Water District','1997','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213745787','1666042249','213745787','2022-10-17T00:07:44.530','98551967','Feras Rachid','Opendoor Brokerage, LLC','','','29.534659','-95.226660','36','77581','3','320000.00','Active','Gulfton','1214','Drive','Pearland','2','1','3','2321','Single-Family','This Pearland two-story home offers a patio, and a two-car garage.','0.1446','5','','','','','Sellers Disclosure','1','','1','Pearland','Central Gas','1','SUNSET MEADOWS-NASAWOOD (A0111 PERRY & AUSTIN) (PEARLAND) BL','Subdivision Lot','6300','Appraisal District','','363','0','','2','','0','','','','','Composition','42 - Pearland','RUSTIC OAK ELEMENTARY SCHOOL','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH EAST','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Sunset Meadows-Nasawood','6548','2.5552','Public Water','1990','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213745791','1666042249','213745791','2022-10-17T00:07:49.180','9801214','Feras Rachid','Opendoor Brokerage, LLC','','','30.202780','-95.166163','34','77372','3','265000.00','Active','Tupelo','25780','Circle','Splendora','2','1','3','2215','Single-Family','This Splendora two-story home offers granite countertops.','0.3905','40','','','','','Sellers Disclosure','1','','1','Porter/New Caney East','Central Electric','0','S951100 - WHITE OAK PLANTATION 01, BLOCK 1, LOT 40','Subdivision Lot','17010','Appraisal District','','','0','','2','','0','','','','','Composition','47 - Splendora','TIMBER LAKES ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','White Oak Plantation 01','5680','3.0383','Water District','2004','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213745909','1666042249','213745909','2022-10-17T00:09:35.523','40897433','Feras Rachid','Opendoor Brokerage, LLC','','','29.644020','-95.767572','22','77406','3','330000.00','Active','Sunlight Springs','3610','Street','Richmond','2','0','3','1784','Single-Family','Built in 2019, this Richmond one-story home offers a patio, granite countertops, and a two-car garage.','0.1326','37','','','','','Sellers Disclosure','','','0','Fort Bend County North/Richmond','Central Gas','1','MCCRARY MEADOWS SEC 4, BLOCK 7, LOT 12','Subdivision Lot','5774','Appraisal District','','600','0','','2','','0','','','','','Other','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Mccrary Meadows Sec 4','6213','2.8548','Water District','2019','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213746217','1666042249','213746217','2022-10-17T00:16:02.820','17234926','Feras Rachid','Opendoor Brokerage, LLC','','','30.037867','-95.517800','36','77379','4','290000.00','Active','Trailway','6303','Lane','Spring','2','1','4','2003','Single-Family','This Spring two-story home offers a two-car garage.','0.2789','13','','','','','Sellers Disclosure','1','','1','Champions Area','Central Gas','1','LT 34 BLK 22 017*S6353500-003-022-034 SPRING CREEK FOREST SE','Subdivision Lot','12150','Appraisal District','','655','0','','2','','0','','','','','Other','32 - Klein','EHRHARDT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Spring Creek Forest Sec 03','4850','2.5315','Other Water/Sewer','1980','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213746583','1666042249','213746583','2022-10-17T00:55:10.627','33747908','Linh Pham','V-Pro Realtors','','','29.805072','-95.145422','31','77530','6','224000.00','Active','Peachmeadow','15211','Lane','Channelview','2','0','3','1542','Single-Family','Beautiful 1 story house with NEW WATER HEATER, NEW STOVE, NEW FLOOR of TILES and LAMINATE WOODS, NEW PAINT, NEW WINDOW TREATMENT, NEW light fixture in Dining Room, NEW REMODELED OVERSIZED SHOWER in second BATHROOM. A/C UNIT IS ONLY 2 YEARS of age. Stainless Steel microwave. Granite countertops in kitchen and bathrooms. Large living room. Must see.','0.132','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','North Channel','Central Electric','1','E 25 FT OF LT 30 & W 25 FT OF LT 31 BLK 1 STERLING GREEN SEC','Subdivision Lot','5750','Appraisal District','','270','0','','2','Electric Oven','0','','','Electric Range','','Composition','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Sterling Green Sec 09','4264','2.518','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully