Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T12:04:31.903' ,`MLSNumber` = '87012541' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.723526' ,`Longitude` = '-95.550777' ,`PhotoCount` = '22' ,`PostalCode` = '77320' ,`RoomCount` = '10' ,`ListPrice` = '268900.00' ,`Status` = 'Active' ,`StreetName` = 'Rudder Way' ,`StreetNumber` = '108' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upon entering this exceptional floor plan, you\'re immediately greeted with a high ceiling foyer. Walking into the open-concept kitchen and living room, you\'ll be stunned by the amount of space you have to gather. This three bedroom, two bath home has placed windows in the living room, primary bedroom, and dining room, crafting a home that is filled with natural light and charm. Granite countertops throughout and a large walk-in primary closet to top it all off and make this home exceptional. Additional options included: Stainless steel appliances, additional LED recessed lighting, integral blinds in rear door, dual primary bathroom vanity, single basin kitchen sink, study option, and an upgraded primary bathroom shower.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING RIDGE SEC-4, BLOCK 1, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090613' WHERE `Matrix_Unique_ID` = '208978219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T12:17:56.590' ,`MLSNumber` = '69043159' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.723526' ,`Longitude` = '-95.550777' ,`PhotoCount` = '18' ,`PostalCode` = '77320' ,`RoomCount` = '9' ,`ListPrice` = '263900.00' ,`Status` = 'Active' ,`StreetName` = 'Rudder' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Way' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The 1514 offers luxury living with three bedrooms and two baths. This beautiful home features large secondary bedrooms with walk-in closets. Open living, dining, and kitchen provides abundant space without all the cost. The primary bedroom suite is fit for a king sized bed and features a large walk-in closet. Additional options included: Stainless steel appliances, additional LED recessed lighting, dual primary bathroom vanity, upgraded primary bathroom shower, and painted cabinets throughout.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING RIDGE SEC-4, BLOCK 2, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090613' WHERE `Matrix_Unique_ID` = '211100257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T12:31:17.130' ,`MLSNumber` = '35013218' ,`ListAgentFullName` = 'Juliana Gonzalez' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = 'Yadira Cruz' ,`SellingOfficeName` = 'CR Elite Realty' ,`Latitude` = '30.045567' ,`Longitude` = '-95.341614' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '228000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Millgate' ,`StreetNumber` = '22851' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 1-story home on corner lot located in the established neighborhood of Postwood. This home features a large living room, formal dining, kitchen, fireplace and tile throughout entire home. Spacious backyard with above ground pool and covered patio perfect for entertaining. Garage has been converted into two additional bonus rooms. Roof only one year old. Quick access to shopping, dining, IAH, Mercer Arboretum, I45, Hardy Toll Rd, & Cypresswood Golf Course. This is a great home, come take a look!' ,`Acres` = '0.1567' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 6 POST WOOD SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Wood' ,`TaxAmount` = '5535' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090613' WHERE `Matrix_Unique_ID` = '213114212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T12:56:48.223' ,`MLSNumber` = '42400337' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.503909' ,`Longitude` = '-95.445855' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '279339.00' ,`Status` = 'Active' ,`StreetName` = 'James Michael' ,`StreetNumber` = '5438' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Charleston Heights in Rosharon, TX! Conveniently located off Highway 6 near 288, Charleston Heights makes commuting a breeze! The Drew floor plan is a charming 1-story home with 3 bedrooms, 2.5 bathrooms, STUDY, and a 2-car garage! This home has it all, including blinds and vinyl plank flooring throughout the common areas! The gourmet kitchen is sure to please with an island overlooking the dining and family rooms, 42” cabinets, and granite countertops! Retreat to the Owner’s Suite featuring double sinks, sizable shower, spacious walk-in closet, and tray ceiling for some dramatic flair! Enjoy the great outdoors with a CORNER LOT and covered patio! Don’t miss your opportunity to call Charleston Heights home, schedule a visit today!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 40 Block 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Charleston Heights' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090613' WHERE `Matrix_Unique_ID` = '213241753' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T11:47:48.213' ,`MLSNumber` = '37068759' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.723526' ,`Longitude` = '-95.550777' ,`PhotoCount` = '21' ,`PostalCode` = '77320' ,`RoomCount` = '10' ,`ListPrice` = '286900.00' ,`Status` = 'Active' ,`StreetName` = 'Rudder' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Way' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upon entering this exceptional floor plan, you\'re immediately greeted with a high ceiling foyer. Walking into the open-concept kitchen and living room, you\'ll be stunned by the amount of space you have to gather. This three bedroom, two bath home has placed windows in the living room, and primary bedroom, crafting a home that is filled with natural light and charm. Granite countertops throughout and a large walk-in primary closet to top it all off and make this home exceptional. Additional options included: Stainless steel appliances, additional LED recessed lighting, dual primary bathroom vanity, and an upgraded primary bathroom vanity.' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING RIDGE SEC-4, BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090614' WHERE `Matrix_Unique_ID` = '213507800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T11:32:51.600' ,`MLSNumber` = '421558' ,`ListAgentFullName` = 'Cathryn Howard' ,`ListOfficeName` = 'Howard Home RealtyLee Brooks & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.650061' ,`Longitude` = '-95.538915' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '9' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Greentree' ,`StreetNumber` = '2196' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This waterview floor plan has been very popular and the builder has made many variations to suit the buyers. Extra large kitchen and larger primary bath and bedroom with huge covered back patio. SEE THE SAMPLE OF THE ELABORATE RETAINING WALLS.\r\n The Primary suite has large duel closets. Primary shower is a spacious walk in and has a separate jacuzzi tub. This kitchen has many custom cabinets and an island. You will be impressed with the elegant entry with beams separating the open living and formal dining areas.\r\nGreat golf course community with all the amenities and facilities. Unlimited golfing, country club with a restaurant, bar, activity center, pro shop...activities galore, mail center. Swimming pools, playground, boat launch, tennis courts. A secure place to bring up a family or retire. Close to great shopping, hospitals, churches, restaurants and Sam Houston University. Also, minutes from 1-45 for easy access to Houston.' ,`Acres` = '0.2675' ,`Area` = '43' ,`BuilderName` = 'AG HOME BUILDERS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 3A, BLOCK 32, LOT 1' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,Subdivision Lot,Water View,Wooded' ,`LotSize` = '11653' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake - Sec 3A' ,`TaxAmount` = '544' ,`TaxRate` = '1.87545' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090614' WHERE `Matrix_Unique_ID` = '213790596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T12:38:03.683' ,`MLSNumber` = '62162313' ,`ListAgentFullName` = 'Denise Hernandez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692439' ,`Longitude` = '-95.661092' ,`PhotoCount` = '27' ,`PostalCode` = '77083' ,`RoomCount` = '7' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Rio Del Sol' ,`StreetNumber` = '15627' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 15627 Rio Del Sol Dr! This beautiful home, is an Investors dream! Offering 1,510 sqft of living space, 3 beautifully appointed bedrooms, 2 bathrooms, and a bright and inviting living space! Boasting incredible attention to detail throughout including tile floors, and wood cabinetry. Sitting on a beautiful 7,179 sqft lot with a well-maintained lawn and beautiful brick elevation this home offers a fantastic curbside appeal and also features a large backyard with a POOL! Easy access to Addicks Clodine Rd + close to West park toll and HWY6. Close to schools, grocery stores, parks, restaurants, shopping centers and more. Must see! Schedule your private showing of this wonderful home today! (Tenant occupied until April 2023)' ,`Acres` = '0.1648' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION BEND SEC 8, BLOCK 33, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7179' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend 8' ,`TaxAmount` = '3279' ,`TaxRate` = '2.0847' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090614' WHERE `Matrix_Unique_ID` = '214127563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T11:28:45.330' ,`MLSNumber` = '29330988' ,`ListAgentFullName` = 'Lindsay Howard' ,`ListOfficeName` = 'Howard Home RealtyLee Brooks & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.940251' ,`Longitude` = '-95.341500' ,`PhotoCount` = '45' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Dawns Edge' ,`StreetNumber` = '227' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This floor plan on a double lot has been very popular, and the builder has made many variations to suit the buyers. Extra-large kitchen and larger primary bath and bedroom with huge covered back patio. The Primary suite has 2 large closets. Primary shower is a spacious walk in and has a separate jacuzzi tub. This kitchen has many custom cabinets and an island. You will be impressed with the elegant entry with beams separating the open living and formal dining areas. YOU WILL BE IMPRESSED WITH THIS BUILDER. Other areas that we are building in: Four Corners in Livingston, Westwood Shores in Trinity, Elkins Lake in Huntsville and Lake Conroe Forest in Conroe/Montgomery.' ,`Acres` = '' ,`Area` = '42' ,`BuilderName` = 'AG Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 08, BLOCK 3 LOT 52' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores Sec 8' ,`TaxAmount` = '46' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675090614' WHERE `Matrix_Unique_ID` = '214379948' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T12:09:02.090' ,`MLSNumber` = '44191297' ,`ListAgentFullName` = 'Tarandeep Singh' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766038' ,`Longitude` = '-95.636405' ,`PhotoCount` = '49' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Langbourne' ,`StreetNumber` = '14211' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning 3 bedroom, 2 bath plus sunroom Houston home is ready for you to call your own! You will appreciate the welcoming and open floor plan. Perfect for hosting guests! Inviting living room with a soaring vaulted ceiling, brick fireplace, and large windows that allow lots of natural light to fill the space. The eat-in kitchen features built-in stainless steel appliances, a breakfast bar, an island with a cooktop, a pantry, and a bright breakfast nook. Ideal formal dining room. The serene primary offers a spa-like ensuite bath with dual sinks, an updated shower, and a walk-in closet. The third bedroom with built-in shelves makes a great home office! {icture yourself enjoying the spacious sunroom all year! The private backyard provides a great spot for a vegetable garden and additional outdoor entertaining space. Exterior updates include ring cameras, double-paned windows, and gutter guards. Here is your opportunity to make this your new home! 3D tour available online' ,`Acres` = '0.1116' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 15 BRIAR HILLS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '916' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarhills' ,`TaxAmount` = '7073' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090615' WHERE `Matrix_Unique_ID` = '214419905' --> 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','214663383','1675090615','214663383','2022-12-13T12:51:53.330','48862760','Robbie Nelson','RE/MAX Crossroads Realty','','','29.395872','-94.912651','10','77590','6','95000.00','Active','12th 1/2','1107','Street','Texas City','1','0','2','866','Single-Family','Being sold as is no repairs. Buyers and buyers agent to verify all measurements and information.','0.143','33','','','','','Sellers Disclosure','','','','Texas City','Central Electric','0','ABST 205 PAGE 2 LOT 243 SNUG HARBOR','Subdivision Lot','6227','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','KOHFELDT ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Snug Harbor','2265','2.5335','Public Sewer,Public Water','1944','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','214793990','1675090615','214793990','2022-12-13T12:27:53.850','54796336','Leomares Vasquez','REALM Real Estate Professional','','','29.847032','-95.651950','15','77084','3','268400.00','Active','Tain Dr','4830','','Houston','2','0','3','1758','Single-Family','Open floor plan. Everything has been remodel. Foundation was repaired. New floor and carpet.','','8','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Bear Creek South','Central Gas','1','LT 8 BLK 27 GLENCAIRN SEC. 3','Subdivision Lot','7150','Appraisal District','','350','0','','1','Convection Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','LIEDER ELEMENTARY SCHOOL','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Glencairn','','','Public Sewer,Public Water','1978','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','215009854','1675090615','215009854','2022-12-13T11:39:55.500','53188548','Michael Demian','Compass RE Texas, LLC Heights','','','29.695478','-95.486412','28','77081','7','599000.00','Active','Pine Ridge Terrace','7623','Road','Houston','4','1','3','3668','Single-Family','Home is full of the latest upgrades. Hardwood and travertine floors, granite counters, huge island in the kitchen, GE Monogram stainless steel appliances. Large master bedroom with huge walk in closets, two other large bedrooms, gameroom, small study, wine cellar, wrought iron stair rails. Terrific home for entertaining,includes small covered patiofor intimate dinners at home!','0.0671','17','Zieben Custom Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','Meyerland Area','Central Gas','1','LT 6 BLK 3 PINE RIDGE TERRACE AMEND','Patio Lot,Subdivision Lot','2925','Appraisal District','','200','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','27 - Houston','BRAEBURN ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','LONG MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','3','Mediterranean,Traditional','Pine Ridge Terrace Amd','','','Public Sewer,Public Water','2006','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','215101519','1675090615','215101519','2022-12-13T11:52:43.637','35043836','Adoracion Agustin','HomeSmart','','','29.668613','-95.638530','22','77498','6','238000.00','Active','Limewood','10122','Lane','Sugar Land','2','0','3','1376','Single-Family','Great 3/2 starter home in a quiet and established neighborhood with easy access to Highway 6, shopping, restaurants, highly rated Fort Bend schools, etc. Stainless refrigerator, microwave, toaster oven, washer/dryer all included in the sale. Livable but needs some upgrades. Easy to clean ceramic tile wood like flooring. High ceiling in living room with fan, and fireplace, open floor plan, wet bar, master\'s bedroom with ceiling fan and sliding glass door to back yard. Two secondary bedrooms on the opposite side of the master\'s with upgraded vanity in the common bathroom. 2-car garage with remote controlled door opener. Bricks all around. Covered patio. Good size backyard for barbecue and a safe place for kids to play. Community has a clubhouse, pool, tennis and basketball court.','0.1567','29','','','Electric Dryer Connections','','Mud,Sellers Disclosure','0','Wood Burning Fireplace','1','Sugar Land North','Central Electric','1','TOWNEWEST SEC 4, BLOCK 6, LOT 16','Subdivision Lot','6825','Appraisal District','','340','0','','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','19 - Fort Bend','TOWNEWEST ELEMENTARY SCHOOL','KEMPNER HIGH SCHOOL','SUGAR LAND MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Townewest Sec 4','4187','2.3329','Water District','1981','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','215370232','1675090615','215370232','2022-12-13T12:41:17.743','35388866','Laura Garcia','Porchlight Realtors, LLC','','','29.636322','-95.520426','18','77071','4','356999.00','Active','Oceanview','11706','Street','Houston','2','0','3','2040','Single-Family','Beautiful new construction and spacious house right here in missouri city area!! Just minutes away from Highway 90 and Beltway 8!! Close to Medical Center!!','0.163','20','RG CASAS LLC','','','','No Disclosures','1','','','Missouri City Area','Central Electric','1','LT 56 BLK 19 FONDREN PARK SEC 4','Subdivision Lot','7100','Appraisal District','','329','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','27 - Houston','GROSS ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Builder','1','Other Style','Fondren Park Sec 04','962','2.7379','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215413934','1675090615','215413934','2022-12-13T12:20:40.060','39131989','Kevin Baker','eXp Realty, LLC','','','29.292987','-94.808552','40','77550','4','325000.00','Active','Avenue M','3802','','Galveston','2','0','4','1740','Single-Family','Tranquil getaway in the heart of Galveston! Fantastic Large Galveston Island home in ideal location, 4/5 Bedroom 2 Bath Home- Flex Room Upstairs Could be Game Room, Media room, Office or 5th bedroom. Updated Kitchen & Bathroom Cabinets, Granite Countertops & Vessel Sinks in Both Baths. new kitchen Appliances. Kitchen, Dining, Utility & Bathrooms w/ Water-Proof Wood Style Vinyl Flooring. Original Hardwood Floor in Living room. Carpet in 4 Bedrooms & Upstairs Flex Room. Entire home with new paint. A fully fenced yard where the dogs can run free and you can enjoy grilling. Large utility room fits full size washer and dryer. Sit on the deck and enjoy a morning coffee or take a walk to the water\'s edge and get in the morning jog on the beach. adjacent to Galveston Historic District with plenty of restored homes and mansions and gives a feeling of being close to history and yet minutes from everything modern and fun: Moody Gardens, Galveston Pleasure Pier, Downtown area, Strand.','0.0872','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','East End','Other Heating,Zoned','0','ABST 628 M B MENARD SUR PT OF LOTS 8 & 9 (8-2) BLK 38 GALVES','Corner,Subdivision Lot','3800','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Controlled Access,Request Online Appointment','Appraisal District','2','Traditional','Galveston Townsite','','','Public Sewer,Public Water','1957','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','215538053','1675090615','215538053','2022-12-13T11:04:48.860','35830774','Daniel Bradshaw-Hull','Texastar Properties','','','29.418336','-95.076172','20','77539','7','1440000.00','Active','Santo Park','5221','Road','Dickinson','2','0','2','1666','Single-Family','This property has it all, a brand new completely remodeled modern farmhouse, 2 workshops, an outdoor pavilion, a standalone cover, a barn, and stocked pond! With sidewalks throughout the property, you get to enjoy all these amenities without walking through wet grass or mud. Truely a site to see, this 25 acre property has all the luxuries of country living while just a short drive from downtown Houston. \r\n\r\nThe house has been completely renovated from the ground up sparing no expense. Featuring LVP flooring, overside windows, brand new HVAC, quartz countertops, and the list goes on and on. Additionally, there is a stretch room which can be used for as a study or a 3rd bedroom. Did I mention that the entire house is handicap accessible! With the ability to have your very own ranch with farm animals and recreation this one-of-a-kind property won\'t last long.','23.923','33','','','','','Sellers Disclosure','1','Mock Fireplace','1','Texas City','Central Electric','0','ABST 11 A FARMER SUR LOT 15 (1-15-0) INTERURBAN GARDENS','Cleared,Wooded','1042086','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Range','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Interurban Gardens','6993','2.4966','Aerobic','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','215545958','1675090615','215545958','2022-12-13T12:07:01.317','44873989','Fabiola Oropeza','Vibrant Realty LLC','','','29.538784','-95.035201','35','77565','3','209000.00','Active','Esther','1217','Street','Kemah','1','1','3','1846','Single-Family','Beautifully remodeled 3 bed 1.5 bath home located in Laguna Vista Estates. New flooring, New paint throughout, updated bright white kitchen, and bathroom. Stainless steel appliances. Schedule your today!','0.1756','33','','','','','No Disclosures','1','','','League City','Central Gas','0','ABST 18 M MULDOON SUR PT OF LOTS 12,13 & 14 (13-0) LAGUNA VI','Cleared','7650','Appraisal District','','','0','','0','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Ranch','Laguna Vista Estates','3377','1.7054','Water District','1965','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','215567327','1675090615','215567327','2022-12-13T12:43:28.653','92296952','Hai Huynh','Keller Williams Signature','','','29.924206','-95.618378','41','77065','4','375000.00','Active','Belmont','10619','Court','Houston','2','1','4','2933','Single-Family','Beautiful updated 2-story home with 4 bedrooms, 2.5 bathrooms. Tile flooring throughout the first story. The owners are very caring and thorough for the house. The backyard is very decent and extremely cool where you can relax with the family. All of the bathrooms are remodeled. This home is located near Highway 6 and Fwy 290 with easy commute to Downtown, Medical Center. Great location 5 minutes away from Walmart, Hospitals, Kohl’s, Hobby Lobby, Home Depot, HEB, Kroger. Only 25-28 min to George Bush Intercontinental Airport. Refrigerator is not included. If you want to buy any furniture please submit your request with the offer. Please schedule your showing today!','0.149','10','','','','','Sellers Disclosure','1','','1','1960/Cypress','Central Gas','1','LT 25 BLK 2 WORTHAM GROVE SEC 1','Subdivision Lot','6481','Appraisal District','','600','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','ADAM ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Wortham Grove Sec 1','5664','2.341','Public Sewer,Public Water,Water District','1998','Appraisal District'); --> New record created successfully