Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:16:18.770' ,`MLSNumber` = '45332986' ,`ListAgentFullName` = 'Andrew Vong' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.611739' ,`Longitude` = '-95.549639' ,`PhotoCount` = '43' ,`PostalCode` = '77477' ,`RoomCount` = '8' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Queens' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Court' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2077' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market with brand new roof installed Nov 2022!!!! Beautiful 4 bedroom 1 story home in the Kingsway neighborhood. This is one of the larger 1 story plans in the area and not only includes the 4 full sized bedrooms, but a formal dining area, spacious kitchen with breakfast area, and family room boasting high ceilings with recessed lighting and built-in cabinets surrounding the gas fireplace. The home sits on a large corner lot so there is plenty of yard for gardening or for the kids to play. This is your chance to get in and see why so many love to call Stafford home. It is located near all the thoroughfares providing easy access into and out of town for work or play. Also, don\'t forget about the low taxes because Stafford is the city with no city property taxes! Call to see this one today!' ,`Acres` = '0.1834' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSWAY, BLOCK 3, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7990' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsway' ,`TaxAmount` = '3891' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419402' WHERE `Matrix_Unique_ID` = '211676213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:08:05.777' ,`MLSNumber` = '93595309' ,`ListAgentFullName` = 'Georganna Zaba' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.543281' ,`Longitude` = '-98.378468' ,`PhotoCount` = '21' ,`PostalCode` = '78657' ,`RoomCount` = '3' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Hi Circle West' ,`StreetNumber` = '716' ,`StreetSuffix` = '' ,`City` = 'Horseshoe Bay' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2229' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss this 3 bedroom, 2.5 bath split bedroom home on a corner lot by Horseshoe Bay Resort’s Slick Rock Golf Course with gorgeous oak trees and a 3-car garage. The home features: 1) LARGE OFFICE/MEDIA ROOM with a big window to view the beautiful trees; 2) OPEN AREA BY FOYER currently used for formal dining; 3) LIVING AREA with wood burning fireplace, built-in cabinetry, floor-to-ceiling glass panels with glass door to backyard covered patio; 4) DRY BAR with granite countertop, upper and lower cabinets; 5) SPACIOUS BREAKFAST ROOM with wall of windows to enjoy backyard views; 6) KITCHEN with granite counters, breakfast bar, built-in desk, lots of cabinets, Whirlpool Stainless Steel refrigerator, double ovens and microwave installed in 2015; 7) LAUNDRY ROOM with sink, storage cabinets, Maytag washer and Samsung dryer included; 8) FENCED BACKYARD with large covered patio and irrigation system for entire yard. 9) Replaced air conditioning system-2016, replaced water heater-2018.' ,`Acres` = '0.3396' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HORSESHOE BAY LT 8008' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '14792' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '305' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '183 - Llano' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LLANO HIGH SCHOOL' ,`SchoolMiddle` = 'LLANO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Horseshoe Bay Proper' ,`TaxAmount` = '5063' ,`TaxRate` = '1.5721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419402' WHERE `Matrix_Unique_ID` = '212085202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:20:27.770' ,`MLSNumber` = '79344002' ,`ListAgentFullName` = 'Yolanda McCraw Cunningham' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Robert M. Bragg' ,`SellingOfficeName` = 'Bayou, REALTORS' ,`Latitude` = '29.561533' ,`Longitude` = '-95.256476' ,`PhotoCount` = '40' ,`PostalCode` = '77581' ,`RoomCount` = '11' ,`ListPrice` = '349500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hidden Creek' ,`StreetNumber` = '2504' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here’s your opportunity to own in the highly sought-after community of Clear Creek Park. A true gem, this immaculate 1 story, 3 bedroom, 2 bath home has been recently updated with granite counters, interior painting, LVP flooring in Primary bedroom, primary bath, and walk-in closet; new built-in oven, cooktop and vent hood, and much more. The refrigerator is included with the sale. Also the washer and dryer. The primary bath features dual vanities, separate garden tub and shower, and private toilet closet. This home is equipped with a home generator for added security and comfort when power goes down. Whether you’re entertaining or looking for a bit of R&R, this home meet the need.. Book an appointment soon. Room sizes are approximate; Buyers to verify.' ,`Acres` = '0.195' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CLEAR CREEK PARK (A0198 TJ GREEN) (PEARLAND) BLK 2 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '407' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Park' ,`TaxAmount` = '8491' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419403' WHERE `Matrix_Unique_ID` = '212869321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T23:53:32.793' ,`MLSNumber` = '44214602' ,`ListAgentFullName` = 'Deanna Clark' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Keith Brown' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.176855' ,`Longitude` = '-95.546912' ,`PhotoCount` = '45' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '1550000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sentinel Point' ,`StreetNumber` = '190' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like pages out of a magazine, this gorgeous 5 bedroom custom home with sparkling pool/spa is tucked into an almost 1/2 acre cul-de-sac lot in coveted Cascade Canyon. The yard has plenty of space to play! Completely remodeled -final finishing touches in 2021, custom features, built-ins & designer upgrades at every turn, the feeling of classic elegance meets you in every room. Large windows throughout allow stunning views of the backyard paradise. Meticulously maintained! Roof 2021! Generator! Unparalleled finishes: custom stained wood floors in the living areas, classic trim - cased openings, archways, and more. Stunning kitchen with classic white cabinets, quartz counters & island, Wolf Range & Thermador refrigerator; butler\'s pantry w/ wine refrigerator. Upgrades include elegant light fixtures throughout, bathrooms inside the home are stunning with marble or granite counters, framed mirrors, marble tile accents, recent designer carpet & tile flooring! Come see the home of your dreams!' ,`Acres` = '0.4849' ,`Area` = '15' ,`BuilderName` = 'Eaglebrook' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S971521 - WDLNDS VIL INDIAN SPRG 21, BLOCK 1, LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '21124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Indian Sprg 21' ,`TaxAmount` = '18804' ,`TaxRate` = '2.1319' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419403' WHERE `Matrix_Unique_ID` = '213506981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:20:33.010' ,`MLSNumber` = '50671964' ,`ListAgentFullName` = 'Angelia McDaniel' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779527' ,`Longitude` = '-95.331225' ,`PhotoCount` = '8' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Worms' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great opportunity for the savvy investor looking to own in the rapidly gentrifying 5th Ward community now being rebranded as East River. This home is occupied with a tenant until March 2023 ($1315 a mth) which gives you time to get your plans designed and replat approved for those wanting to build multiple units on this lot. The home was renovated 2 years and has been maintained pretty well by the existing tenant. Please do not disturb the tenant, will show property upon executed contract. There is new development all around this home and with it being less than 10 minutes to downtown and the East River project and golf course this is the ideal time to get in before the rush.' ,`Acres` = '0.1263' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 16 CHAPMANS SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chapmans Sec' ,`TaxAmount` = '2701' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419403' WHERE `Matrix_Unique_ID` = '213650365' --> 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','213993324','1668419403','213993324','2022-11-14T00:01:36.410','77526340','Rohail Ullah','Baker & Co | Forbes Global Pro','','','29.681118','-95.462885','5','77096','5','2199999.00','Active','Braesvalley','4903','Drive','Houston','5','0','5','7639','Single-Family','Welcome to the new age of homes. Stronger, more efficient, and the most resilient home you can find. Everlasting Homes is changing the way homes are built. They use a structural concrete insulated panel mixed with cement to create a home that is resistant to floods, hurricanes, tornadoes, extreme weather (cold or hot), fires, termites, and molds. One of a kind here in the Meyerland area of Houston, this home also has great location. Minutes from the Galleria, Rice Village, River Oaks, and Upper Kirby! It will sit on a 12,800 SQFT lot with 5 bedrooms and 5 bathrooms with a total living space of 4,754 SQFT. The home is lifted 10 ft off the ground and if you count the 1st floor garage, we are talking 7,639 SQFT. It’s built to entertain, it’s built for a family, and most importantly it’s built to keep your family safe!','0.2938','20','EVERLASTING HOMES','','','','No Disclosures','','','1','Meyerland Area','Central Electric,Central Gas','1','LT 1 BLK 36 MEYERLAND SEC 5','Corner','12800','Survey','','525','1','To Be Built/Under Construction','7','','0','','','','','Other','27 - Houston','LOVETT ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Accompany,Appointment Required','Builder','3','Contemporary/Modern','Meyerland Sec 05','7071','2.3307','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:04:19.007' ,`MLSNumber` = '88579179' ,`ListAgentFullName` = 'Huy Dinh' ,`ListOfficeName` = 'The Taylor Group' ,`SellingAgentFullName` = 'Collette King' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '29.988282' ,`Longitude` = '-95.629402' ,`PhotoCount` = '25' ,`PostalCode` = '77429' ,`RoomCount` = '8' ,`ListPrice` = '370000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Privet' ,`StreetNumber` = '13110' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting just for you in Lakewood Glen! You will start to notice the details before even walking inside from the attractive curb appeal with gorgeous landscaping. A formal entry invites you into an enchanting world of style and luxury where upscale flooring, ornate crown molding and many windows clad in plantation shutters infuse the home in timeless elegance. Unleash your cooking skills in the gourmet kitchen prepared with gleaming granite counters and custom cabinets with direct access into both the formal dining room and breakfast nook. The sophisticated living room will enchant with its custom shelving, gas log fireplace and soaring ceiling heights. Find your relaxation in the massive primary suite with bath offering double sinks, shower and separate soaking tub. The outdoor space continues to excite with spacious flagstone patio and fenced-in landscaped yard. Coming home is always a breeze with the detached garage. Call today to tour your forever home!' ,`Acres` = '0.2032' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 LAKEWOOD GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Glen' ,`TaxAmount` = '6747' ,`TaxRate` = '2.5217' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419403' WHERE `Matrix_Unique_ID` = '214109537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:08:22.547' ,`MLSNumber` = '62969864' ,`ListAgentFullName` = 'Hansa Bhatia' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Bobby Thomas' ,`SellingOfficeName` = 'World Wide Realty' ,`Latitude` = '29.538617' ,`Longitude` = '-95.576126' ,`PhotoCount` = '44' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '567990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'White River Pass' ,`StreetNumber` = '5710' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FALL IN LOVE with this magnificent East facing home with numerous upgrades located in the master-planned community of Riverstone. The dramatic entry shows soaring high ceilings with an open floor plan, beautiful hardwood floors, a formal dining room with a bar/butler’s pantry, study with wooden flooring & french doors. 2-story family room with a beautiful fireplace, and huge backyard. The gourmet kitchen offers a recently upgraded high-end granite countertop. Master suite has wood flooring & bay windows. Masterbath has dual sinks, a jacuzzi tub & huge his/her closets. Grand wooden staircase leads to a separate media room and a big game room. 2nd floor has 3 secondary bedrooms and 2 full baths. Oversized 2.5-car garage with ample storage. House includes a water softener with RO filters, new tankless water heater & sprinkler system.Also included are a projector & screen for the media room, washer & dryer & Fridge. Top-ranked FBISD Schools & great amenities. Schedule a private tour today.' ,`Acres` = '0.212' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'EDGEWOOD AT RIVERSTONE SEC 1, BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9233' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Edgewood At Riverstone Sec 1' ,`TaxAmount` = '9572' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419404' WHERE `Matrix_Unique_ID` = '214165458' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:20:57.720' ,`MLSNumber` = '50362560' ,`ListAgentFullName` = 'Ebin Kurian' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661076' ,`Longitude` = '-95.641579' ,`PhotoCount` = '40' ,`PostalCode` = '77498' ,`RoomCount` = '12' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Brown Bridge' ,`StreetNumber` = '10614' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3718' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move right in with everything included (appliances, NEST System, storage sheds, some furniture, etc.) in this RECENTLY UPGRADED & RENOVATED home! Two-tone accent colors throughout with UPGRADED FIXTURES & Berber Carpet! GRANITE COUNTERTOPS, STAINLESS STEEL APPLIANCES, & COFFEE NOOK IN UPGRADED KITCHEN! Primary Suite equipped with walk-in shower & separate garden tub, His-and-Her sinks, & separate sitting space! Study/5th bedroom on the first level, next to the full bathroom! 2019 ROOF! Beautifully manicured corner lot in a cul-de-sac with a circle driveway! Large yard with TILED FLOOR, BASKETBALL COURT, STORAGE SHED, & COVERED PATIO (Pre-Plumbed With Drain, Water, & Gas Line)! Zoned to GOOD Schools in the VERY SOUGHT-AFTER Fort Bend ISD! Tennis courts, clubhouse, pool, and playgrounds are all provided for residents. Easy Access to TX-6, US-90, & I-69/US-59, making the commute easier. Only a short distance from Sugar Land Town Center, neighborhood parks, trails, restaurants, & shopping!' ,`Acres` = '0.3114' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODBRIDGE OF FBC SEC 12, BLOCK 2, LOT 7' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13566' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DRABEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodbridge Of Fbc Sec 12' ,`TaxAmount` = '7736' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419404' WHERE `Matrix_Unique_ID` = '214261152' --> 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','214310485','1668419404','214310485','2022-11-14T00:09:34.070','74230996','Leslie Threadgill','Coldwell Banker Realty','','','30.044448','-94.881116','0','77535','0','150000.00','Active','Nancy','403','Street','Dayton','1','0','3','740','Single-Family','Own a piece of land outside the city of Houston. This 1/2 acre lot is ready to restore or rebuild home on the property. New homes built a few blocks away. Small town community from US Highway 90, traveling west towards Crosby then FM 1960 connects Dayton to the northern reaching Humble and Huffman Texas.','0.551','52','','','','','Sellers Disclosure','0','','','Dayton','Central Electric,Central Gas','0','OAKDALE, LOT 25-26 TR 2, ACRES 0.551','Subdivision Lot','24002','Appraisal District','','','0','','0','','0','','','','','Composition','74 - Dayton','KIMMIE M. BROWN ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','No Appointment Required','Appraisal District','1','Traditional','Oakdale','2248','2.4832','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:38:48.130' ,`MLSNumber` = '21715367' ,`ListAgentFullName` = 'Allison Tims' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.286297' ,`Longitude` = '-95.478874' ,`PhotoCount` = '24' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Windsor' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PICTURES JUST ADDED 11/9!! KITCHEN COMPLETED UPDATED with Beautiful QUARTZ Countertops! New Backsplash. ALL NEW FLOORING Downstairs!! HUGE PRIMARY SUITE with Huge Walk-in Closet and Double Doors to In-suite Bathroom with Soaking Tub!! . All nice size BR\'s with Walk-in Closets! BRAND NEW AC!! NEW Dishwasher! NEW Fence with Double Gates! NEW push button Toilets! Kitchen has New Disposal, New Sink, Updated Lighting and New Paint! Features gas appliances and opens to breakfast and family room. Lots of windows to invite natural sunlight! Both formals. Covered Patio overlooks Large Private Backyard with a very nice sized Shed with AC! Large lot in the Beautiful neighborhood of Rivershire. Centrally located just minutes to I-45, Lake Conroe is Only 15 Minutes Away! Woodlands Mall 10 minutes away! Brand new stores all around!! You Are Going to LOVE Living Here!!' ,`Acres` = '0.2348' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSHIRE 02 BK 7 LT 35&W31\'OF LT 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Rivershire 02' ,`TaxAmount` = '6586' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419404' WHERE `Matrix_Unique_ID` = '214398855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T23:06:43.547' ,`MLSNumber` = '97065550' ,`ListAgentFullName` = 'Michelle Murray' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890445' ,`Longitude` = '-95.621270' ,`PhotoCount` = '32' ,`PostalCode` = '77095' ,`RoomCount` = '4' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Verde Mar' ,`StreetNumber` = '14107' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE - SUNDAY 1-4 - Beautifully maintained 4 bedroom, one story home in a the gorgeous golfcourse community of Hearthstone. Minutes from Hwy290 & access to shopping, dining and more! Enter into a spacious foyer with the large formal dining to your right & huge living room ahead. Stay warm & cozy in this inviting living space, with gaslog fireplace, cathedral ceilings & gleaming wood floors. Large kitchen w/large serving bar & big breakfast room, enough for a crowd! Ready for your own space? Check out this huge owner\'s getway bedroom, window looking over the back patio & luxurious bathroom. Secondary bedrooms are large & all have walk-in closets. Need office space? This owner put double doors on a bedroom near the primary room and uses it as a study. Outside enjoy a spacious deck and access to your detached/attached 2 car garage. Long driveway at this home allows for family size parking. On your tour note the beautiful Danish furniture for sale! Call today for your personal tour.' ,`Acres` = '0.1894' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 HEARTHSTONE SEC 6' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Sec 06' ,`TaxAmount` = '6848' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419404' WHERE `Matrix_Unique_ID` = '214423510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-14T00:20:32.853' ,`MLSNumber` = '44073150' ,`ListAgentFullName` = 'Ethan Rast' ,`ListOfficeName` = 'Rast & Rast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077326' ,`Longitude` = '-95.262751' ,`PhotoCount` = '16' ,`PostalCode` = '77365' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunrobin Dr' ,`StreetNumber` = '20660' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful House is located in the recently built and highly Sought-after, Brook wood Forest Community. \r\nEnjoy the public park, with a Splash pad and the lake just steps away!\r\nIn this quiet Neighborhood, you can enjoy nice walks in the evening while watching the amazing Texas Sunsets.\r\nWith New Schools, including a Middle School, high School and Lone star College right down the road. You might never have to worry about sending the kids far from home! \r\nITS ALSO BEEN RECENTLY RE PAINTED , AS WELL AS HAVING THE FLOORS RE DONE. \r\n\r\nWhat\'s more to say other than, Welcome Home!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Brookwood Forest 06, BLOCK 1, Lot 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood Forest' ,`TaxAmount` = '4900' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419405' WHERE `Matrix_Unique_ID` = '214485205' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-13T23:21:05.670' ,`MLSNumber` = '31092596' ,`ListAgentFullName` = 'Lanard Lane' ,`ListOfficeName` = 'RE/MAX Pearland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407414' ,`Longitude` = '-95.051950' ,`PhotoCount` = '49' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Key' ,`StreetNumber` = '2603' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Empire home, Wellington Signature Series the only one in Lago Mar. Located in a gated Community, this home features 4 bed, 2.5 baths and over 2,600 sq with all the space your family needs. Open-concept floor plan with a beautiful Kitchen with quarts counter tops, walk-in pantry, GE appliance Pkg. slate, freestanding gas range, subway tile backsplash, and Reverse Osmosis H20.. Primary bedroom downstairs is a retreat. Garden tub, double vanity, separate shower and large walk-in closet. Upstairs game room opens up to 3 bedrooms. Highlights- Energy efficient features, rain gutters, waters softener system, landscape lighting, hurricane panels and pre-wired alarm system. Backyard with covered patio, and storage shed. Welcoming Community- walking trails, parks, lakes,lagoon, club house, swimming pools and much more. Move-in ready.* You Don\'t want to miss all this beautiful home has to offer!' ,`Acres` = '0.1524' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK 5 LAGO MAR POD 6 SEC 2 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7127' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 6 Sec 2' ,`TaxAmount` = '12442' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668419405' WHERE `Matrix_Unique_ID` = '214546575' --> 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','214636712','1668419405','214636712','2022-11-14T00:45:46.430','83818664','Shastyn Stewart','Compass RE Texas, LLC','','','29.676549','-95.470066','37','77096','5','945000.00','Active','Braesheather','5135','Drive','Houston','5','1','5','4942','Single-Family','Complete Remodel!! Gorgeous one story with charming curb appeal located in the highly desired Meyerland community. This home boasts an open floor plan showcasing 5 bedrooms, 5 baths and a large living room that has a beautiful wrap around, back yard view. The inviting outdoor living space has an oversized patio area and pool with waterfall. The home is great for entertaining. Additional upgrades include porcelain wood-like tile floors that run throughout the entire home. Fully updated & upgraded kitchen with white cabinets, granite countertops, tile backsplash and SS appliances. Master bath with fully enclosed steam shower, garden tub, and LED his and her mirrors. Enjoy local parks, shopping, restaurants, grocery& great schools within a short distance.','0.3606','20','','','Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','Meyerland Area','Central Gas','1','LT 3 BLK 25 MEYERLAND SEC 8 R/P I','Subdivision Lot','15708','Appraisal District','','500','0','','2','Double Oven,Electric Oven','1','In Ground','','Gas Range','','Composition','27 - Houston','KOLTER ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Meyerland Sec 08 R/P I','14829','2.3994','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','214701292','1668419405','214701292','2022-11-14T00:37:05.500','21391587','Brooke Mason','Cross-Town Realty, LLC','','','30.613653','-96.411292','10','77807','9','289900.00','Active','Fox Bluff','5516','Drive','Bryan','2','0','4','1797','Single-Family','MOVE IN READY! This new-build home, in Foxwood Crossing, has a desirable, open floor plan and includes 4 bedrooms and a covered\r\npatio space out back. This dream home boasts modern cabinetry, granite countertops, and stunning, Stainless-Steel Appliances.\r\nAdditionally, the primary bedroom has an en-suite, private bath complete with dual vanity sinks and a walk-in closet. Come see this\r\ngem of a home today.','0.137','61','WJH LLC','','','','No Disclosures','','','','','Central Electric','1','FOXWOOD CROSSING PH 1, BLOCK 2, LOT 16, ACRES .137','Subdivision Lot','5968','Appraisal District','','150','1','Never Lived In','2','','0','','','','','Composition','148 - Bryan','MARY BRANCH ELEMENTARY SCHOOL','BRYAN HIGH SCHOOL','STEPHEN F. AUSTIN MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Foxwood Xing Ph 1','1320','2.193','Public Sewer,Public Water','2021','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','214723485','1668419405','214723485','2022-11-13T23:27:36.597','96146960','Donnie Amadi','SKW Realty','','','29.836445','-95.855799','36','77493','6','549990.00','Active','Salange','211','Lane','Katy','3','0','4','2540','Single-Family','','0.2593','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Katy - Old Towne','Central Gas','1','S800002 SUNTERRA SECTION 2 BLK 1 LOT 14','Subdivision Lot','11295','Appraisal District','','750','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Sunterra Sec 2','1503','2.2776','Water District','2022','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','214724795','1668419405','214724795','2022-11-14T00:34:34.683','6042551','Karen Blanton','Walzel Properties','','','29.750724','-95.828449','0','77494','10','699000.00','Active','Grayson Lakes','1618','Boulevard','Katy','3','1','4','4034','Single-Family','LOCATION! Gorgeous home in the beautiful Grayson Lakes, sits on the corner with a breathtaking view of the lake that sits directly across the street. With view from all front windows. Two-story foyer, formal living /a dining room, study with double doors, and half bath. Family room has soaring two story ceiling, and dramatic windows and view of sparkling pool, and backyard. Gourmet kitchen with large island, gas cooktop, lots of storage. Spacious Primary and ensuite includes fireplace, bath w/ separate shower and vanities. Custom closet with custom mirrored cabinets, bonus space can be used as exercise or dressing room. Sweeping wrought iron staircase leads to spacious game room overlooking pool. Fully equipped media room and three bedrooms overlooking lake. Sits on a greenbelt, no rear neighbors, Numerous upgrades include Sprinkler, security, shutters, remote patio shades, sound system, smart home light switches and more. Nearby freeway, schools, restaurants, and entertainment.','0.3194','36','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','2','Katy - Southwest','Central Gas,Zoned','1','COUNTRY LAKES AT GRAYSON LAKES SEC 4, BLOCK 1, LOT 1','Corner,Greenbelt,Subdivision Lot,Water View','13912','Appraisal District','','1321','0','','3','','1','Gunite,In Ground','','','','Composition','30 - Katy','WOODCREEK ELEMENTARY SCHOOL','TOMPKINS HIGH SCHOOL','WOODCREEK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Country Lakes At Grayson Lakes Sec 4','10946','2.4245','Water District','2004','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','214724993','1668419405','214724993','2022-11-13T23:17:30.973','15753464','Kyle Watts','RE/MAX Leading Edge','','','29.137641','-95.052006','47','77554','8','500000.00','Active','Nueces','4130','','Galveston','2','0','3','1637','Single-Family','This BEAUTIFUL property resides in the quiet neighborhood of Isla Del Sol on Galveston\'s \"West End\". The West End, known for SPRAWLING BEACHES AND UNTETHERED WILDLIFE is a PERFECT destination for those looking to get away from the hustle and bustle of city life. The home backs up to a nature preserve, so no back neighbors! At 3 bdrm & 2 full baths the home features 2 decks to soak up the Texas sun, an oversized driveway large enough to park a boat, a garage, a full-service passenger lift, granite counter tops and much more! Just a short golf cart ride to the beach or the private fishing pier, this home has it all. The home is well maintained, updated, and ready for your enjoyment! \r\n**FLOOD INSURANCE LESS THAN $600 ANNUALLY!**','','33','','','','','Sellers Disclosure','1','','1','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 46 (46-0) BLK 4 ISLA DEL SOL S','Water View','5009','Appraisal District','','300','0','','1','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Other Style','Isla Del Sol','','','Public Sewer,Public Water','2005','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','214725028','1668419405','214725028','2022-11-13T23:14:46.977','95617082','Deyanira Gutierrez','Keller Williams HoustonCentral','','','29.609859','-95.223339','0','77089','3','140000.00','Active','Kirkhall','10519','Drive','Houston','2','0','3','1132','Single-Family','Home is ASIS. Home has lots of potential for the right Investor. A full remodel is needed from the floor to the ceiling. The house has 3/4 bedrooms 2 full baths 2 car garage that is being used as a room, a huge bonus is the additional built garage on the left side that is detached for a boat or an open entertainment space. Roof is about 10 years old and water heater is new, AC unit has not been used in a few years seller mentioned it works. Home has never flooded per the Seller. Cash Only! Seller will need a 1 month lease back.','0.1641','3','','','','','Sellers Disclosure','','','','Southbelt/Ellington','Central Gas','0','LT 12 BLK 28 KIRKWOOD SEC 7','Subdivision Lot','7150','Appraisal District','','','0','','1','','0','','','','','Composition','41 - Pasadena','MEADOR ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','BEVERLYHILLS INTERMEDIATE SCHOOL','Accompany,Appointment Required','Appraisal','1','Traditional','Kirkwood Sec 07','3901','2.6863','Public Water','1970','Appraisal'); --> 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','214725188','1668419405','214725188','2022-11-13T23:35:38.727','32163305','Deyanira Gutierrez','Keller Williams HoustonCentral','','','29.590664','-95.449212','0','77053','3','180000.00','Active','Arcridge','4706','Circle','Houston','2','0','3','1221','Single-Family','Great home','0.1756','38','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','','','','Missouri City Area','Central Gas','1','RIDGEMONT SEC 2, BLOCK 20, LOT 2','Cul-De-Sac','7650','Appraisal District','','300','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','RIDGEMONT ELEMENTARY SCHOOL','WILLOWRIDGE HIGH SCHOOL','MCAULIFFE MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal','1','Ranch','Ridgemont Sec 2','2932','2.2137','Public Water','1972','Appraisal'); --> 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','214725422','1668419405','214725422','2022-11-14T00:07:50.567','63769932','Feras Rachid','Opendoor Brokerage, LLC','','','29.405450','-94.901949','17','77590','3','180000.00','Active','22nd','521','Avenue','Texas City','1','0','3','1129','Single-Family','Your dream home is waiting for you! This home has fresh interior paint and windows that create a light filled interior with well placed neutral accents. Step into the kitchen, complete with an eye catching stylish backsplash. Relax in your primary suite with a walk in closet included. Extra bedrooms add nice flex space for your everyday needs. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! A must see!','0.2011','33','','','','','Sellers Disclosure','1','','0','Texas City','Central Gas','0','ABST 167 RICHARDSON D SUR E 5 FT OF LOT 2 & W 65 FT OF LOT 3','Subdivision Lot','8760','Appraisal District','','','0','','2','','0','','','','','Composition','52 - Texas City','ROOSEVELT-WILSON ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Mainland Park','2924','2.5335','Public Water','1982','Seller'); --> New record created successfully