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-24T04:30:26.787' ,`MLSNumber` = '4851692' ,`ListAgentFullName` = 'Ashiqul Talukder' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869535' ,`Longitude` = '-95.732338' ,`PhotoCount` = '49' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Founding' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIUEYS TO VEFRIFY ALL ROOM DIMOANSONS. GORGEOUS 4 BEDROOM, 2.5 BATHROOM, TWO STORY HOME LOCATED IN THE CY-FAIR SCHOOL DISTRICT. SPACIOUS, OPEN FLOOR-PLAN DESIGN WITH INSULATED WINDOWS & AN ABUNDANCE OF NATURAL LIGHT. SELLERS SPENT OVER $20,000 IN RECENT UPGRADES. CARPET WILL BE REPLACED. NEW INTERIOR PAINT. CEILING FANS, A LOVELY BACKYARD. MAKE THIS YOUR \"HOME SWEET HOME!\"' ,`Acres` = '0.1263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 14 SETTLERS VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '318' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 02' ,`TaxAmount` = '5708' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664021814' WHERE `Matrix_Unique_ID` = '209041768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T05:18:25.873' ,`MLSNumber` = '2256189' ,`ListAgentFullName` = 'Jackie Zehl' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661929' ,`Longitude` = '-95.478012' ,`PhotoCount` = '25' ,`PostalCode` = '77096' ,`RoomCount` = '13' ,`ListPrice` = '418000.00' ,`Status` = 'Active' ,`StreetName` = 'Oasis' ,`StreetNumber` = '10906' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fastidiously Fresh & Ultra Meticulously Maintained NEVER FLOODED* 4 Bedroom, 2 Bath Residence located in the Close-In Neighborhood of Westbury. Exceptional Amenities include Oak Hardwood Floors, LED Recessed Lighting, Newly Installed Lennox AC & Heat*, Horizontal Fresh Water Lines (in Attic) Replaced w/ CPVC Pipe*, Replaced Under Slab Plumbing (except to Kitchen Sink)*, & Replaced Yard Line*. Kitchen touts Silestone Counters, Subway Tile Backsplash, Bank of Windows above the SS Kitchen Sink, Coffee Bar, Eat-In Kitchen Area, & SS Appliance Package w/ 5 Burner Gas Cooktop, Dble Ovens, & Newly Installed Dishwasher*. Den boasts a Brick Fireplace & French Doors, which Open to the Landscaped Backyard & Outdoor Living Area complete w/ Expansive Wood Deck & Covered Pergola. Spacious Gameroom w/Recessed Lights & Walk-In Storage Closet. Hall Bath w/ Full Tub/Shower. Primary Suite offers Walk-In Closet, Dual Sinks, & Walk-in Shower.4th Bedroom could be used as an Office. Parker Elem.*Per Seller' ,`Acres` = '0.2204' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 44 WESTBURY SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '5841' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664021814' WHERE `Matrix_Unique_ID` = '209831877' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T05:37:00.827' ,`MLSNumber` = '14860092' ,`ListAgentFullName` = 'Deb Ambrosi' ,`ListOfficeName` = 'Ambrosi Realty INC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225335' ,`Longitude` = '-95.558540' ,`PhotoCount` = '48' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Weisinger' ,`StreetNumber` = '6003' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dreams can come true to those who WAIT!! Welcome to 6003 Weisinger Dr in Magnolia, Texas. This home is currently zoned to Magnolia ISD. Location is KEY in this WESTWOOD gem located close to the Elementary School,(3 MIN DRIVE ACCORDING TO GOOGLE MAPS) shopping and restaurants. This 4/5 Bedroom, 3 full bath is loaded with upgrades like lighting, updated bathrooms, fabulous flooring, (NO CARPET) and neutral paint. The floor plan is super versatile and will allow you to utilize it as needed. There is a separate suite at the back of the home with a full bathroom that can be used for guest suite (no closet), office, craft room, etc... Now the BEST PART- check out this LOT!! The trees are stunning!! Picture yourself having your friends and family over and entertaining in the PARK LIKE backyard!! No flooding as per seller.... Don\'t miss out, book your showing today!! OPEN HOUSE SUNDAY, AUGUST 14TH 2 TO 4:30.' ,`Acres` = '0.4545' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 03, BLOCK 12, LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19796' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '4536' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664021814' WHERE `Matrix_Unique_ID` = '210906553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T05:29:30.863' ,`MLSNumber` = '56270650' ,`ListAgentFullName` = 'Taha Elhajj' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.634415' ,`Longitude` = '-95.759649' ,`PhotoCount` = '24' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '569000.00' ,`Status` = 'Active' ,`StreetName` = 'CLAYHEAD' ,`StreetNumber` = '3220' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1.4 ACRES. WELCOME HOME ,RARE FIND,RELAXED LIVING .4 BEDROOMS 2 FULL BATHS IN THE CITY OF RICHMOND.TILE AND CARPET FLOORING .RECENT PAINT,GRANITE COUNTER TOPS AND SPACIOUS FORMAL LIVING AND DINING AREA.LIVING ROOM WITH WOOD BURNING FIREPLACE.GREAT VIEW ,ENJOY THE POOL.PEACAN TREES ,2 CAR GARAGE ,FIRE PIT AND BARN WITH CHICKEN.SWIMMING POOL.SELLERS DISCLOSURE IS ATTACHED.IF LISTING AGENT SHOWS PROPERTY THEN BUYERS AGENT COMMISION IS 1.5 PERCENT .' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0046 KNIGHT AND WHITE,TRACT 54,ACRES 1.4' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'KNIGHT AND WHITE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664021814' WHERE `Matrix_Unique_ID` = '210990833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T05:01:49.123' ,`MLSNumber` = '49987368' ,`ListAgentFullName` = 'Rainy Rawls' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946245' ,`Longitude` = '-95.143831' ,`PhotoCount` = '35' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Cove' ,`StreetNumber` = '18406' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect home for a first-time buyer or Vacation home. This 3 bedroom, 2 bath Fully fenced backyard, storage shed, and covered screened in patio has plenty of back and side yard space! The interior plan offers a spacious family room w/ adjacent dining area, fireplace, western style kitchen w/ breakfast bar, utility in-home at garage entry, and a split bedroom plan with good-sized rooms. The location is quiet and relaxing and blocks away from the lake. \r\nCome and see a one of a kind home in Lake Shadows that has great access to Lake Houston. Close to FM 1960 with dining and shopping, IAH, and Sam Houston Toll. This is the home for you, don\'t loose the opportunity, come see it today!' ,`Acres` = '0.2571' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 LAKE SHADOWS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadows Sec 01' ,`TaxAmount` = '4493' ,`TaxRate` = '2.6843' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664021814' WHERE `Matrix_Unique_ID` = '211858810' --> 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','212507597','1664021815','212507597','2022-09-24T05:17:20.840','81817578','Joe Iley','Mission Real Estate Group','','','29.764445','-95.220898','18','77015','3','154900.00','Active','Coulson','12173','Circle','Houston','1','0','3','1115','Single-Family','This beautifully updated property is ready for you to call it home. Touting its new flooring throughout, fresh paint, new ceiling fans, newly painted trim, new bathroom and so much more. A must see. The home also highlights a wonderful backyard complete with storage and patio that is great for BBQ\'s and gatherings. Room sizes are approximate.','0.1465','2','','','','','Sellers Disclosure','','','','North Channel','Central Gas','0','LT 3 BLK 21 WOODLAND ACRES ANNEX SEC 6','Subdivision Lot','6380','Appraisal District','','','0','','0','','0','','','','','Composition','21 - Galena Park','PYBURN ELEMENTARY SCHOOL','GALENA PARK HIGH SCHOOL','WOODLAND ACRES MIDDLE SCHOOL','Appointment Required','Seller','1','Traditional','Woodland Acres Annex Sec 06','2528','2.7702','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T05:33:44.970' ,`MLSNumber` = '73740595' ,`ListAgentFullName` = 'Jane LeMoine' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152706' ,`Longitude` = '-95.445046' ,`PhotoCount` = '21' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'WESTWOOD NORTH' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ALL MEASUREMENTS NOT SEEMED TO BE RELIABLE. PLEASE MEASURE YOURSELF. NESTLED AMONGST TALL TREES IN THE DEIREABLE WESTWOOD SUBDIVISION, THIS BEAUTIFUL HOME HAS BEEN TASTEFULLY REDONE FRO, FLOOR TO CEILING. BRAND NEW DRIVE , LANDSCAPING W SPRINKLER STYSTEM. UPON ENTERING, YOU HAVE BEAUTIFUL WOOD FLOORS THAT STEP DOWN TO THE GRANDEOSO FAMILY ROOM. 30 FT CATHEDRAL CEILINGS WITH CAN LIGHTING AND ROWS OF SKYLIGHTS ALLOWING LOTS OF NATURAL LIGHT. A STONE FIREPLACE SETS THE ATMOSPHER OF A SKI LODGE.THE WALL OF WINDOWS AND FRENCH DOORS PRESENT A ZEN FEELING OF ALL NATURE. GREAT FOR ENTERTAINING. ALL NEW STAINLESS APPLIANCES AND BEAUTIFUL CABINETRY IN KITCHEN. FAUX WHITE WOOD BLINDS THROUGHOUT. REGROUND YOURSELF IN NATURE AND FEEL THE FLOW OF SPIRIT.))' ,`Acres` = '0.29' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'lot 155 Blk 9 Westwood Sec 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '19901' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '4089' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664021815' WHERE `Matrix_Unique_ID` = '212635516' --> 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','212760993','1664021815','212760993','2022-09-24T05:04:00.427','10868215','Gayla Gayden','REALM Real Estate Professional','','','29.571545','-95.518441','41','77459','14','424795.00','Active','Griffith View','1114','Lane','Missouri City','3','0','5','2607','Single-Family','Dramatic today style Chic Stucco & Brick Timeless Elevation! Huge Private Lot W/Covered Patio! 1 Story Ranch Home! Guest Suite W/Bathroom, 3 Guest Bedrooms & Primary Suite! Home Office/Study! Dramatic Open Floor Plan that will welcome you with Carefree Luxurious Wood Plank Vinyl Floors! Huge Family Area open to the Casual Dining & Gourmet Kitchen! Gourmet Kitchen Boasts Tall Stylish Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Gorgeous Quartz Counters, Walk In Pantry, Deep Undermount Stainless Steel Sink, Wonderful Large Eat In Working Station Island! Private Primary Suite W/High Ceilings, Huge Walk In Closet, Large Vanity with Quartz Counters with His & Her Undermount Sinks, Large Tile Floors, Shower & More! Guest Bathroom W/Quartz Counters! Guest Bedrooms W/Huge Closets! Fully Landscaped Front & Back Yards! Energy HERS Rated W/Tankless/On-Demand H2O Heater! Park\'s Edge is a 300 acre Master Planned Community W/Lap Pool, Waterslides, Playgrounds, Sports Fields & More!','','38','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Missouri City Area','Central Gas','1','Parks Edge: Lot 12 /Block 3','Greenbelt,Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','No Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Ranch','Parks Edge','','3.240027','Public Sewer,Public Water,Water District','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','212803067','1664021815','212803067','2022-09-24T04:17:14.867','54151474','Gayla Gayden','REALM Real Estate Professional','','','29.702047','-95.706261','27','77407','10','334990.00','Active','Fleetwood Crescent','6811','Way','Richmond','2','0','3','1409','Single-Family','The Baxtor Plan by D.R. Horton Homes! Almost Ready! This beautiful Chic one story home features High Ceilings, Gorgeous Vinyl Wood Plank Floors throughout, Tile in all Bathrooms, Laundry Room & Plush Carpeting in Bedrooms! Amazing Open Floor Plan w/Huge Family Room that Opens into the Gourmet Kitchen w/Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Island w/Under-mount Stainless Sink, Stainless Steel Appliances, Tall Shaker Cabinets & more! The Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Sinks Vanity, \"Massive\" Shower with Tile Surroundings & Walk-in Closet! 2 Guest Bedrooms & Full Bathrooms! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Rinnai Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING ! Amenities include: Pool, Splash Pad & More! No Flooding! Make that call','','37','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Mission Bend Area','Central Gas','1','Lakeview Retreat Lot: 16 /Block: 3','Subdivision Lot','','','','850','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Leave Business Card,No Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Ranch,Traditional','Lakeview Retreat','','','Public Sewer,Public Water,Water District','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','212803106','1664021815','212803106','2022-09-24T04:10:10.647','7789905','Gayla Gayden','REALM Real Estate Professional','','','29.701869','-95.706565','32','77407','10','344990.00','Active','Bradford','6706','Terrace','Richmond','2','0','3','1595','Single-Family','New Construction-The Caden Plan by D.R. Horton! Dramatic Chic Elevation! Upon Entry of this lovely 3 Bedroom 2 Full Bathroom home you are greeted with Upgraded Luxurious Wood Vinyl Plank Flooring which leads the path into the Casual Dining Room & the Gourmet Kitchen with Gorgeous Quartz Counters, Tile Back-splash, Large Eat-in Working Island w/Under-mount Stainless Sink, Drinking Water Filtration System, Stainless Steel Appliances, Tall Shaker Cabinets, Subway Tile Glass Backsplash & more! Amazing Family Room w/Wall of Windows overlooking Covered Patio! The Private Owner\'s Suite with Luxurious Bath featuring Dual Sink Vanity, Huge Separate Shower, Deep Soaker Tub & Huge Walk-in Closet! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home\" allowing you to control the Skybell, Lighting, Deadbolt, Thermostat, Wireless Security & more from anywhere!! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!','','37','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Mission Bend Area','Central Gas','1','Lakeview Retreat Lot: 86 /Block: 2','Cul-De-Sac,Subdivision Lot','','','','850','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Leave Business Card,No Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Ranch,Traditional','Lakeview Retreat','','','Public Sewer,Public Water,Water District','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','212803156','1664021815','212803156','2022-09-24T04:19:38.740','94509982','Gayla Gayden','REALM Real Estate Professional','','','29.701865','-95.706406','30','77407','11','339990.00','Active','Blackpool Bend','19022','Lane','Richmond','2','0','4','1780','Single-Family','The New Construction-Grant Plan by D.R. Horton! Almost Competed! Stunning Stucco& Brick Elevation! This open floor plan features an abundance of natural light inside, high ceilings, Upgraded Vinyl Large Plank Flooring throughout, Tile in all wet areas & Plush Carpeting in all bedrooms! Your Casual Dining area & Family Room flows gracefully into the Gourmet Kitchen w/Upgraded Quartz Counters, Tile Back-splash, Large Eat-in & Working Island w/Undermount Stainless Sink, Beautiful Tall Shaker Cabinets with Stainless Steel Appliances, Tall Cabinets & more! The Private Owner\'s Suite features Luxurious Bath w/his & Her Sinks Vanity, Separate Shower, Deep Soaker Tub & Walk-in Closet! HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & more! Outstanding Smart Home Automation System allows you to control your home from anywhere, Lights, Thermostat & more! Covered Rear Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more! 20 minutes to The Galleria! Almost Ready','','37','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Mission Bend Area','Central Gas','1','Lakeview Retreat Lot: 55 /Block: 2','Greenbelt,Subdivision Lot','','','','850','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Leave Business Card,No Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Ranch,Traditional','Lakeview Retreat','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T04:12:11.943' ,`MLSNumber` = '89877940' ,`ListAgentFullName` = 'Kevin Kuo' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841058' ,`Longitude` = '-95.670739' ,`PhotoCount` = '45' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor Grove' ,`StreetNumber` = '17706' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this amazing 3 bed, 2 bath waterfront property with an idyllic lakeside fountain view at the highly-sought after Lakes of Pine Forest neighborhood. This well-maintained home features a number of recent updates, split floor plan, high ceilings, and a convenient study room with flexible use! The kitchen sports an island and breakfast bar that opens up into the breakfast dining and living room, great for entertaining guests and family alike. The home has a large main bedroom and the main bathroom is adorned with a double vanity and a shower/tub combo suitable for any owner. This beautiful home also provides easy access to the neighborhood’s lakeside jogging path and is within walking distance to the neighborhood pool! This wonderful community is simply unbeatable, with nearby schools, and retail and restaurants in every direction for convenient daily living, and many of Houston’s most popular locations are all just a few minutes away! Property has never flooded!' ,`Acres` = '0.1656' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 LAKES OF PINE FOREST SEC 2' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '7214' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes of Pine Forest' ,`TaxAmount` = '7736' ,`TaxRate` = '2.861' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664021815' WHERE `Matrix_Unique_ID` = '212826273' --> 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','212891314','1664021815','212891314','2022-09-24T04:26:21.633','3136222','Gayla Gayden','REALM Real Estate Professional','','','29.819780','-94.820866','31','77523','10','294990.00','Active','Rain Tree','14922','Drive','Baytown','2','0','3','1409','Single-Family','The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story home with Amazing Stucco & Brick Elevation! Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Lush Carpeting in all the Bedrooms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING','','53','D.R. Horton','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Chambers County West','Central Gas','1','Raintree Lot: 14 /Block: 2','Subdivision Lot,Wooded','6600','Survey','','700','1','Never Lived In','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Leave Business Card,No Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Ranch,Traditional','Raintree','','1.69','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','212916864','1664021815','212916864','2022-09-24T05:25:13.013','97745139','Terry Whitaker','Houston Executive, REALTORS','','','29.863223','-95.736215','42','77449','5','279000.00','Active','Lillybelle','6030','Street','Katy','2','0','3','1445','Single-Family','Welcome to 6030 Lillybelle located in Jasmine Heights up coming new Community in Katy zoned to Cypress Schools. This Popular Open Concept one story floor plan is complete with large kitchen Opens to the Family room and dining area, You\'ll love the Stainless Appliances, gas stove, refrigerator, his easy flow home floor plan offers 3 bedrooms and two full bathrooms. Large primary bedroom with en-suite bathroom. Secondary bedrooms split floor plan feature large closets. New carpet in bedrooms A covered patio along with large decked area for patio furniture allowing easy entertaining to enjoy in your large fenced backyard. Great location. Never flooded','0.1318','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','','Bear Creek South','Central Electric','1','LT 5 BLK 5 JASMINE HEIGHTS SEC 9','Subdivision Lot','5742','Appraisal District','','320','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','HEMMENWAY ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Jasmine Heights','5563','2.831','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully