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'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','204134901','1675106916','204134901','2023-01-09T17:57:20.363','77181903','Vinod Ramani','Urban Living','','','29.850348','-95.430597','16','77091','12','334990.00','Active','Burt','5806','Street','Houston','3','1','3','1771','Single-Family','Just north of 610 in Houston\'s growing neighborhood of Acres Homes lies North Moderno. These 2 story free standing homes have a 2 car private driveway. Each home features 3 bedrooms and 3 1/2 baths. The 1st floor reveals an open concept kitchen and living room. Each unit has designer finishes throughout that give the home the WOW factor you\'ve always wanted. The spacious backyard can be used year round. The master bath posses a spa like tub and separate shower perfect after a long day. Schedule a time today to see your dream home.','','9','Joes Construction','','','','No Disclosures','1','','','Northwest Houston','Central Electric,Central Gas','0','Lot 9 Block 4 North Moderno','Other','','','','','1','To Be Built/Under Construction','2','','0','','','','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Appointment Required','Builder','2','Contemporary/Modern','North Moderno','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T18:38:30.850' ,`MLSNumber` = '52437746' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794944' ,`Longitude` = '-95.821420' ,`PhotoCount` = '43' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '1079000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '5602' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '5304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Iconic property in the heart of Old Towne Katy. Limestone 3 bedroom, 1.5 bath home built in 1953 (2033 sq.ft) on a huge lot with beautiful big trees. Large air-conditioned shop (2715 sq. ft.) can have multiple uses - business, additional living space, storage, etc. Shop has kitchenette, full bath. Additional studio space (556 sq.ft.) is attached to home by shared covered carport. Automatic gate access and paved parking lot. Site well suited to home/business arrangement. Zoned residential/commercial. Don\'t delay, Call today!' ,`Acres` = '0.831' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PT E PT LT 6 TR 14A KATY OL .831AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '36198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Town/Katy' ,`TaxAmount` = '11277' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106916' WHERE `Matrix_Unique_ID` = '208933963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:18:24.847' ,`MLSNumber` = '45886204' ,`ListAgentFullName` = 'Jane Hill' ,`ListOfficeName` = 'J Hill Properties' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.216164' ,`Longitude` = '-96.425166' ,`PhotoCount` = '28' ,`PostalCode` = '77833' ,`RoomCount` = '3' ,`ListPrice` = '639000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Oak Hill' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Drive' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss your opportunity to buy this Rare find in Oak Hill Acres! A beautiful well-maintained sprawling one story home with a resort feel! For the discriminating buyer looking for a unique property offering, privacy, tranquility, and beauty! This is a home that you must see if you\'re looking for some space around you and a large home with a pool! The gorgeous 1.2 acres has nice mature trees, sprinkler system, french drains, fully landscaped, 30 Amp RV plug, RV drain, outdoor lighting in majestic oak trees, fenced heated pool with hot tub and flagstone coping! Two storage buildings, whole house generator, 2 car garage, one car carport and circular drive. The home offers multiple living areas, formal dining, kitchen nook, butler\'s pantry, office, 3 bedrooms, 2 full baths, 2 half baths, large utility room with sink, custom window coverings and more. The owners said that they love their home and they have thoroughly enjoyed living in the neighborhood.' ,`Acres` = '1.2' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'OAK HILL ACRES SEC I , LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '52272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Oak Hill Acres Sec I' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106917' WHERE `Matrix_Unique_ID` = '209334479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:31:22.203' ,`MLSNumber` = '10842839' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Andrea Dunn' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '29.999314' ,`Longitude` = '-95.795801' ,`PhotoCount` = '9' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '307340.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mersmann Ridge' ,`StreetNumber` = '16127' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! BEAUTIFUL BRICK AND STONE EXTERIOR! Impressive Interior Layout with Island Kitchen Open to Large Family Room & Dining Area! Modern Finishes with Hard Surface Flooring! Privately Located Primary Suite - Wonderful Bath with Shower & Tub! Big Walk-In Closet! Convenient Indoor Utility Room! Covered Back Patio! Great Community with Easy Access to 290! Subdivision Offers Pool, Walking Trails, Recreation Center, & so much more! WOW! Hurry and call TODAY!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 2 Section 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106917' WHERE `Matrix_Unique_ID` = '212133896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:16:30.470' ,`MLSNumber` = '90895217' ,`ListAgentFullName` = 'Dustan Gawthorp' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788973' ,`Longitude` = '-95.580858' ,`PhotoCount` = '18' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Forest Glen' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three-story home rivals new construction at a fraction of the cost. Welcome home to Sherwood Forest Glen, an exclusive gated community in West Houston zoned to award winning Spring Branch ISD. Step into the entry with Terrazzo flooring that flows into an expansive first floor living and entertainment space with hardwood floors, floor to ceiling windows, and abundant natural light. Walk outside to your private backyard garden with serenity and calmness, also perfect for that social BBQ gathering. Three generously sized bedrooms and two bathrooms are found on the second floor living space for your retreat. The third-floor space offers an additional flex room with full bath for your overnight guests, an office, or possibly a media room for a relaxing evening. The location has convenient access to all major freeways, shopping and dining experiences around the energy corridor and Memorial areas. Call today to schedule your private viewing of this impressive home before its gone.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '2451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'SHERWOOD FOREST GLEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106917' WHERE `Matrix_Unique_ID` = '212682425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:33:34.377' ,`MLSNumber` = '96904685' ,`ListAgentFullName` = 'Alejandra Silva' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.383014' ,`Longitude` = '-95.555964' ,`PhotoCount` = '26' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '265500.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Shores' ,`StreetNumber` = '9726' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'YOU WANT TO BE NEAR THE LAKE THIS IS THE PERFECT ONE STORY HOME FOR YOU IN TWIN SHORES. FRESHLY PAINTED WITH NEW SS APPLIANCES AND NEW FLOOR IN THE BEDROOMS NO CARPET.\r\nMARINA ACCESS JUST DOWN THE ROAD.\r\nDONT WAIT TO CALL THIS MY HOME.' ,`Acres` = '0.1713' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN SHORES 01, LOT 107' ,`LotDesciption` = 'Other' ,`LotSize` = '7461' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Twin Shores 01' ,`TaxAmount` = '4283' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106917' WHERE `Matrix_Unique_ID` = '213932897' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T18:31:44.920' ,`MLSNumber` = '12976619' ,`ListAgentFullName` = 'Jessica Clements' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820854' ,`Longitude` = '-95.731921' ,`PhotoCount` = '26' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Rain' ,`StreetNumber` = '20710' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 20710 Pine Rain! This beautiful 2 story home sits on a quiet cul-de-sac street with a welcoming brick exterior and large backyard! You\'ll love the incredible features it has to offer including NO Carpet, a game room, bonus space, modern kitchen and large windows letting in tons of natural light! This home has been well kept and updated with travertine tile, wood look floors, white kitchen cabinets, and led lighting. Raintree village is conveniently located near shopping, dining, and zoned to Katy ISD! Schedule your private showing today!' ,`Acres` = '0.1304' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 3 RAINTREE VILLAGE SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree Village Sec 06' ,`TaxAmount` = '6131' ,`TaxRate` = '2.5633' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106918' WHERE `Matrix_Unique_ID` = '214033553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:22:17.107' ,`MLSNumber` = '21798891' ,`ListAgentFullName` = 'Christopher King II' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.121464' ,`Longitude` = '-95.358877' ,`PhotoCount` = '31' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '159000.00' ,`Status` = 'Active' ,`StreetName` = 'Annette' ,`StreetNumber` = '13009' ,`StreetSuffix` = 'Road' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Want to have solitude but still be close to town? Look no further because this manufactured home sits on 1/2 acre of unrestricted land with no backdoor neighbors. Located off of 523 and 2004 so you will have an easy commute to all nearby cities. There is a paved driveway to park behind the house, a storage shed for your tools and a riding lawn mower. Also, plenty of more land to do what you want.' ,`Acres` = '0.551' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'WILLOWBREEZE FARM (A0341 W M MCDERMOTT) LOT 31 MH DESIGNATED' ,`LotDesciption` = 'Other' ,`LotSize` = '24002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Willowbreeze Farm A0341 W M M' ,`TaxAmount` = '2697' ,`TaxRate` = '2.0772' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106918' WHERE `Matrix_Unique_ID` = '214146975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:30:35.293' ,`MLSNumber` = '80165519' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.997556' ,`Longitude` = '-95.787185' ,`PhotoCount` = '8' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '309990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Jordan Meadow Way' ,`StreetNumber` = '16023' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely brand NEW DR Horton one story!! Charming curb appeal! This Open Concept home has a beautiful kitchen open to the dining and a huge living room! Primary bathroom suite with separate soaking tub and shower! Great walk in closet! Modern Features include 36\" Flat panel maple cabinets, exotic granite, 4 burner gas cooktop w/SS appliances in the kitchen! Tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and so much more! Large covered patio overlooks the PRIVATE backyard! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/1/12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6561' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106918' WHERE `Matrix_Unique_ID` = '214330081' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:50:43.807' ,`MLSNumber` = '9839026' ,`ListAgentFullName` = 'Jose Garza' ,`ListOfficeName` = 'Alchemist Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216150' ,`Longitude` = '-95.597129' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '1090000.00' ,`Status` = 'Active' ,`StreetName` = 'Clubhouse' ,`StreetNumber` = '10603' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful home located in Lake Windcrest Magnolia TX sitting on a 1.05 acre lot. This home has been professionally remodeled from top to bottom. The home features 5 bedrooms and 5 full bathrooms, 3 car garage, a backyard oasis and brand new appliances!' ,`Acres` = '1.048' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE WINDCREST 05, BLOCK 1, LOT 20' ,`LotDesciption` = 'Cleared' ,`LotSize` = '45651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Lake Windcrest 05' ,`TaxAmount` = '15947' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106918' WHERE `Matrix_Unique_ID` = '214340425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:17:10.857' ,`MLSNumber` = '50644283' ,`ListAgentFullName` = 'Courtney Johnson Rose' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478928' ,`Longitude` = '-95.374060' ,`PhotoCount` = '32' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '490990.00' ,`Status` = 'Active' ,`StreetName` = 'Water Glen' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You must see this home! Its Like New! Less than 5 years old and still has the 10yr. structural warranty from the builder. Wood-style tile floors throughout the home. Carpet on bedroom floors for comfort. It has a gorgeous and spacious kitchen that\'s open to the living and dinning area. Centered and perfect for family or entertaining. Fenced backyard with covered patio. This home has been exceptionally well-kept and features 4 br, study, 3 full baths, & attached 2 car garage all on one floor. This is the one, do not miss it.' ,`Acres` = '0.1722' ,`Area` = '5' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLUEWATER LAKES SEC 2 (MANVEL) BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bluewater Lakes' ,`TaxAmount` = '13631' ,`TaxRate` = '3.7274' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106919' WHERE `Matrix_Unique_ID` = '214638854' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:29:48.700' ,`MLSNumber` = '80967975' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Chase Smith' ,`SellingOfficeName` = 'The Good Label Real Estate' ,`Latitude` = '29.997240' ,`Longitude` = '-95.785581' ,`PhotoCount` = '9' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '323740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mersmann Ridge' ,`StreetNumber` = '16106' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely BRAND NEW DR HORTON 1 STORY! Beautiful curb appeal!! Wonderful floor plan with 4 bedrooms, island kitchen, spacious living areas and so much more! This home also features modern finishes, granite counter tops, hard surface flooring and stainless steel appliances in the kitchen! Primary suite bath features double sinks and a separate shower and tub! Great outdoor space and large covered patio! Beautiful community with the best amenities! Come take a look! Call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '36/2/12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106919' WHERE `Matrix_Unique_ID` = '214659964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:28:57.673' ,`MLSNumber` = '93170403' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Pamela Roth' ,`SellingOfficeName` = 'Roth & Company Real Estate' ,`Latitude` = '29.997165' ,`Longitude` = '-95.785581' ,`PhotoCount` = '9' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '309340.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mersmann Ridge' ,`StreetNumber` = '16111' ,`StreetSuffix` = '' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming BRAND NEW DR HORTON 1 STORY! Beautiful curb appeal!! Wonderful floor plan with 4 bedrooms, island kitchen, spacious living areas and so much more! This home also features modern finishes, granite counter tops, hard surface flooring and stainless steel appliances in the kitchen! Primary suite bath features double sinks and a separate shower and tub! Great outdoor space and large covered patio! Beautiful community with the best amenities! Come take a look! Call today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '20/2/12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675106919' WHERE `Matrix_Unique_ID` = '214670068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T17:24:07.710' ,`MLSNumber` = '53559652' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.267559' ,`Longitude` = '-95.591929' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '14' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Pin Oak' ,`StreetNumber` = '7610' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Craftsman on 4.6 UNRESTRICTED Acres! 1-Story 3624 SF, 4 BD, 2 BA Main Home +3 Car Garage w/Upstairs Bonus Room+ 2 Carports w/Electricity (1 w/50amp for RV)+2 Storage Sheds + A/C Workshop (all w/Electricity) + Above Ground Pool w/Deck + 720 SF 1BD, 1BA w/Golf Cart Carport + Shed. Property Has 2 Driveways Each w/Automatic Gate. Both Homes Have Their Own Septic, Utilities, & Tax Records So Land Could Be Subdivided. Gourmet Kitchen Has Kent Moore Soft Close Cabinets w/Slide Outs, Thermador Six Burner Stove + Double Oven, Pot Filler, Convection Microwave, Commercial Grade Frigidaire Refrigerator, 2 Islands + Breakfast Bar, a Lg Walk-In Pantry. Back Patio Is Outdoor Kitchen Ready w/Plumbing & Gas. LG Concrete Slab -Also Has Plumbing & Gas. Whole Home Generator, 500 Gallon Propane Tank, Tray Ceilings, Recessed Ambient Lighting, 2 sets of washer & dryers (all are included). Garage Has Extra Storage & Taller Than Standard Doors So Large Vehicles Fit. 30x50 Slab w/Plumbing & Electricity.' ,`Acres` = '4.6' ,`Area` = '39' ,`BuilderName` = 'America\'s Home Place' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S942000 - VALLEYWOOD ACRES, LOT 100, ACRES 4.6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '200376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Salt Water,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Ranch' ,`Subdivision` = 'Valleywood Acres' ,`TaxAmount` = '7215' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106919' WHERE `Matrix_Unique_ID` = '214734481' --> 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','214976932','1675106920','214976932','2023-01-09T17:14:28.123','2172604','Martin Reyes','BHGRE Gary Greene','','','29.871874','-95.348246','6','77093','6','425000.00','Active','Trenton','2414','Road','Houston','1','1','3','1160','Single-Family','Location, simplicity and beauty. Welcome home to 2414 Trenton Rd, Houston, Texas! 2 beds, 1 and half bath home in a beautiful corner lot. Home is being sold as is. Come See it today!','0.8724','34','','','','','Sellers Disclosure','1','','','Northside','Central Gas','0','LT 118 & TRS 119A & 120B WOODSDALE','Wooded','38000','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','SCARBOROUGH ELEMENTARY SCHOOL (HOUSTON)','SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER','PATRICK HENRY MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Woodsdale','3497','1.9741','Public Sewer,Public Water','1961','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215117982','1675106920','215117982','2023-01-09T17:47:31.123','91258924','Lance Loken','Keller Williams Platinum','','','29.945072','-95.204058','32','77346','8','355000.00','Active','Royce Holly','15414','Drive','Humble','3','0','4','2370','Single-Family','Home sits on an oversized lot in a gated section. Outside, the home boasts a gorgeous brick and stone exterior, full gutters, a large backyard and covered patio! Inside, you’ll find grand 10’ ceilings with 8’ doors, 2 bedrooms and 2 full bathrooms on the first floor with 2 more bedrooms and 3rd full bathroom on the second floor. Features/upgrades this house offers are: upgraded lighting, gray wood look tile in all common areas and bathrooms, 2” faux wood blinds throughout, bright white kitchen with 42” cabinets, tile backsplash, and crown molding, first floor primary suite has crown molding, soaking tub, separate shower, and large walk in closet, 2 large upstairs bedrooms with walk in closets, tankless WH, dual zone HVAC, wired alarm and MONITORING INCLUDED with POA , Ring flood light camera and Ring doorbell. Balmoral features a two-acre lagoon, swimming pool, splash pad, playground, tennis court, basketball court, gym, walking/biking trails, dog park, and the Blue Lagoon Bar & Grill.','0.1636','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Summerwood/Lakeshore','Central Gas','1','LT 47 BLK 3 BALMORAL SEC 2','Subdivision Lot','7125','Appraisal District','','1780','0','','2','Gas Oven','0','','','Gas Range','','Composition','29 - Humble','RIDGE CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Balmoral','8867','2.9873','Water District','2018','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215538932','1675106920','215538932','2023-01-09T17:00:58.367','37964385','Cory Kammerdiener','Newhomeprograms.com LLC','','','30.087909','-95.430865','10','77373','7','288000.00','Active','Northgate Springs','1027','Drive','Spring','2','1','4','2447','Single-Family','Location, location, location! Located in the well-established community of Northgate Crossing @ The Park, this Lake Ridge Builders home offers convenient assess to I-4, I-99 Grand Parkway and the Hardy Toll Rd. Offering a guest bedroom suite downstairs is a rare find. Great for gatherings when combine with a formal dining area, high-top bar, and an over-sized breakfast nook for maximum entertaining of guest. The very spacious upstairs game room / media room is a bonus for social gatherings to bring the household together for special events.','0.1263','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Spring East','Central Gas','1','LT 7 BLK 2 PARK AT NORTHGATE CROSSING SEC 3','Subdivision Lot','5500','Appraisal District','','550','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','NORTHGATE ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Park/Northgate Xing','7774','3.1142','Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215574553','1675106920','215574553','2023-01-09T17:28:06.770','67020215','Ronnie Matthews','D.R. Horton Homes','Aubrie Layne','Martha Turner Sotheby\'s International Realty','29.998036','-95.787545','9','77447','6','360740.00','Pending Continue to Show','Jordan Meadow','16126','Way','Hockley','2','1','4','2565','Single-Family','MOVE-IN READY! FABULOUS NEW D. R. HORTON BUILT 4/5 BEDROOM! Ultra Versatile Interior Layout with Home Office/Study/5th Bedroom & Primary Suite Downstairs! Gourmet Island Kitchen Opens to Spacious Dining & Living Areas! Privately Located First Floor Primary Suite - Fabulous Bath with TWO Walk-In Closets + Dual Sinks, Separate Tub, & Shower! Home Office/Study with Walk-In Storage Closet - Use as 5th Bedroom if Desired! Massive Gameroom/Media Room! Three Big Secondary Bedrooms Up - One with Walk-In Closet! Covered Patio Enhances Tranquil Backyard! Easy Access to 290 & the Grand Parkway! MUST SEE!','0.1618','25','D. R. Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Cypress South','Central Gas,Zoned','1','LT 12 BLK 2 STONE CREEK RANCH SEC 12','Subdivision Lot','7046','Appraisal District','','700','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Stone Creek Ranch','1618','3.1924','Public Sewer,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215670706','1675106920','215670706','2023-01-09T17:27:18.507','7066614','Ronnie Matthews','D.R. Horton Homes','Mark Haley','eXp Realty LLC','29.998036','-95.787545','9','77447','8','347740.00','Pending Continue to Show','Jordan Meadow','16115','Way','Hockley','3','0','4','2294','Single-Family','FANTASTIC NEW D. R. HORTON BUILT 4 BEDROOM! Sought-After Interior Layout with Two Bedrooms & Baths Downstairs + 3 Full Baths! Sleek Island Kitchen with Large Corner Pantry - Opens to Supersized family Room! Privately Located First Floor Primary Suite Features Lovely Garden Bath with Dual Sinks & Massive Walk-In Closet! Second Bedroom/Guest Suite Downstairs with Adjoining Full Bath! Convenient Indoor Utility Room PLUS Under Stairs Storage! Huge Gameroom/Media Room! Two Big Secondary Bedrooms Up - One with Walk-In Closet! Covered Patio Enhances Wonderful Backyard! Carrier 16 SEER A/C, Tankless Water Heater, Built-In Home Automation System Controlled from Single App, & Great Appliance Package Included! Easy Access to 290, Outlet Mall, & the Grand Parkway! WOW!','0.1728','25','D. R. Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Cypress South','Central Gas,Zoned','1','LT 4 BLK 2 STONE CREEK RANCH SEC 12','Subdivision Lot','7604','Appraisal District','','700','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Stone Creek Ranch','1630','3.1924','Public Sewer,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216030726','1675106920','216030726','2023-01-09T17:53:25.560','75372987','Ashley Garcia','Newhomeprograms.com LLC','','','29.767402','-94.673054','4','77514','3','234990.00','Active','Beaumont','1293','Street','Anahuac','2','0','3','1345','Single-Family','The Audrey Plan - charming 3/2 on approximately 1/4 acre lot. The kitchen includes granite countertops, has a breakfast bar, plenty of shaker-style cabinets, gas oven and range, for the chef in your family and opens up into the family room. The primary and second bedrooms have walk-in closets. Reach on out to schedule a tour! (Please note: renderings are for descriptive purposes only.)','0.252','53','Hart Homes','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Chambers County East','Central Gas','0','Lot 15 BK 14 Willcox #3','Cleared','','','','0','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','4 - Anahuac','ANAHUAC ELEMENTARY SCHOOL','ANAHUAC HIGH SCHOOL','ANAHUAC MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','W.D. Willcox','','2.9736','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216129667','1675106920','216129667','2023-01-09T17:55:21.213','33417519','Christopher Grande','Grand Realty','','','30.376099','-95.646925','38','77316','9','299900.00','Active','Sunrise Maple','18410','Drive','Montgomery','2','1','4','1957','Single-Family','Turn key ready - Completely renovated - Desirable cul-de-sac location - Within walking distance to Lake Conroe - Fresh paint inside and out - New stainless steel appliances - New electrical fixtures - New plumbing fixtures - All new flooring - New granite counter tops - New hardware - New blinds - Fresh landscaping - Master down w/ double sinks and separate shower/bath - Open floor plan - Ready for quick move in!','0.1269','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','Lake Conroe Area','Central Gas','1','S909205 - SUNRISE RANCH 05, BLOCK 2, LOT 2','Cul-De-Sac','5529','Appraisal District','','200','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Sunrise Ranch 05','4686','1.8242','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216216256','1675106920','216216256','2023-01-09T17:19:02.673','65179134','Jared Turner','LennarVillageBldr-JaredTurner','','','29.835511','-94.989595','6','77521','8','280000.00','Active','Tindarey Glen','4714','Drive','Baytown','2','0','3','1830','Single-Family','BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Wildflower IV Collection Homes in Sterling Point! The Chrysanthemum, Elevation \"A\" provides an excellent layout for families. This single-story home provides a great layout with everything you need on one level. Off the foyer is a study with double doors, which could be used as an office or formal living room. Just passed the foyer is an open layout shared by the kitchen, breakfast room and family room that leads to a back patio. The owner’s suite enjoys a private en-suite bathroom and walk-in closet, while two secondary bedrooms provide quiet spaces for residents or guests.\r\n**Estimated Completion Date, March 2023**','','2','Lennar Homes','','','','Mud,Other Disclosures','','','','Baytown/Harris County','Central Gas','1','SEC 0003 BLK 001 LOT 027','Subdivision Lot','','','','950','1','To Be Built/Under Construction','3','','0','','','','','Composition','23 - Goose Creek Consolidated','PUMPHREY ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Sterling Point','','3.735','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216220434','1675106920','216220434','2023-01-09T17:02:23.133','98817168','Christina Flores','eXp Realty, LLC','','','30.159634','-95.077257','27','77327','6','252990.00','Active','Road 5102C','57','','Cleveland','2','0','3','1321','Single-Family','Welcome home to The Bungalow Floor Plan a Casas-Houston new construction home. This 3 bedroom 2 bath home features 9\' ceilings with open concept kitchen, family and dinning area. The kitchen cabinets boast crown molding and granite counter tops with under cabinet lighting. The Bungalow comes loaded with energy features such as a 16-SHEER HVAC system, Low-E windows, blown insulation and much more. Double wide driveway plus a two car garage makes it easy to store your weekend toys for example bikes, motorcycles, wave runners and so much more. Take advantage of the low tax rate at 1.99 and low POA with brand new schools and a Splash Pad. Appliance package includes Refrigerator, dishwasher, microwave and stove black on stainless steel. Schedule your tour today! To Be Built New Construction','0.34','52','Casas-Houston','','Washer Connections','','No Disclosures','1','','','Cleveland Area','Central Gas','1','SANTA FE, SEC 3, BLOCK 50, LOT 5177, ACRES .16','Cleared','6969','Appraisal District','','120','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','100 - Cleveland','COTTONWOOD SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Contemporary/Modern','Santa Fe','616','1.9238','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216221136','1675106920','216221136','2023-01-09T17:23:48.053','44643437','Elisa Gonzalez','Keller Williams Professionals','','','29.737592','-95.324852','31','77023','5','290000.00','Active','Curtin','5019','Street','Houston','1','0','3','1191','Single-Family','Here is your opportunity for a fresh start or renovate existing home in corner lot. Lots of renovated and new construction going on in this subdivision/area.','0.1189','4','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','East End Revitalized','Central Gas','0','LT 3 BLK 1 EASTWOOD OAKS','Corner','5180','Appraisal District','','','0','','1','Electric Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','CAGE ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Lockbox Front','Appraisal District','1','Traditional','Eastwood Oaks','4056','2.3307','Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216222656','1675106920','216222656','2023-01-09T18:28:39.143','2523977','Ashley Jackson','Martindale Real EstateInvestments','','','30.781795','-94.422484','32','75979','7','175000.00','Active','Pine','707','Street','Woodville','2','1','4','1736','Single-Family','Precious 4 Bedroom 2.5 Bath Brick Home is ready for you and yours to move in and enjoy. The home features 2 living space, office space, large kitchen with breakfast bar open to living room with wood burning stove, backyard area with portable building for storage and situated near schools, hospital and all the conveniences of living in the city limits. The home sits on 0.251+/-Acres and is move-in ready! Call today to schedule your showing!','0.251','48','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Stove','1','Tyler County','Central Electric','0','A0657 J. WHEAT BLOCK 42 8 ACRES 0.2510','Cleared','10934','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range,Freestanding Range','','Composition','253 - Woodville','WHEAT ELEMENTARY SCHOOL','WOODVILLE HIGH SCHOOL','WOODVILLE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Josiah Wheat/Abs #657','1690','2.3937','Public Sewer,Public Water','1966','Appraisal District'); --> New record created successfully