Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T13:39:38.050' ,`MLSNumber` = '97030471' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920930' ,`Longitude` = '-95.732768' ,`PhotoCount` = '44' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Adventurous' ,`StreetNumber` = '18635' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle dreams with the Modern Farmhouse design of The Abney in Bridgeland\'s Parkland Row. Enjoy the peace of working from home in your own private office located off the entry. The open kitchen and family room makes family gathering casual and comfortable. The kitchen island anchors the chef\'s kitchen. You are surrounded with lots of windows making the area feel bright and airy. Enjoy the privacy of your master retreat with a spa like shower. The shaded, covered back patio is the perfect escape to enjoy your morning coffee or relaxing with friends and family. David Weekley Homes is a Diamond Level Environments for Living home builder. Heating and cooling is guaranteed for three years. Come enjoy the resort style amenities of Bridgeland, while living in a new David Weekley Home in a Traditional Neighborhood Design.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 01 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkland Row' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709353' WHERE `Matrix_Unique_ID` = '206694846' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T13:06:37.370' ,`MLSNumber` = '56865155' ,`ListAgentFullName` = 'Laura Salazar' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295356' ,`Longitude` = '-94.804878' ,`PhotoCount` = '38' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue K' ,`StreetNumber` = '3415' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS IT! LOOK NO FURTHER! You’ll love all this gorgeous Galveston 5-6 bedroom home has to offer! All new pex plumbing, AC/Heat on first floor, electrical panel, roof and quartz countertops. You’ll be in awe with the delightful & inviting open concept of the living area—adorned with beautiful island decor and shiplap walls! Stunning kitchen with elegant quartz countertops! Plenty of backyard space, (with it’s larger than most home lots in that area) and covered back patio for those family barbecues after a wonderful day at the beach! Minutes to Pleasure Pier, Moody Park, Schlitterbahn Waterpark, The Strand, & many more exciting attractions! This home is a must see! Make your showing appointment today!' ,`Acres` = '0.165' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR E PT OF LOT 3 & W 1/2 OF LOT 4 & N 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7187' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,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` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5248' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709354' WHERE `Matrix_Unique_ID` = '210716939' --> 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','211180711','1663709354','211180711','2022-09-11T13:56:19.077','67552848','Blanca Benavidez','The Monarch Team, LLC','','','29.704204','-95.242664','19','77017','5','150000.00','Active','Lucore','10125','Street','Houston','1','0','3','1469','Single-Family','','0.1607','3','','','','','Sellers Disclosure','','','','Hobby Area','No Heating','0','LT 90 ALLENDALE TOWNSITE SEC A','Cleared','7000','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','RUCKER ELEMENTARY SCHOOL','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Appraisal District','1','Traditional','Allendale Townsite','1954','2.3307','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T13:24:58.127' ,`MLSNumber` = '26082431' ,`ListAgentFullName` = 'Clarence Snell' ,`ListOfficeName` = 'Goldman Meyer Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985698' ,`Longitude` = '-95.143179' ,`PhotoCount` = '29' ,`PostalCode` = '77346' ,`RoomCount` = '12' ,`ListPrice` = '489999.00' ,`Status` = 'Active' ,`StreetName` = 'Catamaran' ,`StreetNumber` = '18502' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3163' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has it ALL!! Soaring ceilings, Wide open space between Family room, Kitchen and Breakfast area. The study/home office is nestled with beautiful French doors plus formal living and dining. Large bedroom for holiday guests on the 1st floor, while the Huge Primary sits on the 2nd floor with an En-suite and walk-in closet. Large game room area up, which can be used as a media room. The newly installed HVAC units keep this massive home cool on those Summer days and if you get hot you can jump in the POOL and enjoy the jets. While sitting in the pool enjoy the new fencing and lighting along the beautiful patio that is waiting for some PARTIES! COME SEE THIS BEAUTY!!' ,`Acres` = '0.1791' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 52 CHAMPIONS VILLAGE WALDEN ON LAKE HOUSTON PH 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Walden On Lake Houston Ph 05' ,`TaxAmount` = '7610' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709354' WHERE `Matrix_Unique_ID` = '211455333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T12:42:55.120' ,`MLSNumber` = '16986950' ,`ListAgentFullName` = 'Renee Fussell' ,`ListOfficeName` = 'Signature Services Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.446772' ,`Longitude` = '-94.654346' ,`PhotoCount` = '38' ,`PostalCode` = '77650' ,`RoomCount` = '9' ,`ListPrice` = '409500.00' ,`Status` = 'Active' ,`StreetName` = 'Palmetto' ,`StreetNumber` = '965' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! LOCATION! LOCATION! This Amazing 3 Bedroom, 2 Bath Home Situated on 2, Fully Fenced Lots with Spacious South Facing Covered Deck to Enjoy the Views and Listen to the Waves is a Short Golf Cart Ride to The Beach! So Much Charm! Light & Bright! Expansive Family Room with Walls of Windows and Decorative Fireplace, High Ceilings, Ceiling Fans; Spacious Kitchen with Plenty of Counter and Cabinet Space, Pantry; Large Breakfast/Dining Room; Amazing Master Retreat with Walk In Closet and Fabulous, Updated En-Suite; 2 Additional Bedrooms and a Bathroom! Full Size, in house, Laundry Area with Shelving! Plenty of Room for Family and Friends. Downstairs Features HUGE Gathering Area, Outdoor Shower, Foot Wash Station, Garage, Storage and MORE! Centrally Located Near Dining, Shopping, Water Parks, The Bolivar Resort Pool/Concert Venue and More! If you are Beach Combing, This FABULOUS Home is Located Near Beach Marker 60! Come Discover Beach Life on The Bolivar Peninsula!' ,`Acres` = '0.2526' ,`Area` = '33' ,`BuilderName` = 'Unknnown' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 136 & 137' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Beach' ,`TaxAmount` = '4658' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Water,Septic Tank,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709354' WHERE `Matrix_Unique_ID` = '211516597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T12:22:56.303' ,`MLSNumber` = '80638104' ,`ListAgentFullName` = 'Summer Bloom' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.296649' ,`Longitude` = '-94.783583' ,`PhotoCount` = '49' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '524995.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '1519' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a step back in time and see this very charming 1913 (per seller) corner lot home and enjoy soothing gulf breezes on your wraparound porch. Located 2.5 blocks from the seawall..it\'s a short walk to the beach. Abundance of original windows provide lots of natural light in living room and formal dining room. Original pocket doors w/original brass hardware. Hardwood floors downstairs, as well as high ceilings throughout. 60’s cast iron sink and butler panty. Utility room and a bathroom/shower on main level. All bedrooms upstairs & two additional enclosed spaces (one was the sleeping porch & other was the nanny\'s room). Upstairs bathroom has an iron clawfoot soaking tub/shower. Attic has lots of storage. Newer outside HVAC units (2). Fully fenced backyard, single detached oversized garage. Close to downtown, UTMB, shopping, dining. Vacation rentals allowed. Ready to rest, nest or invest? Come call this home! Schedule your showing today!' ,`Acres` = '0.0888' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR S 45 FT OF LOTS 8 & 9 (1008-2) NE BL' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3870' ,`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,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5947' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1913' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663709354' WHERE `Matrix_Unique_ID` = '211540021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T12:53:18.893' ,`MLSNumber` = '59122132' ,`ListAgentFullName` = 'Lauren Akery' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526310' ,`Longitude` = '-95.161090' ,`PhotoCount` = '25' ,`PostalCode` = '77598' ,`RoomCount` = '7' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'English Colony' ,`StreetNumber` = '2802' ,`StreetSuffix` = 'Drive' ,`City` = 'Webster' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated home in Heritage park! This beautiful home has updated flooring throughout (Combination of tile and laminate), granite countertops, stainless appliances, updated bathrooms, double pane windows, and has a NEW AC recently installed (July 2022). And then walk out to your BIG BACKYARD and relax on your COVERED PATIO. Walk across the street to the park, pool, splash pad, tennis and basketball courts .Quick and easy access to I-45, Baybrook, Kroger, etc. Zoned to CCISD school District.' ,`Acres` = '0.1848' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 6 HERITAGE PARK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park' ,`TaxAmount` = '4855' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709354' WHERE `Matrix_Unique_ID` = '211605108' --> 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','211668877','1663709354','211668877','2022-09-11T13:45:18.800','56055509','David Beck','Horace Properties LLC','','','29.737506','-95.446851','50','77027','14','2795000.00','Active','Sul Ross','4028','Street','Houston','4','2','4','5525','Single-Family','This charming custom home boasts a floor plan meticulously designed by Travis Mattingly and Horace Homes. A uniquely applied slurried brick exterior makes for a striking presence on this quiet Lynn Park street. This wider neighborhood lot allows for a sprawling first floor that opens up to a grand outdoor living area and green space out back. Inside, hand hewn custom beams stretch over the family, kitchen and breakfast rooms all illuminated by a vast wall of windows. Wood Panelling lining the walls of the of the grand entry, stairs and upstair hallways is just one of the many custom touches to be found. Other panelling details in the game room, primary bedroom & bath also create spectacular visual details that are one of a kind. Antique lighting, job built cabinetry, exquisite custom draperies and window coverings are just a few of the other elements that add charm to this amazing home.','0.202','16','Horace Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','Gaslog Fireplace,Wood Burning Fireplace','2','Highland Village/Midlane','Central Gas','1','LT 17 & TR 18A BLK 2 LYNN PARK','Subdivision Lot','8800','Survey','','750','0','','2','Double Oven,Freestanding Oven','0','','','Freestanding Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','LAMAR HIGH SCHOOL (HOUSTON)','LANIER MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Lynn Park','47908','2.3307','Public Sewer','2018','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T12:24:26.953' ,`MLSNumber` = '53793555' ,`ListAgentFullName` = 'Zhongting Zhang' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754777' ,`Longitude` = '-95.742266' ,`PhotoCount` = '45' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Westcliffe Falls' ,`StreetNumber` = '21511' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous new renovated 2 stories on a cul-de-sac in the sought-after community of Memorial Pkwy! So many upgrades from the top to the bottom. New sidings, new oak wood staircase, new tiles in foyer, half bath, and second bathroom. Freshly painted the interior and exterior. The updated kitchen with a quartz countertop and marble backsplash. High ceiling family room with gas fireplace! The First-floor primary offers a new wood floor, double sinks, a separate shower, and two walk-in closets. Upstairs features a huge game room with a new wood floor and a newly renovated second bathroom with a quartz countertop. Great backyard with lots of places for kids/pets to play and adults to the garden. 2022 upgrades: Quartz countertops in kitchen and bathroom, laminate wood floors in the primary and upstairs game room, oak wood staircase, new second bathroom, sidings, interior, and exterior paint, new tiles at the foyer, half bath, and utility room, electrical switches and outlets, all locks, etc.' ,`Acres` = '0.1744' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 77 BLK 2 MEMORIAL PARKWAY SEC 18' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 18' ,`TaxAmount` = '6497' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709354' WHERE `Matrix_Unique_ID` = '211836757' --> 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','211955939','1663709355','211955939','2022-09-11T13:11:57.073','80210811','Beverly Helms','JPAR-The Sears Group','','','29.659918','-95.744112','47','77406','8','620000.00','Active','Campaign','8210','Circle','Richmond','3','1','4','4037','Single-Family','Available now, this magnificent 2 story home by Village Builders. Formal entry, high soaring ceilings, open staircase w/metal balusters and beautiful timeless fixtures. Entertain in the private formal dining room w/access to butlers pantry. Kitchen offers 42\" custom Kent Moore cabinets, under-mount lights, large full service island, new gas cooktop and dishwasher. Built in double convection oven and microwave. Living area offers soaring windows and \r\nnatural lighting. Enjoy views of the large backyard offering an open canvas for your designs. The primary bedroom offers a large sitting area, large windows and wood floors. Ensuite bath, jetted tub large walk-in closet w/built-ins. Upstairs includes large game room, built-in desk area, private bedroom w/full bath, secondary bedrooms w/jack-jill bath. All new light fixtures, plumbing fixtures, tile and carpet. Outside offers front/back irrigation, 2 car garage w/porte-cochere. Easy access to 99! Call for private showing!','0.3043','37','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','LONG MEADOW FARMS SEC 7, BLOCK 2, LOT 2 (PT), (48% IN FT BEN','Cul-De-Sac,Subdivision Lot','13255','Appraisal District','','895','0','','2','Convection Oven,Double Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','ADOLPHUS ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Accompany,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Long Meadow Farms Sec 7','9821','2.4929','Water District','2004','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T13:56:48.827' ,`MLSNumber` = '86297839' ,`ListAgentFullName` = 'Blanca Benavidez' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667446' ,`Longitude` = '-95.272274' ,`PhotoCount` = '23' ,`PostalCode` = '77061' ,`RoomCount` = '7' ,`ListPrice` = '269999.00' ,`Status` = 'Active' ,`StreetName` = 'Glenbrae' ,`StreetNumber` = '7951' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is what you have been looking for, great location & spacious 4 beds 3 baths. If you have been looking for an investment or want to house hack this one is perfect. Has a guest house on the back with a bedroom, kitchen and bathroom. Large covered porch and much more. Come tour this property today!' ,`Acres` = '0.1717' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 24 GLENBROOK VALLEY SEC 6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LEWIS/Bellfort Academy' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenbrook Valley Sec 06' ,`TaxAmount` = '4223' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709355' WHERE `Matrix_Unique_ID` = '211975241' --> 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','212031267','1663709355','212031267','2022-09-11T13:03:05.777','1034898','Geraldine Ray','Geri Ray Real Estate','','','29.581260','-95.222494','13','77089','8','289000.00','Active','Sagegreen','11518','Court','Houston','2','0','3','2184','Single-Family','HOME FLOODED DURING HURRICANE HARVEY * CORNER LOT ON CUL-DE-SAC * CLEAR CREEK SCHOOLS * \r\nGRANITE COUNTERTOPS KITCHEN AND BOTH BATHS. * \r\nLARGE PANTRY/BUTLER\'S PANTRY *\r\nTILE FLOORING THROUGHOUT *\r\nUPGRADE BATHS * (NO TUBS) * INGROUND POOL * SOME IMPROVEMENTS TO COME *','0.1864','3','PERRY','','Electric Dryer Connections,Washer Connections','','Home Protection Plan,Mud,Owner/Agent,Sellers Disclosure','1','Mock Fireplace','1','Southbelt/Ellington','Central Gas','1','LT 24 BLK 17 SAGEGLEN SEC 2','Corner,Cul-De-Sac','8120','Appraisal District','','262','0','','2','Double Oven','1','In Ground','','Electric Cooktop','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Appointment Required,Lockbox Back','Appraisal District','1','Contemporary/Modern','Sageglen Sec 02','5116','2.356','Public Sewer,Water District','1977','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','212125025','1663709355','212125025','2022-09-11T13:43:17.383','37050434','Lorena Gonzalez','Gold Quest Realty- Galleria','','','29.656697','-95.494689','22','77035','5','395000.00','Active','Bellfort','5943','Street','Houston','2','1','4','2810','Single-Family','Stunning Spanish Terracotta Tile Roof House in the Westbury Subdivision! 4 Bedroom, 2 full bath, 1 half bath and an extra study room. Gourmet kitchen with 36 in range, large island with extra storage, Custom-made solid wood cabinets with gorgeous high-end granite countertops. Stone arches, wood burning chimney, travertine floors throughout the house, and a beautiful A MUST SEE! House DID NOT flood during Harvey.','0.2517','20','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Brays Oaks','Central Gas','0','LT 27 BLK 79 WESTBURY SEC 5','Corner,Subdivision Lot','10965','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Tile','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','2','Ranch,Spanish','Westbury Sec 05','7748','2.3307','Public Sewer,Public Water','1964','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','212270767','1663709355','212270767','2022-09-11T12:31:56.900','46289265','Jarred DeMore','Keller Williams SoutheastTexas','Tammi Freund','Compass RE Texas, LLC','29.476874','-94.582677','38','77650','3','485000.00','Option Pending','Hidden Gold','3288','','Crystal Beach','2','0','3','1178','Single-Family','3/2, only 6 months young - built in 2022! Better than new w/furnishings, big screen TV-new in box & tons more! High ceilings, tons of lighting inside/outside! Super functional kit offers gorgeous quartz counters w/beautiful custom white cabinetry with tons of storage, open LR/kit area, spacious island, washer/dryer included! Primary BR has beautiful bathroom w/double sinks, walk in closet & tub/shower combo! Guest BR #1 sleeps 5, guest BR #2 sleeps 2 but could easily add a bed/bunk for more! This awesome home features wrap around deck, spacious sand shower, extra-long tandem garage with tons of space to store all of your toys! Deck is spacious with lovely outdoor furniture! This home has not been in the rental pool so it\'s immaculate and ready for full time living, vacay or rental! On a really nice area of the beach. Lafittes Landing is a wonderful neighborhood that has golf cart entry to beach - so not a high-traffic flow. Now is the time to purchase in this booming vacation spot!','0.106','33','Ron Rusche','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Crystal Beach','Central Electric','0','LAFITTES LANDING SEC 2 (2017) ABST 65, LOT 6, ACRES 0.106','Other','4617','Appraisal District','','','0','','2','Freestanding Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Builder','1','Traditional','Lafittes Lndg Sec 2','310','1.6103','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212329461','1663709355','212329461','2022-09-11T13:24:46.270','9247203','Thu-Anh Nguyen','Camelot Realty','','','29.731458','-95.379102','42','77004','5','509000.00','Active','La Branch','4408','Street','Houston','3','1','3','2970','Single-Family','Beautiful free-standing contemporary home in The Museum District with 3 bedrooms and 3.5 baths, rooftop terrace, extra wide stairways, open floor plan, high celling throughout, just minutes to Hermann Park, Houston Zoo, the Medical Center, and Museum District is a MUST SEE. A guest bedroom & bathroom is located on the first floor. Second floor living with a fireplace, balcony access, the kitchen boasting granite countertops, stainless steel appliances, and breakfast bar. Spacious primary suite is on the third floor with dual sinks, separate shower, walk-in closet and a fireplace. The remaining secondary bedroom and bathroom are also on the third floor. The 4th floor is a rooftop deck, bonus game room/office is located on the same floor. Don\'t miss this opportunity to live in an unbelievable 4 story dream, schedule a tour today before it\'s gone!','0.0448','17','','','','','Sellers Disclosure','1','Gas Connections','2','Rice/Museum District','Central Gas','1','LT 2 BLK 1 ROSEWOOD VILLAS','Cleared','1950','Appraisal District','','150','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','27 - Houston','MACGREGOR ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','CULLEN MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Appraisal District','4','Contemporary/Modern','Rosewood Villas','10967','2.3307','Public Sewer,Public Water','2008','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','212335165','1663709355','212335165','2022-09-11T13:29:47.660','62287816','Taneeka Henderson','Keller Williams, LLC','','','29.804711','-95.329861','13','77026','14','285000.00','Active','Leffingwell','4817','Street','Houston','4','0','6','1400','Single-Family','Main home 2 bedrooms 2 baths, large 12x12 walk in closet, bonus room could be a 3rd bedroom. Garage converted to 2 story duplex in 2019. Duplex has 2 bedrooms and 1 bath. Lot over 1/4 acre. Never flooded per owner. All room sizes approximate. Tons of potential.','0.2686','2','','','','','Sellers Disclosure','','','','Northside','Central Gas','0','LT 49 CITY GARDENS SEC 1','Subdivision Lot','11700','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','KASHMERE GARDENS ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Leave Business Card,Lockbox Back,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','City Gardens Sec 01','6651','2.3307','Public Sewer,Public Water','1935','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','212359751','1663709355','212359751','2022-09-11T12:29:05.443','50644845','Gay Milliorn','RE/MAX Eastside','','','29.772597','-94.997283','49','77521','6','244900.00','Active','Woodstone','3107','Drive','Baytown','2','0','3','1743','Single-Family','This is it! The one you\'ve been waiting for! This lovely 3 bedroom, 2 bath home has been lovingly cared for and features great curb appeal, a spacious island kitchen, cozy living room, and so much more. The roof is only 2 years old, and there are new gutters with leaf guard screens, plus the HVAC & ductwork is only 1 year old. The backyard is your own private garden paradise, with covered patio/deck, trees for shade, and lovely flowers and plants. There are no back neighbors, and there is a gate that leads to the open field - perfect for taking your dog out for a walk! As soon as you walk through the front door, it just feels like home. Take a look for yourself and fall in love with this Home Sweet Home!','0.1848','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Baytown/Harris County','Central Gas','1','LT 9 QUAIL HOLLOW SEC 1','Cleared,Subdivision Lot','8050','Appraisal District','','145','0','','2','','0','','','Electric Range','','Composition','23 - Goose Creek Consolidated','HARLEM ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','GENTRY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Quail Hollow Sec 01','3631','2.97','Public Sewer,Public Water','1976','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','212403568','1663709355','212403568','2022-09-11T12:22:51.263','14685078','Anthony Jensen','ZAPP Realty','','','29.268972','-94.838326','27','77551','6','595000.00','Active','Colony Park','18','Circle','Galveston','2','0','4','2325','Single-Family','This beautiful home located in the sought-after subdivision of Colony Park has undergone extensive remodeling and is a real show stopper. This open-concept home offers 4 bedrooms, 2 bathrooms, an office, walk-in pantry, and utility room. Some of the interior features include white oak wood flooring, tall ceilings, custom cabinetry, quartz countertops, stainless steel appliances, and a custom quartz fireplace surround. The primary suite offers a spacious bedroom, vast walk-in closet, and a spa-like bathroom with soak tub, custom tiled shower, custom cabinets, and marble tiled floors. The exterior offers a new driveway, beautiful front porch with stained wood ceilings, new back patio with stained wood ceilings, new sod, new sprinkler system, and new siding around the garage and rear of home. Additional updates include new plumbing, roof, windows, and doors. Come see this home today because it won\'t last!','0.1882','33','','','','','Owner/Agent','1','Gas Connections','1','Near West End','Central Gas','1','ABST 121 HALL & JONES SUR LOT 9 BLK 1 COLONY PARK','Subdivision Lot','8198','Appraisal District','','125','0','','2','Gas Oven','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Left Side,Vacant/Unoccupied','Seller','1','Traditional','Colony Park 1','4959','2.0662','Public Sewer,Public Water','1986','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','212405064','1663709355','212405064','2022-09-11T12:33:37.287','10450219','Andrea Tran','Nextgen Real Estate Properties','','','32.795903','-96.801012','12','75204','1','1499000.00','Active','Hibernia','2600','Street','Dallas','1','0','0','1802','Single-Family','This stunning bungalow in the heart of Uptown Park is the perfect location for an investor looking to buy and hold. Walking distance to high end restaurants, shopping, and next to a Whole Foods, this is the perfect opportunity for anyone looking to own land in the heart of Dallas. The property is for sale and comes with a tenant who has 4 remaining years in their lease agreement. DO NOT BOTHER CURRENT TENANTS. BUNGALOW ZONED FOR COMMERCIAL AND RESIDENTIAL!','0.1033','84','','','','','Tenant Occupied','','','','','Central Gas','0','OVERLANDS BLK B/555 N PT 1 50X90 HIBERNIA & ROUTH','Corner','4500','Appraisal District','','','0','','','','0','','','','','Composition','211 - Dallas','SAM HOUSTON ELEMENTARY SCHOOL (DALLAS)','NORTH DALLAS HIGH SCHOOL','THOMAS J RUSK MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Craftsman','Overlands','25852','2.638','Public Sewer,Public Water','1925','Appraisal District'); --> New record created successfully