Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T17:21:56.817' ,`MLSNumber` = '21874943' ,`ListAgentFullName` = 'Norman Nelson' ,`ListOfficeName` = 'The Residence' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918701' ,`Longitude` = '-95.590972' ,`PhotoCount` = '39' ,`PostalCode` = '77065' ,`RoomCount` = '7' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Hambleton Way' ,`StreetNumber` = '9918' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2053' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful home in an established community in Northwest Houston. This house has 4-bedrooms, 2 full-bathrooms, and 1 half-bathroom. Per the seller, the roof was replaced in 2022, exterior lighting was installed in the soffits, and new baseboards were installed. The garage also features laminate wood flooring. New shutters have also been installed throughout. This home has laminate wood flooring in the living room, gameroom upstairs, and all bedrooms. Kitchen features granite countertops, a small planning desk, and access to the living room and formal dining room. There is a bonus room off the kitchen that could be used as a breakfast room, home office, or first floor game area. Large backyard has a wood deck, and several areas that can be used for fruit and flower gardens. Two attic access areas are on the second floor, one which is walk-in and has space/flooring perfect for storage of holiday decorations. Zoned to schools in the Cypress-Fairbanks I.S.D. Schedule your tour today!' ,`Acres` = '0.1837' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 STEEPLECHASE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMMOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Steeplechase' ,`TaxAmount` = '5714' ,`TaxRate` = '2.541' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090707' WHERE `Matrix_Unique_ID` = '211708449'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T17:31:56.057' ,`MLSNumber` = '91650253' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.517471' ,`Longitude` = '-95.495943' ,`PhotoCount` = '17' ,`PostalCode` = '77545' ,`RoomCount` = '15' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Settler Hill' ,`StreetNumber` = '2607' ,`StreetSuffix` = 'Drive' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2951' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 2607 Settler Hill Drive located in the community of Shipman\'s Cove and zoned to Fort Bend ISD. The Bridgeport floorplan features 4 bedrooms, 3 full baths, 1 half baths and an attached 2 car garage. The first floor includes a study, formal dining room, kitchen open to the family room and breakfast area, and master bedroom. Come upstairs where you will find 3 additional bedrooms and game room. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is December 2022. Call to schedule your showing today! Shipman’s Cove will be attending Scanlan Elementary and Hightower High School due to overflow. Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Shipman\'s Cove Section 2, Block 2, Lot 53' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '7285' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Shipman\'s Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090707' WHERE `Matrix_Unique_ID` = '212577214'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T18:46:42.533' ,`MLSNumber` = '51504541' ,`ListAgentFullName` = 'Jeanette Lopez' ,`ListOfficeName` = 'RE/MAX GO' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.620493' ,`Longitude` = '-95.409200' ,`PhotoCount` = '26' ,`PostalCode` = '77047' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Staffordale Manor' ,`StreetNumber` = '914' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2174' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home Sweet Home! This Gorgeous 3bed, 2 1/2 Bath is nested in the quiet subdivision of Regal Oaks. Just about 20 minutes away from TMC and Downtown Houston with a quick hop on SH 288 and close proximity to Bltw 8 and I-610 you can be anywhere in a blink of an eye! This Beautiful Home features a Great Combination of Wood and Tile floors throughout the Living Area and Kitchen, Gorgeous Granite Countertops with Wood Cabinetry Decorate the Kitchen. Make your way upstairs to Beautiful Laminate Flooring all throughout. You will find All Bedrooms Upstairs with a Perfect Size Game Room/Entertainment Room. Primary Bedroom Features A Double Sink Vanity with Walk In Closet and Amazing Wider than normal Tub/Shower Combo. Bedrooms are just as Cozy as the Remaining of the House! Please don\'t wait! Call to Schedule your Showing Today!' ,`Acres` = '0.1047' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 3 REGAL OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Regal Oaks Sec 03' ,`TaxAmount` = '6235' ,`TaxRate` = '2.9007' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090708' WHERE `Matrix_Unique_ID` = '212582982'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T17:24:14.157' ,`MLSNumber` = '90176348' ,`ListAgentFullName` = 'Rella Sanders' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.247826' ,`Longitude` = '-95.531783' ,`PhotoCount` = '50' ,`PostalCode` = '77384' ,`RoomCount` = '11' ,`ListPrice` = '829000.00' ,`Status` = 'Active' ,`StreetName` = 'Wind River' ,`StreetNumber` = '45' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME TO THIS STUNNING SINGLE-STORY CUSTOM BALLATAR DESIGN, ON .65 OF A ACRE WITH LOTS OF MATURE TREES, TUCKED IN A SOUGHT-OUT SUBDIVISION OF LAKE CREEK FOREST WITH 4 BEDROOMS/3 BATHS/ 2 HALF BATHS*3550 SQ.FT. HOME FEATURES INCLUDE A CUSTOM FRONT DOOR*A FULL HOUSE GENERAC GENERATOR*TRAY CEILINGS* CROWN MOLDING* PLANTATION SHUTTERS*REAL SCRAPED WOOD FLOORING* FORMAL DINING* AN EXECUTIVE STUDY WITH FRENCH DOORS*HOLIDAY CLOSET,*A COZY FAMILY ROOM WITH A FIREPLACE THAT FEATURES ONE OF KIND CEDAR MANTLE* MEDIA/GAMEROOM W/BREATHTLING VAULTED CEILINGS*CHEF\'S KITCHEN BOAST HIGH-END GRANITE COUNTERS & CAFE APPLIANCES & BREAKFAST SPACE WITH LARGE PICTURE WINDOW THAT LOOKS OUT TO A MAGNIFICENT BACKYARD WHICH HAS 1200 SQ.FT. COVERED PATIO WITH A CATHEDRAL CEILING WITH AUSTIN STONE FIREPLACE FOR ENTERTAINING FAMILY/FRIENDS*PRIMARY SUITE OFFERS AN SPA-LIKE EN-SUITE BATH WITH JETTED TUB/STANDING SHOWER*ELECTRIC DRIVEWAY GATE WITH FENCE OF WOOD/AUSTIN STONE COLUMNS* CALL FOR YOUR VIEWING TODAY!' ,`Acres` = '0.65' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CREEK FOREST 01, BLOCK 2, LOT 138, ACRES 0.650' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '28314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '22' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Creek Forest 01' ,`TaxAmount` = '9273' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090708' WHERE `Matrix_Unique_ID` = '213267993'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T17:29:11.013' ,`MLSNumber` = '23214724' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.519970' ,`Longitude` = '-95.495019' ,`PhotoCount` = '22' ,`PostalCode` = '77545' ,`RoomCount` = '13' ,`ListPrice` = '419990.00' ,`Status` = 'Active' ,`StreetName` = 'Preservation Oaks' ,`StreetNumber` = '4631' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 4631 Preservation Oaks Lane located in the community of Shipman\'s Cove and zoned to Fort Bend ISD. The Thames floorplan features 4 bedrooms, 3 full baths, 1 half baths and an 2 car garage. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is February 2022. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.Shipman’s Cove will be attending Scanlan Elementary and Hightower High School due to overflow.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Shipman\'s Cove Section 2, Block 2, Lot 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6810' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Shipman\'s Cove' ,`TaxAmount` = '' ,`TaxRate` = '3.29' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090708' WHERE `Matrix_Unique_ID` = '214486908'  --> Updated record success<br />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','215252400','1675090708','215252400','2022-12-13T17:37:54.393','84640693','Andreas Weber','Martha Turner Sotheby\'s International Realty','','','29.722566','-95.576616','43','77082','17','1250000.00','Active','Chartreuse','3319','Way','Houston','3','1','4','4287','Single-Family','Two story single family home situated in a gated/golf course community. Home boasts four bedrooms/three bathrooms and a half, attached three car garage, home office, formal living, formal dining, dry bar, powder room, large utility room with sink and lots of storage, island kitchen with ample counter and cabinet storage, adjacent breakfast area, open to family room. First floor primary bedroom with views of backyard, ensuite bath has dual vanities, jetted tub, glass enclosed shower, and large walk-in closet. Second floor has game room, media room, three bathrooms and two bathrooms. Access the extra room via one of the bedrooms. Second floor covered balcony. Fenced backyard has pool/spa, covered patio, outdoor kitchen, and views of the golf course.','0.2509','31','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Westchase Area','Central Gas','1','LT 8 BLK 1','In Golf Course Community,On Golf Course,Subdivision Lot','10931','Appraisal District','','3130','0','','3','Convection Oven,Double Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','2 - Alief','OUTLEY ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Royal Oaks Country Club','25714','2.6086','Water District','2001','Appraisal District');  --> New record created successfully<br />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','215370257','1675090708','215370257','2022-12-13T18:49:42.040','69850936','Ashlee Johnston','Realty ONE Group, Experience','','','30.289808','-95.166511','28','77328','8','249900.00','Active','Lost Maples','10623','Drive','Cleveland','2','0','3','1571','Single-Family','Home is only 1 year old and in a quiet, well-kept neighborhood in Cleveland.  Kitchen Refrigerator included!  3 bedrooms, 2 bathrooms and no back neighbors!   Pinewood Trails offers residents incredible on-site amenities, including a children\'s playground, splash pad, shaded picnic areas and walking trails.','0.1305','40','LGI Homes','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Cleveland Area','Central Electric','1','S800200 - PINEWOOD TRAILS 01, BLOCK 10, LOT 28','Subdivision Lot','5685','Appraisal District','','348','0','','2','Electric Oven','0','','','Electric Range','','Composition','47 - Splendora','GREENLEAF ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Pinewood Trails','6627','2.8333','Public Sewer,Public Water','2021','Builder');  --> New record created successfully<br />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','215421867','1675090708','215421867','2022-12-13T17:02:16.180','42208092','Feras Rachid','Opendoor Brokerage, LLC','','','29.399342','-95.048444','18','77568','4','267000.00','Active','Apache Field','313','Lane','La Marque','2','1','4','1854','Single-Family','Come see this charming home now on the market! This home has fresh interior paint and partial flooring replacement. Windows create a light filled interior with well placed neutral accents. This kitchen has everything you need! A center island, walk in pantry, and stylish backsplash accent will have you looking forward to cooking. Head to the spacious primary suite with good layout and closet included. Other bedrooms provide nice flexible living space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Like what you hear? Come see it for yourself!\r\nThis home has been virtually staged to illustrate its potential.','0.1336','33','','','','','Sellers Disclosure','1','','0','La Marque','Central Gas','1','PAINTED MEADOWS SEC 3 (2015) ABST 161, BLOCK 4, LOT 12, ACRE','Subdivision Lot','5820','Appraisal District','','300','0','','2','','0','','','','','Composition','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Painted Meadows Sec 3','5985','2.3912','Public Water','2014','Seller');  --> New record created successfully<br />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','215538673','1675090708','215538673','2022-12-13T17:07:23.693','2503408','Melinda Moudy','Bay City Realty','','','28.827213','-96.141003','28','77465','5','125000.00','Active','Old River Rd/S','0','','Palacios','2','0','3','1064','Single-Family','2 mobile homes on 4 lots, 1 has been remodeled and has 3 bedrooms, 2 baths with inside utility room built in 1985.  Nice screened in large deck in between both homes for entertaining.  2nd home has utilities but needs some work and is currently being used as storage area, but could be a 2 bedroom, 1 bath with some work and was built in 1970.  Most of the furnishings will stay. Bedroom sizes are approximate. Tres Palacios Oaks is a gated private community with swimming pool and boat ramp to the river.  Come take a look.','0.23','54','','','','','Sellers Disclosure','','','','','Other Heating','1','TRES PALACIOS OAKS S/D, LOT 191-194, LIVE OAK SEC','Cleared','20000','Survey','','160','0','','0','','0','','','','','Other','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Other Style','Tres Palacios Oaks Sub','434','2.0195','Septic Tank','1985','Seller');  --> New record created successfully<br />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','215547257','1675090709','215547257','2022-12-13T17:27:33.453','43517680','Steven Franco','Keller Williams Professionals','','','30.363856','-95.621752','8','77316','5','179900.00','Active','Glenheath','16866','','Montgomery','2','0','3','988','Single-Family','10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with granite countertops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.0518','39','Starter Homes of TX','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','LAKE CONROE VILLAGE, BLOCK 12, LOT 57','Cleared,Subdivision Lot','2256','Other','','384','1','To Be Built/Under Construction','0','','0','','','Electric Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Traditional','Lake Conroe Village','332','1.825','Public Sewer,Public Water','2023','Builder');  --> New record created successfully<br />