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-18T12:50:07.730' ,`MLSNumber` = '41336425' ,`ListAgentFullName` = 'Evelyn Guinn' ,`ListOfficeName` = 'Premier Relocation' ,`SellingAgentFullName` = 'Theresa Almogabar' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.050251' ,`Longitude` = '-95.365536' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '192500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Enchantedgate' ,`StreetNumber` = '4538' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON MARKET. NO INSPECTIONS WERE DONE. BUYER COULDN\'T GET LOAN. Step into this Birnam Wood beauty and feel right at home! Great floor plan with 4 bedrooms and 2 bathrooms. The primary bedroom is large with lots of closets and the secondary bedrooms are very good sizes. You will enjoy the wood burning fireplace with a nice hearth. The tall ceiling in the living room gives it a spacious feel. Nice sized kitchen and the stainless steel refrigerator stays. Check out the big backyard. Schedule your showing today. We think you will love it. Room sizes are approximate. Do you own due diligence if necessary. Perfect family home or rental property.' ,`Acres` = '0.1597' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 BIRNAM WOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6955' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '415' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Birnam Wood Sec 04' ,`TaxAmount` = '3243' ,`TaxRate` = '2.7118' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675215727' WHERE `Matrix_Unique_ID` = '199790290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:40:03.017' ,`MLSNumber` = '42252182' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666050' ,`Longitude` = '-95.361711' ,`PhotoCount` = '19' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Galesburg' ,`StreetNumber` = '4409' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Rio Grande plan by CastleRock Communities located in Medical Center South area! This open concept plan has dramatic high ceilings, 4 bedrooms, study, game room, 2.5 baths, and 2.5 car garage. This home will look like the model home photos when completed, the kitchen features Quartz countertops in kitchen, undermount stainless sink, white 42\" cabinets, pendant lights, upgraded backsplash, and island! Family room has laminate wood floor, 2-story high ceilings with a modern wrought iron stair case! Master bedroom on first floor with upgraded tile in master bath, separate soaker tub and shower, and walk-in closet! Gameroom for the kids and separate study for those who work from home!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 67, Block 7 Ruberfield No 66' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Ruberfield' ,`TaxAmount` = '' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215727' WHERE `Matrix_Unique_ID` = '210213712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:39:47.853' ,`MLSNumber` = '81838427' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667965' ,`Longitude` = '-95.361494' ,`PhotoCount` = '18' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Elmwood' ,`StreetNumber` = '4426' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Rio Grande plan by CastleRock Communities located in Medical Center South area! This open concept plan has dramatic high ceilings, 4 bedrooms, study, game room, 2.5 baths, and 2.5 car garage. This home will look like the model home photos when completed, the kitchen features Quartz countertops in kitchen, undermount stainless sink, white 42\" cabinets, pendant lights, upgraded backsplash, and island! Family room has laminate wood floor, 2-story high ceilings with a modern wrought iron staircase! Master bedroom on first floor with upgraded tile in master bath, separate soaker tub and shower, and walk-in closet! Gameroom for the kids and separate study for those who work from home!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 120, Block 9 Ruberfield No 66' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Ruberfield' ,`TaxAmount` = '' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215728' WHERE `Matrix_Unique_ID` = '210214550' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:39:19.320' ,`MLSNumber` = '19497928' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686512' ,`Longitude` = '-95.350676' ,`PhotoCount` = '19' ,`PostalCode` = '77021' ,`RoomCount` = '9' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Liverpool' ,`StreetNumber` = '6926' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Rio Grande plan by CastleRock Communities located in Medical Center South area! This open concept plan has dramatic high ceilings, 4 bedrooms, study, game room, 2.5 baths, and 2.5 car garage. This home will look like the model home photos when completed, the kitchen features Quartz countertops in kitchen, undermount stainless sink, white 42\" cabinets, pendant lights, upgraded backsplash, and island! Family room has laminate wood floor, 2-story high ceilings with a modern wrought iron staircase! Master bedroom on first floor with upgraded tile in master bath, separate soaker tub and shower, and walk-in closet! Gameroom for the kids and separate study for those who work from home!' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 18, Block E Grand Park Annex' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARTSFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Grand Park Annex' ,`TaxAmount` = '' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215728' WHERE `Matrix_Unique_ID` = '210215403' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:40:22.077' ,`MLSNumber` = '59603186' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671465' ,`Longitude` = '-95.357471' ,`PhotoCount` = '19' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'White Rock' ,`StreetNumber` = '4607' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Rio Grande plan by CastleRock Communities located in Medical Center South area! This open concept plan has dramatic high ceilings, 4 bedrooms, study, game room, 2.5 baths, and 2.5 car garage. This home will look like the model home photos when completed, the kitchen features Quartz countertops in kitchen, undermount stainless sink, white 42\" cabinets, pendant lights, upgraded backsplash, and island! Family room has laminate wood floor, 2-story high ceilings with a modern wrought iron stair case! Master bedroom on first floor with upgraded tile in master bath, separate soaker tub and shower, and walk-in closet! Gameroom for the kids and separate study for those who work from home!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 8, Block 7, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sunnyside Place' ,`TaxAmount` = '' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215728' WHERE `Matrix_Unique_ID` = '210216108' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:01:24.000' ,`MLSNumber` = '44733361' ,`ListAgentFullName` = 'Dan McCarver' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Dan McCarver' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.591410' ,`Longitude` = '-95.109540' ,`PhotoCount` = '42' ,`PostalCode` = '77059' ,`RoomCount` = '9' ,`ListPrice` = '374500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Havenpark' ,`StreetNumber` = '16375' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING COURTYARD ENTRY- LARGE YARD WITH MATURE TREES AND GREAT LOCATION ADJACENT TO NEIGHBORHOOD POOL AND WALKING PATH ON THE BAYOU. TWO LIVING AREAS DOWN- LIGHT FILLED ROOMS. PRIMARY BEDROOM DOWN, THREE BEDROOMS UP. LARGE SECONDARY BATH W/ TUB AND SEPERATE SHOWER. FORMAL DINING MAY BE USED AS A STUDY. STAINLESS STEEL DOUBLE OVEN AND MICROWAVE 8/22, CARPET 8/22, MUD ROOM BETWEEN UTILITY ROOM AND GARAGE IS GREAT FOR A PET STATION OR KIDS LOCKER AREA. SCREENED PATIO OFF OF FAMILY ROOM. NEW ROOF 9/22. FRENCH DRAIN SYSTEM IN BACKYARD. NO FLOODING PER SELLERS. BREAKER BOX REPLACED AND HOME REPIPED.' ,`Acres` = '0.2405' ,`Area` = '7' ,`BuilderName` = 'VILLAGE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 73 BROOK FOREST SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10478' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '479' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest Sec 02' ,`TaxAmount` = '7853' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215728' WHERE `Matrix_Unique_ID` = '210243069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:28:41.813' ,`MLSNumber` = '42498170' ,`ListAgentFullName` = 'Mark Benoit' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716192' ,`Longitude` = '-95.322738' ,`PhotoCount` = '14' ,`PostalCode` = '77023' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Delafield' ,`StreetNumber` = '2418' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCED $10,000!!! This is an estate sale. Come see this 3 bedroom, 1 bath house in the East End Revitalization. Large living and dining area. Large bedrooms. Bathroom has a single standing shower. Water heater has been updated.' ,`Acres` = '0.1309' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 50 W L EDMUNDSON SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON J ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edmundson' ,`TaxAmount` = '2330' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215729' WHERE `Matrix_Unique_ID` = '210808412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:12:41.443' ,`MLSNumber` = '60768810' ,`ListAgentFullName` = 'Inez Tripson' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.305941' ,`Longitude` = '-96.036898' ,`PhotoCount` = '31' ,`PostalCode` = '77488' ,`RoomCount` = '7' ,`ListPrice` = '364996.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 123' ,`StreetNumber` = '814' ,`StreetSuffix` = '' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2199' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bird watchers Paradise! Feel like you’re “at one with nature” in this private 3-bedroom 2.5 bath home on 3.06 acres. This home features a large open living room with views into an incredible sunroom that lights up the home w/ views of Crepe Myrtles, Lilies, Jasmine & Sunflowers! The home stays cool with an energy efficient radiant heat barrier. The home also features a largeden complete with a full bath and a wood burning stove for the cooler nights. The kitchen has beautiful cabinetry, quartz countertops w/ island, a travertine backsplash and engineered wood floors that spill into the formal dining room. The primary bedroom has a walk-in closet and private bathroom. The home also has a utility room, a water softener, ceiling fans throughout and several large closets. Outside you will find yourself surrounded by gorgeous mature trees and the serene sounds of Caney Creek flowing through the property when full . There is also a 2-stall barn with plenty of storage for any horse lovers.' ,`Acres` = '3.06' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Caney Acres Sec. Lot 7 and 6' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Caney Acres' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215729' WHERE `Matrix_Unique_ID` = '210963162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:12:16.387' ,`MLSNumber` = '56616413' ,`ListAgentFullName` = 'Pamela Eppes' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.240497' ,`Longitude` = '-95.566300' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '928000.00' ,`Status` = 'Active' ,`StreetName` = 'Sendera Ranch' ,`StreetNumber` = '1418' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this serene oasis with a picturesque setting on 2+ acres of lakefront property. Adjoining 2+ acres are also available for sale! Very liveable floorplan, 5 bedrooms 3.5 bath, woodlike tile throughout 1st floor, high ceilings, lots of natural lighting, island kitchen with breakfast bar, granite counters, fireplace, and stunning view of the peaceful wooded property. Primary suite with a private entrance to the patio, a soaking tub, a walk-in shower, and a large walk-in closet with built-ins. The generous upstairs game room/living area features a separate bedroom and bath. Exterior features an amazing private backyard with expansive back patio, pool/spa with featured waterfall, summer kitchen, fireplace, detached pass-through brick garage, porte-cochere, 20KW generator, and mosquito system! Take a stroll down the path to the beautiful stocked lake for evening sunsets! Just minutes from The Woodlands, Lake Conroe, and all of the conveniences of suburban life. No MUD Tax!' ,`Acres` = '2.046' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SENDERA RANCH 01, BLOCK 3, LOT 2, ACRES 2.046' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '89124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sendera Ranch 01' ,`TaxAmount` = '7790' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215729' WHERE `Matrix_Unique_ID` = '211325160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:18:19.607' ,`MLSNumber` = '44866630' ,`ListAgentFullName` = 'Wan Yi' ,`ListOfficeName` = 'W Realty & Investment Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790981' ,`Longitude` = '-95.537862' ,`PhotoCount` = '15' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Westview' ,`StreetNumber` = '9909' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location! Easy access to I-10, City Centre, Memorial Mall, Energy Corridor, and Downtown. New Roof 2019. Well maintained one story property with updated kitchen and wood floor. Spacious backyard with a deck. The garage has been converted to flex space, and it can easily convert back to a garage.' ,`Acres` = '0.1928' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 5 SPRING BRANCH WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Woods Sec 01' ,`TaxAmount` = '6470' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215729' WHERE `Matrix_Unique_ID` = '211671791' --> 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','211938252','1675215729','211938252','2023-01-18T11:56:04.007','60428277','Damon Cooper','Prime Realty Group','','','29.831966','-95.195682','18','77049','5','120000.00','Active','Shelburne','13218','','Houston','2','0','3','960','Single-Family','Come and see this adorable updated 3 bedroom, 2 bath home today. This cozy home features many upgrades from the kitchen and baths to the flooring. The spacious living room that opens up into the kitchen makes it the perfect home for entertaining family and friends. Last but not least, you\'ll enjoy every peaceful minute spending time out on the deck overlooking this amazing size yard. The yard is not only a great spot for large gatherings but it also features an Iron rod gate for your personal safety and privacy. Make that appointment today before it\'s too late! All room sizes are approximate and must be verified.','','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','North Channel','Central Gas','0','LT 256 BLK 21 BEAUMONT PLACE SEC 2','Subdivision Lot','10800','Survey','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','46 - Sheldon','ROYALWOOD ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Lockbox Front','Seller','1','Traditional','Beaumont Place','','','Public Water,Septic Tank','1980','Seller'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:53:49.650' ,`MLSNumber` = '89431964' ,`ListAgentFullName` = 'Wesley Bryant' ,`ListOfficeName` = 'Partners in Building LP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710015' ,`Longitude` = '-95.417592' ,`PhotoCount` = '16' ,`PostalCode` = '77030' ,`RoomCount` = '11' ,`ListPrice` = '1839950.00' ,`Status` = 'Active' ,`StreetName` = 'Goldsmith' ,`StreetNumber` = '2525' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EARLY STAGES-STILL TIME TO PERSONALIZE FLOORPLAN AND DESIGN FINISHES! Exquisite New Construction by Partners in Building. Modern home perfectly set in the Brantwood community. This 4 bedroom, 4.5 bath luxury home will display tremendous craftsmanship and attention to detail throughout. Beautiful kitchen with island, custom cabinetry, stainless appliances, and breakfast seating area. Grand dining room with adjacent wine room; a sizeable home office, and a family room adjacent to a large covered patio, 10\' ceilings down. As you walk upstairs, you will be greeted with a spacious loft, 3 en suite bedrooms, each uniquely designed. Impressive upstairs Primary suite with a walk in closet; primary bath with double vanities. Two car garage with shadow line portico. Pool is not included in list price. Conveniently located just minutes from the Medical Center, shops, restaurants and entertainment. This masterpiece is the true epitome of luxury at its finest!' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'Partners in Building' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 4 & 5A BLK 2 BRANTWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brantwood' ,`TaxAmount` = '15753' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215729' WHERE `Matrix_Unique_ID` = '212064537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:58:54.103' ,`MLSNumber` = '23687348' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.350088' ,`Longitude` = '-95.502676' ,`PhotoCount` = '36' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '333566.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence Park' ,`StreetNumber` = '2918' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Poole floor plan is a spacious two-story home with 4 bedrooms, 3.5 baths, and 2-car garage. This home has it all - including a game room and vinyl plank flooring throughout the first floor! The gourmet kitchen is sure to please with tons of COUNTER SPACE, 42\" cabinets, island, granite countertops, and tile backsplash! Enjoy the privacy and convenience of having the Owner\'s Suite on the first floor! Retreat to the Owner\'s Suite featuring a beautiful bay window, separate tub and shower, and spacious walk-in closet. Don\'t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 59, BLOCK 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215730' WHERE `Matrix_Unique_ID` = '212311006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:59:55.210' ,`MLSNumber` = '19421037' ,`ListAgentFullName` = 'Susan Vaughan' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.656380' ,`Longitude` = '-95.140116' ,`PhotoCount` = '42' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway' ,`StreetNumber` = '141' ,`StreetSuffix` = 'Loop' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Natural light flows into this cottage with a vaulted ceiling, wall of windows and a view of endless greenspace. The open concept takes advantage of the scenery. The home abuts Trinity River Authority property with potential plans for a new public golf course. Enjoy morning coffee or afternoon cocktails from the covered back deck or upstairs balcony and the ambiance of wildlife. The split floor plan allows privacy for the upstairs primary suite while two guest rooms are downstairs. The backyard is fenced to accommodate fur babies or toddlers. The garage includes an air-conditioned art studio/workshop, one-car garage and golf cart storage. Located in the gated Cape Royale waterfront community on Lake Livingston, experience the many recreational activities available in the area. The home has a new furnace & AC on first floor level.' ,`Acres` = '0.1837' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE ROYALE - ROYALE GREENS, BLOCK 5, LOT 11, ACRES .1837' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Royale' ,`TaxAmount` = '3998' ,`TaxRate` = '2.0554' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215730' WHERE `Matrix_Unique_ID` = '212405336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:18:09.250' ,`MLSNumber` = '68863424' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437751' ,`Longitude` = '-95.434410' ,`PhotoCount` = '19' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10607' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home is the ultimate floor plan! When you walk through the front door into the extra large entryway, you will feel right at home. There are 4 bedrooms, 3 bathrooms, plus an office. The living room, kitchen, & dining area are all open to each other with high ceilings. The kitchen features a huge island with seating, 42\" cabinetry, & a walk in pantry. The primary bedroom is tucked away in the back of the home with an extremely spacious en suite bathroom & walk in closet. Oversized game room located upstairs with secondary bedroom. 3 car garage and a covered back patio. This home is truly beautiful - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 BLK 1 SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215730' WHERE `Matrix_Unique_ID` = '212419848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:39:04.813' ,`MLSNumber` = '96592585' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661019' ,`Longitude` = '-95.356688' ,`PhotoCount` = '23' ,`PostalCode` = '77051' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkspur' ,`StreetNumber` = '4646' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Rio Grande plan by CastleRock Communities located in Medical Center South area! This open concept plan has dramatic high ceilings, 4 bedrooms, a study, a game room, 2.5 baths, and a 2.5-car garage. The kitchen features Quartz countertops, an under-mount stainless sink, white 42\" cabinets, pendant lights, an upgraded backsplash, and an island! The family room has laminate wood floors, 2-story high ceilings, and a modern wrought iron staircase! Master bedroom on the first floor with upgraded tile in master bath, separate soaker tub and shower, and walk-in closet! Gameroom for the kids and a study for those who work from home!' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7, Block 6 Flower City' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Flower City' ,`TaxAmount` = '' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215730' WHERE `Matrix_Unique_ID` = '212458718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:19:01.527' ,`MLSNumber` = '74424618' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437751' ,`Longitude` = '-95.434410' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10714' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Colina Home is the ultimate floor plan! When you walk through the front door into the extra large entryway, you will feel right at home. There are 4 bedrooms, 3 bathrooms, plus an office. The living room, kitchen, & dining area are all open to each other with high ceilings. The kitchen features a huge island with seating, 42\" cabinetry, & a walk in pantry. The primary bedroom is tucked away in the back of the home with an extremely spacious en suite bathroom & walk in closet. Oversized game room located upstairs with secondary bedroom. 3 car garage and a covered back patio. This home is truly beautiful - it just needs you and your family to make it a home.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 BLK 2 SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215731' WHERE `Matrix_Unique_ID` = '212810621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:12:23.767' ,`MLSNumber` = '5323935' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918846' ,`Longitude` = '-95.732807' ,`PhotoCount` = '32' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Wolf Mountain' ,`StreetNumber` = '18530' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new Chesmar Home is a one story that is perfect for entertainment! Home has a big yard, rear covered patio, & a large living room w/ an elegant fireplace. Spacious kitchen w/ lots of counter space, beautiful colored cabinets, & a designer backsplash. Tall ceilings are throughout the home. Main bedroom is spacious & fts 2 walk-in closets! Main bath has separate garden tub, standing shower, & dual vanity sinks. Home is loaded: granite @ kitchen & baths, blinds, sprinkler sys, & more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 19 Block: 2 Section: 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7064' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.5407' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215731' WHERE `Matrix_Unique_ID` = '212832148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:03:00.047' ,`MLSNumber` = '39555236' ,`ListAgentFullName` = 'Wesley Bryant' ,`ListOfficeName` = 'Partners in Building LP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226751' ,`Longitude` = '-95.467063' ,`PhotoCount` = '16' ,`PostalCode` = '77384' ,`RoomCount` = '12' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Bennet' ,`StreetNumber` = '2021' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PARTNERS IN BUILDING CUSTOM HOME! Early stage of construction-Perfect time to customize the floorplan and design features. This stunning 2-story, 4 bedroom home is perfectly situated in the beautiful community of Stillwater. Immediately you are welcomed with a wall full of windows, high ceilings, natural lighting, and a fireplace. In the heart of the home you will find an island kitchen stocked with high-end appliances, and custom cabinetry. Plenty of room for gatherings in the first floor game and media rooms! A convenient home office sits just off the expansive foyer. Primary suite features an oversized walk-in closet and ensuite bath. The Primary bathroom has impressive finishes including a carwash shower and soaking tub. Upstairs you will find 2 large bedrooms and a picturesque loft. Spacious 3-car garage and utility room with built-ins. Relax on the covered back patio or enjoy a workout in the home gym. Close to all The Woodlands has to offer!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Partners in Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Blk 1 Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14822' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Stillwater' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215731' WHERE `Matrix_Unique_ID` = '212875925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T12:46:48.137' ,`MLSNumber` = '71319839' ,`ListAgentFullName` = 'Christine Hebel' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932605' ,`Longitude` = '-95.696032' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Painted Crescent' ,`StreetNumber` = '10726' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FINAL opportunities for Towne Lake in exclusive gated section, Sunset Harbor Villas. Caldwell built home, Waterlily Elevation A. 3 bedroom, 2 1/2 bath, plus a 3 car garage. Fireplace in family room, 8\' interior doors, under cabinet lighting in kitchen, enlarged kitchen island with upgraded granite, double ovens, 5 burner gas cooktop, engineered wood flooring in common areas, omega stone countertops in all bathrooms. Large covered back patio. Front yard maintenance included in this section. Quick walk to the water! Expected completion date Dec 2022.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Caldwell' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10743' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675215731' WHERE `Matrix_Unique_ID` = '212950802' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:32:03.030' ,`MLSNumber` = '84182599' ,`ListAgentFullName` = 'Jack Burns Brady' ,`ListOfficeName` = 'Hometown America Incorporated' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565006' ,`Longitude` = '-95.729756' ,`PhotoCount` = '39' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '567000.00' ,`Status` = 'Active' ,`StreetName` = 'Burton Grove' ,`StreetNumber` = '22818' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3029' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 1 story home in Veranda. Extended entry features 11-foot ceiling. Game room off entry complete with French doors. Great open floorplan with kitchen, dining, living combo. Island kitchen features an granite counters, tile backsplash, stainless appliances, and walk-in pantry. Family room with ceramic tile floor, cast stone fireplace and walls of windows. Private primary suite with elevated ceiling, wood flooring. Primary bath offers double door entry and includes garden tub, separate glass-enclosed shower, dual vanity sink, and two spacious walk-in closets. Covered backyard patio. Two-car garage.' ,`Acres` = '0.2119' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VERANDA SEC 7, BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '11786' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675215732' WHERE `Matrix_Unique_ID` = '212969909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-18T11:41:33.363' ,`MLSNumber` = '23659257' ,`ListAgentFullName` = 'Celeste Beaher' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792594' ,`Longitude` = '-95.372817' ,`PhotoCount` = '31' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Vincent' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1749' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located near downtown Houston, this remodeled Craftsman is within the highly sought-after, historic Brooke Smith neighborhood. This property is close to great restaurants, bars, and shops in the Heights and has easy access to major highways. The enormous kitchen is open to the living area. The Primary suite has a large bathroom, giant walk-in closet, and private access to the back porch. The outdoors feature a covered front and rear porch, a fully fen