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` = '2023-01-22T15:08:23.707' ,`MLSNumber` = '66563189' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.162033' ,`Longitude` = '-95.420704' ,`PhotoCount` = '17' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '216900.00' ,`Status` = 'Active' ,`StreetName` = 'Bryan Way' ,`StreetNumber` = '312' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 1425 sq.ft with tall ceilings with 2 car garage. 4 sides brick with large covered back patio. 3 bedrooms and 2 full baths. Coffered ceilings in Family and Primary bedroom. Granite kitchen with deep under mount sink and 36\" cabinets with crown molding. Stainless steel Frigidaire electric range, microwave, dishwasher, 2\" blinds included!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adama Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '0/0/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '281' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217617' WHERE `Matrix_Unique_ID` = '210034286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T16:22:45.740' ,`MLSNumber` = '54513977' ,`ListAgentFullName` = 'Frank Seymore' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886403' ,`Longitude` = '-95.476996' ,`PhotoCount` = '22' ,`PostalCode` = '77088' ,`RoomCount` = '9' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Bihia Forest' ,`StreetNumber` = '5803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located home in the Geater Inwood area, close to major transportation throughfares such as 249, 290, and Beltway 8. Renovated kitchen with new countertops and cabinets. Stainless steel appliances included. New hard wood floors throughout the home. Large primary bedroom with beautifully renovated en suite bathroom. Secondary bathroom has been beautifully renovated as well. Large formal dining room. New hot water heater. Ample Storage.' ,`Acres` = '0.2571' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 017*I5645955-001-001-009 INWOOD NORTH SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'NITSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood North Sec 01' ,`TaxAmount` = '3727' ,`TaxRate` = '2.6055' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217617' WHERE `Matrix_Unique_ID` = '212017400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T16:58:10.527' ,`MLSNumber` = '73340890' ,`ListAgentFullName` = 'TaShana Talley' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.408176' ,`Longitude` = '-95.182905' ,`PhotoCount` = '43' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '358000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1725' ,`StreetNumber` = '13305' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly Remodeled home situated on approximately 1 acre. This stunning home features tile flooring throughout, updated appliances, and quartz countertops. The shiplap walls add the farmhouse feel. Plenty of storage and garage space with a shop. Large covered patio along back of home, that leads to you to the gorgeous pool area. The oversized pool is complimented by a large covered entertaining patio. This home has an entire home generator, and much much more. Make an appointment to see this beauty.' ,`Acres` = '0.97' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A255 FRANCIS REIMER, TRACT 23.2, ACRES .97' ,`LotDesciption` = 'Cleared' ,`LotSize` = '42253' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Francis Reimer' ,`TaxAmount` = '4391' ,`TaxRate` = '1.9249' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217617' WHERE `Matrix_Unique_ID` = '212520490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T15:51:38.880' ,`MLSNumber` = '23413340' ,`ListAgentFullName` = 'Wendy De La Rosa' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.916838' ,`Longitude` = '-95.569714' ,`PhotoCount` = '20' ,`PostalCode` = '77064' ,`RoomCount` = '7' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Prospect Hill' ,`StreetNumber` = '10143' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER !!!!! This cottage inspired 3Bd, 2.5 Ba home is PRICED TO SELL with ALL APPLIANCES INCLUDED! NO CARPET, ceiling fans, in all rooms, Open concept kitchen, breakfast bar and 2 car garage! This home is in the established Winchester Country neighborhood, located in a desirable area of Jersey Village and within minutes of everything Jersey Village has to offer . Call today to schedule your private tour of this wonderful home!' ,`Acres` = '0.1626' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 10 WINCHESTER COUNTRY SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7084' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winchester Country' ,`TaxAmount` = '4675' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217618' WHERE `Matrix_Unique_ID` = '212662049' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T15:53:36.050' ,`MLSNumber` = '44293765' ,`ListAgentFullName` = 'Victoria Fernandez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'David Nguyen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.327195' ,`Longitude` = '-94.942263' ,`PhotoCount` = '31' ,`PostalCode` = '77563' ,`RoomCount` = '11' ,`ListPrice` = '360000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Barracuda' ,`StreetNumber` = '196' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy and relax yourself at home, front canal residence. Just renovated beautiful house with new appliances, bonus washer and dryer. New cabinets throughout the house, quartz counters. Upper-level laminated flooring and 2 carpeted bedrooms, 2 full bathrooms. Lower-level tile flooring and 2 additional bedrooms and 1 full bathroom. Plenty of storage space inside and outside. Minutes away from Galveston and shops.\r\nRooms dimensions are approximate.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 196 NEW BAYOU VISTA ADDN 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 2' ,`TaxAmount` = '5257' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217618' WHERE `Matrix_Unique_ID` = '212706960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T16:09:11.350' ,`MLSNumber` = '64486024' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947939' ,`Longitude` = '-95.781366' ,`PhotoCount` = '22' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '925623.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Wood Aster' ,`StreetNumber` = '21319' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Cologne for sale by Newmark Homes in Bridgeland. 5 beds (2 down), 5.5 baths, living, formal dining, mud room, game room, media room, three car garage, and of course featuring our courtyard entry. This is the one you will fall in love with on a quiet no thru street! Come see this north facing home before it is gone....' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '33/01/06' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9480' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1196' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.637885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217618' WHERE `Matrix_Unique_ID` = '212730267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T15:03:31.060' ,`MLSNumber` = '38932047' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.165775' ,`Longitude` = '-95.437800' ,`PhotoCount` = '15' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '270900.00' ,`Status` = 'Active' ,`StreetName` = 'Lago' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant, Two story home is waiting to be yours. This charming home offers a stunning long front entrance, open concept floor plan, high ceilings, spacious kitchen overlooking the living room. The kitchen is surrounded with tall cabinets, granite countertops, backsplash, and a stainless steel under-mound sink. Included Frigidaire stainless steel electric range, dishwasher, and microwave and a walk in pantry. This 4 bedroom 2 and Half bath has roomy bedrooms, walk in closets, spacious private commode bathrooms, with double sinks. Master suite boasts soaring ceiling, separate tub and shower with tile surround and double vanities. Energy efficient 16 seer HVAC, programmable digital thermostat. Covered patio. Inside windows have faux wood blinds is included.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '15-2-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217618' WHERE `Matrix_Unique_ID` = '213205947' --> 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','214342128','1675217619','214342128','2023-01-22T15:34:57.920','51753603','Brandon Nava','Texas Relocation Experts','','','29.984574','-95.621735','32','77429','14','1100000.00','Active','Hunters Canyon','12734','Lane','Cypress','5','2','5','5301','Single-Family','Luxury lovers your Dream is a reality now.This home features a 5 bedroom 2.1 bath,3 car garage, is nestled on a premium Lake front lot.The grand foyer opens you to a double front door that leads you to an amazing curved staircase! The kitchen has a large quartz island, stainless steel appliances, double ovens, custom backsplash, and huge over and under cabinet LED lighting island for hosting and opens into the family room. The spacious casual dining room has a putting green view. The Master suite has a large California Dream walk-in closet and there are dual shower heads w/ and Outdoor shower! After a delicious dinner or after enjoying the swimming pool you can entertain in your game room and theater style media room. Wait till you see the pool with majestic view at night. Private Putting green to practice your game swings is a cherry on cake.','1.2362','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure,Tenant Occupied','1','Gas Connections,Gaslog Fireplace','1','Cypress North','Central Gas,Zoned','1','TR 1 BLK 1 GREAT OAKS ESTATES','Water View','53849','Appraisal District','','1766','0','','3','Convection Oven,Double Oven,Gas Oven','1','Enclosed,In Ground','','Gas Cooktop,Gas Range','','Composition','13 - Cypress-Fairbanks','HAMILTON ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','2','Other Style','Great Oaks Estates','19130','2.1637','Aerobic,Septic Tank,Well','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T16:19:01.250' ,`MLSNumber` = '96074509' ,`ListAgentFullName` = 'Pamela DeBlasio' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.728346' ,`Longitude` = '-94.989065' ,`PhotoCount` = '37' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '298600.00' ,`Status` = 'Active' ,`StreetName` = 'Parks' ,`StreetNumber` = '133' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1641' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand spanking new!!! Charming single story home situated on approx 1/2 acre just minutes from Lake Livingston and close proximity to downtown Livingston. This home has all of the finishes you would expect including luxury vinyl plank flooring, granite countertops, S/S appliances, insulated windows and doors and cement board siding, concrete driveway and fenced backyard. Picture yourself Relaxed and enjoying the peace and quiet from the spacious front porch. This could be your new home! Call today for an appointment.' ,`Acres` = '0.4304' ,`Area` = '44' ,`BuilderName` = 'Pneuma Group' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WIGGINS VILLAGE #1 SECTION 2 LOT 185, 187 & 189' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '18750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wiggins Village #1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217619' WHERE `Matrix_Unique_ID` = '214657741' --> 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','215449239','1675217619','215449239','2023-01-22T15:06:02.953','5626968','Pattie Reeves','Century 21 Realty Partners','','','30.205161','-94.978409','47','77535','8','639900.00','Active','County Road 3011','2265','','Dayton','2','0','4','1856','Single-Family','Country charmer on 12.2+/- acres. Relax from the hustle & bustle in this log cabin style home. Features include front & back covered porches, open concept with living/dining/kitchen, French doors and windows provide natural light. Upgrades in kitchen include custom designed leather granite w/chiseled edges, stone backsplash, granite composite sink, porcelain tile in kitchen, dining & utility. New brick on f/p w granite to match kitchen countertops. Ask for the list of updates/upgrades! Primary bedroom w/walk-in closet. The Guest house was built in 2022 is 12x32 w/ 8x32 covered porch & features a full kitchen & bath w/handicap accessible shower, mini split a/c. The 1/2 acre livestock pen w/ 5ft fencing & crossed fenced is ready for those 4H or FFA projects. The shop has rollup 3 carport overhangs, new slabs and one carport attached to home for covered parking. There is so much to enjoy with this property!','12.21','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Cleveland Area','Central Electric','0','000232 H&TC-149, TRACT 51 (MS-11), ACRES 12.21','Cleared,Wooded','531868','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Other','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox','Appraisal District','1','Ranch','H&Tc-149','3453','1.4124','Aerobic,Well','2011','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','215532967','1675217619','215532967','2023-01-22T16:52:20.643','57949631','Mark Ghebranious','Texas Ally Real Estate Group,','','','29.690252','-95.681004','11','77083','3','199999.00','Active','Tierra Verde','7806','Drive','Houston','2','0','3','1464','Single-Family','Located in the desirable neighborhood of Mission West, 7806 Tierra Verde Dr is a 3 bedroom/2 bathroom home that offers the best of Houston living. With a variety of shopping, dining, and entertainment options just minutes away and top-rated schools in the area, this property is the perfect blend of convenience and quality. Plus, with a large backyard and easy access to major highways, you\'ll love calling this home. Schedule your showing today and make 7806 Tierra Verde Dr your new address!\r\nAsk agent about potential repair options for the property!','0.1303','37','','','','','Sellers Disclosure','','','1','Mission Bend Area','Central Gas','1','MISSION WEST SEC 2, BLOCK 6, LOT 7','Subdivision Lot','5678','Appraisal District','','350','0','','2','','0','','','','','Composition','19 - Fort Bend','MISSION WEST ELEMENTARY SCHOOL','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Mission West','5483','2.4297','Public Sewer,Public Water','1983','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','215595994','1675217619','215595994','2023-01-22T16:29:14.640','17975356','Alina Bupte','Realty Associates','','','29.997750','-95.404632','46','77073','8','289900.00','Active','Hillock Bluff','834','Circle','Houston','2','1','3','2154','Single-Family','GORGEOUS 3 BEDROOM, 2 AND HALF BATHROOM VERY UPDATED AND UPGRADED HOUSE IN VERY CONVENIENT LOCATION WITH EASY ACCESS TO I-45. A LOT OF WINDOWS, VERY LIGHT, OPEN FLOOR PLAN WITH HIGH CEILINGS. TWO LARGE LIVING AREAS DOWNSTAIRS. BEAUTIFULLY REDONE STONE FINISHING ON THE FIREPLACE. GORGEOUS KITCHEN WITH GAS APPLIANCES, A LOT OF WHITE CABINETS AND RECENTLY INSTALLED LIGHT COLOR COURTSIDE COUNTERTOPS. METAL RAILWAY MAKES THE HOUSE VERY OPEN AND MODERN. BIG BEDROOMS UPSTAIRS, HUGE MASTER BATHROOM WITH TWO WINDOWS. BATHTUB WITH A BATHTUB AND SEPARATE SHOWER. SPACIOUS MASTER CLOSET WITH SHELVING AND DRAWERS. WOOD LOOKING TILE DOWNSTAIRS AND WOOD FLOORING UPSTAIRS. 2\" BLINDS, MODERN LIGHT FIXTURES AND CEILING FANS. FINISHED GARAGE WITH PAINTED FLOORING AND AIR CONDITIONER CAN SERVE AS A MAN CAVE OR A GAMEROOM. RECENT PAINT INSIDE ALL THE HOUSE. EASY ACCESS TO MAJOR HIGHWAY, AIRPORT AND SHOPPING. CALL TODAY, IT WON\'T LAST LONG!','0.1169','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding,Gas Connections','1','Aldine Area','Central Gas','1','LT 33 BLK 1 NORTHRIDGE PARK SEC 2 AMEND','Subdivision Lot','5091','Appraisal District','','425','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','48 - Spring','CAROLEE BOOKER ELEMENTARY SCHOOL','ANDY DEKANEY H S','RICKY C BAILEY M S','Accompany,Appointment Required,No Supra Keybox','Appraisal District','2','Traditional','Northridge Park Sec 02 Amd','4609','2.5554','Public Sewer,Public Water,Water District','2002','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','215639569','1675217619','215639569','2023-01-22T15:10:23.217','78933192','Dana Bellanger','2011 AMERICAN REAL ESTATE CO.','','','29.911704','-93.939443','29','77642','6','139000.00','Active','Forest','3148','Avenue','Port Arthur','1','0','3','1455','Single-Family','Completely Remodeled 3/1 Cottage Near Shopping & Restaurants!! Bonus room could be used as a third bedroom! The exterior of this beautifully tree-lined road leads you to a freshly remodeled stucco & brick fronted home with a gorgeous tiled, covered front porch. This spacious home is adorned with luxury upgrades including quartz countertops, all new wood-look laminate flooring, 3-year-old roof and double pane windows, decorative trey ceiling and arched doorways in living room. Beautifully tiled shower with customized shower massage unit, and new lighting fixtures and cabinets throughout. This home has never flooded and looks much larger and grander inside, you must see inside to appreciate everything it has to offer. Give us a call to book your viewing.','0.197','51','','','Washer Connections','','Other Disclosures','1','','','','Central Gas','0','LT 35 BLK 1 PARK PLACE','Cleared,Subdivision Lot','8580','Appraisal District','','','0','','0','','0','','','Freestanding Range','','Composition','236 - Port Arthur','HOUSTON ELEMENTARY SCHOOL (PORT ARTHUR)','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','LINCOLN MIDDLE SCHOOL (PORT ARTHUR)','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Park Place To Port Arthur','2437','3.176','Public Sewer,Public Water','1962','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','215678038','1675217619','215678038','2023-01-22T16:39:19.887','47638000','Brian Rohe','Rohe Realty','','','30.393169','-95.612294','27','77356','3','284500.00','Active','Glenforest','3242','Road','Montgomery','2','0','3','1706','Single-Family','Attractive! Quiet cul de sac large lot with curb appeal. NEW LED lighting, NEW shower glass,, NEW carpet, fresh paint throughout, upgraded fireplace with TV INCLUDED, stainless appliances and fridge INCLUDED. Spacious kitchen opens nicely to living room. Jacuzzi style tub w separate shower in master. Massive walk in closet for master. Laundry room in house. Washer and Dryer INCLUDED. Covered back porch with extended back patio for outdoor kitchen. Lots of cabinets in garage. This community has loads of amenities!','0.1921','39','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Conroe Area','Central Electric','1','S945508 - WALDEN 08, BLOCK 23, LOT 25','Cul-De-Sac','8370','Appraisal District','','1050','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Walden 08','4872','2.2242','Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215769261','1675217619','215769261','2023-01-22T15:06:54.900','35287796','Kimberly Augustine','eXp Realty, LLC','Tiffany Curry','BHHS Tiffany Curry & Co., REALTORS','30.070607','-95.421504','48','77373','8','499999.00','Option Pending','Lazy Springs','818','Lane','Spring','3','1','5','3250','Single-Family','This sophisticated, character-filled home is STUNNING! It is absolutely gorgeous and is truly an amazing gem. From entrance to exit you wont be disappointed. I wont even mention the upgrades, the owner has truly made this home a suburban getaway, lovely and serene-the perfect spot to nurture your soul. Schedule your personal tour today you wont want to leave. This home lacks nothing. This is truly the gift that keeps giving.','0.1945','12','Perry','','Electric Dryer Connections,Gas Dryer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections','1','Spring East','Central Electric,Central Gas','1','LT 11 BLK 1 SPRING LAKES SEC 8','Cul-De-Sac','8474','Appraisal District','','850','0','','0','Convection Oven,Double Oven','1','Fiberglass,In Ground,Salt Water','','Gas Range','','Composition','48 - Spring','SALYERS ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Supra Keybox','Appraisal District','2','Contemporary/Modern','Spring Lakes Sec 08','7964','2.9067','Water District','2007','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','215919799','1675217619','215919799','2023-01-22T15:17:31.940','39183286','Nicole Chandler','Lee DeForke Jr.','','','29.437902','-95.262547','35','77511','10','385000.00','Active','Shane Trail','1744','Drive','Alvin','3','1','5','2711','Single-Family','Charming, like new home ready for its new owners. This home features a spacious open floor plan for ease of entertaining and family time, the kitchen is sure to please the chef in your life complete with stainless steel appliances. Work from home? You\'re covered, the spacious office is waiting for your personal touches. Upstairs holds an oversized game room with the four additional bedrooms and two full baths. Did we mention the abundance of storage space in this home, not only are the closets spacious but there is a tremendous amount of walk-in attic space, that\'s right no climbing that little hide-away staircase with your holiday decor! As a bonus the primary suite is located on the first floor overlooking the backyard and community pond. This home has it all, call today for your private showing, it won\'t last long!','0.1364','5','','','','','Sellers Disclosure','1','','','Alvin South','Central Gas','1','SUNSET RANCH SEC 1 (A0420 HOOPER & WADE) (ALVIN) BLK 3 LOT 2','Subdivision Lot,Water View','5942','Appraisal District','','625','0','','2','','0','','','','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required','Appraisal District','2','Traditional','Sunset Ranch Sec 1','8888','2.743','Public Sewer,Public Water','2020','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','216112115','1675217619','216112115','2023-01-22T16:17:42.860','47403845','Suzanne Chapman','Hamilton Real Estate','','','29.474119','-94.583117','36','77650','10','1395000.00','Active','Gulf Castle','3228','Drive','Crystal Beach','3','3','4','2628','Single-Family','BEACHFRONT BEAUTY on Bolivar near Galveston. 4/3.3 with HUGE GRAND Room with Spectacular Views. Clay Based established dunes. COVERED And SUN Decks. Covered Elevator Access from the Screened in porch. Elegant GRAND ROOM: for kitchen, dining, and living area. GOURMET KITCHEN: Wolf appliances, double ovens w/ warming drawer, wine cooler, 6 burner gas cooktop wall mounted pot filler, custom cabinets and lighting, huge island w/ storage, seating, & built in microwave, water filtration system, beverage bar, wine chiller. All bedrooms are ensuite. Main Master glorious views and sinks walk-in shower. QUARTZITE COUNTES. 2ND MASTER: walk-in shower, large enough for a king. Office/bedroom. HVAC zoned, dehumidifier, & ion systems. OVERSIZED Garage for Boat and beach toys. TIKI BAR with beach view. Mosquito Repel system+++MORE. Between Lagoon and Beach for quiet street. Appointment only for showings and previews.','0.8155','33','Brett West','','Electric Dryer Connections,Washer Connections','','Home Protection Plan','1','Freestanding,Wood Burning Fireplace','1','Crystal Beach','Central Electric,Zoned','0','ABST 65 LOT 5 BLK 1 SAND CASTLE BEACH','Cul-De-Sac,Other,Water View,Waterfront','35524','Appraisal District','','','0','','1','Convection Oven,Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Controlled Access,Lockbox Back','Appraisal District','1','Other Style,Traditional','Sand Castle Beach 1','14387','1.6113','Public Water','2014','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','216215566','1675217619','216215566','2023-01-22T15:39:50.067','96124101','Adriane Taylor','Walzel Properties','Lacy DeSouza','Coldwell Banker Realty','30.185462','-95.757531','42','77355','9','375000.00','Option Pending','Rickett','30215','Lane','Magnolia','3','0','4','2315','Single-Family','Beautifully maintained home in a quiet community, nestled on a HUGE .89 acre lot! Step inside this cute home and discover soft contemporary tones, tiled flooring throughout the main living areas, an open concept layout, and plenty of space for hosting & entertaining. This home offers 4 spacious bedrooms with 2 primary suites, 3 full bathrooms, and a bonus room through the garage that would be ideal as a home office or game room! Prepare meals in the well appointed kitchen that features a tall breakfast bar, tons of cabinet space, stainless steel appliances, and a cozy breakfast nook, with an open view to the generously sized living room where you can curl up around a wood burning fireplace. Outside, you can enjoy large front & back yards, covered patio in the back, covered front porch, and added privacy with NO BACKYARD NEIGHBORS! Additional perks you will love include NO HOA and LOW TAXES. Recently replaced carpet & new windows last spring.','0.8945','15','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Wood Burning Fireplace','1','Magnolia/1488 West','Central Electric,Zoned','0','S868501 - SHADY BROOK ACRES PARTN, LOT 8D-1, 9-C, ACRES 0.89','Subdivision Lot','38964','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Range','','Composition','36 - Magnolia','NICHOLS SAWMILL ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Shady Brook Acres Partn','6591','1.8587','Public Water,Septic Tank','1997','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216306394','1675217619','216306394','2023-01-22T15:46:27.310','23230079','Michelle Doss','Mega Realty','','','29.433733','-95.440949','29','77583','4','379200.00','Active','Matterhorn','10306','Drive','Rosharon','2','1','4','2513','Single-Family','Welcome home! This 2019 build in the Sierra Vista master-planned community is sure to take your breath away! \r\nThis well maintained home features 4 bedrooms, a study, 2 spacious living areas, and high ceilings that will have you SOLD! Open concept, split level floor plan, with luxurious features throughout. Home also has a security system, keypad lock on the front door, Wifi ethernet connections for a plug and play connection, granite countertops, and more! Don\'t let this gem pass you by, schedule your showing today!','0.1537','5','','','','','Sellers Disclosure','1','','','Alvin North','Central Electric','1','SIERRA VISTA SEC 2 (A0288 HT&BRR) BLK 4 LOT 17','Cleared,Subdivision Lot','6695','Appraisal District','','900','0','','2','','0','','','','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Sierra Vista West Sec 1','10547','3.4896','Public Sewer,Public Water','2019','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','216312928','1675217619','216312928','2023-01-22T16:58:36.110','49918718','Rebekah Sanders','RE/MAX One','','','30.150978','-94.023911','32','77662','7','365000.00','Active','Kells','3','Circle','Vidor','3','0','5','2471','Single-Family','','0.329','50','','','Electric Dryer Connections','','Sellers Disclosure','1','','','','Central Electric','0','LOT 8 BLK 2 WEXFORD PARK','Cul-De-Sac','14331','Appraisal District','','','0','','2','Freestanding Oven','1','Gunite','','Electric Cooktop','','Composition','1005 - Vidor','VIDOR ELEMENTARY SCHOOL','VIDOR HIGH SCHOOL','VIDOR JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch','Wexford Park','2818','2.1207','Public Sewer,Public Water','1966','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','216593133','1675217619','216593133','2023-01-22T15:24:42.330','21977543','Paul Hicks','Hicks and Associates','Julie Wiley','Hometown America Incorporated','29.618917','-95.722119','28','77406','7','389900.00','Pending Continue to Show','Bittersweet','1319','Drive','Richmond','2','1','4','2580','Single-Family','Stunning one story home with private pool oasis. Private lot backs up to acreage. Updates include kitchen remodel with new granite countertops, tile backsplash, paint, etc. Primary bath recently renovated with massive walk in shower. Recent window replacement on whole home with double paned gas units. Fresh luxury vinyl plank flooring. Whole house Generac generator in 2021. HVAC replaced in 2019 interior and exterior units with all new ductwork. Exterior painted in 2019. Irrigation system 2022. Landscape lighting installed 2022. Super-efficient energy upgrades throughout. Privacy fencing replaced 2018. Pool replastered in 2019. Water heater replace in 2021. See attachments for full details on all upgrades.','0.2329','37','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','PECAN GROVE PLANTATION SEC 4, BLOCK 20, LOT 22','Subdivision Lot','10147','Appraisal District','','209','0','','2','Double Oven,Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','33 - Lamar Consolidated','AUSTIN ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Pecan Grove Plantation','6874','2.3298','Public Sewer,Public Water,Water District','1983','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','216642500','1675217619','216642500','2023-01-22T15:12:22.957','23837398','Michelle Cannon','RE/MAX Distinction','','','29.421443','-94.689194','37','77650','8','586800.00','Active','Atkinson','345','','Crystal Beach','2','0','3','1304','Single-Family','Amazing 2 story beach house on the 2nd row with incredible views from every room in the house! Spectacular decks on both floors with lots of room for eating or just sitting out to enjoy. Both of the second floor bedrooms have access to the upper deck. The kitchen is open to the family room and dining room, perfect for entertaining. Large fenced backyard to enjoy playing games or safe for letting the kids and pets out to play. Oversized garage and outdoor shower. This home sleeps up to 10 and comes fully furnished.','0.3106','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Crystal Beach','Central Electric','0','ABST 203 A VAN NORDSTRAND SUR LOT 25 CRENSHAW BEACH & ADJ N','Water View','13530','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Crenshaw Beach','6612','1.6113','Septic Tank','1995','Appraisal District'); --> New record created successfully