Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:54:51.390' ,`MLSNumber` = '80865499' ,`ListAgentFullName` = 'Karen Melgar' ,`ListOfficeName` = 'Boncler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.173877' ,`Longitude` = '-94.995339' ,`PhotoCount` = '43' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Shaman' ,`StreetNumber` = '18035' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New custom home construction on almost half an acre lot with 3 large bedrooms, closets, and 2 custom restrooms. This custom home has a 12\' ceiling around the kitchen and living room area and also has 9’ ceiling throughout the house. Featuring quartz countertops, tile floors, kitchen Island, impact windows, impact doors and stainless appliances. Driveway is designed with a parking space of 8 cars. Indian Beach subdivision offers a beautiful swimming pool, tennis court, boat launch, fishier pier and a short ride on a golf cart to the beach.' ,`Acres` = '0.496' ,`Area` = '33' ,`BuilderName` = 'J & A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 24 BLK 3 INDIAN BEACH SEC 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '21606' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Beach 3' ,`TaxAmount` = '615' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098861' WHERE `Matrix_Unique_ID` = '205279421' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:52:03.010' ,`MLSNumber` = '66871682' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220803' ,`Longitude` = '-95.347623' ,`PhotoCount` = '39' ,`PostalCode` = '77302' ,`RoomCount` = '5' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemary Hill' ,`StreetNumber` = '15734' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available in February 2023!! \r\n\r\nThe Arlington’s one-story living features an island kitchen open to the dining area and the Large Extra Pantry. This home features upgrades such as granite countertops, stainless steel appliances, and Enhanced Vinyl Plank flooring. Gorgeous 8 foot Front Door, Full Blinds, Bay Window, Covered Patio, huge Corner Lot.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '18104' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098861' WHERE `Matrix_Unique_ID` = '209354531' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:36:32.513' ,`MLSNumber` = '48410580' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201981' ,`Longitude` = '-95.338226' ,`PhotoCount` = '30' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '505000.00' ,`Status` = 'Active' ,`StreetName` = 'Aqua Haven' ,`StreetNumber` = '17926' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 48410580 - Built by Highland Homes - Ready Now! ~ Fall in love with this great one story design with high ceilings and lots of natural light. Open kitchen/dining area and family room with fireplace, expanded secondary bedrooms, study, and media room. Great island kitchen with wood cabinets, quartz countertops, and stainless steel appliances too! Nothing like a Highland Home with its tankless water heater, 8\' solid core doors, and whole home dehumidifier. Sprinkler system, full gutters, full sod, and 3 car tandem garage. Don\'t miss out on this one.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 49, Block 2' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098861' WHERE `Matrix_Unique_ID` = '209640950' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:37:45.100' ,`MLSNumber` = '91084696' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.203873' ,`Longitude` = '-95.337176' ,`PhotoCount` = '28' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Brook' ,`StreetNumber` = '17787' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 91084696 - Built by Highland Homes - Ready Now! ~ Fall in love with this great one story design with high ceilings and lots of natural light. Open kitchen/dining area and family room with fireplace, study, and lifestyle room. Great island kitchen with wood cabinets, quartz countertops, and stainless steel appliances too! Nothing like a Highland Home with its tankless water heater, 8\' solid core doors, and whole home dehumidifier. Sprinkler system, full gutters, full sod, and no back neighbors! Don\'t miss out on this one.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8878' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098862' WHERE `Matrix_Unique_ID` = '209641577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:33:16.347' ,`MLSNumber` = '24243282' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220324' ,`Longitude` = '-95.350436' ,`PhotoCount` = '19' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Shadow' ,`StreetNumber` = '14365' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available March 2023!! Pulte welcomes you to the Riverdale plan featuring 5 bedroom, 4 bathrooms and walking distance to the pool and trails on the lake! Wood look tile floors are found in the main and wet areas, and upgraded carpet upstairs and in the bedrooms. The kitchen has a single basin sink, white cabinetry, quartz countertops and stainless steel appliances. Your downstairs Owners suite includes an ensuite bathroom, separate tub and shower, and bay windows!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '05302' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098862' WHERE `Matrix_Unique_ID` = '209781917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:05:44.383' ,`MLSNumber` = '45003730' ,`ListAgentFullName` = 'Cathy Tabor' ,`ListOfficeName` = 'The Real Estate Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096815' ,`Longitude` = '-95.714265' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Rosewood' ,`StreetNumber` = '22919' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Interior of this 2-Story, 4-Bedroom, 2-Bath, Brick/Wood Home has been Beautifully Remodeled & Updated including New Windows & Appliances! Open Kitchen w/Granite Countertops, Glass Tile Backsplash & Soft-Close Cabinets. Breakfast Room. Living Room w/Brick-Faced Wood-Burning Fireplace. Over-Sized Family/Game Room. Inside Utility Area Includes a Full-Size Washer & Dryer. Downstairs Primary Bedroom w/En-Suite Bath. Upstairs has 3-Add\'l Bedrooms plus a Full-Hall Bath. Approx. 1.25-Acre Wooded Corner Lot w/Majestic Trees. *Room to Build a Guest House or Add-on a Room!* Ready for your Creative Landscaping Ideas. The Seller\'s kept the Home\'s Exterior in it\'s Original Design, providing you w/the opportunity to Make-It-Your Own & add your personal touch on the Curb Appeal including Exterior Paint, Garage Door Styles, etc. Roof approx. 10 Years Old. A/C approx. 4 Yrs Old. Neighborhood Lake, Tennis Courts & Pool w/Pavilion! NEVER FLOODED! NO MUD TAXES! CONSIDER AN FHA LOAN W/ REPAIR ESCROW!' ,`Acres` = '1.2641' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT C105 ROSEWOOD HILL SEC 4 U/R' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '55064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'ROSEWOOD HILL' ,`TaxAmount` = '5460' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098862' WHERE `Matrix_Unique_ID` = '210669604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:45:10.697' ,`MLSNumber` = '40310342' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.326723' ,`Longitude` = '-96.089900' ,`PhotoCount` = '33' ,`PostalCode` = '77488' ,`RoomCount` = '4' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Tennie' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This very well maintained home is a must see. Nice 4 bedroom, 2 full and 1 half bath home has a split plan, 2 large living rooms separated by the formal dining room and kitchen in the middle. Three bedrooms and one full and one half bath on one side, the master and full bath on the other. The backyard is a dream with the one year old wood fence, nice covered back patio and ample room for entertaining. There is also a nice sitting area on the side yard to enjoy that early morning or late evening coffee. This one also has a nice doublewide concrete driveway and a 2 car garage. Call fast to see this one!' ,`Acres` = '0.2348' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HELMS BLOCK 1 LOT 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10228' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Helms' ,`TaxAmount` = '4070' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098862' WHERE `Matrix_Unique_ID` = '211751059' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:48:43.660' ,`MLSNumber` = '70959175' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221123' ,`Longitude` = '-95.348753' ,`PhotoCount` = '19' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '424920.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Hollow' ,`StreetNumber` = '15810' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available February 2023!!\r\n\r\nPulte welcomes you to the Riverdale plan featuring 5 bedroom, 4 bathrooms and walking distance to the pool and trails on the lake! Wood look tile floors are found in the main and wet areas, and upgraded carpet upstairs and in the bedrooms. The kitchen has a single basin sink, white cabinetry, quartz countertops and stainless steel appliances. Your downstairs Owners suite includes an ensuite bathroom, Glam spa shower, and bay windows!\r\nPremier Package Daybreak, Tavern Bronze exterior color' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '27302' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098863' WHERE `Matrix_Unique_ID` = '212073386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:24:50.393' ,`MLSNumber` = '9897669' ,`ListAgentFullName` = 'Steven Do' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680637' ,`Longitude` = '-95.260874' ,`PhotoCount` = '38' ,`PostalCode` = '77017' ,`RoomCount` = '4' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Howard' ,`StreetNumber` = '8222' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '5095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Massive 5000sqft mixed use space sitting on 1/3 of an acre. This property is waiting for the perfect buyer to add their final touch. No HOA!! Property is being sold as-is, where-is. Room sizes are approximate. Buyer to verify all room sizes. Schedule your showing today!' ,`Acres` = '0.3329' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 17 & 19 BLK 33 MEADOWBROOK SEC A' ,`LotDesciption` = 'Other' ,`LotSize` = '14500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BONNER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Meadowbrook Sec A' ,`TaxAmount` = '4578' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098863' WHERE `Matrix_Unique_ID` = '212362199' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:20:02.080' ,`MLSNumber` = '39016041' ,`ListAgentFullName` = 'Elissa Campbell' ,`ListOfficeName` = 'Lucid Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796156' ,`Longitude` = '-95.386773' ,`PhotoCount` = '27' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '989999.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '1116' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the highly sought after Norhill Subdivision, this home has been fully renovated to keep its classic charm while adding modern custom finishes throughout that you will not find anywhere else. The house boasts an amazing and spacious open floor plan that includes a spectacular gourmet kitchen with custom built cabinetry and quartz countertops. Engineered white oak hardwood floors throughout are just beautiful. The master en-suite is breathtaking with custom built walnut vanities, an intricate marble tile accent wall, free standing tub, and walk-in shower. A new 30 year roof has been installed. The electrical is all new. The plumbing has been updated as well to include new pex plumbing throughout the home. The builder pulled out all the stops on this one y’all! She’s a beauty! Come see for yourself!' ,`Acres` = '0.1194' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 118 NORTH NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Norhill' ,`TaxAmount` = '11702' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1924' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098863' WHERE `Matrix_Unique_ID` = '212587533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:42:24.283' ,`MLSNumber` = '3512982' ,`ListAgentFullName` = 'Daniel Lopez' ,`ListOfficeName` = 'Homemax Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569999' ,`Longitude` = '-95.122719' ,`PhotoCount` = '50' ,`PostalCode` = '77062' ,`RoomCount` = '12' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Beachcomber' ,`StreetNumber` = '1514' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '3664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully landscaped, spacious two story home with 7 bedrooms on an oversized, shaded lot. This home has upgrades everywhere. If you enjoy entertaining, this home has a formal living room, a dining room, a fire lit family room and a breakfast area adjacent to the peninsula kitchen. Beautiful granite countertops grace the kitchen and bathrooms. The oversized laundry/mudroom could also be a great area to store crafts, sewing or quilting items. The attached garage has an additional workshop area, 220 amp power & a concrete pad behind. The large walk-in attic is ideal for storage. Game room (20x14) upstairs was added in 2020, not reflected in tax records. Small refrigerator in game room stays. Video projector in game room will be remover by owner prior to closing. Two water heaters, one of them tankless. Beautiful landscaping on front, large covered patio on back. Recent foundation repairs, full lifetime warranty. NEVER FLOODED!' ,`Acres` = '0.2833' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 509 BLK 38 CLEAR LAKE CITY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Lake City Sec 03 Reserve H' ,`TaxAmount` = '7270' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098863' WHERE `Matrix_Unique_ID` = '212771724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:53:49.213' ,`MLSNumber` = '40533494' ,`ListAgentFullName` = 'Isabella Rodas' ,`ListOfficeName` = 'Realty World Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.896843' ,`Longitude` = '-93.909712' ,`PhotoCount` = '30' ,`PostalCode` = '77642' ,`RoomCount` = '6' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Avant' ,`StreetNumber` = '248' ,`StreetSuffix` = 'Lane' ,`City` = 'Port Arthur' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR SPECIAL!! Distressed property. House has 3 bedrooms and 2 1/2 bathrooms. Sitting on HUGE LOT (12,200 sqft).' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'AVANT LANE LT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'DEQUEEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098864' WHERE `Matrix_Unique_ID` = '213241787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:43:51.497' ,`MLSNumber` = '6814946' ,`ListAgentFullName` = 'Ronald Graham' ,`ListOfficeName` = 'Sharpstown Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698259' ,`Longitude` = '-95.472962' ,`PhotoCount` = '11' ,`PostalCode` = '77401' ,`RoomCount` = '5' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen' ,`StreetNumber` = '5309' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT OPPORTUNITY W/ SELLER FIN AVAIL.\r\n VERY CHARMING FOUR BEDROOM ONE BATH MID-CENTURY BELLAIRE COTTAGE. THIS IS AN AMAZING REAL ESTATE INVESTMENT. (Not requiring 20% down)\r\n\r\nNEVER FLOODED' ,`Acres` = '0.1405' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 10 PEACEFUL VALLEY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Peaceful Valley Sec 01' ,`TaxAmount` = '7818' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098864' WHERE `Matrix_Unique_ID` = '213254235' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:35:40.580' ,`MLSNumber` = '85461559' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219924' ,`Longitude` = '-95.349399' ,`PhotoCount` = '15' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '404970.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Shadow' ,`StreetNumber` = '14377' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Available February 2023!! Pulte welcomes you to the Riverdale plan featuring 5 bedroom, 4 bathrooms and walking distance to the pool and trails on the lake! Wood look tile floors are found in the main and wet areas, and upgraded carpet upstairs and in the bedrooms. The kitchen has a single basin sink, white cabinetry, quartz countertops and stainless steel appliances. Your downstairs Owners suite includes an ensuite bathroom, separate tub and shower, and bay windows!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '7380 02302' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5523' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.198' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098864' WHERE `Matrix_Unique_ID` = '213330277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:17:28.173' ,`MLSNumber` = '50092877' ,`ListAgentFullName` = 'Jovany Trujillo' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833747' ,`Longitude` = '-95.164111' ,`PhotoCount` = '29' ,`PostalCode` = '77049' ,`RoomCount` = '10' ,`ListPrice` = '259800.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty Hall' ,`StreetNumber` = '7238' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3 bedroom 2 Bathroom with brand new floors and Brand new paint inside and out!!! The Home features a second living room in the second floor to everyone to enjoy. The open floor plan will allow you to entertain guest while your in the kitchen. Brand new A/C system was just installed earler this year, many amazing features and ready for you to call it home!!! Schedule your private showing today!!' ,`Acres` = '0.102' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 3 LIBERTY LAKES SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4444' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Lakes Sec 10' ,`TaxAmount` = '5548' ,`TaxRate` = '2.9293' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098864' WHERE `Matrix_Unique_ID` = '214191686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:41:13.180' ,`MLSNumber` = '55079496' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750895' ,`Longitude` = '-95.884188' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '699517.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood Trace' ,`StreetNumber` = '2830' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 55079496 - Built by Highland Homes - May completion! ~ Our model home floorplan and one of our top selling one-story plans! This open layout is heightened by 13ft ceilings throughout, double front door entry, sliding glass doors to extended patio and massive wrap around kitchen with wine hutch and 12 ft island! One of the most popular elements is the giant walk-in primary closet attached directly to the oversized laundry room. Never again will laundry have to pass into the main area! This home is situated on a corner lot. Call the sales office to inquire about all of the cosmetic upgrades including wood floors, quartz countertops, farmhouse sink double ovens and more!!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '6/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9972' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098864' WHERE `Matrix_Unique_ID` = '214624348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:20:11.160' ,`MLSNumber` = '79704884' ,`ListAgentFullName` = 'Rachel Barzilay' ,`ListOfficeName` = 'Integra RE Investments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680734' ,`Longitude` = '-95.499529' ,`PhotoCount` = '32' ,`PostalCode` = '77074' ,`RoomCount` = '6' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Crest' ,`StreetNumber` = '6126' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to YOUR NEW ROBINDELL HOME. This fully renovated home has it all. Large Kitchen, Updated luxurious bathrooms, an enclosed air conditioned sunroom - AND a Gorgeous backyard with a fish pond and beautiful landscaping. This home sits on a corner lot with mature Oak trees and fantastic landscaping. \r\nThe House has has been equipped with several security cameras and monitors with in the home for security. The sunroom has been enclosed and has its own AC unit. \r\n\r\nCome make this Gem your Home Today. All Furniture Available for purchase with the home.' ,`Acres` = '0.2139' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 15 ROBINDELL SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCNAMARA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robindell Sec 04' ,`TaxAmount` = '5181' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098865' WHERE `Matrix_Unique_ID` = '214826809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:51:43.510' ,`MLSNumber` = '84042805' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.842215' ,`Longitude` = '-95.857632' ,`PhotoCount` = '44' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal Bend' ,`StreetNumber` = '921' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 84042805 - Built by Highland Homes - Ready Now! ~ Built by Highland Homes - Walking distance to the famous Crystal Lagoon in a community that\'s just 15 minutes from both I-10 and 99! The spacious floorplan offers tile floors, soaring ceilings and huge family room. The light & bright kitchen is open to the family room and boasts stainless steel appliances, large island, pantry and so much more! The open floorplan is a true entertainer\'s delight. The primary bedroom is a dream retreat while the primary bath offers dual sinks, separate shower & tub along with a large closet. SMART HOME PACKAGE, tankless water heater, full sprinkler system are all included!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '27/1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098865' WHERE `Matrix_Unique_ID` = '214900379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T12:52:20.733' ,`MLSNumber` = '75968558' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750078' ,`Longitude` = '-95.884194' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '667394.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2846' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 75968558 - Built by Highland Homes - June completion! ~ This spacious home features tall 13’ ceilings & huge windows and sliding doors for a bright & airy feeling. Premier Farmhouse style kitchen boasts a large island with quartz counter tops. Dramatic Benedettini cabinetry allows for full drawer extension & soft-close features. Extended master suite. Luxurious master bath with large freestanding tub & walk in closet. Private guest bedroom with ensuite bath. Beautiful hardwood floors and Upgraded lighting package! Also includes home office & entertainment room. Smart home package included along with tankless hot water heater!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8873' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098865' WHERE `Matrix_Unique_ID` = '214991286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T11:00:20.693' ,`MLSNumber` = '18987510' ,`ListAgentFullName` = 'Alejandro Barrella' ,`ListOfficeName` = 'Pinnacle Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582260' ,`Longitude` = '-95.669481' ,`PhotoCount` = '24' ,`PostalCode` = '77479' ,`RoomCount` = '6' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Crisfield Dr' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Weekley Plan with master and second bedroom with full bathroom down, plus both formals and upstairs game room. The house is immaculate, a new kitchen that was rebuilt with an open concept and an amazing island. and a really nice wood floor downstairs. The house is on a very large corner lot, which is just across from a park area and with views of a lake. The backyard has a huge pool with a spa, plenty of grassy play areas and covered patio. Oversized garage for 2 cars with eight foot extension faces street for easy parking and a driveway that fits more cars, This wonderful house is at walking distance to exemplary middle school and retail center.' ,`Acres` = '0.2669' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEW TERRITORY PARCEL SF-22, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '11624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'New Territory Prcl Sf-22' ,`TaxAmount` = '12207' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675098865' WHERE `Matrix_Unique_ID` = '215080245' --> 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','215120011','1675098866','215120011','2023-01-02T11:02:15.540','96670367','Brian Worrell','CUFG Keystone Realty Group','','','29.464838','-95.070497','23','77539','7','255000.00','Active','Greenbriar','2705','','Dickinson','2','0','3','1878','Single-Family','COMPLETELY UPDATED/RENOVATED OVER LAST 2 YEARS. Kitchen is a Chef’s Dream - HIGH END and tons of custom features including High End Butcher Block Counters, Custom Backsplash, gorgeous Cabinetry (Soft close cabinets and drawers), lighting, Huge walk-in Patry, and many other features. Family Room with Built-In Entertainment Center. Luxury Vinyl Plank Flooring. (3/22); NEW ROOF (8/22) (includes transferrable lifetime warranty)! NEW A/C (9/20) and Furnace (11/21). NEW Drain Side Plumbing (2/22). This home is like new in many ways and boasts many cool features! Family Room boasts a beautiful, custom Entertainment Center with Fireplace with a modern farmhouse vibe! Modern Bathrooms beautifully done with clean, fresh lines and new vanities. Minutes away from schools, restaurants, shopping and a short hop to the interstate! Don’t miss this one!','','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Dickinson','Central Gas','0','ABST 19 PERRY & AUSTIN SUR LOT 72 OAK FOREST ADDN','Cleared,Subdivision Lot,Wooded','8505','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','17 - Dickinson','BAY COLONY ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required,Request Online Appointment','Appraisal','1','Ranch','Oak Foresst','','','Public Sewer,Public Water','1982','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','215536590','1675098866','215536590','2023-01-02T11:59:23.820','25252055','Gayla Gayden','REALM Real Estate Professional','','','29.671133','-95.739880','32','77407','10','339999.00','Active','Rubble','20627','Lane','Richmond','2','0','3','2160','Single-Family','Stunning One Story Ranch Home in the Outstanding Community of Fieldstone! Energy Rated features Attic Vents, Digital Program Thermostat, Energy Star/Reflective Roof, 15 Seers High-Efficiency HVAC, Insulated Doors, Insulated/ Vinyl Low-E Windows, Radiant Attic Barrier & more! Freshly Painted Outside & Inside! Sink your toes into the New Lush Carpet in all Bedrooms! Grand Entrance with High Ceilings, Elegant Formal Dining, Upgraded Tile in Gourmet Kitchen, Casual Dining, Family Area, Laundry Room, Hallways & All Bathrooms! Gourmet Kitchen W/Granite Counters, Tile Backsplash, Tall Beautiful Cabinets, Black Appliances, Family Area with Fireplace & Wall of Windows looking out to your Covered Patio! French Glass Panels Doors Open to your Study! Private Primary Suite with High Ceilings, French Doors opens to the Spa Like Bathroom with His & Her Private Sinks Vanity, Deep Whirlpool Tub, Shower & 2 Huge Walk In Closets! 2 Guest Bedrooms & Large Guest Bathrooms! No Flooding! Outstanding Schools','0.1465','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','FIELDSTONE SEC 2, BLOCK 2, LOT 2','Subdivision Lot,Wooded','6383','Appraisal District','','700','0','','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','OAKLAND ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','Fieldstone','8671','2.8429','Public Sewer,Public Water,Water District','2008','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','215752374','1675098866','215752374','2023-01-02T11:32:46.893','40529339','Melida Marquez','RE/MAX Lake Livingston','','','30.807798','-95.183836','31','77364','1','87000.00','Active','Captain Kidd','211','Lane','Point Blank','1','0','1','560','Single-Family','Nestled in the La