Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:40:54.800' ,`MLSNumber` = '51271994' ,`ListAgentFullName` = 'Brenda Venable' ,`ListOfficeName` = 'Brenda Venable' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790230' ,`Longitude` = '-95.464204' ,`PhotoCount` = '42' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Little Caprese' ,`StreetNumber` = '7562' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a must see home! Corner end unit w/ lots of privacy! Walk through a wrought iron gate entrance to lush landscaping and a brick paved walkway! Fig ivy walls, Brick paved patio with overhang. Perfect for outdoor dining! Enter into beautiful wood flooring, downstairs bedroom w/ full bath and ELEVATOR! Walk in closet as well. Wide open living area with super high ceilings, chef\'s kitchen with the most beautiful colored cabinets (some glass front), gas cooking, Miele high end ss appliances, Liebherr refrigerator, motorized window coverings in living area, walk in pantry, walls of windows, center island with Quartz counters too! Wine refrigerator! Primary bedroom features coffered ceilings, resort style bathroom with soaking tub, large seamless glass shower, double sinks, walk in closets! Wood flooring throughout! Gated community! Lovely community pool, fabulous parks, walkways! Zoned to Memorial High School! Walking distance to Awty Int\'l School! Minutes from the Galleria/Downtown!' ,`Acres` = '0.0756' ,`Area` = '24' ,`BuilderName` = 'Lovett' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 1 RAVENNA AMEND' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '3291' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3447' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Ravenna Sub' ,`TaxAmount` = '17603' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556936' WHERE `Matrix_Unique_ID` = '210400789'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:52:52.953' ,`MLSNumber` = '57134313' ,`ListAgentFullName` = 'Barbara Bullock' ,`ListOfficeName` = 'Brockway Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599093' ,`Longitude` = '-95.117283' ,`PhotoCount` = '47' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Cavendish' ,`StreetNumber` = '15907' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T MISS YOUR OPPORTUNITY TO TOUR AND OWN THIS WELL TAKEN CARE OF, GREATLY LOVED, BEAUTIFULLY UPDATED, 3/2/2 WITH OFFICE (TEXAS BASEMENT) AND LARGE LAUNDRY ROOM IN HOUSE! IN THE WONDERFUL, SOUGHT AFTER COMMUNITY OF CLEAR LAKE CITY. HOME HAS NEW PAINT, COUNTERTOPS, BLINDS, LUXURY VINYL PLANK FLOORING, COZY FIREPLACE, LARGE, FULLY FENCED BACK YARD WITH COVERED PATIO AND HURRICANE CLIPS, NEW PEX PLUMBING THROUGHOUT. LOW TAX RATE AND LOW HOA! MOVE IN READY! NO FOUNDATION ISSUES!! ROOF HAS 30 YEAR SHINGLES AND 15 YEARS LEFT OF LIFE PER CONTRACTOR! SUBDIVISION HAS AN AREA POOL, RECREATIONAL FACILITY AND PLAYGROUND. SCHEDULE TO VIEW TODAY!! NEVER FLOODED!! ZONE X NO MANDATORY FLOOD INSURANCE REQUIRED BY LENDER.' ,`Acres` = '0.169' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 30 MIDDLEBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Middlebrook Sec 02' ,`TaxAmount` = '4973' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556936' WHERE `Matrix_Unique_ID` = '210631647'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:05:55.377' ,`MLSNumber` = '39323072' ,`ListAgentFullName` = 'Laura Austin' ,`ListOfficeName` = 'REALTY TEXAS LCA, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.296889' ,`Longitude` = '-95.487514' ,`PhotoCount` = '50' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '574990.00' ,`Status` = 'Active' ,`StreetName` = 'Pebblestone' ,`StreetNumber` = '6' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in a Cul-De-Sac street on a serene 1 Acre lot in a gated community. Here is the 3026 sq ft 1 story home you have been looking for, the space without the stairs! Yippee! Husbands, you know how sometimes you are not able to always get what YOU want in a home... Well, you will be in Garage Heaven when you see all the storage, fans, workbench, insulation, etc.,& it can all be yours! Now, Ladies, you will not be left out in the storage department, WOW, all the cabinets in the Kitchen and Walk-In Closets are everywhere! You can store to your heart\'s desire. Are you working from Home? You will have your own office with a wall of built-ins and a view of your spacious backyard. This open spacious home with a covered slate patio will be great for entertaining at your upcoming House Warming Party with your friends & family. Kitchen Frig & Micro to Stay. You will have easy access to I-45, 336 Marketplace, Lake Conroe, The Woodlands,etc. Call today to schedule your viewing before it\'s gone.' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILVERSTONE 01, BLOCK 2, LOT 60' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Silverstone 01' ,`TaxAmount` = '8388' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556936' WHERE `Matrix_Unique_ID` = '211414140'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T06:20:52.097' ,`MLSNumber` = '69327957' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635824' ,`Longitude` = '-95.814486' ,`PhotoCount` = '13' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '353000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Deer Lane' ,`StreetNumber` = '4927' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lowest price for a beautiful new home with water view! Large back yard. Kitchen opens to family room. Huge walk-in pantry. All big bedrooms upstairs. Lots of windows in game room. Extra storage space in garage. Garage door opener. A must see!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT4, BLK2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Run Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.922' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556936' WHERE `Matrix_Unique_ID` = '211623785'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:19:30.590' ,`MLSNumber` = '71596464' ,`ListAgentFullName` = 'Sue Crow' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.786550' ,`Longitude` = '-95.650783' ,`PhotoCount` = '15' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Seagull' ,`StreetNumber` = '95' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PRICE!! A charming place, off-water but good views of wide open Sargent spaces in back, creek view front. and features front screened porch.  Open concept Living, Dining and Gourmet Kitchen, featuring granite island seated bar, Jenn-aire Gas cooktop, lots of cabinets stainless dishwasher, oven and Refrigerator/freezer combination.  Nice Bedroom, and Family Room that can be converted to 2nd Bedroom.  Primary Bathroom features large walk-in shower with granite bench.Laundry room complete with washer/dryer and storage closet.  Off Family room is 2nd screened porch.  A portion of the garage has been converted to 2 bedroom bunk space with large gathering area and full bath.  4 Large Landscaped lots offer lots of space for family fun times.  EASY TO SEE- JUST CALL AND I WILL BE RIGHT THERE TO GUVE YOU A TOUR!' ,`Acres` = '0.473' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 7, LOT 72-75' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20605' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '48' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Downey Caney Creek' ,`TaxAmount` = '3740' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556937' WHERE `Matrix_Unique_ID` = '211661670'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T06:37:33.590' ,`MLSNumber` = '52678520' ,`ListAgentFullName` = 'Tonya Grandmaiter' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = 'Adelina Allahar' ,`SellingOfficeName` = 'RE/MAX Fine Properties' ,`Latitude` = '29.595434' ,`Longitude` = '-95.800984' ,`PhotoCount` = '32' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '335000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Maxon' ,`StreetNumber` = '5718' ,`StreetSuffix` = 'Court' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME! Step inside and fall in love with this 3-bedroom, 2.5-bathroom house in Kingdom Heights. This home features bright tile flooring, designer paint, timeless dark wood cabinets in the kitchen and both bathrooms, Granite countertops, high-end light fixtures, and recessed lighting. This home is in immaculate shape and has been well taken care of! The property is PRISTINE with lush landscaping, a thriving yard, and well-manicured trees. The chef’s kitchen is spacious and features a large breakfast bar, sprawling counter space, a massive walk-in pantry & SS appliances. The living room is the heart of the home with a stylish fireplace, the room\'s focal point. Luxe primary suite with ensuite bathroom and massive walk-in closet. Natural light flows into every room with large bright windows throughout. The backyard is an outdoor paradise with a large fenced green space and beautifully maintained yard. Ideal location with easy access to downtown Rosenberg, 723 and 69. Zoned to LCISD.' ,`Acres` = '0.151' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGDOM HEIGHTS SEC 3, BLOCK 2, LOT 4' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '6579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '5627' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556937' WHERE `Matrix_Unique_ID` = '211790724'  --> Updated record success<br />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','213012307','1666556937','213012307','2022-10-23T07:45:11.073','57905545','Jeanil Garcia','Central Metro Realty','','','30.172444','-96.394115','5','77833','3','250000.00','Active','Ross','600','Street','Brenham','2','0','3','1463','Single-Family','','0.1543','58','','','','','Sellers Disclosure','','','','','Central Gas','0','WOODLAWN HEIGHTS , BLOCK C, LOT 1, (600 ROSS)','Other','6720','Appraisal District','','','0','','1','','0','','','','','Composition','137 - Brenham','BISD DRAW','BRENHAM HIGH SCHOOL','BRENHAM JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Right Side,Vacant/Unoccupied','Seller','1','Traditional','Woodlawn Heights','1283','2.0369','Public Water','1978','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:53:45.230' ,`MLSNumber` = '92857446' ,`ListAgentFullName` = 'Donna Labbe' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = 'Suzanne Mason' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.093876' ,`Longitude` = '-95.616898' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pine' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Street' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a part of Tomball’s history!  This Beautiful Craftsman home was built in 1914 and was lovingly restored in 1999.  From the moment you enter the front door, you are welcomed by original hardwood floors, wonderful built-in bookcases, high ceilings, crown moldings and stunning pillars from a bank building in downtown Houston! There is also a Guest suite (3rd bedroom) with its own bathroom located in the back of the property. Fabulous outdoor living areas make this a perfect place to hosts guests! New roof 2015, new water heater 2017, Amana heat pump (may be used as gas or electric) 5 ton electric AC, gas log fireplace, gas oven & cooktop. Walking distance to all the wonderful shopping, dining & festivals downtown Tomball has to offer! The Farmer\'s market is held on Saturday mornings and is just a short walk away! Exemplary Tomball ISD!' ,`Acres` = '0.1607' ,`Area` = '14' ,`BuilderName` = 'Sears Craftsman' ,`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 Electric,Central Gas,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 37 WILSON TRACT' ,`LotDesciption` = 'Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Old Town Tomball' ,`TaxAmount` = '2436' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1914' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556937' WHERE `Matrix_Unique_ID` = '213254172'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:39:18.923' ,`MLSNumber` = '16966334' ,`ListAgentFullName` = 'Terry Cominsky' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.673522' ,`Longitude` = '-95.500454' ,`PhotoCount` = '22' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Rutherglenn' ,`StreetNumber` = '6210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this stunning, remodeled home with an open floor plan perfect for family living or entertaining. Soft bull nose granite counters highlight the fabulous gourmet kitchen with abundant custom cabinetry and high end stainless steel appliances including a gas range and convection oven. Granite top island is the perfect place to have a quiet breakfast and read the morning news. Relax in your primary bedroom retreat with double sinks and an oversized shower. Hall bath for 3 secondary bedrooms also has double sinks and a long granite countertop. Wonderful backyard! Improvements include- Automatic driveway gate, replaced windows, condenser, furnace, evaporator coil, attic insulation, siding, tub, double sinks, plumbing fixtures, French doors, driveway, garage door, ducts, roof, gutters with leaf screen, oven/ range with convection! Wow! Never flooded per owner. This is a must see! Don\'t miss this wonderful home!' ,`Acres` = '0.1956' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 35 MAPLEWOOD SOUTH SEC 7 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '487' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood South' ,`TaxAmount` = '8623' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556937' WHERE `Matrix_Unique_ID` = '213282869'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:33:53.060' ,`MLSNumber` = '9954520' ,`ListAgentFullName` = 'Mary Vergara' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765821' ,`Longitude` = '-95.882607' ,`PhotoCount` = '39' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '489900.00' ,`Status` = 'Active' ,`StreetName` = 'Waverly Park' ,`StreetNumber` = '29815' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this stunner in Young Ranch!  This is the former Lennar Model home and it has so many upgrades!  \r\n4 bedroom/2.5 baths over 2600+ square feet of living space.  Beautiful hardwood floors, white open kitchen, custom design touches throughout the home.  This home is a smart home with several features like ring doorbell, wired for Amazon connect etc.\r\nLocated on a cul de sac in the Young Ranch master planned community with several pools, playgrounds, splash pads and walking trails.\r\nEasy access to I-10, Heritage Grand Parkway, and Westpark toll Road.  There is nearby shopping, restaurants walking distance.  The Texas Heritage Marketplace a large mixed use entertainment and retail space is already underway and is within walking distance from the community. Zoned to highly acclaimed Lamar Consolidated ISD schools!\r\n This home has so much to offer, don\'t miss out on this opportunity to buy this gorgeous home!' ,`Acres` = '0.1818' ,`Area` = '30' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'YOUNG RANCH SEC 1, BLOCK 2, LOT 27' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7965' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Young Ranch Sec 1' ,`TaxAmount` = '8925' ,`TaxRate` = '3.072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666556938' WHERE `Matrix_Unique_ID` = '213555077'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T06:57:44.590' ,`MLSNumber` = '12550115' ,`ListAgentFullName` = 'Donna Bell' ,`ListOfficeName` = 'Meadows Company, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799862' ,`Longitude` = '-95.181466' ,`PhotoCount` = '30' ,`PostalCode` = '77015' ,`RoomCount` = '8' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'White Cedar' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2375' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HOME! Lovely spacious multi-generational traditional home with newly remodeled detached garage apartment. This home has NEW: Roof, HVAC, exterior paint, appliances, hot water heater, garage door/opener, pool equipment, newly updated primary shower w/new PB floor, new floor in secondary bath PLUS remodeled garage apartment w/granite countertops/new vinyl plank floor. The home has a graciously sized formal dining room that flanks the entry area. Large family/living room has a brick gas fireplace w/gas logs, a wall of custom built-ins, wet bar, and windows overlooking the beautiful large pool, perfect for outdoor entertaining! Kitchen has an abundance of counter/storage space, two pantries, and double ovens. Large Primary Suite has TWO walk-in closets PLUS a third closet, custom built-ins and large newly remodeled shower. There are two spacious secondary bedrooms PLUS a formal paneled study/office with built-ins. This is a rare find that will not last long!' ,`Acres` = '0.235' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 68 WOODFOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10235' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'HAVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest Sec 16' ,`TaxAmount` = '4693' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556938' WHERE `Matrix_Unique_ID` = '213777636'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T07:20:17.780' ,`MLSNumber` = '11614848' ,`ListAgentFullName` = 'Gary Cruseturner' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Diandra Cerda' ,`SellingOfficeName` = 'Sky Real Estate Professionals' ,`Latitude` = '29.783940' ,`Longitude` = '-95.950374' ,`PhotoCount` = '0' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '185000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rouse' ,`StreetNumber` = '715' ,`StreetSuffix` = 'Street' ,`City` = 'Brookshire' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Starte Home or Investment Property. Small town Charm. Close to neighborhood Park, Shopping, and easy on Major Highway. Large Front Porch for outside sitting. Hugh yard for Family fun. Roof, A/C & Heating, Electrical updated in 2012. Priced for Quick Sell.' ,`Acres` = '0.4821' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S412000 BROOKSHIRE TOWNSITE BLK 13 LOT 4 THRU 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brookshire Townsite' ,`TaxAmount` = '2790' ,`TaxRate` = '2.7487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666556938' WHERE `Matrix_Unique_ID` = '213862963'  --> Updated record success<br />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','213984430','1666556938','213984430','2022-10-23T06:44:43.240','22199354','Meng Yeh','Parra Design Group, LTD.      ','','','29.778163','-95.322390','10','77020','8','364900.00','Active','Oats','4704A','','Houston','2','1','3','1830','Single-Family','Great new housing by award winning architect in the Fifth Ward. Open living room with tall ceilings and abundant natural light. Gourmet kitchen with stainless GE appliances, modern cabinets, island, Silestone counters. White oak hardwood floors and contemporary porcelain tile throughout. Luxurious master bath, extra large balcony overlooking beautiful private garden.','','2','Parra Design Group','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Denver Harbor','Central Gas','0','Lot 1 Block 1','Patio Lot','2500','Survey','','0','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','ATHERTON ELEMENTARY SCHOOL (HOUSTON)','WHEATLEY HIGH SCHOOL','MCREYNOLDS MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Augusta Add P/R 3','','','Public Sewer,Public Water','2022','Builder');  --> New record created successfully<br />