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-15T00:20:53.150' ,`MLSNumber` = '94613545' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.431686' ,`Longitude` = '-95.408468' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Watson' ,`StreetNumber` = '4030' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 94613545 - Built by Highland Homes - Ready Now! ~ Located 10 minutes from Pearland! As you enter the home, you\'re greeted by soaring 19ft ceilings & double stacked windows at the family room which let natural light pour in. Wood-look tile is in all main living areas. Dream kitchen features built-in stainless steel appliances, endless storage & countertop space, perfect for meal prepping! Upstairs is a spacious game room that can be used for hosting movie nights, game nights, study area, and more! Secondary bedroom located DOWNSTAIRS! Front yard maintenance covered by developer. On-site schools. Live the Meridiana lifestyle with fun-filled activities planned daily and unmatched amenities at the Oasis Village such as a cafe, 24 hr fitness center with lap pool, resort style pool & splashpad, event space overlooking the lake. running & biking trails, playgrounds, dog park, and more! Make an appointment today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 76A (A0287 HT&BRR) (IOWA COLONY) BLK 2 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4902' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527674' WHERE `Matrix_Unique_ID` = '208560608' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:21:11.277' ,`MLSNumber` = '43530123' ,`ListAgentFullName` = 'Ruby McCullough' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = 'Ruby McCullough' ,`SellingOfficeName` = 'Keller Williams Platinum' ,`Latitude` = '29.912683' ,`Longitude` = '-96.869865' ,`PhotoCount` = '28' ,`PostalCode` = '78945' ,`RoomCount` = '5' ,`ListPrice` = '239000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fannin' ,`StreetNumber` = '902' ,`StreetSuffix` = 'Street' ,`City` = 'La Grange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful four bedroom, two bath Manufactured Clayton home is situated on approximately 0.2669 acres. This 2020 Open Concept Farm Style home features a split level floorplan, a large fenced yard, 10x20 workshop, carport, and an enclosed greenhouse (8\' X 15\'), just waiting for you to try out your gardening skills! The primary bathroom has a large soaker tub and a separate tiled walk-in shower, a dream kitchen with a oversized island (4\'2\" X 10\'), where you can feed the entire family; the kitchen sink faces the living room.\r\nUpgraded/added features include, tape and textured walls throughout, custom painted accent walls, decorative tin backsplashes in kitchen/bathrooms, ceiling fans in bedrooms/living room, gutters on the front of the home. Concrete driveway/sidewalks leads up to the workshop and the home.\r\n\r\n“Don’t miss out on this captivating home. Schedule a private tour today!”' ,`Acres` = '0.27' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0.2669 MANUFACTURED HOME C/PORT S#ATH002170TXA/B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Split Level' ,`Subdivision` = 'MOORE FARM BLOCKS (446) Lot 8 Block 47' ,`TaxAmount` = '927' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527674' WHERE `Matrix_Unique_ID` = '210792296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:55:13.380' ,`MLSNumber` = '91605400' ,`ListAgentFullName` = 'Jennifer Robinson' ,`ListOfficeName` = 'J\'s Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589986' ,`Longitude` = '-95.517071' ,`PhotoCount` = '21' ,`PostalCode` = '77489' ,`RoomCount` = '12' ,`ListPrice` = '265900.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Echo' ,`StreetNumber` = '16331' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hidden Jewel in Missouri City! \r\nA beautiful traditional home located in the Quail Run subdivision perfect for any family. Large Master Bedroom is down stairs which includes a Master Bathroom and large Walk In Closet. Formal Living and Dining Room, Kitchen includes plenty of cabinets with beautiful granite counter tops. Large game room and two spacious bedrooms upstairs for maximum comfort. Upgrades and Fresh Painting throughout the interior of the home, along with some Exterior painting, \r\nNice Size Backyard which includes a covered Patio! New Dish Washer and New A/C unit for the upstairs. Stainless Steel Refrigerator can stay with the House, New Double Oven or Wall Microwave with Oven to be Installed before Closing.' ,`Acres` = '0.1515' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL RUN SEC 1, BLOCK 14, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'EDGAR GLOVER JR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Run Sec 1' ,`TaxAmount` = '4691' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527674' WHERE `Matrix_Unique_ID` = '211706823' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T23:30:45.603' ,`MLSNumber` = '81275534' ,`ListAgentFullName` = 'Jacqueline Cooper' ,`ListOfficeName` = 'CCD Ventures' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779757' ,`Longitude` = '-95.553881' ,`PhotoCount` = '22' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '713000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Meadow' ,`StreetNumber` = '12602' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story 4/2.5 on quite cul-del-sac featuring breakfast nook, formal dining, family room with fireplace, master bed up, nice large backyard with a 2 car detached garage. Located near City Centre and Memorial City a must see!' ,`Acres` = '0.2027' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 1O FONN VILLAS SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fonn Villas Sec 05' ,`TaxAmount` = '15733' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527674' WHERE `Matrix_Unique_ID` = '211816097' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:28:36.550' ,`MLSNumber` = '48132090' ,`ListAgentFullName` = 'Mario Flores' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667751' ,`Longitude` = '-95.303982' ,`PhotoCount` = '22' ,`PostalCode` = '77087' ,`RoomCount` = '5' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Flamingo' ,`StreetNumber` = '7022' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEED SPACE DON\'T LOOK ANY MORE!! BEAUTIFUL TOTALLY REMODELED HOME READY TO MOVE IN!!! JUST COME AND SEE THIS HUGE HOME WITH 5 BEDROOMS 3 1/2 BATH WITH FORMAL LIVING, DINING AND LAUNDRY ROOM INSIDE, JACUZZI IN MASTER ROOM, NEW A/C UNIT HUGE BACK YARD WITH A SUN ROOM. YOU WON\'T BE DISAPOINTED! HURRY THIS WON\'T LAST!!!' ,`Acres` = '0.3186' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 11 BAYOU OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Oaks' ,`TaxAmount` = '4990' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527675' WHERE `Matrix_Unique_ID` = '212178109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T23:30:29.817' ,`MLSNumber` = '33260048' ,`ListAgentFullName` = 'Ruth Hawkins' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = 'Thanh Tran' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.854948' ,`Longitude` = '-95.721779' ,`PhotoCount` = '20' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Meadowivy' ,`StreetNumber` = '5814' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful listing is ready for a new family to call home! A charming one-story floorplan is bright and open with high ceilings, designer neutral paint, and tons of natural light. Relax with your family in the spacious family room that is the central hub of the home. A serving bar keeps this space open to the kitchen for seamless family living and extra counter space when entertaining. Your family chef will appreciate the beautiful and functional kitchen complete with a gas range, stainless steel appliances, and walk-in pantry. The casual dining area is just off the kitchen. Tucked away at the back of the home is the luxurious owner\'s suite complete with wood laminate floors, an en-suite bath, and walk-in closet! All the bedrooms boasts wood laminate flooring. there\'s no carpet in this home! The backyard offers plenty of space where the kiddos and pets can play. Close to tons of great shopping and dining. New 2022: HVAC, microwave. Water heater 3 years old, New left fence.' ,`Acres` = '0.1149' ,`Area` = '25' ,`BuilderName` = 'MHI' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 2 BEAR CREEK GLEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bear Crk Glen' ,`TaxAmount` = '4821' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527675' WHERE `Matrix_Unique_ID` = '213024186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T23:31:17.113' ,`MLSNumber` = '44761345' ,`ListAgentFullName` = 'Knakita Jones' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.987921' ,`Longitude` = '-95.536346' ,`PhotoCount` = '35' ,`PostalCode` = '77069' ,`RoomCount` = '7' ,`ListPrice` = '286000.00' ,`Status` = 'Active' ,`StreetName` = 'Champions' ,`StreetNumber` = '14241' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! This well maintained, 1 story patio home in the beautiful, quaint, sought-after area of Champions Creek is waiting on you. Nice size island kitchen with a recently installed cook top, as per seller. Lots of cabinets and granite countertops with a breakfast area that looks out to your private patio/garden area. Kitchen has a built in desk area. The home has a formal dining room, a living room that features a gas log fireplace surrounded by built-ins, crown molding and high ceilings. The large primary bedroom has one walk-in closet and a second closet once you go through the bathroom. The bathroom featuring separate shower with bench & dual shower heads, soaker tub with dual vanity. The 2 secondary bedrooms and another bath is on the opposite side of the home. This is a fabulous location within walking distance to Champions Golf Club. Easy access to HWY 249 and Beltway 8 and LOW TAXES!!!' ,`Acres` = '0.0763' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 5 CHAMPIONS CREEK' ,`LotDesciption` = 'In Golf Course Community,Patio Lot' ,`LotSize` = '3325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Creek' ,`TaxAmount` = '5896' ,`TaxRate` = '2.5156' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527675' WHERE `Matrix_Unique_ID` = '213183055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:20:52.447' ,`MLSNumber` = '13213860' ,`ListAgentFullName` = 'Julie Husband' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Janet Martinez' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.646649' ,`Longitude` = '-95.139232' ,`PhotoCount` = '26' ,`PostalCode` = '77505' ,`RoomCount` = '7' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Winterborne' ,`StreetNumber` = '4222' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated with lots of upgrades, this oversized home features a massive living area, updated kitchen, breakfast area and an additional den/family room!! You\'ll love the patio covered backyard with new fans, lots of privacy and a workshop!! New roof, new windows, new paint, new flooring, new kitchen countertops and tons more!! Don\'t miss this one!!' ,`Acres` = '0.1742' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 VILLAGE GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Village Grove Sec 01' ,`TaxAmount` = '6119' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527675' WHERE `Matrix_Unique_ID` = '213238080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:20:52.260' ,`MLSNumber` = '14182450' ,`ListAgentFullName` = 'Jose Ramirez Garcia' ,`ListOfficeName` = 'American Property Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.370680' ,`Longitude` = '-95.492285' ,`PhotoCount` = '22' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Palmetto' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Place' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 31 Palmetto Place. Conveniently located near 45 North, Panorama Golf Club, Lake Conroe, and more. This single-story home sits on a half-acre corner lot boasting over 2,000 square feet of living space. Featuring a fresh new coat of interior paint. The interior includes 3 bedrooms, and 2 baths with double vanity sink in the primary restroom, a massive walk-in pantry, and a wood-burning fireplace. New carpet and fixtures. A Generac gas-powered backup generator is also included! The exterior of the home also features a fresh new coat of paint surrounded by mature oak trees. Contact your REALTOR today to add this home to your viewing list.' ,`Acres` = '0.2686' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PANORAMA-GREEN BRIAR 01, LOT 31' ,`LotDesciption` = 'Corner' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama-Green Briar 01' ,`TaxAmount` = '4486' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527676' WHERE `Matrix_Unique_ID` = '213559598' --> 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','213563450','1668527676','213563450','2022-11-15T00:20:53.273','52333388','Candra Brown','eXp Realty, LLC','','','29.817635','-95.384025','25','77022','3','489990.00','Active','34th','1215','Street','Houston','2','1','3','1954','Single-Family','Located in the upcoming area of Laurel Heights. This new construction 2-story home features covered back patio, double wide driveway, welcoming front door entry, large windows throughout, and a large open living room, dining combo with an island kitchen you will fall in love with. Zoned to the historical Washington High School.','0.0875','9','WBJ Holding Company','','','','No Disclosures','1','','','Northwest Houston','Central Electric','0','LT 8 BLK 1 LAUREL HEIGHTS','Subdivision Lot','3810','Survey','','','1','Never Lived In','2','','0','','','','','Composition','27 - Houston','BURRUS ELEMENTARY SCHOOL','WASHINGTON HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Builder','2','Traditional','Laurel Heights','1776','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:38:54.120' ,`MLSNumber` = '31869760' ,`ListAgentFullName` = 'Rebecca Drake' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.149650' ,`Longitude` = '-95.504620' ,`PhotoCount` = '22' ,`PostalCode` = '77381' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Wavy Oak' ,`StreetNumber` = '37' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In this central Woodlands location this charming one story home is situated on a greenbelt home site and is nestled amongst beautiful, mature trees. Owners have updated the exterior with Hardie Plank siding, concrete driveway, garage door, and energy-efficient double-paned windows. The home has been freshly painted inside, and has easy-care laminate flooring in the living area. No carpet here. There\'s plenty of potential here for you to add your own touches to this sweet home, but it\'s neutral, clean and ready to go. Garage has a nice-sized storage closet for added convenience. The back yard is fenced too.' ,`Acres` = '0.1217' ,`Area` = '15' ,`BuilderName` = 'Glenwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 9, BLOCK 9' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '5300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GLEN LOCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Woodlands Village Panther Creek' ,`TaxAmount` = '3449' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527676' WHERE `Matrix_Unique_ID` = '213574584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:20:52.103' ,`MLSNumber` = '91705810' ,`ListAgentFullName` = 'Luis Ramirez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687627' ,`Longitude` = '-95.670537' ,`PhotoCount` = '32' ,`PostalCode` = '77083' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Barbarossa' ,`StreetNumber` = '16143' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a charming one-story home for sale! Fall in love with the sweet curb appeal, lush front yard, and welcoming porch. Inside, you\'ll discover a semi-open layout with vaulted ceilings, wood-look floors, recessed lighting, and neutral palette. The large living area brings the outdoor living in with its sliding glass doors! Immaculate kitchen has white staggered cabinets, SS appliances, granite counters, and a center island w/breakfast bar. Have a good night\'s sleep in the sizable main bedroom boasting a closet and a private ensuite with a tub/shower combination & double sinks. Spend fun weekends in your lush backyard, including two mature trees. Don\'t wait any longer to see it!' ,`Acres` = '0.1152' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION BEND SAN MIGUEL SEC 3, BLOCK 9, LOT 8 (W 42\' OF E 44' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '408' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION GLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend San Miguel Sec 3' ,`TaxAmount` = '752' ,`TaxRate` = '1.9747' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527676' WHERE `Matrix_Unique_ID` = '213630966' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:49:04.653' ,`MLSNumber` = '42113640' ,`ListAgentFullName` = 'Dalton Lytle' ,`ListOfficeName` = 'Hometown America Incorporated' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545831' ,`Longitude` = '-95.697310' ,`PhotoCount` = '39' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Knoll Forest' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ryland 4/2.5/2 floor plan on cul de sac with pool! Great floor plan, formal living or 2nd den on the left at entry, with adjoining formal dining room with chair rail molding. Impressive entry way opens to large den with traditional red brick fireplace. The den peeks into large kitchen with electric cooktop, granite, tile, and has a windowed breakfast area. Double door entry to primary suite, bath with soaking tub and separate shower with seamless glass. Three bedrooms and full bath upstairs. Light and airy home with wonderful windows, including a bay window at the front. This is a well maintained home, the roof is 2018, exterior wood has been replaced with Hardi board, and fresh paint. You only need the key! The backyard is tropical and private with a sparkling pool! It is very private as it backs to a commercial building. Large lot with mature landscaping and double wide driveway. Not in flood zone. Greatwood offers several recreational parks, pools and Greatwood Golf Club.' ,`Acres` = '0.1834' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD KNOLL SEC 4, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '7988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Knoll' ,`TaxAmount` = '5348' ,`TaxRate` = '2.0413' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527676' WHERE `Matrix_Unique_ID` = '213914570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:15:44.293' ,`MLSNumber` = '67571800' ,`ListAgentFullName` = 'Rachel Harris' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.303817' ,`Longitude` = '-95.570626' ,`PhotoCount` = '42' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Water Crest' ,`StreetNumber` = '9014' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate custom home on private, cul-de-sac/corner lot in Montgomery Trace.Enjoy tranquil mornings on the secluded front porch and relaxing evenings by the cozy outdoor fireplace. Workshop with water and whole home Generac generator complete the outdoors. The interior offers dramatic wood beams, wood-look tile and travertine flooring, stone fireplace, 4 bedrooms, 3 full and 1 half baths, a bonus room/home gym with private entrance, dedicated study w/ built-ins, media room, and massive upstairs gameroom w/ fridge and dry bar. Also upstairs is a second ensuite. Dramatic circular entry greets guests, then flows effortlessly to study with glass French doors and built-ins. Kitchen is open to family room and features stainless Monogram appliances, stunning backsplash, breakfast bar, desk area and direct access to outdoor living space with limitless potential. Minutes to shopping, dining and entertainment of ever-growing Woodforest. Short commute to convenience of The Woodlands.' ,`Acres` = '1.044' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S728110 - MONTGOMERY TRACE 10, BLOCK 3, LOT 14' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '45477' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Trace' ,`TaxAmount` = '9651' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527677' WHERE `Matrix_Unique_ID` = '213915683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:52:41.270' ,`MLSNumber` = '26185070' ,`ListAgentFullName` = 'Truc-Linh Truong' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716593' ,`Longitude` = '-95.771344' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '625940.00' ,`Status` = 'Active' ,`StreetName` = 'Shallow Spring' ,`StreetNumber` = '22610' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4118' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grand Lakes GEM with great curb appeal located on a cul-de-sac! This home features slate tile entry and impressive staircase. Elegant formal dining room and spacious office space with a bay window. Inviting kitchen with GRANITE countertops, STAINLESS STEEL APPLIANCES and a large island open to the HUGE living room. First floor primary bedroom with a large sitting area full natural light. Primary bath includes double sinks, jetted tub and 2 walk-in closets. UPGRADES and features galore w/ new flooring throughout the second floor. Large upstairs game room with a raised game/theatre area. 3 large bedrooms upstairs! EXTENDED patio, perfect for entertaining. 3 CAR DETACHED GARAGE with long driveway. This home is a MUST-SEE!' ,`Acres` = '0.2348' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES SEC 11, BLOCK 1, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Sec 11' ,`TaxAmount` = '11094' ,`TaxRate` = '2.4613' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527677' WHERE `Matrix_Unique_ID` = '214163125' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:23:31.530' ,`MLSNumber` = '95571629' ,`ListAgentFullName` = 'Nusrat Ghafoor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.048679' ,`Longitude` = '-95.694117' ,`PhotoCount` = '39' ,`PostalCode` = '77480' ,`RoomCount` = '5' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Earley' ,`StreetNumber` = '1011' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4-bedroom 2 bath home in a nice quiet subdivision! Huge Dining area and two huge living areas, perfect for entertaining guests! Gorgeous Kitchen with Quartz countertops, backsplash and brand-new stainless-steel appliances! Spacious primary suite with a beautiful primary bath, featuring a standing shower with tiled walls and quartz countertops! Two additional bedrooms next to the Primary bedroom! Beautiful spacious secondary bath! Fourth bedroom is on the opposite side of the house, ideal for privacy! Brand New Electric Box, Water heater, HVAC as well as brand new Roof and siding with WPI certificates. Huge Lot! Come and see today!' ,`Acres` = '0.3383' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EARLY TRS 48-49 BLOCK C (SWEENY) BLK 1 LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14736' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Early Trs 48-49 Blk C Sween' ,`TaxAmount` = '4428' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527677' WHERE `Matrix_Unique_ID` = '214343899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T23:20:20.980' ,`MLSNumber` = '60901406' ,`ListAgentFullName` = 'Lindsey Foster' ,`ListOfficeName` = 'Kenyson Roane Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839776' ,`Longitude` = '-95.454284' ,`PhotoCount` = '33' ,`PostalCode` = '77018' ,`RoomCount` = '11' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Del Norte' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2406 Del Norte St! Located in the highly coveted Candlelight Woods neighborhood. Walk on into the spacious home that offers cathedral ceilings in main den. Kitchen offers granite countertops and plenty of storage for all your cooking needs and a breakfast area that looks into the den. This home offers 3 spacious bedrooms, a front living room that can be converted to a 4th bedroom. Walk outside to your beautiful inground sparkling private pool and covered patio ready for entertaining. Backyard is fully fenced and NO back neighbors!! Home has new pex water plumbing and duct work in 2022, Remodeled guest bathroom, Plantation Shutters in Kitchen and Motorized private driveway gate. Don\'t miss the opportunity to call this home yours, schedule today to come see it!!' ,`Acres` = '0.1912' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 CANDLELIGHT WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '72' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Candlelight Woods' ,`TaxAmount` = '6666' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527677' WHERE `Matrix_Unique_ID` = '214474178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T00:20:51.760' ,`MLSNumber` = '16864721' ,`ListAgentFullName` = 'Juan Francisco Munoz' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906176' ,`Longitude` = '-95.640407' ,`PhotoCount` = '42' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Canton Park' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location Locatio! Bautiful sought after 5 bedroom home in the gated family friendly community of Copper Grove. This beautiful home has a private pool and no back neighbors. Home has new new porcelain tile and granite countertops. Great open floor plan and stuning high ceilings. Come check out 8907 Canton Park today. Home has never flooded.' ,`Acres` = '0.1573' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 COPPER GROVE SEC 9' ,`LotDesciption` = 'Other' ,`LotSize` = '6854' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '720' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Copper Grove Sec 09' ,`TaxAmount` = '5797' ,`TaxRate` = '2.441' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527677' WHERE `Matrix_Unique_ID` = '214580806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T23:26:58.550' ,`MLSNumber` = '56450829' ,`ListAgentFullName` = 'Vanessa Hyman' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.613641' ,`Longitude` = '-95.745241' ,`PhotoCount` = '2' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Allegro Dr' ,`StreetNumber` = '2402' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upscale Richmond . Excellent schools . \r\nCUL-DE-SAC \r\n5 Bedroom , Home Office, Game room , Bright natural light , ready for a little rehab !\r\nALL OFFERS WELCOME' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIO VISTA SEC 1, BLOCK 1, LOT 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527678' WHERE `Matrix_Unique_ID` = '214684912' --> 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','214760919','1668527678','214760919','2022-11-14T23:47:29.683','29877908','Etha Eglin','Keller Williams Metropolitan','','','30.140212','-94.411024','18','77659','8','299990.00','Active','Haidlyns','1625','Way','Sour Lake','2','0','4','2024','Single-Family','The Kingston Elevation G is a one-story modern farmhouse design featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room.','0.2859','49','D.r. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','1','LOT 58 BLK 1 HOLLY TRAILS SUB PHASE II P# HT-II-1-58','Subdivision Lot','12454','Appraisal District','','135','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','163 - Hardin-Jefferson','SOUR LAKE ELEMENTARY SCHOOL','HARDIN-JEFFERSON HIGH SCHOOL','HENDERSON MIDDLE SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Holly Trails','705','1.8384','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214761920','1668527678','214761920','2022-11-14T23:00:40.407','94628034','Jose Rayo','Vive Realty LLC','','','29.778076','-95.187537','1','77015','3','89000.00','Active','Mobile','13370','Street','Houston','1','0','3','1194','Single-Family','Investment opportunity! Drive by only!!! Do not disturb tenants.','0.1928','2','','','','','Sellers Disclosure','','','','North Channel','Central Gas','0','LT 1179 BLK 38 HOME OWNED ESTATES SEC 2','Subdivision Lot','8400','Appraisal District','','','0','','0','','0','','','','','Composition','21 - Galena Park','CIMARRON ELEMENTARY SCHOOL (GALENA PARK)','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','1','Traditional','Home Owned Estates Sec 02','3187','2.7702','Public Sewer,Public Water','1951','Appraisal District'); --> New record created successfully