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-09-11T22:10:04.363' ,`MLSNumber` = '77445881' ,`ListAgentFullName` = 'Hai Huang' ,`ListOfficeName` = 'Realty Right' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569260' ,`Longitude` = '-95.639850' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '1138000.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Path' ,`City` = 'Sugar Land' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2013 built Taylor Morrison house. Real hardwood and travertine tile floor. CLEMENTS/FORT SETTLEMENT School zone. Big backyard in the corner lot.Huge granite countertop in kitchen. Large windows in high ceiling family room. Gated front courtyard. With study room and media room. 3 bedrooms upstairs and master downstairs. A separate guest bedroom with full bath (entering from the front courtyard). A separate full pool bath entering from backyard.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 25B, BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '811' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 25b' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709509' WHERE `Matrix_Unique_ID` = '207565508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T23:16:50.447' ,`MLSNumber` = '25231082' ,`ListAgentFullName` = 'Virginia Schilling' ,`ListOfficeName` = 'Turbo Realty of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.697514' ,`Longitude` = '-97.463365' ,`PhotoCount` = '50' ,`PostalCode` = '76126' ,`RoomCount` = '12' ,`ListPrice` = '1853000.00' ,`Status` = 'Active' ,`StreetName` = 'Verde' ,`StreetNumber` = '5200' ,`StreetSuffix` = 'Circle' ,`City` = 'Benbrook' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A chance to own a superb single story Mediterranean style property located on a corner lot in the gated and guarded La Cantera. Enjoy wood flooring throughout, coffered and barrel ceilings, arched walkways, and a chef\'s kitchen equipped with JennAir appliances. Spacious master with an extravagant walk-in closet, complemented by an en-suite that boasts vaulted ceilings, copper tub and walk thru rain shower. Open concept living with walls of windows, built-ins, gas fireplace and adjacent study. Media room with patio access to the outdoor kitchen. Two additional split bedrooms with en-suite bathrooms. Wine room with brick flooring, utility room with an abundance of storage and outdoor access, butler’s pantry, as well as a large walk-in pantry.\r\nThe outdoor space has a beautiful, covered patio, pool and spa with waterfall and fire bowls, an outdoor kitchen, as well as additional space beyond the fence line that is part of the property. \r\nFourth car parking in the porte-cochère.' ,`Acres` = '0.7515' ,`Area` = '84' ,`BuilderName` = 'Integrity Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LA CANTERA AT TEAM RANCH BLOCK 12 LOT 1 PER PLAT D214155544' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '32734' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate,Tile' ,`SchoolDistrict` = '527 - Fort Worth' ,`SchoolElementary` = 'WAVERLY PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTERN HILLS HIGH SCHOOL' ,`SchoolMiddle` = 'BENBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'La Cantera/Team Ranch Ph II' ,`TaxAmount` = '31434' ,`TaxRate` = '2.5443' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663709509' WHERE `Matrix_Unique_ID` = '208481473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T22:28:25.103' ,`MLSNumber` = '47306336' ,`ListAgentFullName` = 'Jeffrey Sadler' ,`ListOfficeName` = 'Sadler Realty' ,`SellingAgentFullName` = 'Andrea Bustamante' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.501127' ,`Longitude` = '-95.512325' ,`PhotoCount` = '35' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '374900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Garden' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Way' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely updated single story home in the highly desirable Steep Bank of Sienna. Everything is NEW... This CUSTOM HOME is truly a SHOWSTOPPER! Fabulous floorplan offering 3/4 beds, 2.5 baths, study, living/dining, spacious family room + Bonus room. So many upgrades & features including: New Roof, New HVAC, New water heater, New Plumbing, New electrical, whole house surge protector, designer wood like tile thruout, New trim & moulding, custom barn doors, updated lighting/fans, fireplace w/ shiplap accent wall, expansive island kitchen w/ new white cabinetry, custom epoxy resin counter tops, high-end appliances, pot filler, built-in pantry, primary suite w/ ensuite- new vanity, custom countertop, vessel sinks, steam shower, new tub, custom walk-in closet w/ easy access to laundry room. Oversized bedrooms w/ customized closets. Upstairs Bonus room w/ additional nook + half bath. Enjoy no back neighbors & green space behind home. WALKING DISTANCE TO SIENNA CROSSING ELEMENTARY.' ,`Acres` = '0.152' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA STEEP BANK VILLAGE SEC 8, BLOCK 1, LOT 14' ,`LotDesciption` = 'In Golf Course Community,Ravine,Subdivision Lot' ,`LotSize` = '6621' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'SIENNA' ,`TaxAmount` = '6220' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709509' WHERE `Matrix_Unique_ID` = '209915007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T22:26:16.717' ,`MLSNumber` = '77237460' ,`ListAgentFullName` = 'Elena Cain' ,`ListOfficeName` = 'A. O. Cain Co' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.997299' ,`Longitude` = '-95.732491' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Pattington Cypress' ,`StreetNumber` = '15426' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home features beautiful, BRAND-NEW wood-look vinyl flooring downstairs in the living room, dining room and primary bedroom. Spacious 4/5 bedroom, two story home in Cypress Landing Park. Large primary bedroom 1st floor with three bedrooms up plus gameroom up with its own separate sitting area and closet that could serve as a\r\ngreat extra bedroom if needed. Ample kitchen with granite countertops, lots of cabinets, stainless appliances, plenty of room for all the cooks and open to a most comfortable family room with fireplace.\r\nJust step out your back door to enjoy a covered patio large enough for everyone in the family plus the barbecue grill, when the weather moderates. This home is kept comfortably cool, even during these hot Texas summers with spray foam insulation in walls and attic. Two inch blinds throughout covering insulated, low E windows. Sprinkler system for both front and back yards. Easy access to both Hwy. 290 & Hwy. 99, Grand Parkway. Cy-Fair ISD.' ,`Acres` = '0.134' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 CYPRESS LANDING PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5836' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '404' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Lndg Park' ,`TaxAmount` = '7510' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709509' WHERE `Matrix_Unique_ID` = '209953097' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T22:05:22.287' ,`MLSNumber` = '27336746' ,`ListAgentFullName` = 'Minal Vyas' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Jacqueline Moten' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.565202' ,`Longitude` = '-95.717092' ,`PhotoCount` = '31' ,`PostalCode` = '77469' ,`RoomCount` = '12' ,`ListPrice` = '425000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Emerald Run' ,`StreetNumber` = '22114' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the perfect home for you and your family. It features 4 bedrooms and 3.5 bathrooms, along with both formal living and dining, a home office and a gameroom. The kitchen has exotic granite countertops, contemporary backsplash, stainless steel appliances and an island! The primary bathroom has a jetted tub, dual vanity and a spacious walk-in closet. There’s also a 3 sided fireplace that’s open to the family room, breakfast room and the kitchen. There’s NO CARPET in this house, beautiful quartz tile in the family room, engineered hard wood and bamboo flooring in the bedrooms and other living areas. There’s also a detached garage as well as a nice backyard for entertaining. Located on a cul-de-sac street in Riverpark West. Community features many amenities including a wildlife preserve, pools, lakes and walking trails. This house is conveniently located near Highway 59 and Highway 99 so you can easily get to work or school. There are lots of shopping and restaurants nearby too!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 2, BLOCK 1, LOT 20, 50.000000% UDI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8057' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark West' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709510' WHERE `Matrix_Unique_ID` = '210405367' --> 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','211857546','1663709510','211857546','2022-09-11T23:13:00.503','37242004','Flor Avila','Keller Williams Professionals','','','29.904848','-95.429575','9','77038','6','225000.00','Active','Debbie','9708','Lane','Houston','1','1','3','1566','Single-Family','Great opportunity to own or invest in this neighborhood with no HOA and low taxes. This established neighborhood is located close to three major Highways with public transportation just a block away. This home has a shed in the back for additional storage a mock fireplace and a surveillance system for your comfort.\r\nPlease contact me for additional details. Si Necesita ayuda en español, le podemos ayudar.','0.0861','11','','','Gas Dryer Connections','','Sellers Disclosure,Tenant Occupied','','Mock Fireplace','1','Aldine Area','Central Electric','0','TR 37 CHARLESTON GARDENS','Subdivision Lot','3750','Appraisal District','','','0','','2','','0','','','Freestanding Range','','Composition','1 - Aldine','GOODMAN ELEMENTARY SCHOOL (ALDINE)','ALDINE HIGH SCHOOL','STOVALL MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','2','Traditional','Charleston Gardens','3527','2.1528','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212196644','1663709510','212196644','2022-09-11T22:07:04.997','40507140','Bryan Lillis','RE/MAX Grand','Sergio Medina','Fathom Realty','29.612468','-95.724245','20','77406','13','268000.00','Pending Continue to Show','Country Place Dr','2422','','Richmond','2','1','4','2308','Single-Family','Come see this investor/handyman special and don\'t miss out! The home is currently priced WAY below market value so this is a steal for the right person or family. Come check out this traditional styled home built in the beautiful Grove Section of Pecan Grove in Richmond. The home features a large foyer, formal living and dining room, extra tall family room with built in bar nook, utility room, recently updated kitchen with SS appliances and granite countertops. The bedrooms are located upstairs and feature recently renovated tub/showers in both the primary and secondary bathrooms. Recent upgrades on the home include the kitchen, appliances, exterior windows, water tank, ac/furnace, 2 bath/showers, duct cleaning, UV system and gutter guards. \r\nWith some new paint and carpet, you\'ll have instant equity in this home. It won\'t last long!','0.179','37','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','','1','Fort Bend County North/Richmond','Central Electric','1','The Grove Sec 3, Block 13, Lot 21','Subdivision Lot','7786','Appraisal District','','209','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','AUSTIN ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','The Grove','5145','2.3298','Water District','1982','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212279351','1663709510','212279351','2022-09-11T22:02:49.907','51465930','Brandy Snipp','Savvy Property Group','','','30.298277','-95.553285','26','77316','8','818000.00','Active','Wind Jammer','8978','Lane','Montgomery','3','1','4','2496','Single-Family','Stunning Home set on 2.1 Acres! Easy, graceful living with this open concept Kitchen, Family Room and Dining Room floorpan! Impressive Floor to Ceiling Oklahoma Flagstone Fireplace. Transom Windows & Architectural Openings provide an abundance of Natural Light. Home features a separate Living Room that could easily convert to a Home Office. Spacious Owner’s Suite featuring an Extended Sitting Area, 2 Walk-In Closets, Luxurious En-Suite w/Jetted Soaker Tub, Separate Glass Surround Shower, and Granite Counters with 2 Under Mount Sinks. Second floor features a unique flex space with a full bath. This space can be used as a 2nd Primary Bedroom, In-law Suite, Teen Retreat, Media/Game Room, Workout Room, Private Office, etc. Ridgelake Shores is only minutes away from Lake Conroe, The Woodlands Township, Mall & Medical Centers. It\'s a community of custom homes on acreage home sites. The amenities include two private parks & lakes for fishing, boating & water sports. SEE PHOTOS for details!','2.103','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Conroe Southwest','Central Gas','1','S827104 - RIDGELAKE SHORES 04, BLOCK 1, LOT 112','Greenbelt,Subdivision Lot,Wooded','91607','Appraisal District','','350','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1.5','Traditional','Ridgelake Shores 04','8140','1.8488','Public Water,Septic Tank','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212302456','1663709510','212302456','2022-09-11T22:49:11.887','21291478','Robert Smith','Walzel Properties','','','29.849069','-95.810210','16','77493','9','340000.00','Active','Stone Tower','25219','Court','Katy','2','1','4','2670','Single-Family','Great Buy!! This four bedroom, two-and-a-half bath traditional home offers inspiring 2700 square feet of exceptional living space. The great room features high ceilings, multiple exposures, and custom lighting, while the beautiful kitchen boasts quartz countertops, customized Granite Island and Energy Star stainless steel appliances, From the open-concept kitchen and living space to the upstairs gameroom, there is plenty of room for the whole family to enjoy. . SELLER\'S ARE MOTIVATED! Do not miss all this home has to offer! CALL TO SCHEDULE A SHOWING TODAY!','0.1148','25','KB Homes','','Electric Dryer Connections','','Home Protection Plan,Mud,Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','LT 42 BLK 2 KATY MANOR SEC 5','Subdivision Lot','5800','Appraisal District','','495','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Katy Manor Sec 5','7761','3.4768','Public Sewer,Public Water','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212393157','1663709510','212393157','2022-09-11T22:49:17.503','46095690','Olawale Oladipupo','Walzel Properties','','','29.560761','-95.723504','13','77469','8','554490.00','Active','Mamie Springs','1854','Court','Richmond','4','0','5','2760','Single-Family','WELCOME HOME !!! BEAUTIFUL 2 STORY - OFFER- 5 BEDROOMS AND 4 FULL BATHS- TWO(2) -DOWN AND THREE (3 )UP. A LOT OF UPGRADE- KITCHEN EQUIPPED WITH SILESTONE COUNTERTOPS, STAINLESS STEEL APPLIANCES, TILES FLOOR AND SOARING CEILING. SPACIOUS MASTER BEDROOM WITH SEPERATE WALK IN SHOWER AND JACUZZI TUB WITH WALK IN CLOSET. A LARGE BACK-YARD FOR PRIVATE USE.','0.2377','30','NEWMARK','','Gas Dryer Connections','','Estate','1','','','Fort Bend South/Richmond','Central Gas','1','VERANDA SEC 11, BLOCK 1, LOT 4','Corner','10353','Survey','','990','0','','2','','0','','','','','Composition,Other','33 - Lamar Consolidated','PHELAN ELEMENTARY SCHOOL','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Lockbox Front','Builder','2','Other Style','Veranda Sec 11','11276','3.1798','Water District','2019','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','212411104','1663709510','212411104','2022-09-11T22:42:49.537','33473406','Kimberly Walt','RE/MAX RESULTS','','','29.729844','-95.319992','39','77023','8','339900.00','Active','Cuerta','5431','Street','Houston','2','1','3','1795','Single-Family','Location, Location, Location, This beautiful almost new home is centrally located close to Downtown, MedCenter and Freeway, Great gated subdivision in EADO brings you close to all the area restaurants, bars and sporting events Houston\'s East End has to offer. Great open concept living with split concept bedrooms. The owners have put additional love and care into this home and it shows. Enter through the beautiful frosted leaded glass front door and you are greeted by an open and airy living area. Huge island makes for great entertaining and use as a breakfast bar. Enjoy relaxing after a long day or throwing something on the BBQ in the quaint back yard with lovely landscaping and an extended patio. Need that spot to drop your things at night? The Mud area is conveniently located by the garage entry door. The primary suite is large with a huge walk in closet and oversized bath with walk in shower. Niche area upstairs perfect to add a small desk or library area. Call with add\'l questions.','0.0456','4','Meritage','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End Revitalized','Central Gas','1','LT 8 BLK 6 SIMMS WOODS PAR R/P & EXTN','Subdivision Lot','1988','Appraisal District','','2880','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','CARRILLO ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','2','Traditional','Simms Woods Pt Rep #1','6987','2.3307','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully