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-12-24T01:22:31.560' ,`MLSNumber` = '50157414' ,`ListAgentFullName` = 'Susanna Mayberry' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297825' ,`Longitude` = '-94.799303' ,`PhotoCount` = '50' ,`PostalCode` = '77550' ,`RoomCount` = '13' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '2911' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4692' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the 1915 Brockman-Estrada House. Step back in time entering the grand foyer of this beautiful brick Prairie School inspired home situated on Broadway, one of Galveston Island\'s most prestigious streets. Current owner was awarded the Sally B. Wallace Preservation Award in 2020-if you have a love of these old homes, you will appreciate how well this home has been preserved and maintained to look as it did back in the day. Downstairs you will find a formal parlor and study to the east of the entry along with a full bath and utility room. On the south side of the first floor, you will find a formal dining room connected to a butler\'s pantry, kitchen with walk-in pantry and breakfast room. Don\'t forget to check out the back staircase as well! Upstairs boasts four oversized bedrooms, two of which offer private balconies; two solariums/sunrooms; and a full bath with soaking tub. Carriage house with apartment! Sellers recently installed leaf filters and electric driveway gate!' ,`Acres` = '0.236' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 4 & 5 BLK 149 GALVESTON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '7117' ,`TaxRate` = '2.262' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094873' WHERE `Matrix_Unique_ID` = '199190166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '17143152' ,`ListAgentFullName` = 'Liliana Pena' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710553' ,`Longitude` = '-95.166787' ,`PhotoCount` = '21' ,`PostalCode` = '77503' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Bond' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Listed! Come see this beautiful 4 bedroom 2 baths home located in a quiet neighborhood. Home has been completely renovated with modern touches, zoned to Deer Park ISD. Large backyard, double drive way, single-story house with washer and dryer connections in the inhouse utility room. Close to Highway 225 and Beltway 8 and all the industrial complexes.' ,`Acres` = '0.1607' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 DEEPWATER TERRACE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEEPWATER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEEPWATER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Deepwater Terrace Sec 01' ,`TaxAmount` = '4695' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094873' WHERE `Matrix_Unique_ID` = '208431558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '43350726' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = 'David Cole' ,`SellingOfficeName` = 'First Class, Realtors®' ,`Latitude` = '29.470012' ,`Longitude` = '-95.463956' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '264990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Robert' ,`StreetNumber` = '7707' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Camden Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094873' WHERE `Matrix_Unique_ID` = '211173013' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '63859346' ,`ListAgentFullName` = 'Anne Hettiger' ,`ListOfficeName` = 'Segue Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646623' ,`Longitude` = '-95.122522' ,`PhotoCount` = '42' ,`PostalCode` = '77505' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Flora' ,`StreetNumber` = '4206' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning 4/3.5 home in Village Grove Community, zoned to Deer Park ISD. Nestled on a quiet street w/community pool. Your guests will enter through grand lead glass door. As you step in you will feel right at home with the open concept floor plan & high, vaulted, open ceilings. The impressive light & bright chef\'s kitchen boasts beautiful granite countertops & extensive cabinetry for tons of storage. Gorgeous newly installed waterproof vinyl plank flooring. Cozy fireplace is the perfect centerpiece for your spacious family room that is open to upstairs floor. The master suite is located on 1st floor w/private bath, double sinks, walk-in closet, & separate standup shower. It is the ultimate retreat on its own separate floor. Oversized gameroom and 3 spacious guest bedrooms are upstairs.This home has a large backyard that is great for get togethers and bbq! Also has tankless water heater. GENERAC Generator for complete peace of mind for any power issues installed May 2022' ,`Acres` = '0.2056' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 2 VILLAGE GROVE EAST SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8957' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove East' ,`TaxAmount` = '7498' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094873' WHERE `Matrix_Unique_ID` = '211987567' --> 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','212838981','1675094874','212838981','2022-12-24T01:22:31.560','46860170','Claire Liang','Houston Elite Properties LLC','','','29.927737','-95.667073','26','77095','7','374900.00','Active','Lyndon Meadows','10610','Drive','Houston','2','1','4','2581','Single-Family','Stunning house with 4 bedrooms, 2.5 baths in Stone Gate Subdivision. Recently replaced HAVC. NO carpet. Waterproof vinyl floor was replaced in 2021. Upon entering the house, a cozy living room with a fireplace and large windows invites you to create precious memories with your loved ones. The kitchen and a well-lit breakfast room with easy access to the backyard are located to the side of the living room. Cook like a pro in the stunning kitchen, which features stainless steel appliances and hardwood custom cabinets. A butler\'s pantry connects the kitchen & well-lit dining room. A spacious master bedroom with an en suite bathroom awaits you on the first floor. On the second floor, there are three guest rooms and a game room to offer you and your guests more space to relax and enjoy. Located on a golf course with the amazing view in your backyard. Don\'t forget to check our 3D tour.','0.1401','8','Westin Homes','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Copperfield Area','Central Gas','1','LT 3 BLK 2 STONE GATE SEC 16','In Golf Course Community,On Golf Course','6103','Appraisal District','','1140','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','BIRKES ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Stone Gate Sec 16','6777','2.561','Public Sewer,Water District','2006','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '70922387' ,`ListAgentFullName` = 'Michelle Schlentz' ,`ListOfficeName` = 'Michelle Schlentz, Broker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658180' ,`Longitude` = '-95.090230' ,`PhotoCount` = '36' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '344500.00' ,`Status` = 'Active' ,`StreetName` = 'Desert Run' ,`StreetNumber` = '3638' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely located between Fairmont Pkwy and Spencer Hwy with easy access to Hwy 225 and Beltway 8. 3 bedrooms with an additional den/game room with closets for optional large 4th bedroom, 2 baths. Master suite has separate shower and tub with his and her sinks. Formal dining room and additional office make study or work from home easy. Additional bedrooms are a nice size with great closet space. Enjoy your mornings or evenings in the backyard under the covered patio. Hot Water Heater & Roof replaced 2019, One of the 2 A/C units replaced 2021. Seller\'s Concessions available. Make this your home today! Michelle Schlentz, Broker' ,`Acres` = '0.1791' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 SUMMER WINDS SEC 3 AMEND' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Ranch' ,`Subdivision` = 'Summer Winds Sec 3' ,`TaxAmount` = '7561' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094874' WHERE `Matrix_Unique_ID` = '213192462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '91009485' ,`ListAgentFullName` = 'Jessica Cejka' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539533' ,`Longitude` = '-95.071268' ,`PhotoCount` = '33' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo Harbour' ,`StreetNumber` = '2373' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3573' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this 4 bedroom home with a tropical paradise in the backyard. Two-story entryway. Study and formal dining off the entryway. Primary suite down. Open kitchen with breakfast bar and island. Upstairs has 3 additional bedrooms, 2 huge game/media rooms and an extra room that could be used as study or 5th bedroom. Backyard paradise with covered patio and pool/spa. 3 car tandem garage is handyman\'s dream with shelves built-in. Zoned to CCISD schools and easy access to 45.' ,`Acres` = '0.1872' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALM COVE SEC 2 (2000) ABST 18, BLOCK 3, LOT 3, ACRES 0.187' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8154' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`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` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Palm Cove Sec 2 2000' ,`TaxAmount` = '9158' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094874' WHERE `Matrix_Unique_ID` = '213472032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '97149280' ,`ListAgentFullName` = 'Rebekah Fry' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.607880' ,`Longitude` = '-95.373282' ,`PhotoCount` = '47' ,`PostalCode` = '77047' ,`RoomCount` = '10' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Westwood Manor' ,`StreetNumber` = '3119' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautiful 5 bed/4 bath is in a prime location at the end of cul-de-sac! Custom stone entrance outside and inside the home creates very welcoming, at home feel. Master bath features his and hers sinks with LARGE tub. Master bedroom on first floor with all other bedrooms upstairs and oversized game room. 2 car garage with custom cabinetry for storage. Laundry room with ample room for storage, also includes folding/ironing table. The huge backyard and covered outdoor patio with kitchen is the perfect spot for entertaining guests! Best of all, no back neighbors!' ,`Acres` = '0.1967' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 BRUNSWICK MEADOWS SEC 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8567' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunswick Mdws Sec 12' ,`TaxAmount` = '8199' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094874' WHERE `Matrix_Unique_ID` = '213821847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '48616879' ,`ListAgentFullName` = 'Brandi Wade' ,`ListOfficeName` = 'Diverse City Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727074' ,`Longitude` = '-95.368571' ,`PhotoCount` = '18' ,`PostalCode` = '77004' ,`RoomCount` = '4' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle' ,`StreetNumber` = '2518' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1940s 3/2 bungalow beams with character: original hardwood floors, large windows, gas log fireplace, and shiplap behind the drywall. In 2009, bathroom remodeled to include a walk-in shower, jacuzzi tub. All plumbing, fixtures, HVAC & electrical wiring replaced in 2009. Work permitted/ approved by the City of Houston. New sewer line added in 2014. Garbage disposal, refrigerator, back porch covering installed in 2021. Home Warranty available. Enclosed sunporch plus side & back porch offer great outdoor entertainment options. Kitchen comes fully equipped with all appliances. Laundry room off the kitchen equipped for electric/gas dryer. Once you walk in the door, you will be amazed! Well suited for owner occupier, landlord, or investor who wants to add their own special touch.\r\n\r\nThe location of this oversized corner lot in Washington Terrace can\'t be beat...just steps away from TSU, and a short commute to Downtown, Med Center, U of H, Theatre & Museum Districts, Zoo, parks' ,`Acres` = '0.1205' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 11 WASHINGTON TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Washington Terrace' ,`TaxAmount` = '3869' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094874' WHERE `Matrix_Unique_ID` = '214049375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '98063130' ,`ListAgentFullName` = 'Bardia Samiee' ,`ListOfficeName` = 'Mazan Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816578' ,`Longitude` = '-95.398434' ,`PhotoCount` = '30' ,`PostalCode` = '77018' ,`RoomCount` = '8' ,`ListPrice` = '547000.00' ,`Status` = 'Active' ,`StreetName` = '33rd' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2309' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! Located in the quickly growing and highly desirable Independence Heights neighborhood. Excellent location with easy freeway access for quick access to Downtown, Galleria and Med Center. Italian porcelain tiles on the first floor and hardwood floors throughout the rest of the home; quartz countertops, modern hardware, plentiful natural light, high end appliances, high ceilings and many many more details! Large, spacious bedrooms and massive closets for primary and secondary bedrooms.' ,`Acres` = '0.0596' ,`Area` = '9' ,`BuilderName` = 'Mazan Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 78 INDEPENDENCE HEIGHTS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'INDEPENDENCE HEIGHTS PARK' ,`TaxAmount` = '1211' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094875' WHERE `Matrix_Unique_ID` = '214341180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '75743858' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.203790' ,`Longitude` = '-96.025215' ,`PhotoCount` = '22' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '304370.00' ,`Status` = 'Active' ,`StreetName` = 'Park View Drive' ,`StreetNumber` = '38280' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Build this beautiful NEW, one story, 3 bedroom, 2 bath, 1,572 square foot home on the lot of your choice! Freedom Star Homes of Texas will build the home of your dreams on your lot in the gated Deerwood Lakes Subdivision of Hempstead. 12 plans (3/4 bedrooms - choose your finish outs) to select from. Homes feature an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. 3 car garage & extended covered porch are optional. Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living. Build in Deerwood OR let us help you find the best location for your home in Waller County. You can live in an area where you have neighbors nearby or enjoy your solitude with some acreage surrounding you.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Freedom Star Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'lot 1 blk 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10890' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Deerwood Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675094875' WHERE `Matrix_Unique_ID` = '214466121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '9558021' ,`ListAgentFullName` = 'Claudia De La Garza' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140734' ,`Longitude` = '-95.567245' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '955000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunder Valley' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous home, in one of the newest subdivisions of Creekside Park. \r\nImpressive entry with high ceilings, open floor plan with lots of light and modern feel. \r\nEnjoy the great gourmet kitchen with granite countertops, soft closing drawers and cabinets, and large island open to the family and dining area. In the first floor you can also find the confortable private primary suite, with a very large bathroom and walk-in closet, a good size study to work comfortably from home, and a guest bedroom with a full bathroom.\r\nEnjoy 2 secondary bedrooms upstairs, along with a good size game room and media room perfect to enjoy family time.\r\nLots of space in the large backyard, perfect to enjoy the nice weather, or to have a nice time in the covered patio.\r\nThis home has everything that you need! Close to parks, trails, shopping, and convenient to top rated schools. Don\'t miss it!' ,`Acres` = '0.2631' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST SEC 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11460' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Creekside Park West' ,`TaxAmount` = '17354' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094875' WHERE `Matrix_Unique_ID` = '214543784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '95721712' ,`ListAgentFullName` = 'Maria Garza' ,`ListOfficeName` = 'White Picket Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.720497' ,`Longitude` = '-95.650877' ,`PhotoCount` = '50' ,`PostalCode` = '77082' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce Park' ,`StreetNumber` = '14806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An amazing find! Lovely house with lots of charm. Gated community located in Harris County\'s Clayton Woods subdivision. 4 BR and 2 1/2 BA. Freshly painted 2 Story. Has a spacious kitchen with a wide island & plenty of storage cabinets. Side wall of formal dining area has extravagantly framed mirror. 1st Flr. has a luxurious ceramic flooring. There is a gorgeous relaxing spa tub in the master suite that will make you late to work most mornings. Located in the backyard is an enormous area with a view of the tranquil water fountain that provides a sense of tranquility to those sitting outside. A wonderful patio for those summer bbq among mature landscaping, palm trees fully fenced in w/ privacy. The garage is large enough to accommodate a home gym or man cave as well a your cars. New roof. Schools, restaurants & parks are within walking distance. Now is your chance to claim it! Check it out! This home offers a lot of room and the opportunity to personalize it for your family.' ,`Acres` = '0.195' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 CLAYTON WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HOLMQUIST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clayton Woods Sec 01' ,`TaxAmount` = '5877' ,`TaxRate` = '2.405' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094875' WHERE `Matrix_Unique_ID` = '214772350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '70743945' ,`ListAgentFullName` = 'Ozzie Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.397990' ,`Longitude` = '-95.163759' ,`PhotoCount` = '21' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Highway 6' ,`StreetNumber` = '17321' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated home on an oversized lot located on Hwy 6 with no restrictions. Property can can be used for commercial or residential. Light and bright with new appliances, fresh paint and tile throughout the whole house. This will be a great starter home. Call us to schedule your viewing today.' ,`Acres` = '0.316' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 603 PAGE 1 LOT 20 SUMRALL SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13765' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sumrall' ,`TaxAmount` = '2819' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094876' WHERE `Matrix_Unique_ID` = '214816084' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '21860895' ,`ListAgentFullName` = 'Nena Hernandez' ,`ListOfficeName` = 'House Matchmaker Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874843' ,`Longitude` = '-95.505185' ,`PhotoCount` = '20' ,`PostalCode` = '77040' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Williams' ,`StreetNumber` = '7618' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is the one you been waiting for , Welcome Home .This 3 bedroom, 2 full bathroom home has amazing natural light through out .As you walk in ,you will notice the beautiful porcelain tile floors .Step into the kitchen ,ample and eye catching stylish backsplash with quartz Countertops and new stain steel appliances .A new refrigerator was recently added and will be included .The Primary suite offers a large walk in closet, you will fall in love with .This home features Wood tile floors through out the home. This Property is completely renovated .Some Upgrades include brand new HVAC Unit , new roofing and new water heater . Large Backyard for your outdoor fun including a cover sitting area .Home sweet Home!' ,`Acres` = '0.1515' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 7 WOODLAND TRAILS NORTH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ERMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Trails North Sec 04' ,`TaxAmount` = '3327' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094876' WHERE `Matrix_Unique_ID` = '214904130' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T01:22:31.560' ,`MLSNumber` = '64729496' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000307' ,`Longitude` = '-95.504722' ,`PhotoCount` = '33' ,`PostalCode` = '77068' ,`RoomCount` = '4' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Brightwood' ,`StreetNumber` = '4306' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2735' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming traditional home located in an established community. This two story offers a covered front porch, formal dining room upon entry, 4 bedrooms with the primary suite on the 1st floor, upstairs gameroom & a huge backyard. The family room features raised ceilings, a brick fireplace, rich wood paneling, wood beams, built-ins & a wet bar that is great for entertaining. The kitchen boasts granite countertops, updated backsplash, gas cooking & a breakfast room with bay window. Spacious primary suite with slate tile flooring. Upstairs you will find the secondary bedrooms & gameroom. PEX piping throughout installed in 2021. New HVAC system installed in 2020. Recent interior & exterior paint. Large private backyard with no direct back neighbors. Mature trees in the front & back including 3 fruit trees in the backyard. Convenient location with easy access to 249, 45 & Beltway 8. **Actual utility costs are much lower than HAR\'s estimate - see attachment with amounts.' ,`Acres` = '0.2393' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 OLDE OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '445' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olde Oaks' ,`TaxAmount` = '5075' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094876' WHERE `Matrix_Unique_ID` = '214998854' --> 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','215373785','1675094876','215373785','2022-12-24T01:22:31.560','51041395','Stacy Johnson','Keller Williams Signature','','','29.948996','-95.741296','33','77433','7','660000.00','Active','Timberwood Run','19115','Drive','Cypress','3','1','3','3328','Single-Family','Stunning 1.5 story home in Bridgeland boasts over 3,300 Sq Ft, 3 bedrooms, 3 1/2 bathrooms, office and media room! Gorgeous exterior has lush landscaping to welcome you into the home. Upon entry, you are greeted with high ceilings, wood-like tile flooring and neutral tones throughout the home. Spacious office with glass paned french doors are right off of the entry. Media room is equipped with large closet for storage! Immaculate gourmet island kitchen features stainless steel appliances, granite countertops, subway tile backsplash, and breakfast bar allowing ample additional seating! Kitchen is open to the family and dining room. Perfect for entertaining! Luxurious primary retreat features beautiful ensuite bathroom with soaking tub, dual sinks, and separate shower and walk-in closet! Upstairs boasts a spacious secondary bedroom with ensuite bathroom! Beautiful backyard with covered patio! Located to tons of walking trails and other amenities offered in the community!','0.1722','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 12 BLK 2 BRIDGELAND HIDDEN CREEK SEC 24','Subdivision Lot','7500','Appraisal District','','1284','0','','3','Electric Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Supra Keybox','Appraisal District','1.5','Traditional','Bridgeland Sec 24','19667','3.4329','Water District','2017','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','215407772','1675094876','215407772','2022-12-24T01:22:31.560','63343659','Nola Lusk','A\'Lon Realty Co.','','','29.906446','-95.317679','31','77039','5','259000.00','Active','Sandydale','4922','Lane','Houston','3','0','3','1630','Single-Family','Totally Renovated single story with two Primary Bedrooms with private baths in an established neighborhood! This home has a great Open floor plan. New updated cabinets and quartz countertops, new roof, new AC, New flooring and updated baths. New vanities, & beautiful light fixtures added. Kitchen is open to the family room and breakfast room for great family time. All new interior doors and hardware. Spacious primary bedroom with a large walk-in closet. Huge Backyard is perfect for bbq, pets, and kids, fully fenced with new fence all around!','0.1453','34','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Aldine Area','Central Gas','0','LT 140 BLK 8 FAIRGREEN SEC 2','Subdivision Lot','6330','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','OLESON ELEMENTARY SCHOOL','MACARTHUR HIGH SCHOOL (ALDINE)','MEAD MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Fairgreen Sec 02','4629','2.9881','Water District','1968','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','215421905','1675094877','215421905','2022-12-24T01:22:31.560','78350533','Shahin Naghavi','eXp Realty, LLC','','','29.577329','-95.383236','21','77584','6','250000.00','Active','Peach Blossom','918','Drive','Pearland','2','0','2','1565','Single-Family','One story home in the 55+ senior community of Country Place. This home features a open concept living room and formal dining room. Kitchen with granite countertops, white cabinets, pantry and breakfast nook. Spacious primary bedroom with walk-in in closet, primary bathroom with double sinks, tub, and separate shower. Guest bedroom and bathroom with walk in shower. Both bathrooms have taller toilets and grab bars. This home also features a sun porch with ac unit and backyard, perfect for pets. Other upgrades include: Sprinkler system, windows and door on sun porch, keyless locks and ring door bell, dishwasher in kitchen, HVAC extended to garage, tile floors throughout, fans in all rooms and wooden back fence. This community features a control guard gates, pool, club house, tennis courts, golf course, library, game room, gym, community grill, lakes, walking trails and social activities. Easy access to 288 hwy. Minutes away from shopping, restaurants, retail, Medical Center and Downtown.','0.1033','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Pearland','Central Gas','1','COUNTRYPLACE SEC 7 (A0174 J CRAWLEY) BLK 1 LOT 19','Subdivision Lot','4500','Appraisal District','','198','0','','2','Gas Oven','0','','','Gas Range','','Composition','42 - Pearland','CHALLENGER ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Countryplace Sec 7','4239','2.4056','Public Sewer,Public Water','1997','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','215466112','1675094877','215466112','2022-12-24T01:22:31.560','52196053','Trinh Le','Keller Williams Signature','','','29.710263','-95.674546','30','77082','8','320000.00','Active','Barrow Ridge','4235','Lane','Houston','2','1','4','2700','Single-Family','Lovely and spacious 2700sqft, 4bed/2.5bath CORNER lot home that comes with formal dining room and a den/office space. Large island kitchen offers multiple storage space, granite countertop and opens to the cozy living room, perfect for family/friends gathering. All bedrooms are up. Primary bedroom with sitting area by the windows, separate shower/tub and walk-in closet. Huge gameroom upstairs for extra entertainment space. Large backyard is perfect for bbq or just simply a relaxing space after work. Tile and wood/vinyl flooring down and carpet upstairs. Quiet neighborhood. Conveniently located within minutes to Westpark Tollway/Highway 6, 15m to Hong Kong Food Market/Chinatown/Bellaire Blvd., 30m to Downtown/Medical Center. LOW TAX AND HOA. Make this your home sweet home before it\'s gone!','0.1377','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Mission Bend Area','Central Gas','1','LT 9 BLK 2 WESTHEIMER PLACE SEC 3','Corner,Subdivision Lot','5997','Appraisal District','','450','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','2 - Alief','REES ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Accompany,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Westheimer Place Sec 03','6380','2.937','Water District','2003','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','215474426','1675094877','215474426','2022-12-24T01:22:31.560','82343329','Jose Barbosa','RE/MAX Real Estate Assoc.','','','30.419089','-95.622889','47','77356','10','795000.00','Active','Waterford','24','Way','Montgomery','4','2','4','3857','Single-Family','New Construction in the heart of Bentwater gated Community. With high ceiling foyer leading into a spacious kitchen that is pristine and bright follows into a large family room great for entertaining family and friends. Very well illuminated primary bedroom. Primary bathroom with 2 separate sink and extra vanity, separate walk in shower and bath tub. First floor level contains 1 bedrooms and a guest room, study/office, an extra space as a entertainment space. Second floor where you will find spacious game room with bar to allow you to enjoy the view of the lake. You will also find a media room, 2 bedroom and a full bathroom. This house has lots more to offer and is a must see!','0.219','39','ARY HOMES LLC','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Lake Conroe Area','Central Gas','1','S261506 - BENTWATER 06, BLOCK 5, LOT 4','Subdivision Lot','9540','Appraisal District','','1146','1','Never Lived In','3','Double Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Leave Business Card,Supra Keybox','Builder','2','Traditional','Bentwater 06','610','2.1142','Public Water,Septic Tank','2022','Seller'); --> 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','215480630','1675094877','215480630','2022-12-24T01:22:31.560','6546331','Jose Jimenez','AroundTown Properties Inc','','','29.571258','-95.248082','27','77089','9','419900.00','Active','Coventry Bay','2023','Drive','Houston','2','0','4','2562','Single-Family','Beautiful updated one story 4 bedroom, 2 bath. Updates throughout, floors, custom built ins, whole house water softener, painted garage floor, exterior landscaping lighting. Great living/kitchen open floor plan with high ceilings throughout. Quiet primary suite at the rear of the home with high ceiling, updated bathroom with large jetted tub, tiled walk-in shower, double sinks, quartz countertop, generous closet, extensive cabinets, and new wide plank tiled floor. A table can fit the casual dining area so the more formal dining room can be used as a second living room, children\'s play area or however you want! Fourth bedroom can be used as office. 10,378 square foot lot. Will not last. Make your private appointment today!','0.2382','3','Meritage Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','LT 11 BLK 2 RIVERSTONE RANCH AT CLEAR CREEK SEC 4','Subdivision Lot','10378','Appraisal District','','825','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','SOUTH BELT ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Request Online Appointment','Appraisal District','1','Ranch,Traditional','Riverstone Ranch/Clear Crk','11572','3.6869','Water District','2016','Seller'); --> 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','215630032','1675094877','215630032','2022-12-24T01:22:31.560','61901070','Fatima Haq','Compass RE Texas, LLC','','','29.931150','-95.630875','46','77429','11','399999.00','Active','White Oak Springs','13910','Drive','Cypress','3','1','5','3878','Single-Family','Don\'t fight over a Primary Bedroom, we have 2 here!5 bedrooms home that offers comfort & space. Grand Entry w/ high ceilings & lots of windows for natural sunlight. Dining area w/ wall to wall mirror, easy access to the Kitchen .Cozy Living area w/ sunroom attached overlooking the backyard. Enjoy quiet time for sipping coffee or entertain friends. Primary suite sits on the 1st floor w/ huge walk-in closet, dual sinks, vanity space, separate tub & shower. The kitchen has brand new stainless steel appliances and newly painted cabinets. 2nd Primary upstairs w/ ensuite bath w/ dual sinks & 2 beds. Huge game rm upstairs, allowing guests many options. Recent updates includes entire home new interior paint, 2 recent carrier HVAC systems, 2019 roof, recent water heater, & recent exterior painting. Original home owner, no pets! Easy access to 290 and the Beltway. Less than .5 miles from HCA Houston Healthcare North Cypress Hospital. Zoned to \"A\" rated CyFair ISD, per TEA rating system.','0.151','10','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','1','Cypress North','Central Electric','1','LT 27 BLK 1 WHITE OAK SPRINGS SEC 1','Subdivision Lot','6577','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','LAMKIN ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Lockbox Front,No Appointment Required','Appraisal District','2','Traditional','White Oak Spgs Sec 01','7536','2.551','Public Sewer','2001','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','215651177','1675094877','215651177','2022-12-24T01:22:31.560','17771167','Evan Ballew','JLA Realty','','','30.279805','-95.629873','50','77316','8','725000.00','Active','Grand Lake Estates','8931','Drive','Montgomery','3','1','3','3073','Single-Family','Absolutely STUNNING 3/4 bedroom, 3.5 bath, 2 story home on 1+ acre WITH A POOL is nestled in the gated golf course community of Grand Lake Estates, minutes from Conroe and The Woodlands. Inside is an open layout w/ soaring ceilings and Shaw LVP flooring throughout the 1st level. The kitchen features new quartz counters, shaker style cabinetry, stainless steel appliances including a wine refrigerator, and updated plumbing and lighting fixtures. The island has bar seating and opens to the living room w/ a wood burning fireplace complete w/ floor to ceiling tile. The primary suite is on the 1st level and has an incredible ensuite w/ double sinks, a soaking tub, separate shower and walk-in closet. Upstairs is a MASSIVE gameroom w/ storage galore. One guest suite has a private balcony while the other has it\'s own full bath. Enjoy the peace and quite out back under the covered back patio overlooking the pool and hardwood trees w/ the utmost privacy. Ask for the complete upgrade list!','1.05','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Wood Burning Fireplace','1','Conroe Southwest','Central Gas','1','GRAND LAKE ESTATES 08, BLOCK 1, LOT 6, ACRES 1.050','In Golf Course Community','45738','Appraisal District','','770','0','','2','Gas Oven','1','In Ground','','Gas Range','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','2','Traditional','Grand Lake Estates 08','11804','1.825','Aerobic,Public Water','2013','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','215653749','1675094877','215653749','2022-12-24T01:22:31.560','25629775','Leah Mudd','Keller Williams Realty - Memor','','','29.673556','-95.470330','30','77096','7','525000.00','Active','Rutherglenn','5118','Drive','Houston','2','0','3','2093','Single-Family','The epitome of everything a buyer wants. Owner has done it all,including:recent double pane low E windows and doors,removed old insulation and replaced w/upgraded insulation in exterior walls,rewired electrical,plumbing redone with tankless water heater,replaced HVAC and ductwork,custom cabinets w/pull out shelves in kitchen and baths,wine bar/butler\'s pantry w/pull out shelves,Chefs kitchen w/6 burner gas cooktop,built in microwave in island,recent appliances,2 spacious pantries with room to store sm appliances, freshly painted exterior,recent roof,automatic driveway gate,gutters,fencing and security system have also been replaced. High end engineered hardwood floors throughout house.Tile in bathrooms, kitchen&laundry. Family room with vaulted ceiling and custom built in cabinetry. Gaslog fireplace,recessed lights,large windows,crown molding and plantation shutters. Backyard with professional landscaping,greenhouse & pergola. Zoned to Bellaire HS, across the street from Kolter Elem.','0.2167','20','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Meyerland Area','Central Gas','1','LT 11 BLK 29 MEYERLAND SEC 8 R/P F','Subdivision Lot','9440','Appraisal District','','493','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','27 - Houston','KOLTER ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','1','Traditional','Meyerland Sec 08 R/P F','8031','2.3307','Public Sewer,Public Water','1961','Appraisal District'); --> New record created successfully