Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:28:30.240' ,`MLSNumber` = '36848135' ,`ListAgentFullName` = 'Mayada Shahrokhi' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211223' ,`Longitude` = '-95.555715' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '552900.00' ,`Status` = 'Active' ,`StreetName` = 'Downy Willow Circle' ,`StreetNumber` = '83' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offer received waiting on signature***Reduced***. ***Come and see***. Beautiful fully updated home in the desirable neighborhood of Woodlands Village. Come and see this model like home, updated kitchen with island, quartz countertops and backsplash. New SS stove and dishwasher. Kitchen open to the living room with matching quartz fireplace. All new floors. Wood like tile first floor and carpet second floor. The whole house is newly painted. New light fixtures and fans throughout the house. Study or formal with French doors as you enter. Master bedroom down. Stunning maser bath with stand alone tub, modern shower, all new sinks and quartz vanity. Game room upstairs with plenty of storage. Mature trees all around with beautiful stone and rock elevation. A nice size backyard for entertaining or future pool. Outstanding schools and school district. You do not want to miss this home. Come see it before its gone.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 60, BLOCK 1, LOT 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Village Alden Bridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725910' WHERE `Matrix_Unique_ID` = '210144823' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:20:14.750' ,`MLSNumber` = '93642124' ,`ListAgentFullName` = 'Travis Humphreys' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286436' ,`Longitude` = '-95.172246' ,`PhotoCount` = '22' ,`PostalCode` = '77328' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Ivy' ,`StreetNumber` = '25131' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCEDDDDD!!! Welcome to this sweet home on a large but manageable lot! Country vibes with easy access and commute to Houston and in a growing area!' ,`Acres` = '0.2204' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NORTH WOODS 01, LOT 11' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Woods 01' ,`TaxAmount` = '3730' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725911' WHERE `Matrix_Unique_ID` = '211404354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:19:06.020' ,`MLSNumber` = '94714838' ,`ListAgentFullName` = 'Ige Johnson' ,`ListOfficeName` = 'Ige Johnson Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812443' ,`Longitude` = '-95.170094' ,`PhotoCount` = '17' ,`PostalCode` = '77049' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Wimberly' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Park' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 1 story home with 4 bedrooms, Formal living room/dinning room area in the front of the home. The front bedroom can used as a study. Large kitchen with island and breakfast bar. Bedrooms are considered split plan with Master Bedroom at the rear of the home. Master features sitting area with double sink, separate bath and shower. Den has a gas fireplace. Many amenities in the neighborhood, including shopping, schools, YMCA.' ,`Acres` = '0.1782' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 8 PLANTATION AT WOODFOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '483' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'DR SHIRLEY J WILLIAMSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Plantation At Woodforest Sec 0' ,`TaxAmount` = '' ,`TaxRate` = '3.019' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725911' WHERE `Matrix_Unique_ID` = '213151136' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:07:00.720' ,`MLSNumber` = '37962074' ,`ListAgentFullName` = 'David Delarosa' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.013050' ,`Longitude` = '-95.512320' ,`PhotoCount` = '45' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'York Minster Drive' ,`StreetNumber` = '16015' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a meticulously updated home in the sought after Wimbledon subdivision? You\'ve come to the right listing. These designer inspired features are a must see!! The kitchen is truly a dream...Quartz countertops, 42\" cabinets, farmhouse sink and stainless steel appliances make the perfect show kitchen while giving lots of counter space for cooking or entertaining. The kitchen is not only open to the formal dining room but also to the breakfast room that overlooks the spacious backyard, so entertaining would be a breeze. Walk into the living room to the high ceilings and floor to ceiling stone fireplace with gas logs that give it that extra cozy at home feeling. The large primary bedroom, located on the first floor, has a bathroom that is just as meticulously done as the rest of the home. There are also 2 very roomy bedrooms upstairs with a shared full bath and a family room. Seller is offering a $5,000 seller concession to buy down the buyers interest rate.' ,`Acres` = '0.2313' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 WIMBLEDON PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '664' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wimbledon Park' ,`TaxAmount` = '4713' ,`TaxRate` = '2.1875' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725911' WHERE `Matrix_Unique_ID` = '213433503' --> 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','213681556','1667725911','213681556','2022-11-06T00:20:13.423','18759267','Jessica McCreary','HTX Living, LLC','','','29.821990','-95.399893','20','77018','5','449999.00','Active','Yale Heights','3905','Drive','Houston','2','1','3','','Single-Family','Welcome to Yale Heights – a community unlike any other w/its proximity to the 610 Loop & Houston Heights. This fabulous development is located just minutes from Whole Foods Market, Orangetheory Fitness & all that the Garden Oaks/Oak Forest neighborhoods have to offer. A luxurious take on the Modern Farmhouse is evident in this 43-home, gated community that offers retreat-like seclusion w/its private walking trail, lush landscaping & dry creek. The two-story single-family home will offer first-floor living. The gourmet kitchen will open to the spacious living & dining areas which have a convenient powder room just off the entry way for guests to use. All bedrooms are perfectly laid out on the second floor where the utility room is located, along with a niche, ideal for a small study. The primary suite features two closets, an oversized walk-in shower, dual vanities & a water closet. Don’t miss your opportunity to own an inner-city, custom gem like this! It’s HTX Living at its finest!','0.0365','9','Lamar Builders','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Northwest Houston','Central Gas','1','LT 23 BLK 1 LAMAR UPPER YALE HEIGHTS','Other','1590','Appraisal District','','200','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','KENNEDY ELEMENTARY SCHOOL (HOUSTON)','WASHINGTON HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access,Vacant/Unoccupied','','2','Contemporary/Modern,Other Style','Yale Heights','967','2.3307','Public Sewer,Public Water','',''); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:07:39.840' ,`MLSNumber` = '88767435' ,`ListAgentFullName` = 'Patricia Negrich' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.089191' ,`Longitude` = '-95.335388' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '15' ,`ListPrice` = '1791405.00' ,`Status` = 'Active' ,`StreetName` = 'Ossineke' ,`StreetNumber` = '27603' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5687' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Timeless luxury in this custom French inspired home in coveted Benders Landing Estates. Carefully designed for entertaining by Gary Keith Jackson Design INC, walk into this trophy property nested in a large corner lot with fully paved oversized circle driveway. From the pecky cypress beams, large panel doors and trim accents, to the custom window REMOTE CONTROL shades, plantation shutters and drapes, delight in an exquisite living experience in this meticulous maintained property. 5 bedrooms PLUS a CASITA with full bathroom/steam room and kitchenette area with a bar sink, that opens to the spacious 758 sqft covered patio with an outdoor kitchen and fireplace, custom pool with oversized travertine decking and views of the private backyard lined with mature trees. Other features include:Whole house generator(36KW), water filter system, upgraded 400 AMP service, TWO tankless hot water heaters, and 2 large floored walk-in attics. This home pairs with the subdivision EXCLUSIVE amenities!' ,`Acres` = '1.1661' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S257204 - BENDERS LANDING ESTATES 04, BLOCK 6, LOT 23' ,`LotDesciption` = 'Corner' ,`LotSize` = '50795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Benders Landing Estates' ,`TaxAmount` = '20153' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667725911' WHERE `Matrix_Unique_ID` = '213744326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:33:23.027' ,`MLSNumber` = '11922592' ,`ListAgentFullName` = 'Cassandra Moss' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.633957' ,`Longitude` = '-95.469060' ,`PhotoCount` = '30' ,`PostalCode` = '77085' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Tidewater' ,`StreetNumber` = '5726' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A must see! This home is a beautiful 2 story with wood and tile floors downstairs and carpet and tile upstairs. Clean open concept with lots of natural lighting. Kitchen opens to the family room making great space for entertainment. Upstairs game room, man cave or bonus room. Backyard has a beautiful covered patio great for family gatherings. This beautiful jewel wont last long, come and see for yourself.' ,`Acres` = '0.1033' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 4 POST OAK PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HINES-CALDWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Place Sec 02' ,`TaxAmount` = '3993' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725912' WHERE `Matrix_Unique_ID` = '213942054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:20:14.563' ,`MLSNumber` = '54616092' ,`ListAgentFullName` = 'Bonnie Porter' ,`ListOfficeName` = 'Dynamic Home Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.307189' ,`Longitude` = '-94.778767' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your gorgeous Coastal Oasis! Beautiful hardwood floors, open concept, huge kitchen island with gorgeous quartz countertops. 4 Large bedrooms and an additional bunk room. This amazing historical Victorian beauty boast a spacious primary bedroom with a luxurious primary bath retreat and private balcony for those morning cups of coffee or evening sips of wine with a good book. Primary bath includes and free standing soaker tub, rainfall shower and large vanity. Private gated backyard with a large deck to entertain and enjoy the sea breeze. Automatic gate with ally access and private off street parking. Schedule your private tour today!' ,`Acres` = '0.0885' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR E 1/2 OF LOT 4 & W 10-8.5 FT OF LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5388' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725912' WHERE `Matrix_Unique_ID` = '214047239' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:20:13.923' ,`MLSNumber` = '46456225' ,`ListAgentFullName` = 'Bonnie Porter' ,`ListOfficeName` = 'Dynamic Home Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.293088' ,`Longitude` = '-94.800669' ,`PhotoCount` = '26' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue N' ,`StreetNumber` = '3128' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Historic Beach Cottage that sits just 3 minutes from Pleasure Pier. It is a 1900 storm survivor. Sit back and enjoy coffee on the front porch listening to the ocean waves. Mature trees all around that include a pecan, oak and beautiful magnolia tree in the backyard. High ceilings, and wood floors. Gorgeous kitchen open to living and dining room areas. Luxurious quartz countertops. Second bedroom has private access to the side porch. Huge outdoor deck that is great for entertaining. Parking space below house. Walking distance to the beach. Short bike ride to the historic district, shopping & restaurants. Excellent home for your coastal getaways or a fantastic Airbnb. Schedule your private tour today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S 80 FT OF LOT 14 (3014-0) SE BLK 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1883' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667725912' WHERE `Matrix_Unique_ID` = '214050429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:20:13.270' ,`MLSNumber` = '85856759' ,`ListAgentFullName` = 'L Gregory Dorsey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443806' ,`Longitude` = '-95.446540' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Sapphire Creek' ,`StreetNumber` = '9443' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous, well-maintained, one owner home will encourage you to plant your feet in the sought after, gated, master-planned community of Sterling Lakes. This beautiful LGI home boasts 5 spacious bedrooms (any of which could serve as a flex room, gym or office) and a large game room with views of the beautiful, calming lake. \r\n\r\nThis home sits at the end on a premium, cul-de-sac lot. Seller upgrades include freshly painted walls throughout, grey-toned laminate flooring, Honeywell thermostat, Smart Home security system, and Eufy Home doorbell and smart front door lock. Outside the home, enjoy an upgraded, custom designed landscape retaining wall. No need to worry about walking through wet grass as you head to the backyard with limestone pavers surrounded by Blackstar gravel! \r\n\r\nEnjoy time with the family at the community tennis courts, Splashpad Texas, junior Olympic sized swimming pool, basketball court, and clubhouse, or travel amongst the miles of paved walking trails.' ,`Acres` = '0.1532' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 12A (A0289 HT&B) BLK 2 LOT' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '10324' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725912' WHERE `Matrix_Unique_ID` = '214053567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:41:08.720' ,`MLSNumber` = '98266787' ,`ListAgentFullName` = 'Ben Fuentez' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960715' ,`Longitude` = '-95.493349' ,`PhotoCount` = '36' ,`PostalCode` = '77066' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Hazel Orchard Dr' ,`StreetNumber` = '5015' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, Better than new -Must see! Two story on a cul-de-sac large lot. Modern open concept floorplan area. No back neighbors. Four bedroom, 2.5 bath and game room to entertain. Huge beautiful back yard! Spacious island kitchen with breakfast area open to family room. Granite counter top. Kitchen boasts stainless steal appliances. Beautiful fireplace! Primary bed room downstairs. Attached two car garage. Tankless water heater. Back patio with an extended concrete slab! Widened driveway!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 22 Blk 2 Traces Sec 1 7th PAR R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KLENK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Klein Orchard 40\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667725912' WHERE `Matrix_Unique_ID` = '214104153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:20:13.130' ,`MLSNumber` = '57551932' ,`ListAgentFullName` = 'Maria Robichaud' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531768' ,`Longitude` = '-95.057563' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Ryder' ,`StreetNumber` = '2609' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2361' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live behind the gated community of South Shore- golf course, pools, parks and a manned gate. Well over 100 amaryllis line the front flower beds leading to the front door. As you enter the home you will notice designer touches plus a light/bright feel coming through the new windows(2021). In the kitchen, a chef\'s dream with sleek/modern kitchen cabinetry and an abundance of prep space, matching appliances, USB plug-ins, filtered water. Around the corner is the oversized den with great views into the back patio addition(2021) w/ new flowerbeds, sprinkler system and new electric iron fence. In the primary bathroom a separate tub + frameless shower w/ handicap access and sleek white modern tile, tall wardrobe system in bedrooms stay. Wall to wall laminate floors throughout, recent paint int/ext. 2018 water heater, new A/C coil, gutters, over $100k in recent updates to the home. Near I-45, NASA, UTMB, Ellington, Galveston! You won\'t see anything like this home- one of a kind!' ,`Acres` = '0.238' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 6 LOT 11 BLK 3 SOUTH SHORE HARBOUR SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10367' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '7145' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725913' WHERE `Matrix_Unique_ID` = '214142521' --> 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','214335998','1667725913','214335998','2022-11-06T00:40:20.330','21045248','Aida Villalobos','Keller Williams Metropolitan','','','29.035790','-95.406898','20','77531','6','285000.00','Active','Lexington','500','Avenue','Clute','2','0','3','1606','Single-Family','Come to see this beautiful House, Big Back Yard.\r\nQuiet community, great location and definitely you will love this property.','0.1911','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Clute','Central Gas','0','COLLEGE PARK ESTATES SEC 6 (A0066 J E GROCE) (CLUTE) BLK 2 L','Subdivision Lot','8324','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','7 - Brazosport','GRIFFITH ELEMENTARY SCHOOL','BRAZOSWOOD HIGH SCHOOL','CLUTE INTERMEDIATE SCHOOL','Appointment Required,Controlled Access','Appraisal District','1','Traditional','College Park Estates Sec 6','6576','2.6231','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T00:21:48.630' ,`MLSNumber` = '87924006' ,`ListAgentFullName` = 'Edrina Fitting' ,`ListOfficeName` = 'Ladybug, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583069' ,`Longitude` = '-95.132234' ,`PhotoCount` = '35' ,`PostalCode` = '77062' ,`RoomCount` = '11' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Elk Hill' ,`StreetNumber` = '14818' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'QUALITY VILLAGE BUILDER HOME, DECORATED W/ COUNTRY COLORS, WELCOMES YOU UPON ENTERING. OPEN FROM KITCHEN/BREAKFAST AREA TO FAMILY ROOM W/ COZY FIREPLACE AND ABUNDANCE OF LIGHTING. KITCHEN BOASTS GRANITE COUNTERTOPS W/ TILE BACKSPLASH, AND SS APPLIANCES. ENJOY YOUR BREAKFAST OR MORNING COFFEE IN THE CHEERFUL BREAKFAST AREA, WHICH FEATURES A BOW WINDOW AND DOORS LOOKING OUT ON THE LARGE DECK AND CATALINA SWIM SPA. THE OPEN LIVING ROOM/DINING ROOM OFFERS DIFFERENT OPTIONS OF USE. Current owners have staged it exceptionally well as an office and dining room with plenty of space left over. PRIMARY BEDROOM FEATURES A WALL OF WINDOWS W/ A WINDOW SEAT. MASTER BATH HAS SEPARATE SHOWER AND WHIRLPOOL BATH, DUAL SINKS, AND OVERSIZED CLOSET! OVERSIZED, LANDSCAPED BACKYARD W/ SHADE TREES. QUIET CUL-DE-SAC WITH PARK NEARBY, WALKING DISTANCE TO ELEMENTARY SCHOOL AND EXPLORATION GREEN.' ,`Acres` = '0.223' ,`Area` = '7' ,`BuilderName` = 'Village' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 BAY GLEN SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WARD ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Glen Sec 06' ,`TaxAmount` = '6701' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725913' WHERE `Matrix_Unique_ID` = '214428807' --> 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','214432510','1667725913','214432510','2022-11-06T00:02:02.283','7305687','Jennifer Vidales','RE/MAX Opportunities','','','29.314883','-96.095827','23','77488','3','315500.00','Active','Resident','520','Street','Wharton','2','1','3','3043','Single-Family','**SHOWINGS TO BEGIN ON 11/8/2022** Gorgeous family home located in the heart of Wharton, Texas. Come home to upgraded tile, laminate wood flooring, upgraded hardware, built-in oven and cooktop. Huge primary bedroom includes sitting area. Primary bath with built-ins, beautiful custom tile, wainscoting, linen closet as well walk-in closet. Each room has its own special touches from sliding barn door leading into the bathroom to recent paint. Family room as well as large living room provide space for days. Enjoy gatherings in your large kitchen leading out to the covered patio. From large gorgeous trees to side home entry with covered parking, this home has it all. SCHEDULE YOUR SHOWING TODAY - THIS HOME WILL NOT LAST LONG','0.3329','55','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Gas,Zoned','0','BARBEE BLOCK 10 LOT 8','Other','14501','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Accompany,Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Barbee','6549','2.3512','Public Sewer,Public Water','1961','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','214454084','1667725913','214454084','2022-11-06T00:12:57.713','67851082','Fabyan Banos','BHGRE Gary Greene','','','30.008039','-95.307212','33','77338','4','199000.00','Active','Barnhill','7819','Drive','Humble','2','0','4','1630','Single-Family','Beautiful home in growing community of Humble. Home offers four bedrooms and two baths. EZ access to 1960, Hardy Toll Rd. and I-69. great sized front and back yard. Living room has had flooring recently updated as well as some fixtures throughout the house. Scheduling a showing today for this fantastic house close to many restaurants and Deerbrook mall.','0.1446','12','','','Electric Dryer Connections,Washer Connections','','Mud','1','Gas Connections','1','Humble Area West','Central Electric','1','LT 28 BLK 8 MILL CREEK SEC 1','Subdivision Lot','6300','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Supra Keybox','Appraisal District','1','Traditional','Mill Creek Sec 01','3284','2.7433','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','214460368','1667725913','214460368','2022-11-06T00:03:01.390','44195405','Eveliz Gutierrez','Connect Realty','','','29.912980','-95.080979','5','77532','6','249900.00','Active','Hyannis Port','706','Street','Crosby','2','0','3','1534','Single-Family','Beautiful three bedroom two bath home has been freshly pained, remodeled with new floors, carpet, kitchen appliances, kitchen countertops as well as updated bathrooms with luxurious white and gray tile. Don\'t miss out on this stunning home located in the highly desired Newport subdivision that offers pools, tennis courts, and Lake Houston boat ramp access.','0.2259','1','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Crosby Area','Central Electric','1','LT 16 BLK 22 NEWPORT SEC 1','Subdivision Lot','9840','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Newport Sec 01','3589','2.7105','Public Sewer,Public Water','1977','Appraisal District'); --> New record created successfully