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` = '2023-01-27T12:49:06.913' ,`MLSNumber` = '75953480' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402359' ,`Longitude` = '-95.059883' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '13' ,`ListPrice` = '395990.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Bay' ,`StreetNumber` = '2207' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Enjoy your own slice of paradise in this beautiful Lake Ridge Builders home in Lago Mar. Nestled on a spacious lot, this 4-sided brick home boasts a premium elevation, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, cast stone fireplace, guest suite, full gutters, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The tranquil primary suite features dual vanities, a 42” tub, and a separate shower. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Call today to learn more!' ,`Acres` = '' ,`Area` = '33' ,`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` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`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` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265042' WHERE `Matrix_Unique_ID` = '204298857' --> 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','206881232','1675265043','206881232','2023-01-27T12:56:48.490','73029864','Lance Loken','Long Lake LTD','','','29.882861','-95.142589','8','77044','15','384990.00','Active','Painted Trillium','11323','Lane','Houston','3','1','5','2785','Single-Family','This home is under construction. Find exactly what you’re looking for in this wonderful Lake Ridge Builders home in Sheldon Ridge. Resting on a spacious lot, this 3-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, and a covered patio. Cook up new cuisines in the kitchen, complete with granite countertops, tile backsplash, and 42” upper cabinets. Spend evenings relaxing in the primary suite, which features a 42” tub and separate shower. Popular restaurants and shopping centers are only a short distance away, among the area’s stunning nature parks. Bush Intercontinental Airport and Downtown Houston are easily accessible via Hwy 90. Zoned to the recognized Sheldon ISD. Don’t wait – call today for more information!','','2','Lake Ridge Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','North Channel','Central Electric','1','Lot 12 Block 2','Subdivision Lot','','','','345','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Gas Range','','Composition','46 - Sheldon','SHELDON ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Sheldon Ridge','','3.79','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:57:39.980' ,`MLSNumber` = '87106447' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936786' ,`Longitude` = '-96.035016' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '14' ,`ListPrice` = '1349000.00' ,`Status` = 'Active' ,`StreetName` = 'Cessna' ,`StreetNumber` = '12099' ,`StreetSuffix` = 'Place' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Pilots Dream Estate! Your Opportunity to purchase (owner terms available) a Meticulously Maintained, 2021, single story, 3,215 Sq ft Custom Built Brick home in the Gated community of Fair Weather Field. Beautifully landscaped, Fully fenced backyard, & Two Separate, Private, Entry Gates onto your Property. Two Car Garage with Golf Cart Garage too. The interior? The pictures don\'t lie. Shows like a Model Home. The 65x75 Metal Hangar has a 45Wx14T Hydraulic Door, a 12ftT x 10ftW Roll Up Automatic door, a downstairs Build Shop with a Fold Away Wall, and A/C. A Well Appointed Upstairs Apartment above. Plenty of room for aircraft, your car collection, and toys! The Airport Identifier is TX42 with a 3,375 ft long asphalt 13/31 runway & a 2,400 ft 18/36 turf strip. Push your plane from the Hangar to your Over-sized concrete pad. Taxi on a separate asphalt taxiway to the run up - no back taxiing. Plenty of room for other airplanes, invite your friends to fly in & visit. #SearchTexasAirparks' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = 'New Camden Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S474600 FAIR WEATHER FIELD BLK 2 LOT 1 ACRES 1.0 (.61 AC IN' ,`LotDesciption` = 'Airpark' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '15' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Fair Weather Field' ,`TaxAmount` = '20942' ,`TaxRate` = '3.1767' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675265043' WHERE `Matrix_Unique_ID` = '207266555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:26:21.487' ,`MLSNumber` = '15448036' ,`ListAgentFullName` = 'Donna Branham' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = 'Amber Hull' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.297889' ,`Longitude` = '-94.928116' ,`PhotoCount` = '37' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '690000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Isles End' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Road' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2071' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see ONE-story canal home on oversized lot with bay views and an ELEVATOR.\r\nThis home illustrates an open floor plan, large screened in porch and storm shutters. Large closets, laundry room, walk in pantry and an abundance storage.\r\n\r\n TWO boat slips with easy access to Galveston Bay. \r\n Come relax on the breezy deck.\r\nYou will love the large ground level entertainment area for all the Tiki parties!\r\nNEW ROOF!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7SC BUNDICK SUR LOT 31 TIKI ISLAND SEC 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265043' WHERE `Matrix_Unique_ID` = '207401467' --> 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','208154293','1675265043','208154293','2023-01-27T12:57:59.717','38732474','Lance Loken','Long Lake LTD','','','29.495983','-95.811150','14','77471','16','494990.00','Active','Trembling Aspen','5006','Lane','Rosenberg','3','1','4','3306','Single-Family','This home is under construction. Find many comforts in this stunning Briarwood Home in Briarwood Crossing. Situated on an oversized lot, this 4-sided brick home boasts a premium elevation, tile flooring, sprinkler system, wrought iron spindles, faux wood blinds, a cast stone fireplace, a media room with surround sound pre-wiring, and a covered patio. Dream up new recipes in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The serene primary suite features a drop-in tub and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Arrange your private showing today!','','30','Briarwood Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Fort Bend South/Richmond','Central Gas','1','Lot 22 Block 1','Subdivision Lot','','','','533','1','To Be Built/Under Construction','2','Double Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','CULVER ELEMENTARY SCHOOL','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Briarwood Crossing','','3.47','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:23:47.810' ,`MLSNumber` = '43009709' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887624' ,`Longitude` = '-93.936067' ,`PhotoCount` = '14' ,`PostalCode` = '77640' ,`RoomCount` = '3' ,`ListPrice` = '82499.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '1626' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Decent 3 bed 1 bath investment home available in Port Arthur. This property is a terrific DIY project that any first-time homebuyer or investor can easily transform into a fabulous living space. It features a nice sized family room, spacious bedrooms, and a covered front porch area. Location is another bonus, seeing as the home is in the epicenter of Port Arthur making several popular destinations only mere minutes away. Visit the Museum of the Gulf Coast on the weekends or enjoy some outdoor time with the kids at Blue Bonnet Park just down the road. You will also get to enjoy all the multicultural eateries, local markets, and grocery stores such as H-E-B and Walmart Supercenter nearby. Don\'t wait any longer! Contact us today for more information! AS IS.' ,`Acres` = '0.1607' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 380 CITY OF PORT ARTHUR' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'DEQUEEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Arthur City' ,`TaxAmount` = '2466' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265043' WHERE `Matrix_Unique_ID` = '209056310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:02:32.037' ,`MLSNumber` = '96122511' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153807' ,`Longitude` = '-95.394611' ,`PhotoCount` = '35' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '636000.00' ,`Status` = 'Active' ,`StreetName` = 'Soaring Willow' ,`StreetNumber` = '32422' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle ambitions in the vibrant and innovative Milburn home plan. The Jack-and-Jill bedrooms and a separate front bedroom offer plenty of personal space for your growing residents and overnight guests. A quiet media room and front study present unparalleled opportunities to craft the family movie theater and home office you’ve been dreaming of. The streamlined kitchen provides an easy culinary layout for the resident chef with an extended pantry and prep area and a delightful view of the sunny family and dining spaces. Spend quality time together in the shade of your Outdoor Living covered patio with a built-in Outdoor Kitchen. Your blissful Owner’s Retreat offers an everyday escape from the outside world and includes a spa-inspired en suite bathroom with a luxury walk-in split closet design. Experience all the lifestyle benefits of this new EnergySaver™ home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 03 Block 02' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265043' WHERE `Matrix_Unique_ID` = '209839606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:48:52.983' ,`MLSNumber` = '93639552' ,`ListAgentFullName` = 'Kathryn Hensley' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.444732' ,`Longitude` = '-94.748874' ,`PhotoCount` = '33' ,`PostalCode` = '75904' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkland' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Road' ,`City` = 'Lufkin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom Home located on 3.56 acres. Come tour this open floor plan, split floor plan with all the upgrades\r\nThis home offers a formal dining or office, Beautiful Quartz countertops, eat in kitchen with large island, stainless steel appliances, Large Primary bedroom w/ walk in shower and great walk in closet! This home has so much character and all that is missing is YOU!' ,`Acres` = '3.56' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '4665 KIRKLAND RD ESTATES BLK 1 LOT 3' ,`LotDesciption` = 'Wooded' ,`LotSize` = '155074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '267 - Central' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (CENTRAL)' ,`SchoolHigh` = 'CENTRAL HIGH SCHOOL (CENTRAL)' ,`SchoolMiddle` = 'CENTRAL JUNIOR HIGH SCHOOL (CENTRAL)' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Kirkland Road Estates' ,`TaxAmount` = '4798' ,`TaxRate` = '1.717' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265044' WHERE `Matrix_Unique_ID` = '210591233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:37:57.507' ,`MLSNumber` = '56661998' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '773859.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Bend' ,`StreetNumber` = '28910' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story Windsor home. Enter through the grand 8\' double front doors\r\nshowcasing the stunning curved staircase and high ceilings. Save time on your commute\r\nby utilizing the spacious at-home office. Entertain guests in the open-concept layout, with\r\nthe kitchen and great room flowing together. In the kitchen, benefit from the centralized\r\nisland and a large pantry and share a meal in the casual dining area. Unwind in the\r\nprimary suite that features two vanities, a free-standing tub, and a large walk-in closet.\r\nHead upstairs and host a game night in the game room, that oversees that main great\r\nroom. Retreat to your covered patio or cozy up with a book by the fireplace. This twostory will check all the boxes for function and style! Huge homesite and ready for pool.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '34/1/CTO4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265044' WHERE `Matrix_Unique_ID` = '210628194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:02:09.417' ,`MLSNumber` = '88666749' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153689' ,`Longitude` = '-95.395030' ,`PhotoCount` = '31' ,`PostalCode` = '77385' ,`RoomCount` = '8' ,`ListPrice` = '584000.00' ,`Status` = 'Active' ,`StreetName` = 'Soaring Willow' ,`StreetNumber` = '32413' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Explore superb balance of energy-efficiency, individual privacy and elegant gathering spaces in The Bluffwood plan by David Weekley Homes. Start each day rested and refreshed in the extended Owner’s Retreat, which includes a walk-in closet and a luxurious en suite bathroom with oversized walk-in shower. The en suite guest room and two junior bedrooms make it easy for everyone in the family to thrive. The front study presents an ideal place for a welcoming den or a productive home office. A tasteful kitchen rests at the heart of this home, balancing impressive style with easy function, all while maintaining an open design that flows throughout the sunny family and dining spaces. Build your future with the peace of mind that our industry-leading Warranty brings to this new home plan in The Meadows at Imperial Oaks. Experience all the lifestyle benefits of this new EnergySaver™ home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 01 Block 03' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265044' WHERE `Matrix_Unique_ID` = '210712916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:02:51.427' ,`MLSNumber` = '51367483' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154980' ,`Longitude` = '-95.394404' ,`PhotoCount` = '38' ,`PostalCode` = '77385' ,`RoomCount` = '8' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Noble Creek' ,`StreetNumber` = '32327' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coming home is the best part of each day in the beautiful and spacious Birkshire family home plan. Hone your culinary skills and explore new horizons of cuisine with the aid of split countertops, a deluxe walk-in pantry and a full-function island in this epicurean kitchen. Your open floor plan provides a sunny and cheerful place to host family dinners, social gatherings and your favorite times together. Assemble your ideal lounge, media room or office in the versatile study. The spare bedrooms offer endless personalization opportunities for your growing residents. A luxurious bathroom and a bedroom-sized walk-in closet contribute to the everyday getaway of your sensational Owner’s Retreat. Experience all the lifestyle benefits of this new EnergySaver™ home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 04' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265044' WHERE `Matrix_Unique_ID` = '210714389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:44:10.613' ,`MLSNumber` = '26089168' ,`ListAgentFullName` = 'Pompello Rubio' ,`ListOfficeName` = 'Texas Key Holders Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132546' ,`Longitude` = '-95.391914' ,`PhotoCount` = '40' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Linder Green' ,`StreetNumber` = '3219' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for that one special place that you can call home and feel like you are at paradise? Look no further, super clean come that has it all. Plenty of space for the family or friends to hang out. Large living room area that opens up to the kitchen. This home is made for entertaining. Back door paradise. Home has a ton of upgrades. Come and lock this home in now to be yours before the interest rates take leap.' ,`Acres` = '0.1691' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S328308 - CANYON GATE AT LEGENDS RANCH 08, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7366' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch 0' ,`TaxAmount` = '8033' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265044' WHERE `Matrix_Unique_ID` = '210941922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:00:53.680' ,`MLSNumber` = '77005368' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154828' ,`Longitude` = '-95.394375' ,`PhotoCount` = '35' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '522000.00' ,`Status` = 'Active' ,`StreetName` = 'Noble Creek' ,`StreetNumber` = '32332' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy living at its finest in the awe-inspiring excellence of The Ware new home plan. Your open-concept lifestyle spaces offer stunning opportunities to create your ideal living, dining, gathering and hosting arrangements. Design an organized home office or a family fun and games zone in the inviting study. Each spare bedroom provides ample closets and a great place for growing minds to flourish. The gourmet kitchen features a large pantry and a center island that’s ideal for family breakfasts and party snacks. Your glamorous Owner’s Retreat includes a resort-style bathroom and an impressive walk-in closet. Experience all the lifestyle benefits of this new EnergySaver™ home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 03' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Meadows at Imperial Oaks' ,`TaxAmount` = '' ,`TaxRate` = '3.03' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265045' WHERE `Matrix_Unique_ID` = '211048458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:27:30.730' ,`MLSNumber` = '34814181' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465805' ,`Longitude` = '-95.048765' ,`PhotoCount` = '11' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Rasberry' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Court' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 3 bedroom, 2 bath 1-story home is situated on a corner lot in the quiet neighborhood of Berry Field. Updates include a BRAND NEW ROOF! New LVP flooring in the living room & hallway with new carpet in all 3 bedrooms! Fresh interior paint! Kitchen features granite counters with stainless appliances (stove, vent hood, dishwasher, & refrigerator). The dining room is located in the kitchen in a bay window overlooking the front yard. Adjacent to the kitchen/dining room is a generous living room. The large primary suite features two closet plus an ensuite bath with granite counters, garden tub and separate shower. Two additional bedrooms share a hall bath. Large windows throughout home bring in an abundance of natural light. Huge fenced backyard with a beautiful tree for shade. Located in the heart of Dickinson and only minutes to the Kemah Boardwalk and Space Center. Convenient access to 146 or I-45 for easy commuting to Houston, Galveston, Texas City or the Pasadena area.' ,`Acres` = '0.165' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BERRY FIELD SUB (2005) ABST 19, BLOCK 4, LOT 13, ACRES 0.165' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '7186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Berry Field' ,`TaxAmount` = '4962' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265045' WHERE `Matrix_Unique_ID` = '211115080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:33:52.280' ,`MLSNumber` = '77163913' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.244711' ,`Longitude` = '-95.541460' ,`PhotoCount` = '42' ,`PostalCode` = '77384' ,`RoomCount` = '11' ,`ListPrice` = '2675000.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Oaks' ,`StreetNumber` = '11093' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '8691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story custom home on 5 lush, wooded acres in Red Oak Ranch - horses welcome! Enjoy direct access to miles of dedicated horseback riding trails. Gated entry, 5 car garage, double circular driveway, new roof, water well, new LED lighting, & the whole house is wheelchair accessible. Lavish formal dining with adjacent butler\'s pantry; wood paneled study with attached separate study is perfect for working from home; magnificent sunroom has views of the beautiful pool & a dual-sided fireplace; owner\'s retreat with relaxing bath & door to a bonus room, ideal for a home gym. Chef\'s kitchen has a LaCanche gas range, ice maker, wine grotto, built-in Miele coffee maker, pot filler & opens to the breakfast room and den; 4 addt\'l bedrooms with walk-in closets; 2 separate apartments attached to the garage. The private fenced backyard features a covered patio, outdoor kitchen, gorgeous pool, 4 stall barn with tack & feeding room. A well maintained riding arena available exclusively for owners.' ,`Acres` = '5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'RED OAK RANCH 02, BLOCK 2, LOT 11, ACRES 5.00' ,`LotDesciption` = 'Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Red Oak Ranch 02' ,`TaxAmount` = '24139' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265045' WHERE `Matrix_Unique_ID` = '211168515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:15:46.740' ,`MLSNumber` = '6028949' ,`ListAgentFullName` = 'George Gallagher' ,`ListOfficeName` = 'Westwood Shores Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.940537' ,`Longitude` = '-95.343692' ,`PhotoCount` = '27' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '251872.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway Dr' ,`StreetNumber` = '77' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION HOME!! This Home Sits on Two Lots on the Golf Course! 3 Bedrooms, 2 Baths, Covered Back Porch and 2 Car Garage. Located in the Highly Sought-After Westwood Shores Community! This Is A Very Active Community With 24Hr Manned Access Gate, Country Club with 19th Hole Bar & Grill, Fitness Center, 18 Hole Golf Course, Swimming Pools, Tennis Courts / Pickle Ball Courts, 9 Interior Lakes, Marina with Gas/Boat Ramp, + Access to Campground with Activity Center/Community Center and So Much More! Call Today to Book Your Appointment!' ,`Acres` = '0.2904' ,`Area` = '42' ,`BuilderName` = 'Trend View' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 08, BLOCK 2 LOTS 01 & 2' ,`LotDesciption` = 'Corner,In Golf Course Community,On Golf Course' ,`LotSize` = '12647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2509' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265045' WHERE `Matrix_Unique_ID` = '211397733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:18:41.970' ,`MLSNumber` = '51269162' ,`ListAgentFullName` = 'George Gallagher' ,`ListOfficeName` = 'Westwood Shores Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.942354' ,`Longitude` = '-95.342726' ,`PhotoCount` = '21' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '251872.00' ,`Status` = 'Active' ,`StreetName` = 'Greenway Dr' ,`StreetNumber` = '14' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 Bedroom, 2 Bath, New Construction Home with Covered Back Porch that Looks Over #15 Tee Box/Fairway! Kitchen is Open to Family and Dining Room with Plenty of Windows to Enjoy the Views! Located in the Highly Sought-After Westwood Shores Community! This Is A Very Active Community With 24Hr Manned Access Gate, Country Club with 19th Hole Bar & Grill, Fitness Center, 18 Hole Golf Course, Swimming Pools, Tennis Courts / Pickle Ball Courts, 9 Interior Lakes, Marina with Gas/Boat Ramp, + Access to Campground with Activity Center/Community Center and So Much More! Call Today to Book Your Appointment!' ,`Acres` = '0.1338' ,`Area` = '42' ,`BuilderName` = 'Trend View' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 09, BLOCK 01 LOT 07' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '5830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2509' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265046' WHERE `Matrix_Unique_ID` = '211400565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:14:26.697' ,`MLSNumber` = '51289689' ,`ListAgentFullName` = 'George Gallagher' ,`ListOfficeName` = 'Westwood Shores Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.942133' ,`Longitude` = '-95.339336' ,`PhotoCount` = '26' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '274720.00' ,`Status` = 'Active' ,`StreetName` = 'Pinnacle' ,`StreetNumber` = '354' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION HOME ON GOLF COURSE!! 3 Bedroom, 2 Bath, 2 Car Garage, Granite Countertops, Kitchen is Open to Dining and Family Room, Lots of Windows to Enjoy the Wonderful Views this Property has to Offer! Primary Bedroom has a Very Generous Walk-In Closet! Located in the Highly Sought-After Westwood Shores Community! This Is A Very Active Community With 24Hr Manned Access Gate, Country Club with 19th Hole Bar & Grill, Fitness Center, 18 Hole Golf Course, Swimming Pools, Tennis Courts/ Pickle Ball Courts, 9 Interior Lakes, Marina with Gas/Boat Ramp, + Access to Campground with Activity Center/Community Center and So Much More! Call Today to Book Your Appointment!' ,`Acres` = '0.1252' ,`Area` = '42' ,`BuilderName` = 'Trend View' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 09, BLOCK 01 LOT 35' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '5453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2509' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265046' WHERE `Matrix_Unique_ID` = '211438902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:09:40.603' ,`MLSNumber` = '24898489' ,`ListAgentFullName` = 'George Gallagher' ,`ListOfficeName` = 'Westwood Shores Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.943624' ,`Longitude` = '-95.339668' ,`PhotoCount` = '23' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '274720.00' ,`Status` = 'Active' ,`StreetName` = 'Pinnacle' ,`StreetNumber` = '232' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS NEW CONSTRUCTION HOME ON GOLF COURSE!! 3 Bedroom, 2 Bath, 2 Car Garage and Did I Mention it’s On The Golf Course! Kitchen is open to Family and Dining Room and there are Plenty of Windows to Enjoy the Views! Granite Countertops and a Nice Sized Pantry. Primary Bedroom has a Very Generous Walk-In Closet! Located in the Highly Sought-After Westwood Shores Community! This Is A Very Active Community With 24Hr Manned Access Gate, Country Club with 19th Hole Bar & Grill, Fitness Center, 18 Hole Golf Course, Swimming Pools, Tennis Courts, (Pickle Ball Courts Coming Soon!) 9 Interior Lakes, Marina with Gas/Boat Ramp, + Access to Campground with Activity Center/Community Center and So Much More! Call Today to Book Your Appointment!' ,`Acres` = '0.1263' ,`Area` = '42' ,`BuilderName` = 'Trend View' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 09, BLOCK 01 LOT 26' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2509' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265046' WHERE `Matrix_Unique_ID` = '211444294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:11:11.440' ,`MLSNumber` = '36945990' ,`ListAgentFullName` = 'George Gallagher' ,`ListOfficeName` = 'Westwood Shores Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.941686' ,`Longitude` = '-95.341606' ,`PhotoCount` = '23' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '273712.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway Drive' ,`StreetNumber` = '111' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1659' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL NEW CONSTRUCTION HOME ON TWO LOTS ON THE GOLF COURSE!! 3 Bedrooms with One Being a Possible Study/Office, 2 Baths, Covered Back Porch, Nice Size Kitchen, Granite Countertops, and the Primary Bedroom has a Walk-In Closet! Located in the Highly Sought-After Westwood Shores Community! This Is A Very Active Community With 24Hr Manned Access Gate, Country Club with 19th Hole Bar & Grill, Fitness Center, 18 Hole Golf Course, Swimming Pools, Tennis Courts/ Pickle Ball Courts/ 9 Interior Lakes, Marina with Gas/Boat Ramp, + Access to Campground with Activity Center/Community Center and So Much More! Call Today to Book Your Appointment!' ,`Acres` = '0.2058' ,`Area` = '42' ,`BuilderName` = 'Trend View' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 08, BLOCK 4 LOTS 59 & 60' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '8965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2509' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265046' WHERE `Matrix_Unique_ID` = '211448081' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:18:51.497' ,`MLSNumber` = '81115565' ,`ListAgentFullName` = 'Bobbie Callahan Spain' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076577' ,`Longitude` = '-95.193207' ,`PhotoCount` = '18' ,`PostalCode` = '77339' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaver Glen' ,`StreetNumber` = '3311' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home located in the Elm Grove subdivision of Kingwood, featuring 3 beds, 2 baths, a large backyard w/ fresh sod, and new interior paint! Laminate floors throughout the home, with tile in the kitchen and both bathrooms. Absolutely no carpet! Kitchen features granite countertops and tile backsplash. Large living space connected to formal dining w/ views from the kitchen! Primary bedroom includes private en-suite and large walk-in closet. 2nd bedroom has its own private entrance into secondary/hall bathroom. Utility room located inside house w/ direct access to attached 2 car garage. Access to community green belt trails and parks!' ,`Acres` = '0.1736' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 11 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '493' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '4235' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265047' WHERE `Matrix_Unique_ID` = '211449431' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:56:22.483' ,`MLSNumber` = '7750253' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938820' ,`Longitude` = '-96.037853' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '7' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Bonanza' ,`StreetNumber` = '12209' ,`StreetSuffix` = 'Place' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hello Pilots! Live with your Airplanes - all of them! 80 ft wide x 120 ft deep, Lighted Hangarminium at the Gated access Airpark of Fair Weather Field (TX42) in Brookshire, Texas. You\'ll own 1 acre right on the runway. The Airpark has multiple Runways with a 3,375 ft long asphalt 13/31 runway & a 2,400 ft 18/36 turf strip. Remotely operated 60 ft wide x 14.5 ft high Higher Power Hydraulic Hangar Door for your aircraft. GENERAC Backup Electric system. A 14 ft x 14 ft push button Roll Up door on the driveway side for your Cars, RV\'s and toys. Air-conditioned Aircraft Build/Work Shop with a Fold Away Wall to get airplanes in and out. Dumb waiter installed for supplies to the upstairs. 1/2 bath in the hangar area. Almost 2000 square feet of air conditioned living space upstairs. Open kitchen into the family room. 2 separate primary bedrooms, each with their own bathroom. Private Office/Study that has it\'s own external door to the balcony. Huge Utility Room and Pantry. #SearchTexasAirparks' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S474600 FAIR WEATHER FIELD BLK 1 LOT 3 ACRES 1.0' ,`LotDesciption` = 'Airpark' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Fair Weather Field' ,`TaxAmount` = '7829' ,`TaxRate` = '1.8575' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265047' WHERE `Matrix_Unique_ID` = '211762980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:06:46.260' ,`MLSNumber` = '69562764' ,`ListAgentFullName` = 'Courtney Robertson' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770234' ,`Longitude` = '-95.473476' ,`PhotoCount` = '37' ,`PostalCode` = '77056' ,`RoomCount` = '13' ,`ListPrice` = '2599000.00' ,`Status` = 'Active' ,`StreetName` = 'Point Broad Oak' ,`StreetNumber` = '127' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '7593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Iconic French Normandy architecture designed by Robert Dame on a charming gated street in Broad Oaks. The elegant custom, one-owner home features grand rooms with 12’ ceilings on the first floor, picturesque balconies and a patio you will never want to leave. The open kitchen boasts a large island, 2 dishwashers, double ovens, gas range and a butler’s pantry leading to the dining room. Family room with set of French doors that lead to the covered patio with outdoor kitchen, and yard space. The primary suite has it all, from 2 full bathrooms and walk-in closets to a separate vanity area. Unwind in the gorgeous library featuring a wet bar, private balcony, and pocket door access to the primary suite. Secondary bedrooms are generously sized and all feature ensuite baths with walk-in closets. Other standouts include a 3 car garage with additional storage room, 2 staircases, elevator capable, abundant storage with walk up access on the third floor, home office/flex space, guest parking.' ,`Acres` = '0.233' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 POINT BROAD OAKS R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10151' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '7000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Other Style,Traditional' ,`Subdivision` = 'Point Broad Oaks R P' ,`TaxAmount` = '53605' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265047' WHERE `Matrix_Unique_ID` = '212204851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:52:06.040' ,`MLSNumber` = '9677273' ,`ListAgentFullName` = 'Samantha Medve' ,`ListOfficeName` = 'Schultz Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153192' ,`Longitude` = '-96.690400' ,`PhotoCount` = '21' ,`PostalCode` = '78932' ,`RoomCount` = '2' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Hill' ,`City` = 'Carmine' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable barndominium is located under tree shade. There are some beautiful oak trees that frame the driveway and yard. The home was built in 2017 and remodeled in 2022. Updates include, new kitchen cabinets and hardware, new refrigerator, new dishwasher, new microwave, new range, new washer and dryer, new toilet and new water heater. Pex piping was also added and the home has had new vinyl flooring installed.\r\n\r\nBoth bedrooms have closets. The open floor plan makes the home feel larger. Some furniture can convey in the house.\r\n\r\nThis home is about 5-10 min from Round Top and located within about 1 mile of JWs in Carmine.\r\n\r\nBuyer to verify dimensions.' ,`Acres` = '0.472' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ULLRICH ADDITION LOT 1, .472 ACRES, HSE, C/PORT' ,`LotDesciption` = 'Other' ,`LotSize` = '20560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '206 - Round Top-Carmine' ,`SchoolElementary` = 'ROUND TOP-CARMINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROUND TOP-CARMINE HIGH SCHOOL' ,`SchoolMiddle` = 'ROUND TOP-CARMINE HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Ullrich Add' ,`TaxAmount` = '1337' ,`TaxRate` = '1.4344' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265047' WHERE `Matrix_Unique_ID` = '212444810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T12:27:28.440' ,`MLSNumber` = '30793169' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895317' ,`Longitude` = '-95.740402' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '336990.00' ,`Status` = 'Active' ,`StreetName` = 'Vida Costa' ,`StreetNumber` = '8111' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love Where You Live in Marvida! This community of new homes in the Houston area of Texas features a clubhouse for neighborhood gatherings, a sparkling community pool with a winding lazy river, and more. Children can cool off on the splash pad, meet new friends at the playground, and attend highly-rated Cypress-Fairbanks schools. Ideally located north of FM 529 between Fry Road and the Grand Parkway, Marvida has easy access to Highway 290 and I-10, making the commute to Katy, The Energy Corridor, and Downtown Houston a breeze! This NEW construction home is a 1-Story, 3 Beds with flex space, 2 Baths & covered patio! The kitchen features light noca kitchen backsplash, chocolate cabinets, vineyard granite countertops, stainless steel undermount kitchen sink & sorrel floor tile. The primary suite offers double sinks, oversized walk-in closet, walk-in shower with shower seat. The home is Complete with full sod, sprinkler system & garage door opener! Will be ready for a September move-in!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Bock 6 Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5460' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265048' WHERE `Matrix_Unique_ID` = '212468844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:37:35.617' ,`MLSNumber` = '13708055' ,`ListAgentFullName` = 'Clay Ryan' ,`ListOfficeName` = 'Ryans Real Estate Brokers, LLC' ,`SellingAgentFullName` = 'Emanuel Marsis' ,`SellingOfficeName` = 'Keller Williams Realty - Memor' ,`Latitude` = '29.724697' ,`Longitude` = '-95.423357' ,`PhotoCount` = '36' ,`PostalCode` = '77005' ,`RoomCount` = '9' ,`ListPrice` = '840000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wroxton' ,`StreetNumber` = '2830' ,`StreetSuffix` = 'Road' ,`City` = 'West University Place' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property offers a wonderful opportunity for those interested in renovating or building new. It has been in the same family for generations. It has been well maintained throughout the decades, and the major systems are in good working condition. The home has 1,740 square feet of living space and sits on a lot which is 6,048 square feet. The home offers 3 bedrooms, one and one half bathrooms, large living room, formal dinning and kitchen with breakfast room. There is a privacy fence, driveway gate and two car detached garage with laundry connections. All measurements are approximate.' ,`Acres` = '0.1388' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 25 & 26A BLK 2 MONTICELLO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6048' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Monticello' ,`TaxAmount` = '16187' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265048' WHERE `Matrix_Unique_ID` = '212514536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-27T11:34:04.273' ,`MLSNumber` = '4839113' ,`ListAgentFullName` = 'David Jones' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.824687' ,`Longitude` = '-95.116180' ,`PhotoCount` = '50' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Lone Oak' ,`StreetNumber` = '346' ,`StreetSuffix` = 'Road' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath Mobile Home on 2 lots. There are 2 drive ways and an 8x8 outbuilding. Front covered deck along the whole front. This home is near the end of a in depth remodeling. Should be ready to move in in mid October. New Roof, all flooring replaced, replaced all water lines and fittings with PEX. New kitchen cabinets and tops, bath room vanity\'s. Took out the old fire pla