Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T08:14:17.940' ,`MLSNumber` = '36477684' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440138' ,`Longitude` = '-95.396000' ,`PhotoCount` = '41' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '389975.00' ,`Status` = 'Active' ,`StreetName` = 'Eliot' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Place' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your open and spacious new home in Meridiana! The Baileywood by David Weekley Homes is built from the same floor plan as our model home. Brick and stone accents contribute to the welcoming charm of this one-story home situated on great homesite with no back neighbor. The front door opens onto gorgeous open-concept living spaces with an easy traffic flow and sight lines that extend all the way to the backyard. A streamlined kitchen with quartz countertops and stainless steel appliances rests at the heart of the home, and maintains an open view to the dining and family spaces. Enjoy the spacious Owner’s Retreat with a walk-in closet and an extended shower in the Owner’s Bath. The enclosed study makes an ideal home office, game room, or media studio.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 08 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706641' WHERE `Matrix_Unique_ID` = '206403750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:14:04.933' ,`MLSNumber` = '76960889' ,`ListAgentFullName` = 'Jenifer Somich' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569214' ,`Longitude` = '-95.042402' ,`PhotoCount` = '33' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Pebblebrook' ,`StreetNumber` = '427' ,`StreetSuffix` = 'Drive' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautiful & rare 5 bedroom, 2 bath home is ready for move-in! Open concept with the master suite downstairs, plus formal living and dining! Great UPDATES completed in 2020- New carpet, New windows on front of house, New wood-look tile flooring, New granite countertops in kitchen & bathrooms, New subway tile backsplash in kitchen, New lights/fixtures/fans/faucets, New stainless appliances, Bathrooms completely remodeled with tile tub backsplash surround plus new toilets! New interior paint in 2022, fans in all bedrooms & kitchen features double ovens. You will love the wall of windows in the living room overlooking the huge deck with lush landscaping & the oversized detached garage! Ample driveway space for parking. Family friendly subdivision with scheduled family activities & close to clear lake water! Low taxes!' ,`Acres` = '0.2206' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 6 EL LAGO SEC 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9608' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '49' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'El Lago' ,`TaxAmount` = '7992' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706641' WHERE `Matrix_Unique_ID` = '209210094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:34:15.153' ,`MLSNumber` = '2873189' ,`ListAgentFullName` = 'Gary Evans' ,`ListOfficeName` = 'Evans Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658157' ,`Longitude` = '-95.578751' ,`PhotoCount` = '32' ,`PostalCode` = '77099' ,`RoomCount` = '7' ,`ListPrice` = '234500.00' ,`Status` = 'Active' ,`StreetName` = 'Bellfort' ,`StreetNumber` = '11510' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FOR SALE OR TRADE (*) This is a wonderful classic one-story home featuring 3 bedrooms and 2 baths in the Parkglen Subdivision. This home is close to ever amenity that Houston has to offer. Convenient to major shopping, health care and business centers. Minutes from Sugarland Town Square, The Galleria and Downtown Houston. Granite Countertops in the Kitchen with plenty of counterspace and cabinet storage, spacious family room with cozy fireplace and formal dining room plus spacious bedrooms. Open House Everyday Call for Times. 3-Ton 14 SEER AC System installed 2019 w/10 year parts limited warranty. This home is move in ready and will make a great first-time buyer or a downsizing option. Schedule your showing today. (*) conditions apply' ,`Acres` = '0.175' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 12A & 13A BLK 2 NW 21 FT OF LT 12 & SE 40 FT OF LT 13 PA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CUMMINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkglen Sec 03 Alief' ,`TaxAmount` = '3567' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706641' WHERE `Matrix_Unique_ID` = '210009531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:49:36.993' ,`MLSNumber` = '11571578' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '11' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite' ,`StreetNumber` = '272' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAIN-FLOOR BEDROOM | VERSATILE LOFT. \r\nYou will love this BEAUTIFUL NEW 2 story home in the Cedar Point Community! The desirable 1802 Plan features a main floor guest suite means this plan offers private living space both upstairs and downstairs. Kitchen highlights include gorgeous cabinets, granite countertops, and stainless-steel appliances (includes range, microwave, and dishwasher). All other bedrooms, including the primary suite, are on the 2nd floor. In the primary suite, there is a private bath with dual vanity sinks and a walk-in closet. The other 2 bedrooms are well-sized and share another full-sized bath. You’ll also love the versatile loft space and a walk-in laundry room on the upper floor. This welcoming plan comes with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 1 LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706641' WHERE `Matrix_Unique_ID` = '210502404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:52:31.820' ,`MLSNumber` = '47459039' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '17' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '219990.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite' ,`StreetNumber` = '260' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPACIOUS LIVING ROOM | 2-BAY GARAGE Prepare to be impressed by this DELIGHTFUL New home in the Cedar Point Community! The desirable 1402 Plan features an open living room that flows into a well-appointed kitchen. The Kitchen features gorgeous cabinets, granite countertops, and Stainless-Steel Steel Appliances (Includes, Range with Microwave, and Dishwasher). The primary suite has a private bath with dual vanity sinks and a roomy walk-in closet. This desirable plan also comes complete with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete Bld' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 1 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706641' WHERE `Matrix_Unique_ID` = '210503341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:50:20.547' ,`MLSNumber` = '24317319' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '251990.00' ,`Status` = 'Active' ,`StreetName` = 'Mesquite' ,`StreetNumber` = '250' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FLEX SPACE | OPEN-CONCEPT LAYOUT\r\nDon’t miss this opportunity to own a BEAUTIFUL NEW 2 Story home in the Cedar Point Community! The elegant 2002 Plan offers flex room on the main floor. The kitchen features gorgeous cabinets, granite countertops, and stainless-steel appliances (includes, range, microwave, and dishwasher). All bedrooms including the laundry room are on the 2nd floor. The primary suite has a private bath with dual vanity sinks and a walk-in closet. This desirable plan also comes complete with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete Bld' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 1 LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706641' WHERE `Matrix_Unique_ID` = '210504612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:53:15.547' ,`MLSNumber` = '62426264' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '249990.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Oak' ,`StreetNumber` = '228' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FLEX SPACE | OPEN-CONCEPT LAYOUT\r\nDon’t miss this opportunity to own a BEAUTIFUL NEW 2 Story home in the Cedar Point Community! The elegant 2002 Plan offers flex room on the main floor. The kitchen features gorgeous cabinets, granite countertops, and stainless-steel appliances (includes, range, microwave, and dishwasher). All bedrooms including the laundry room are on the 2nd floor. The primary suite has a private bath with dual vanity sinks and a walk-in closet. This desirable plan also comes complete with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete Bld' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 6 LOT 53' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '210505217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:55:18.503' ,`MLSNumber` = '75424841' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '11' ,`ListPrice` = '241990.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '174' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAIN-FLOOR BEDROOM | VERSATILE LOFT. \r\nYou will love this BEAUTIFUL NEW 2 story home in the Cedar Point Community! The desirable 1802 Plan features a main floor guest suite means this plan offers private living space both upstairs and downstairs. Kitchen highlights include gorgeous cabinets, granite countertops, and stainless-steel appliances (includes range, microwave, and dishwasher). All other bedrooms, including the primary suite, are on the 2nd floor. In the primary suite, there is a private bath with dual vanity sinks and a walk-in closet. The other 2 bedrooms are well-sized and share another full-sized bath. You’ll also love the versatile loft space and a walk-in laundry room on the upper floor. This welcoming plan comes with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 12 LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '210505709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:54:35.793' ,`MLSNumber` = '93786036' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '17' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '221990.00' ,`Status` = 'Active' ,`StreetName` = 'Hollow Oak' ,`StreetNumber` = '193' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPACIOUS LIVING ROOM | 2-BAY GARAGE Prepare to be impressed by this DELIGHTFUL New home in the Cedar Point Community! The desirable 1402 Plan features an open living room that flows into a well-appointed kitchen. The Kitchen features gorgeous cabinets, granite countertops, and Stainless-Steel Steel Appliances (Includes, Range with Microwave, and Dishwasher). The primary suite has a private bath with dual vanity sinks and a roomy walk-in closet. This desirable plan also comes complete with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete Bld' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 12 LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '210515333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T08:09:55.020' ,`MLSNumber` = '76881705' ,`ListAgentFullName` = 'Beatriz Garcia-Blanco' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819053' ,`Longitude` = '-95.503049' ,`PhotoCount` = '28' ,`PostalCode` = '77080' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Friendship' ,`StreetNumber` = '8603' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location, The property has been fully updated. 2016. All Interior Drywall was changed, including Ceiling. All Exterior Siding was updated. All the roof including the board was replaced . One bedroom and a full bathroom was added in 2016. No HOA, Low Tax Rate. Selling AS IS. Seller won\'t do Additional Repairs. Washer, dryer and refrigerator are not included. New Air Conditioner replaced in 2022. Since it is an owner occupied property please 2 Hrs notice for showings. ' ,`Acres` = '0.1641' ,`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` = '0' ,`Legal` = 'LT 557 BLK 22 LANGWOOD SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Langwood Sec 02' ,`TaxAmount` = '4539' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '210533375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T09:35:32.403' ,`MLSNumber` = '51748382' ,`ListAgentFullName` = 'Jean Jabbour' ,`ListOfficeName` = 'Jabbour Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699735' ,`Longitude` = '-95.737285' ,`PhotoCount` = '44' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagebranch' ,`StreetNumber` = '7111' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful house with an open plan, new flooring, updated bathrooms French paint ready to move in.' ,`Acres` = '0.2269' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEMONT MEADOWS SEC 1, BLOCK 1, LOT 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9882' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MCNEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakemont Meadows Sec 1' ,`TaxAmount` = '7131' ,`TaxRate` = '2.9265' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '211076145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T08:01:38.180' ,`MLSNumber` = '66973879' ,`ListAgentFullName` = 'Kay Krampitz' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942294' ,`Longitude` = '-96.263208' ,`PhotoCount` = '20' ,`PostalCode` = '77418' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Masonic' ,`StreetNumber` = '904' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HISTORICAL BEAUTY!!!! Victorian home located in the Heart of Bellville. This home is on a Huge Corner Lot with mature Magnolia and Pecan trees. There is a picket fence, privacy fencing in Back with a fabulous welcoming front porch. Original wood floors, shiplap walls, high ceilings, and a transom window. There is a large kitchen with all new appliances, new backsplash, kitchen sink and faucet, and original wood countertops. The bathroom has been completely remodeled with new tile floors. There is a detached garage with a workshop area and tons of storage. The backyard is gorgeous with shade trees and an outdoor shower to enjoy! Close to downtown Bellville, shopping and great restaurants! SHOWINGS ON SATURDAY AND SUNDAYS ONLY!' ,`Acres` = '0.284' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A073 J NICHOLS ACRES .284' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12371' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'Bellville' ,`TaxAmount` = '4305' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '211478849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T08:20:14.863' ,`MLSNumber` = '78871667' ,`ListAgentFullName` = 'Aimee Santos' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492175' ,`Longitude` = '-95.817193' ,`PhotoCount` = '45' ,`PostalCode` = '77471' ,`RoomCount` = '10' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Coachmaker' ,`StreetNumber` = '3026' ,`StreetSuffix` = 'Trail' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Your Opportunity to own this exquisite 4 bedroom 2 1/2 bath home in Briarwood Crossing community. This gorgeous, two-story home features an open concept kitchen with a center island, a beautiful backsplash tile, and wraparound cabinets. Kitchen is also equipped with shiny granite countertops. Refrigerator, washer and dryer stay! Formal dining and living room downstairs make an open floorplan right off the kitchen. Spacious bedrooms and game room upstairs. Spacious master suite with huge walk-in closet, huge shower, and separate tub, perfect for relaxing after a long day.Rich laminate floors and tile throughout the house, blinds, and gutters. This home has a back covered patio and a large backyard for great family fun time. Zoned to Culver Elementary School, an excellent school with an \"A\" RATING! Also, zoned to a brand-new Wright Junior High and Randle High School. It\'s just minutes from Highway 59 with an easy trip to Sugar Land. Call me for a showing!' ,`Acres` = '0.1997' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARWOOD CROSSING SEC 4, BLOCK 3, LOT 17' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8698' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing Sec 4' ,`TaxAmount` = '6813' ,`TaxRate` = '3.2048' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706642' WHERE `Matrix_Unique_ID` = '211651687' --> 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','211846766','1663706643','211846766','2022-09-04T08:05:56.670','69526386','Lorrie Parker','Keller Williams Advtge Realty','','','30.027518','-95.409919','36','77073','15','330000.00','Active','Woodchurch','1231','Lane','Houston','2','1','5','3027','Single-Family','Charm and Character are the best ways to describe this traditional home. Formal foyer leads to the sophisticated living and dining rooms. Large kitchen with a breakfast bar for impromptu meals or buffet serving. Inviting Den has full brick wood-burning fireplace to enjoy with company. With 2 bedrooms down, all the bedrooms are spacious and all have walk-in closets. The large upstairs room is great for a game or media room and centralized to the other 3 bedrooms. The luscious greenery of the fenced-in backyard and covered patio make the afternoons perfect for an entertaining time. The three-car garage gives plenty of space for the handyman with projects. With a little imagination and love, your dream home can be a reality!','0.303','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Aldine Area','Central Gas','1','Inverness Forest Sec 01 Block 2 Lot 45','Corner,Wooded','13200','Appraisal District','','700','0','','3','Double Oven','0','','','Electric Cooktop','','Composition','1 - Aldine','DUNN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','LEWIS MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Inverness Forest','5172','2.5234','Water District','1968','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','211865479','1663706643','211865479','2022-09-04T09:39:21.330','61898821','Janet Dublin','Janet Dublin Real Estate','','','30.374585','-95.622023','27','77356','6','365000.00','Active','Cove W','107','','Conroe','2','1','3','1983','Single-Family','Beautiful 3–2 ½ on cul-de-sac. Former builders’ home has extra-large 2 car garage. Downstairs is open concept with kitchen overlooking family room and dining area with tile throughout. Kitchen has high end granite counters, beautiful, upgraded cabinets, Samsung 5 burner gas range with convection oven, and large pantry.\r\nUpstairs the only carpeted areas are in secondary bedrooms, with Wood flooring on stairway and master bedroom. Primary suite includes bay window area for seating, and access to the balcony with a view of open treed area to enjoy solitude with a cup of coffee in the morning, or the stars at night. Primary bath has full his/her walk in closet, the vanity has double sinks, a walk-in shower, and a separate jacuzzi tub. \r\n Outdoor kitchen in back is cook’s dream with a Rec Tec smoker/Grill, Kamado Joe Grill and a Camp Chef Flat Top Grill. The extended patio was designed to accommodate gatherings of friends and family with market umbrellas that light up the night.','0.1154','39','','','','','Sellers Disclosure','1','','','Lake Conroe Area','Central Gas','1','APRIL SOUND 08, BLOCK 34, LOT 1, 1-A','Cul-De-Sac,Greenbelt,In Golf Course Community','5027','Appraisal District','','234','0','','2','Convection Oven,Gas Oven','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal','2','Traditional','April Sound 08','4616','2.2625','Water District','2004','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','212174070','1663706643','212174070','2022-09-04T09:36:35.427','63925018','Martha Hernandez','JLA Realty','','','30.049718','-95.395452','22','77373','5','207000.00','Active','Earlmist','23426','Drive','Spring','2','1','3','1516','Single-Family','COME BY A SEE THIS BIG HOUSE IN A NICE NEIGHBORHOOD CLOSE TO ALL AMENITIES AND SCHOOLS. WITH AN EXTRA LARGE ROOM THAT CAN BE USE FOR AN OFFICE AND CAN BE TURN IN INTO AN EXTRA LARGE ROOM.','0.1653','12','','','','','Mud','','','1','Spring East','Central Gas','1','LT 14 BLK 49 TIMBER LANE SEC 6','Other','7200','Appraisal District','','390','0','','2','','0','','','','','Composition','48 - Spring','PEARL M HIRSCH ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','2','Other Style','Timber Lane Sec 06','4705','3.0268','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully