Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '79827700' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.402660' ,`Longitude` = '-95.506224' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '431715.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Carp' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story home features 4 bedrooms, 2.5 bathrooms, a formal dining room, a game room, 2-car attached garage and a covered patio. Formal dining room showcased off of foyer. The chef’s kitchen has a casual eating area, as well as two separate countertop eating areas. The dramatic two-story family room overlooks the covered patio. The large master suite is privately located while the three secondary bedrooms and spacious game room are upstairs. The Emma is located on a corner lot that is very wide. Great side back yard! \r\nHome just finished construction, photos are coming soon. In the interim, photos are representative. Please contact Chesmar Homes for more info.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927111 - The Woodlands Hills 11, BLOCK 3, Lot 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1243' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 11' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623695' WHERE `Matrix_Unique_ID` = '205362803' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '39515412' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.168767' ,`Longitude` = '-95.634289' ,`PhotoCount` = '20' ,`PostalCode` = '77486' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '439' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39515412 Built by CastleRock NEW HOME UNDER CONSTRUCTION! Greeley (C) 1-Story 3BD 2 BA 3 Car Garage 1,801 sq ft! High Ceilings! Open Concept! Impressive Interior Upgrades! Modern White 42\" Kitchen Cabinets! Quartz Counters! Stainless finish appliances exude refinement and elegance! Inviting Owner\'s Suite! Soaker Tub & Separate Shower! 2\'\' Faux blinds! Wall of windows! Energy-Efficient! HERS Rated! No Flooding! Tankless Water Heater! Low Tax Rate 2.186 before homestead! Covered Patio! Offers a golf course family-friendly gated community, Easy Commute to Hwy 288, Exciting Pearland Town Center, Houston, Bay City, Sweeny & Lake Jackson! Experience the breathtaking sandy beach views just 30 mins away! CastleRock offers NEW HOMES in various stages of construction for those who are looking for spacious 1 & 2 story layouts and Quick Move-In Homes. Nestled in Natural Splendor Enjoy Country Living in Columbia Lakes! Best kept secret south of Houston! Schedule a tour today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 82, Block 31, Section 3' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes' ,`TaxAmount` = '' ,`TaxRate` = '2.186' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1668623695' WHERE `Matrix_Unique_ID` = '207462423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '32193552' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.403678' ,`Longitude` = '-95.505848' ,`PhotoCount` = '23' ,`PostalCode` = '77318' ,`RoomCount` = '5' ,`ListPrice` = '387240.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Perch' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1901' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large open family room, casual dining, and kitchen with countertop dining overlooks covered patio and is easily accessible to study. Private master suite with spacious master bath with double sinks, garden tub, shower, and ample closet space. Utility room is centrally located. \r\n**THIS HOME IS UNDER CONSTRUCTION AND NOT COMPLETE. PHOTOS ARE REPRESENTATIVE AND NOT ACTUAL PHOTOS OF HOME. COLORS AND SELECTIONS WILL VARY. Please contact Chesmar Homes for more info** SEPT estimated completion' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927111 - The Woodlands Hills 11, BLOCK 3, Lot 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 11' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623695' WHERE `Matrix_Unique_ID` = '208466483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:38:55.400' ,`MLSNumber` = '55060494' ,`ListAgentFullName` = 'Linda Swope' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705168' ,`Longitude` = '-95.413142' ,`PhotoCount` = '29' ,`PostalCode` = '77030' ,`RoomCount` = '14' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Dorrington' ,`StreetNumber` = '2323' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mid-Century Modern home built by by Architect for his personal home. Many modern updates including kitchen w/ glass front cabinets,1st floor tile floors, recent double-paned windows, tankless water heater, renovated baths. All bedrooms are up, large, and have hardwoods. Ascend the 4\' wide stairway to the Primary bedroom with recently remodeled en suite bath w/ steam shower. A study/baby\'s room is adjacent to the Primary. The second bedroom, is oversized and would be great for twin beds and a play sized area. The spacious living/dining rom is 34x15 and has new tile floors & windows coverings. The updated kitchen, open to the family room, has a view of the pool. The cozy front room off the entryway can be used as a study, library or bar. it\'s adorable! Park under porte-cochere w/flagstone deck. The large garage with awnings can be used as a party room. its doors open to the recently re-plastered heated pool. Foundation warranty, tankless water heater.' ,`Acres` = '0.1934' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 5 & 6A BLK 16 BRAESWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Braeswood' ,`TaxAmount` = '15615' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623695' WHERE `Matrix_Unique_ID` = '210224243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '4916547' ,`ListAgentFullName` = 'Candelaria Hernandez' ,`ListOfficeName` = 'MDK Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872019' ,`Longitude` = '-95.666807' ,`PhotoCount` = '18' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonechase' ,`StreetNumber` = '6515' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house will not last on the market. New floors, carpet, ceiling, fans, light fixtures and fresh paint in the surrounding home. The bonus man cave/theater room will include negotiable theater seating. Incredible custom trim work inside such as ShipLap, Beadboard panels, Board & Batten accent walls, LifeProof flooring, updated hvac vent covers, complete exterior power washed driveway, sidewalk, gutters and bricks. Brand new recently installed roof and negotiable new Samsung range. Contact agent for all showings.' ,`Acres` = '0.1567' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 7 STONE CREEK SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Sec 01' ,`TaxAmount` = '6044' ,`TaxRate` = '3.071' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623695' WHERE `Matrix_Unique_ID` = '210449749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T02:05:47.723' ,`MLSNumber` = '58994287' ,`ListAgentFullName` = 'Sabrina Ash' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869310' ,`Longitude` = '-95.780581' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Providence River' ,`StreetNumber` = '6511' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 6 bedroom Next Gen plan - a home within a home. Second living quarters features it\'s own front door, kitchenette, bedroom, living area, washer/dryer hook up and full bath with shower. The main home offers an inviting foyer entry, island kitchen w/walk-in pantry, dining area with a spacious family room, large utility room, mud room and a 3 car garage. Covered back patio and no back neighbors. First floor offers a 2nd bedroom and full bath room. Second floor offers 3 bedrooms, 2 full baths, game room, media room. Each bath has it\'s own medicine cabinet and linen closet, providing ample space throughout. Pre-wired for a generator, full gutters and reverse osmosis in both kitchens, offers filtered water for drinking and cooking. Call to schedule your private tour today! This spacious home is great for entertaining and won\'t last long!' ,`Acres` = '0.1841' ,`Area` = '25' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 ELYSON SEC 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '15295' ,`TaxRate` = '3.5368' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623696' WHERE `Matrix_Unique_ID` = '211612379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T02:20:33.077' ,`MLSNumber` = '9584007' ,`ListAgentFullName` = 'Quyen Nguyen' ,`ListOfficeName` = 'Smith Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.707148' ,`Longitude` = '-96.215447' ,`PhotoCount` = '16' ,`PostalCode` = '77465' ,`RoomCount` = '5' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '801' ,`StreetSuffix` = 'Street' ,`City` = 'Palacios' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful newly-renovated Craftsman-style home you have to see! This charming home has 4 bedrooms, 3.5 baths, large kitchen island with stainless steel appliances, designer backsplash, Quartz countertops, and a spacious mud room. The home sits on a huge corner lot with a new privacy fence, roof, and HVAC (per seller)' ,`Acres` = '0.344' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PALACIOS ORIGINAL TOWNSITE, BLOCK 45, LOT 1-3-S-100\'' ,`LotDesciption` = 'Other' ,`LotSize` = '14985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Palacios Original Townsite' ,`TaxAmount` = '2233' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623696' WHERE `Matrix_Unique_ID` = '211807090' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '59411941' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.156725' ,`Longitude` = '-95.055083' ,`PhotoCount` = '40' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '232485.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5138' ,`StreetNumber` = '83' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.42' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1648, ACRES 0.4200' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1083' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623696' WHERE `Matrix_Unique_ID` = '211940605' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '33716737' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157414' ,`Longitude` = '-95.057290' ,`PhotoCount` = '8' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '199460.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5117' ,`StreetNumber` = '18' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.35' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1639, ACRES .35' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '1034' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623696' WHERE `Matrix_Unique_ID` = '211976130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '10106508' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157659' ,`Longitude` = '-95.056886' ,`PhotoCount` = '24' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '212454.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5117' ,`StreetNumber` = '35' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.35' ,`Area` = '52' ,`BuilderName` = 'ASGi Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 1, BLOCK 10, LOT 1638, ACRES .35' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe, Sec 1' ,`TaxAmount` = '940' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623696' WHERE `Matrix_Unique_ID` = '211978905' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '48229944' ,`ListAgentFullName` = 'Tiffany LaRose' ,`ListOfficeName` = 'The LaRose Kaileh Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739852' ,`Longitude` = '-95.445783' ,`PhotoCount` = '42' ,`PostalCode` = '77027' ,`RoomCount` = '10' ,`ListPrice` = '3395000.00' ,`Status` = 'Active' ,`StreetName` = 'Essex' ,`StreetNumber` = '4006' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another Carol Isaak Barden project: House 21. The House of Many Palms, situated in the prestigious Highland Village subdivision, has been influenced by the glamorous luxury of West Palm Beach. Situated on a 7,700 square foot lot, the gated 5 bedroom, 4 1/2 bath home, has a spacious kitchen and vast entertaining area, a north-facing tropical garden, and is designed for indoor and outdoor living. Amenities include a soaring 24-foot entrance, an elevator shaft, and massive amounts of storage. The house has many large walls having been designed with art collectors in mind. Scott Strasser, designer, gave the house transformational rooms infused with natural light. Developer Carol Isaak Barden avoided cold, austere spaces in favor of luxurious finishes and lighting.' ,`Acres` = '0.1768' ,`Area` = '16' ,`BuilderName` = 'Carol Isaak Barden' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Highland Village/Midlane' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 5 HIGHLAND VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Village' ,`TaxAmount` = '16690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623697' WHERE `Matrix_Unique_ID` = '212514924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '42016741' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404359' ,`Longitude` = '-95.507747' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '426565.00' ,`Status` = 'Active' ,`StreetName` = 'Northern Pike' ,`StreetNumber` = '412' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story | 4 Bedrooms | Study | 3 baths | Covered Patio | 2-car Garage | Located on a cul-de-sac without a direct back neighbor.\r\nHome is under construction, photos are representative. New photography coming soon. Home is available for immediate move in!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '412 NORTHERN PIKE DR, WILLIS, TX 77318' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 11' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623697' WHERE `Matrix_Unique_ID` = '212857112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '87618697' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404344' ,`Longitude` = '-95.507608' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '462665.00' ,`Status` = 'Active' ,`StreetName` = 'Northern Pike' ,`StreetNumber` = '408' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large open family room, casual dining, and kitchen with countertop dining overlooks covered patio and is easily accessible to study. Private primary suite with spacious primary bath with double sinks, garden tub, shower, and ample closet space. Utility room is centrally located. Photos are representative and are not of the actual home. Professional photos coming soon. For more info, contact Chesmar Homes in The Woodlands Hills. Available for immediate move-in!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927111 - The Woodlands Hills 11, BLOCK 2, Lot 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills 11' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623697' WHERE `Matrix_Unique_ID` = '212858177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '15209685' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Juliann Rhodes' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '30.119286' ,`Longitude` = '-95.638466' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Capella' ,`StreetNumber` = '31510' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHECK OUT THE VIRTUAL TOUR ~ Charming Traditional Two Story Conveniently located in Tomball near FM 249 in quiet neighborhood on a cul-de-sac Street. This home features 3 Bedrooms, 2 1/2 Bathrooms, Game Room & Formal Dining Room with Sculpted Ceiling. The Kitchen offers Granite Countertops, 42\" Upper Cabinets, Gas Cooktop, Convection Oven, Refrigerator & Huge Walk In Pantry. On the second floor is a Large oversized Primary Suite with sitting area. Primary Bath has Dual Sinks, Whirlpool Tub, Separate Shower and Amazing Walk In Closest. Beautifully Landscaped Yard with Rain Bird Sprinkler System, Backyard with Privacy Fence. This Home offers Lots of Storage Space, Workspace & Cabinets in Garage. Walking distance to Tomball Junior High and Tomball High School. 2 Minutes from 249. HVAC system fully replaced in 2020. Low Tax Rate! Schedule your own private tour.' ,`Acres` = '0.1736' ,`Area` = '14' ,`BuilderName` = 'Norwood Homes Texas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 4 NORTH STAR ESTATES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Star Estates' ,`TaxAmount` = '6035' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623697' WHERE `Matrix_Unique_ID` = '213018121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '47044795' ,`ListAgentFullName` = 'Andrew McCain' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721092' ,`Longitude` = '-95.404870' ,`PhotoCount` = '39' ,`PostalCode` = '77005' ,`RoomCount` = '16' ,`ListPrice` = '3245000.00' ,`Status` = 'Active' ,`StreetName` = 'Bolsover' ,`StreetNumber` = '1907' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Southampton. Classic elegant design of Reagan-Andre Architects. 4 Bedrooms, 4.5 Baths, Formals, Family Room, Gameroom, oversized 2 car garage, private alley way access. Exquisite new construction by Grace Development known for quality construction in Southampton. This home features architectural designs, custom millwork, high end fixtures & grand spaces. Entry foyer invites into formal rooms or leads to family rooms. All bedrooms upstairs each w/ensuite bath. Primary has cathedral ceiling, sitting area and luxurious ensuite. Wonderful natural light floods the rooms and sets off the millwork. French white oak wide plank eng hardwoods, marble and stone flooring throughout the home. Marble and Quartzite countertops. Elevator capable. SubZero-Wolf appliances. Beautifully landscaped front yard and fenced backyard with room for a pool and outdoor entertainment. Tree lined location across from Rice U, this residence is minutes from the medical center, downtown, museums.' ,`Acres` = '0.1653' ,`Area` = '17' ,`BuilderName` = 'Grace Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 2 SOUTHAMPTON PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southampton Place' ,`TaxAmount` = '38414' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623698' WHERE `Matrix_Unique_ID` = '213034401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '10948277' ,`ListAgentFullName` = 'Anne Bielstein' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192423' ,`Longitude` = '-95.539456' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '16' ,`ListPrice` = '2180000.00' ,`Status` = 'Active' ,`StreetName` = 'Winslow' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5157' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Outstanding custom home on a peaceful wooded 3/4+ acre cul-de-sac lot in the heart of guard-gated Carlton Woods. Lives like a one story!!! Superbly renovated and updated with the utmost attention to details. Grand floor plan with high ceilings - great flow for living and entertaining - formal LR and DR, home office/library, spacious den with custom millwork entertainment wall. Private primary suite with fireplace – serene ensuite bath and dual closets. Plus a private 2nd bedroom/guest suite down. Gourmet kitchen + butler’s pantry is a show-stopper - beautifully redone with custom millwork and architectural accents + fresh color palette and Quartzite countertops and backsplash. Stepping outside from multiple doorways you’ll find terraces surrounding a heated pool and separate spa, plus a covered terrace with fireplace and outdoor kitchen. Upstairs is a spacious home theatre room with wet bar and custom millwork entertainment wall and two bedrooms with ensuite baths. Impeccable!' ,`Acres` = '0.774' ,`Area` = '15' ,`BuilderName` = 'Robin Rueby' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18, BLOCK 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Wooded' ,`LotSize` = '33715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Of Carlton Woods' ,`TaxAmount` = '34496' ,`TaxRate` = '2.18' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623698' WHERE `Matrix_Unique_ID` = '213238092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '55100339' ,`ListAgentFullName` = 'Caroline Schlemmer' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798369' ,`Longitude` = '-95.403683' ,`PhotoCount` = '35' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashland' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1915 Heights bungalow has been thoughtfully expanded to feature a stunning light-filled addition that lends contemporary design elements to this historic home with floor to ceiling metal windows and panoramic double sliding door that overlooks the lush 8,800 sf double lot. The renovation added an additional living area, a primary suite featuring a luxurious bath, re-imagined closet & laundry room to maximize storage and also preserved the original artwork of renowned artist Daniel Anguilu. The floor plan also includes 2 secondary bedrooms, study/formal living & formal dining. Some of the original details include: hardwood floors (refinished in 2022), transom windows, wall paneling, moldings and glass door hardware. The fully fenced outdoor space is exceptional with a front porch overlooking the yard, spacious backyard with seating areas and firepit, mosquito system, storage shed & long driveway. Located just 2 blocks from the hike/bike trail provides great walkability too!' ,`Acres` = '0.202' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 15 & 16 BLK 146 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '19543' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623698' WHERE `Matrix_Unique_ID` = '213812253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '41500277' ,`ListAgentFullName` = 'Caroline Schlemmer' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = 'Cheryl McCleary' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`Latitude` = '29.784561' ,`Longitude` = '-95.384712' ,`PhotoCount` = '43' ,`PostalCode` = '77009' ,`RoomCount` = '11' ,`ListPrice` = '1650000.00' ,`Status` = 'Option Pending' ,`StreetName` = '7th 1/2' ,`StreetNumber` = '1028' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4629' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Woodland Heights home located on an incredible block with 4 bedrooms/4.5 baths, a saltwater/heated pool & zoned to Travis Elementary! True chef’s kitchen w/ two islands, double ovens & bar area. Upstairs features a very spacious primary suite, 3 secondary bedrooms including a large bedroom that would be an ideal home office or gym plus an open flex space. Updates/Features: impressive spiral staircase, exterior paint(2022), interior paint(2022), pool equipment(2020), whole home water filtration system, reverse osmosis water filter at kitchen sink & AC systems replaced(2018). Fantastic outdoor spaces include a large screened porch overlooking the pool & yard, covered front porch, long gated driveway & oversized 2-car garage. Located on a picture-perfect block lined with mature Live Oak trees and just a short walk to Norhill Esplanade, Stude Park, hike/bike trails access points & neighborhood shops/restaurants along White Oak & Studewood. This beauty has it all!' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 19 NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Woodland Heights' ,`TaxAmount` = '35042' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623698' WHERE `Matrix_Unique_ID` = '213845534' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '77211638' ,`ListAgentFullName` = 'Ginny Jackson' ,`ListOfficeName` = 'New Leaf Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710511' ,`Longitude` = '-95.432329' ,`PhotoCount` = '34' ,`PostalCode` = '77005' ,`RoomCount` = '12' ,`ListPrice` = '2150000.00' ,`Status` = 'Active' ,`StreetName` = 'Mercer' ,`StreetNumber` = '6512' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful light filled home featuring front and back covered porches in West U! 4 bedrooms, 6 full baths plus oversized third floor game room with additional space that could be a fifth bedroom. Full kitchen renovation in 2016 and features fine cabinetry, under counter and accent lighting and top of the line appliances. Handsome paneled study with french doors. Spacious master suite with reading lights and coffered ceilings. Recessed lighting and switches/outlets updated, surround sound speakers. Back yard is complete with turf and an incredible covered outdoor kitchen/living space with outdoor speakers. Each bedroom has a private bath. Elevator capable to third floor! Convenient to West U elementary, Rice Village and the medical center. Replaced all HVAC 2015/2018!' ,`Acres` = '0.1492' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5A BLK 35 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '33464' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623699' WHERE `Matrix_Unique_ID` = '213864330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:21:29.250' ,`MLSNumber` = '26422034' ,`ListAgentFullName` = 'Nicholas Damian' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681030' ,`Longitude` = '-95.709767' ,`PhotoCount` = '28' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '320900.00' ,`Status` = 'Active' ,`StreetName` = 'Majestic Vista' ,`StreetNumber` = '18810' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '~Taylor Morrison home designed for entertaining ~ Enter through the impressive foyer with high tray-style ceilings, then continue to the center of the home which functions as one large integrated space for cooking, dining, and socializing. The kitchen design is perfect for casual and formal occasions and is open to the family & dining room, family room has 10\' cove style ceiling. Relax in your owner\'s suite at the back of the home separated from the guest bedrooms and office/4th bedroom that are located on the opposite side of the home. Enter the owner\'s bath through double doors, inside you\'ll find dual sinks with quartz countertops , linen closet, a separate intricate tile walk-in shower, a luxurious big garden-style tub to soak in, and an extra-large walk-in closet. The huge study features a small closet making it possible to use the space as a 4th bedroom if needed. This home is strategically located with nearby access to Westpark Tollway, 99, HWY 6, 90, or 59!' ,`Acres` = '0.1502' ,`Area` = '37' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 6, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista' ,`TaxAmount` = '5102' ,`TaxRate` = '2.4429' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623699' WHERE `Matrix_Unique_ID` = '213902885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '77165219' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924055' ,`Longitude` = '-95.732414' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '484000.00' ,`Status` = 'Active' ,`StreetName` = 'Prosperous' ,`StreetNumber` = '15107' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle dreams with the Modern Farmhouse design of The Allanson in Bridgeland\'s Parkland Row. This chef\'s kitchen offers all the culinary conveniences celebratory feasts, everyday breakfasts, and quick snacks. The sliding glass doors open up to your oversized covered patio with plenty of room to gather in the evening with family and friends. Enjoy relaxing in your private Owner’s Retreat & spa like bathroom.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas 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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623699' WHERE `Matrix_Unique_ID` = '214008748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '67968297' ,`ListAgentFullName` = 'Caroline Schlemmer' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801038' ,`Longitude` = '-95.403419' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '889000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashland' ,`StreetNumber` = '1708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury appointments and only 2 blocks to 19th Street with easy access to neighborhood hotspots, parks & hike/bike trail! Elegant New Orleans style home is located in a gated community complete with lush landscaping & common area amenities including 10,000 sf rooftop deck, putting green, plunge pool, firepit area & outdoor sitting areas throughout the community. Home includes a welcoming foyer & 1st floor guest suite w/ full bath. Chef’s kitchen w/ a large island, custom cabinetry w/ soft close drawers & cabinets, Thermador appliances including double oven, gas cooktop & microwave drawer. Open concept 2nd floor includes a stylish beamed ceiling & large living room with amazing natural light plus a custom-built office with pocket door. Spacious primary suite on the 3rd floor with spa-like bath 2 oversized walk-in closets plus 3rd floor guest suite. This stunning home in highly desired Heights location is an entertainer’s dream and perfect for a lock & leave lifestyle as well.' ,`Acres` = '0.0389' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 BELL HEIGHTS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1696' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4461' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Bell Heights' ,`TaxAmount` = '15564' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623699' WHERE `Matrix_Unique_ID` = '214087536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '9214209' ,`ListAgentFullName` = 'George Sutherland' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Vikki Evans' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.724457' ,`Longitude` = '-95.443987' ,`PhotoCount` = '30' ,`PostalCode` = '77005' ,`RoomCount` = '13' ,`ListPrice` = '1190000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Law' ,`StreetNumber` = '4119' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously maintained and tastefully updated traditional brick home in highly desired West University Place and just 2 blocks from shops, grocery stores, restaurants, etc. Enter the gracious hallway leading to formal living, dining and then spreading full house breadth to an open flow kitchen, breakfast and family room which look through a wall of sunlit windows onto the landscaped back patio and yard. Upstairs to the gracious primary suite with large sitting area and sparkling bath with frameless glass shower, jetted tub, double sinks, double closets and vanity area. Three additional spacious bedrooms and two baths plus a game room and utility room, all accessed from a central hallway with an elevator capable closet. Enjoy West U’s fabulous amenities, among them parks, pools, ballfields, recreation center, library, oak shaded streets and popular restaurants plus municipal government with dedicated police force and fire department; all at a lower tax rate than Houston. All per Seller' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 17 COLLEGE COURT PLACE' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'College Court Place' ,`TaxAmount` = '21840' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623699' WHERE `Matrix_Unique_ID` = '214236857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '37555872' ,`ListAgentFullName` = 'Hayden Hamilton' ,`ListOfficeName` = 'South RECA' ,`SellingAgentFullName` = 'Leticia Zapata' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.862489' ,`Longitude` = '-95.394941' ,`PhotoCount` = '3' ,`PostalCode` = '77076' ,`RoomCount` = '3' ,`ListPrice` = '165000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Spreading Oak' ,`StreetNumber` = '150' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Corner-Lot Home located next to Northline Park will not last long! ***Room measurements are approximate.*** Square Footage information provided by Appraisal District.' ,`Acres` = '0.1784' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 53 BLK 3 AIRLINE MANOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7770' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURKEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'FONVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Airline Manor' ,`TaxAmount` = '3212' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623700' WHERE `Matrix_Unique_ID` = '214276911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '78255241' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923841' ,`Longitude` = '-95.732543' ,`PhotoCount` = '41' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '592326.00' ,`Status` = 'Active' ,`StreetName` = 'Prosperous' ,`StreetNumber` = '15111' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2354' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle dreams with the Modern Farmhouse design of The Crowson in Bridgeland\'s Parkland Row. Working from home is a breeze with your quiet study off the entry. This chef\'s kitchen offers all the culinary conveniences celebratory feasts, everyday breakfasts, and quick snacks. The oversized covered patio gives you plenty of room to gather in the evening family and friends. Enjoy relaxing in your private Owner’s Retreat & spa like bathroom. Doing laundry will be a breeze with a direct access door from the walk-in closet to the utility room. There’s plenty of space for storage, a garage workshop or a third car in the extensive garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 5' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas 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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668623700' WHERE `Matrix_Unique_ID` = '214283789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '54437009' ,`ListAgentFullName` = 'Sandra Paul' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782938' ,`Longitude` = '-95.352824' ,`PhotoCount` = '35' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Terry' ,`StreetNumber` = '2312' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like new, taken down to the studs, this centrally located home is absolutely beautiful! With 3 bedrooms and 2 full baths, you will love the open-concept layout of the entertaining areas. The living space, dining room, and kitchen flow seamlessly together and offer plenty of room to spread out. Immediately, you will notice the high ceilings, the immense amount of natural light, and the neutral color palette throughout. The Seller has done a masterful job blending traditional elements like hexagon floor tiles, subway kitchen backsplash with contemporary new cabinets, quartz counters in the kitchen and bathrooms, and stunning modern light fixtures and sleek black hardware. No detail has been overlooked in this renovation. The entire property is fenced. There\'s a lovely front porch for a swing or morning coffee and plenty of room for a firepit or seating area in the backyard. The commute to Downtown, Midtown, and the Rail is short. Easy access to 45N, US-59, 610 Loop and Hardy Toll Rd.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 46 LITTLE & DICKINSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Little & Dickinson' ,`TaxAmount` = '1909' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623700' WHERE `Matrix_Unique_ID` = '214293864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '78802976' ,`ListAgentFullName` = 'Kathleen Graf' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698266' ,`Longitude` = '-95.472402' ,`PhotoCount` = '29' ,`PostalCode` = '77401' ,`RoomCount` = '9' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen' ,`StreetNumber` = '5315' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live in the heart of Bellaire! Just half a mile from the Bellaire Family Aquatic Center & zoned to Condit Elementary School as well as Pershing & Bellaire High School(buyer to verify & confirm eligibility & enrollment). Although close to all Bellaire has to offer, this home features its own glistening pool w/reverse swim feature. With a flowing floor plan, high ceilings, tasteful moldings, & gleaming hardwood floors, this home is inviting from the moment you walk through the door. The kitchen opens to the breakfast & family rooms w/a gorgeous view of the pool & backyard. Upstairs, a second living area can serve as a TV room, game room or separate living area. The large primary bedroom has two walk-in closets & the primary bath w/travertine tile has a jetted tub w/separate frameless shower. AC system for 2nd & 3rd floor replaced in June of 2022, included both the coil and condensing unit. All info per seller' ,`Acres` = '0.1405' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 10 PEACEFUL VALLEY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peaceful Valley' ,`TaxAmount` = '18413' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623700' WHERE `Matrix_Unique_ID` = '214368666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '75628772' ,`ListAgentFullName` = 'Jacqueline Kneese' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.715647' ,`Longitude` = '-95.430720' ,`PhotoCount` = '36' ,`PostalCode` = '77005' ,`RoomCount` = '8' ,`ListPrice` = '2185000.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '3419' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live! You will love living in this charming Bardwell home in a prime West University location within walking distance from popular restaurants, parks and the elementary school. The updated kitchen has Carrara marble countertops/backsplash, 2018 Bosch dishwasher, a 2020 Wolf double oven, a 2018 Viking range, a SubZero refrigerator, butler\'s pantry, wine cooler and Viking microwave.* In 2020, the family room was extended* and opens to the flagstone patio and turfed backyard complete with a gazebo. Standouts include new windows and doors (\'20-21)*, Aquasana system (\'21)*, Honeywell direct link alarm (\'22)*, LiftMaster driveway gate (\'21)*, Nest thermostats*, water heaters (\'18/\'20)*, A/C (\'17)*, wet bar, remodeled primary bathroom (\'13) & secondary baths (\'21)*, formal living room, dining room, study/office and a bonus apartment over the garage remodeled (15).* Cedar closet, EV charger in garage, lots of storage!\r\n*As per seller' ,`Acres` = '0.1722' ,`Area` = '17' ,`BuilderName` = 'Bardwell' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1B BLK 46 WEST UNIVERSITY PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West University Place Sec 02' ,`TaxAmount` = '36536' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623701' WHERE `Matrix_Unique_ID` = '214430392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-16T01:22:00.480' ,`MLSNumber` = '92429290' ,`ListAgentFullName` = 'Suzann Richardson' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Lexi Sakowitz Marek' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.716711' ,`Longitude` = '-95.426432' ,`PhotoCount` = '40' ,`PostalCode` = '77005' ,`RoomCount` = '10' ,`ListPrice` = '1595000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Jarrard' ,`StreetNumber` = '3108' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This classic brick traditional home has everything you need! Four bedrooms, three & a half bathrooms, hardwood floors, walk-in closets, turf backyard plus high ceilings all on one of the neighborhood’s most sought after streets. Spacious dining room & living room flank the front entryway. Large family room with fireplace, built-in cabinetry & French doors overlooking the backyard. Kitchen is well-equipped with Wolf gas cooktop, Bosch dishwasher, gorgeous marble countertops & light filled breakfast area. Primary suite with coffered ceiling, two walk in closets, double sinks, separate shower plus large tub. Three generous secondary bedrooms with walk in closets. Other highlights include shutters on downstairs front & upstairs windows, recent landscaping plus turf in the backyard. Gated driveway & detached two car garage.' ,`Acres` = '0.1205' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 8 RICE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rice Court' ,`TaxAmount` = '23774' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668623701' WHERE `Matrix_Unique_ID` = '214499639' --> 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','214795189','1668623701','214795189','2022-11-16T01:39:30.827','23786650','Alan Herrera','Walzel Properties','','','29.929135','-95.569664','17','77064','11','312000.00','Active','Rippling Fields','9910','Drive','Houston','2','0','3','1732','Single-Family','immaculate maintained! New low E windows throughout. Kitchen features lots of cabinetry. The breakfast room flows effortlessly into the living room which features a floor to ceiling brick fireplace. \r\nMain room retreat features & in-suite bathroom with updated amenities, granite tops and large glass surround walk in shower with custom tile work and shower seat. Mature tress that bring character to your backyard as you enjoy a beautiful screened room!! the perfect place to appreciate your new home.','0.1716','10','N/A','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding','1','Willowbrook South','Central Electric','1','LT 22 BLK 9 HARVEST BEND SEC 1','Subdivision Lot','7475','Appraisal District','','400','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','13 - Cypress-Fairbanks','FRANCONE ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Harvest Bend Sec 01','5239','2.5587','Public Sewer,Public Water','1978','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','214795793','1668623701','214795793','2022-11-16T01:40:55.250','70115795','Colleen Adams','CB&A, Realtors-Katy','','','29.760405','-95.899498','47','77423','8','445000.00','Active','Falcon Trace','30710','','Brookshire','2','1','4','2465','Single-Family','Welcome home to this beautiful Jordan Ranch J Patrick home. LIKE NEW HOME without the new home price. Enter this lovely home through the beautiful wood & glass front door into the welcoming foyer boasting high ceilings and gorgeous tile that goes through out the main living areas of this home. Plentiful windows let natural light into the space! Kitchen features stainless steel Whirlpool appliances, 5-burner gas range, double ovens, microwave and dishwasher. Beautiful granite counter tops and subway tile backsplash dress up the ample counter space and generous amount of storage. Large primary bedroom & adjacent bath includes a vanity with double sinks, separate shower, comfortable soaking tub & large master closet. Recessed lighting throughout this home, ceiling fans, covered patio (plumbed for an outdoor kitchen) with ceiling fan, full sprinkler system, oversized 2 car garage with pop-out storage area. Call today for your private tour of this beautiful home.','0.1836','30','J Patrick','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fulshear/South Brookshire/Simonton','Central Gas','1','JORDAN RANCH SEC 2, BLOCK 3, LOT 3','Cul-De-Sac,Subdivision Lot','7999','Appraisal District','','1050','0','','2','Convection Oven,Double Oven,Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Jordan Ranch','10552','3.1948','Water District','2017','Appraisal District'); --> New record created successfully