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-15T09:55:30.867' ,`MLSNumber` = '64817515' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.483781' ,`Longitude` = '-94.107858' ,`PhotoCount` = '17' ,`PostalCode` = '75692' ,`RoomCount` = '3' ,`ListPrice` = '84999.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 80' ,`StreetNumber` = '17317' ,`StreetSuffix` = '' ,`City` = 'Waskom' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take a look at this cute property! The home sits on a little over half an acre and is minutes from the I-20 freeway. The property is close to the TX-Louisiana border. Will soon feature a new roof! Call to see it today!' ,`Acres` = '0.597' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.597, LOT: 23, SUBD: PINEWOOD ACRES, HSE' ,`LotDesciption` = 'Other' ,`LotSize` = '26005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '231 - Waskom' ,`SchoolElementary` = 'WASKOM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASKOM HIGH SCHOOL' ,`SchoolMiddle` = 'WASKOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinewood Acres' ,`TaxAmount` = '1119' ,`TaxRate` = '1.8048' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091334' WHERE `Matrix_Unique_ID` = '192040142' --> 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','210724721','1675091334','210724721','2022-12-15T09:21:45.757','45921954','Libby Mitchell','REGENCY REAL ESTATE PROF','','','29.999911','-93.814653','6','77611','7','296005.00','Active','Zachary','205','Lane','Bridge City','2','0','4','2204','Single-Family','DSLD Homes \"Camellia\" plan offers a 4 bedroom and 2 full bathroom open floor plan. Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!','','50','DSLD Homes, LLC','','','','No Disclosures','1','','','','Central Gas','1','Lot 9','Cleared','','','','53','1','To Be Built/Under Construction','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','367 - Bridge City','BRIDGE CITY ELEMENTARY SCHOOL','BRIDGE CITY HIGH SCHOOL','BRIDGE CITY MIDDLE SCHOOL','Vacant/Unoccupied','Builder','1','Traditional','Marsh Estates','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T10:24:07.257' ,`MLSNumber` = '77603162' ,`ListAgentFullName` = 'Yolanda Whitlock' ,`ListOfficeName` = 'SOS Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583803' ,`Longitude` = '-95.251646' ,`PhotoCount` = '46' ,`PostalCode` = '77089' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Haybrook' ,`StreetNumber` = '8111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2766' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only home in Clear Brook Meadows for sale. You will fall in love with this one it exudes elegance from the moment you walk in the door. Rich hardwood floors throughout, high ceilings and plenty of windows for natural light. Sit, relax and enjoy your gas log fireplace in the living room while visiting others that are in the open light and bright island kitchen. Plenty of seating with abundance of cabinets for all your kitchen/dining essentials. The primary room is on the other side of the home with a great view of the extended large covered patio. Walk across the catwalk to the game room overlooking the family room that is large enough for a pool table and seating area. You won’t believe how nice and big the covered backyard patio is until you see if yourself. So many beautiful memories to be made in this area. Located near Pearland Parkway and Beltway 8. Looking to for shopping or dining out? So many options just a hop-skip and away!' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 4 CLEAR BROOK MEADOWS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Brook Meadows Sec 04' ,`TaxAmount` = '7833' ,`TaxRate` = '2.7255' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091334' WHERE `Matrix_Unique_ID` = '212881914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T09:32:41.797' ,`MLSNumber` = '54608925' ,`ListAgentFullName` = 'Emily Arce' ,`ListOfficeName` = 'One Property Grp' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.190643' ,`Longitude` = '-95.337231' ,`PhotoCount` = '27' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Village Woods' ,`StreetNumber` = '15590' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION & OPPORTUNITY!! This area is rapidly growing and this is your chance to get in on the action. Corner lot on FM 1314 with approximately 120 feet of frontage! Developments all around this area. Lot can be used as commercial or residential. Sits on almost 1/2 an acre, with utilities, a 3 bedroom manufactured home, 2 sheds, complete with several mature trees. Don\'t miss out on this opportunity.\r\nBoundary lines shown in aerial photos are approximate. Will need to be independently verified.' ,`Acres` = '0.4675' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'VILLAGE WOODS, LOT 5, SERIAL # TXFL1AB15033698, 0921, LABEL' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '21153' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Woods' ,`TaxAmount` = '235' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091334' WHERE `Matrix_Unique_ID` = '213149506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T10:40:54.113' ,`MLSNumber` = '83226423' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Gayla Gayden' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.738640' ,`Longitude` = '-96.168241' ,`PhotoCount` = '22' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '256990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Waterside' ,`StreetNumber` = '1261' ,`StreetSuffix` = 'Trace' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! The Easton by D.R. Horton in the New D. R. Horton Community called Westward Pointe in Sealy! Grand entry with gorgeous High Ceilings, Beautiful Wood Vinyl Floors throughout! Open Concept for entertainment! Casual Dining Room & Amazing Family Room with Wall of Windows overlooking your Covered Patio! Family Rm flows gracefully into the Casual Dining & Gourmet Kitchen W/Upgraded Granite Countertops, Large Eat-in Island W/Deep Under-mount Stainless Sink, Pull-Out Swan Kitchen Faucet, Stainless Steel Appliances, Tall Beautiful Shaker Cabinets & Walk In Spacious Pantry! The Owner\'s Suite features Plush Carpeting & Luxurious Bath w/Dual Deep Undermount Sinks, DuPure Drinking Water Filter System, Tall Shaker Cabinets with Granite Counters, Oversized Shower & Walk-in Closet! 3 Private Guest Bedrms, Granite on Full Bathrooms Vanity! \"Smart Home Automation allows you to control lighting, deadbolt locks, thermostat & Control from anywhere! NO FLOODING! Wonderful Amenities!' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Westward Pointe Lot: 4 / Block: 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'WESTWARD POINTE' ,`TaxAmount` = '' ,`TaxRate` = '3.079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091334' WHERE `Matrix_Unique_ID` = '213876921' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T10:41:25.080' ,`MLSNumber` = '4477244' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Gayla Gayden' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.738533' ,`Longitude` = '-96.167771' ,`PhotoCount` = '37' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '269990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Waterside' ,`StreetNumber` = '1257' ,`StreetSuffix` = 'Trace' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The New Community Westward Pointe in Sealy! New One Story Ranch Home by D.R. Horton! Under Construction! Beautiful Stone & Brick Elevation! Large Covered Patio! Beautiful Wood Vinyl Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Concept Floor Plan! Dramatic Gourmet Kitchen with stunning Granite Countertops, Large Eat-in Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining Area & Amazing Family Room with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for Two with His & Her Deep Undermount Sinks, Vanity with Granite Countertops, Oversized Shower with Seamless Glass Door & Walk-in Closet! Linen Nook! Blinds Included! HERS Energy Rated! \"Smart Home System, which allows you to control lights, locks, & thermostat! NO FLOODING! Pool, Playgrounds, Lakes & More! Make that call!' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Westward Poine Lot: 6 /Block: 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'WESTWARD POINTE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091335' WHERE `Matrix_Unique_ID` = '213944105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T10:41:05.687' ,`MLSNumber` = '20148667' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Natalie Tye' ,`SellingOfficeName` = 'Monarch Real Estate & Ranch' ,`Latitude` = '29.739369' ,`Longitude` = '-96.169621' ,`PhotoCount` = '21' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '272990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Thornbird' ,`StreetNumber` = '1281' ,`StreetSuffix` = 'Trail' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Under Construction! Brick and Stone Elevation! Covered Patio! Gorgeous Vinyl Floors throughout! Granite Countertops in all the Full Bathrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Granite Countertops, Large Eat-in Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets W/Hardware on Cabinets & Draws , Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Area with Wall of Windows! The Private Owner\'s Suite features High Ceilings, Luxurious Bathroom built for 2 with His & Her Deep Undermount Sinks, Granite Vanity, Oversized Shower W/Seamless Glass Door & Walk-in Closet! Linen Nook! Energy Efficient Home: HERS Energy Rated! Blinds Included! \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! The New Community Westward Pointe in Sealy!' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Westward Poine Lot: 3 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'WESTWARD POINTE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091335' WHERE `Matrix_Unique_ID` = '213944396' --> 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','214177521','1675091335','214177521','2022-12-15T10:51:16.113','78373339','Joseph Ray Diosana','Keller Williams Realty - Memor','','','30.392258','-95.673628','22','77356','13','1282420.00','Active','Mia Lago','122','Drive','Montgomery','4','0','3','','Single-Family','Welcome to the Estates of Mia Lago! A beautiful, gated community just north of Houston featuring large lots, a community lake and walking trail and membership to the Walden Country Club and Northgate Country Club. Build your luxury dream home on this 1.75 acre lakefront lot.','1.751','39','Gryphon Builders','','','','No Disclosures','','','','Lake Conroe Area','Central Gas','1','S456200 - ESTATES OF MIA LAGO 01, BLOCK 2, LOT 5, ACRES 1.75','Subdivision Lot,Water View,Waterfront','76274','Appraisal District','','1400','1','To Be Built/Under Construction','3','','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Controlled Access,Request Online Appointment','','2','Mediterranean','Estates Of Mia Lago 01','3131','2.2242','Aerobic,Public Water','',''); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T09:44:37.063' ,`MLSNumber` = '11477008' ,`ListAgentFullName` = 'Maricela Benton' ,`ListOfficeName` = 'Lea Homes Realty INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.712558' ,`Longitude` = '-95.061840' ,`PhotoCount` = '30' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Village Cove' ,`StreetNumber` = '166' ,`StreetSuffix` = 'Loop' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LEA Homes is offering these 3 bedrooms and 2 bath signature series home that features a modern theme with trend conscious colors and designer floors. The home has 10-foot ceilings throughout home and 11-foot ceilings in family room and master. The kitchen features upgraded quartz countertops, brush nickel faucets, hardware and door levers, also upgraded Samsung appliance package. Dining room has a modern chandelier and living room and master bedroom have trendy ceiling fans. The master bathroom includes an oversize fully tiled walk-in shower with a bench seat and separate garden tub with an added window for natural lighting. The antique porcelain tile floors and designer mirrors in both bathrooms make it a real treat after a long day. An efficient Carrier HVAC system with digital thermostat will keep your electricity bills low. The subdivision has a private boat ramp and swimming pool' ,`Acres` = '0.1964' ,`Area` = '44' ,`BuilderName` = 'LEA HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 12 LOT 64' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '26' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '44' ,`TaxRate` = '2.0361' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091335' WHERE `Matrix_Unique_ID` = '214187195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T09:40:31.967' ,`MLSNumber` = '63760360' ,`ListAgentFullName` = 'Carlos Cardona' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475841' ,`Longitude` = '-94.583190' ,`PhotoCount` = '20' ,`PostalCode` = '77650' ,`RoomCount` = '9' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Pirates Cove' ,`StreetNumber` = '3260 1/2' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful beach home is being sold FULLY FURNISHED. The floor plan is large and open. The fresh air and Gulf breezes will refresh your mind and spirit while you live or utilize it as a vacation home. \r\n\r\n*Property comes with manual Rolling Hurricane Shutter for all the windows. \r\n*As per the seller, property has been an income producing property via Airbnb and Virbo.' ,`Acres` = '0.16' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 39 BLK 3 LAFITTES LANDING' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lafittes Landing' ,`TaxAmount` = '6881' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091335' WHERE `Matrix_Unique_ID` = '214669999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T10:41:15.267' ,`MLSNumber` = '97506720' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Julie Kaiser' ,`SellingOfficeName` = 'Realty ONE Group, Experience' ,`Latitude` = '29.737137' ,`Longitude` = '-96.166573' ,`PhotoCount` = '34' ,`PostalCode` = '77474' ,`RoomCount` = '10' ,`ListPrice` = '264990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Waterside' ,`StreetNumber` = '1249' ,`StreetSuffix` = 'Trace' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! The Caden Plan by D.R.Horton has so much to offer! Grand entry with High Ceilings, Beautiful Wood Like Carefree Vinyl Flooring that leads the way into your Casual Dining Room & Amazing Family Room with Wall of Windows overlooking your Backyard & Huge Covered Patio! Family Room flows gracefully into the Casual Dining & Dramatic Gourmet Kitchen with Upgraded Granite Counters, Huge Eat In Island w/Deep Under-mount Stainless Sink, DuPure Drinking Water Filter System, Stainless Steel Appliances, Tall Beautiful Shaker Cabinets with Crown Molding & Walk In Spacious Pantry! The Owner\'s Suite features Plush Carpeting & Luxurious Bath with His & Her Undermount Sinks, Granite Countertops Vanity, Oversized Shower & Walk-in Closet! 2 Guest Bedrooms & 1 Full Bath with Granite! HER\'S Energy Home! \"Smart Home Automation allows you to control lighting, deadbolt locks, thermostat & Control from anywhere! NO FLOODING! The New Community Westward Pointe in Sealy with Wonderful Amenities!' ,`Acres` = '0.33' ,`Area` = '57' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Westward Pointe Lot: 10 / Block: 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'WESTWARD POINTE' ,`TaxAmount` = '' ,`TaxRate` = '3.079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091336' WHERE `Matrix_Unique_ID` = '214768354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T10:38:27.523' ,`MLSNumber` = '91627154' ,`ListAgentFullName` = 'Chawannia OConner' ,`ListOfficeName` = 'O\'Conner Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530019' ,`Longitude` = '-95.470067' ,`PhotoCount` = '7' ,`PostalCode` = '77545' ,`RoomCount` = '8' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Teal Estates' ,`StreetNumber` = '1103' ,`StreetSuffix` = 'Circle' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely open floor plan home located in the desirable community of Teal Run Estates. The primary bedroom is large with a sitting room which can be used as a workout space, a nursery, a home office or just an extention of bedroom for lounging/relaxing space. This gem is being sold AS IS! This home is as a \"blank canvas\" the potential to make it your own. Roof replaced 2021. Priced to sell; schedule your viewing today.' ,`Acres` = '0.1624' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES OF TEAL RUN SEC 4, BLOCK 4, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Estates Of Teal Run Sec 4' ,`TaxAmount` = '4792' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091336' WHERE `Matrix_Unique_ID` = '214985144' --> 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','215341202','1675091336','215341202','2022-12-15T10:33:24.033','8304774','Brian Newhouse','Dixie Newhouse-Estep, Broker','','','30.407047','-95.456927','9','77378','5','150000.00','Active','Birchwood','138','Drive','Willis','4','0','5','1904','Single-Family','Great investment opportunity! Great Rental! Located close to Willis with restaurants and shopping near by. There are 2 mobile homes connected creating 1904 sqft of living space. 2 Living areas, 2 kitchens.\r\n5 bedrooms and 4 baths on +/- .404 acres.','0.404','19','','','','','Sellers Disclosure,Tenant Occupied','','','','Conroe Northeast','Other Heating','0','S766302 - OAK WOODS 02, BLOCK 1, LOT 26, SERIAL 480B48053769','Other','17600','Appraisal District','','','0','','0','','0','','','','','Other','56 - Willis','A.R. TURNER ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Other Style','Oak Woods','1918','2.4131','Public Water,Septic Tank','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','215493550','1675091336','215493550','2022-12-15T09:24:52.407','60517439','Rashad Ajalov','Walzel Properties','','','29.679214','-95.489670','43','77096','8','380000.00','Active','Cheltenham','5710','Drive','Houston','2','1','3','1842','Single-Family','Beautifully REMODELED 3 bed and 2.5 bath property in a well-established MAPLEWOOD neighborhood. EXTRA large TILE floors with ELEGANT Formal Dining Rm. GOURMET kitchen comes with GRANITE Counters, island, TILE back-splash, stainless steel APPLIANCES and tall WHITE cabinets. This home has all the ENERGY efficient updates needed(double pane windows, all new plumbing and electrical). Garage has been sheet rocked comes with garage DOOR opener. Items completed in 2020: flooring, electrical wiring, plumbing, 2-zone HVAC, tankless water heater. Located NEAR Meyerland Plaza, ZONED to BELLAIRE high school and within walking distance to Herod ELEMENTARY.','0.1901','20','','','','','No Disclosures,Tenant Occupied','','','','Meyerland Area','Central Electric','1','LT 13 BLK 5 MAPLEWOOD NORTH SEC 2','Cul-De-Sac','8280','Appraisal District','','450','0','','1','','0','','','','','Wood Shingle','27 - Houston','HEROD ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','FONDREN MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Contemporary/Modern','Maplewood North Sec 02','9195','2.3307','Public Sewer,Public Water','1964','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215522150','1675091336','215522150','2022-12-15T10:18:13.880','26276597','Donya McLaurin','Keller Williams SoutheastTexas','','','30.382447','-94.218159','34','77656','8','225000.00','Active','Briarwood','5724','Lane','Silsbee','2','0','3','2695','Single-Family','Spacious white brick ranch style home sitting on almost 2 acres in a quiet neighborhood off of Hwy 418 in Silsbee. This house provides 3 large bedrooms with cedar closets and 2 bathrooms, in an addition to an expansive kitchen that includes stainless steel appliances, two islands, a 5 burner gas cooktop, soft-close drawers and concrete countertops- perfect for hosting a family event or party! There is also an office/ study room that could be used for a 4th bedroom. The space is not limited to the inside. Outside you will find 2 patios with plenty of room for taking the party outside! There is so much more this home has to offer so call me and let\'s go see it!','1.83','49','','','Electric Dryer Connections','','Sellers Disclosure','1','','','','Central Gas,Propane','0','AB 6 H BINNS P# 6-38 I# 890/390','Corner','79715','Appraisal District','','','0','','2','Double Oven','0','','','Gas Cooktop','','Composition','252 - Silsbee','SILSBEE ELEMENTARY SCHOOL','SILSBEE HIGH SCHOOL','EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch','N/A','3251','1.8501','Septic Tank,Water District','1960','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','215531980','1675091336','215531980','2022-12-15T09:22:18.657','78705601','Nu Le','HomeSmart','','','29.706866','-95.574868','25','77072','11','250000.00','Active','Oakcenter','11114','Drive','Houston','2','0','3','1370','Single-Family','Looking for a home that\'s community tied. This home is the one. Located in the fast-growing international district. Walking distance to shopping centers, multi-cultures, friendly neighborhood and safe district to a grown family. This home has extra living area for a move in ready family. Fridge, washer, and dryer included.','0.1191','28','','','','','Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Alief','Central Electric,Central Gas','1','LT 20 BLK 3 BRAYS VILLAGE SEC 4','Subdivision Lot','5187','Appraisal District','','350','0','','2','Double Oven','0','','','Electric Range,Freestanding Range','','Composition','2 - Alief','CHANCELLOR ELEMENTARY SCHOOL','AISD DRAW','ALIEF MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Brays Village Sec 04','4701','2.4411','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','215534611','1675091336','215534611','2022-12-15T10:10:26.767','76176015','Rashad Ajalov','Walzel Properties','','','29.295301','-94.806841','39','77550','7','479000.00','Active','Avenue K','3602','','Galveston','2','0','3','2750','Single-Family','BEAUTIFULLY remodeled (down to the studs) historic home stamped on concrete floor ORIGINALLY built in 1876. PROPERTY can be a single-family, multi-family, and commercial. NO restrictions. NEW flooring and high-end QUARTZ countertops throughout. Home has TWO kitchens with two SEPARATE meters. FROSTED tile backsplash with SOFT closing kitchen cabinets. IMPORTED composite siding on the exterior corner. Some areas with ORIGINAL shiplap walls saved for RUSTIC design. CUSTOM entry door and hand-scraped BARN door. NEW double-paned windows throughout. 2 NEW AC units. Beautiful cedar stained BALCONY and NEW concrete in the backyard. HIGH-END fixtures and all STAINLESS steel appliances. LOCATED just a few blocks from Seawall Blvd/beach. One of a kind home!','0.1167','33','','','','','No Disclosures','','','','East End','Central Electric','0','ABST 628 M B MENARD SUR S 55 FT OF LOT 8 & 9 (8-1) BLK 156 G','Corner','5085','Appraisal District','','','0','','','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Traditional','Galveston Townsite','6001','2.0161','Public Sewer,Public Water','1876','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','215547999','1675091336','215547999','2022-12-15T10:19:54.497','38917664','Steven Franco','Keller Williams Professionals','','','30.332572','-95.616513','9','77316','5','249900.00','Active','Piper','16498','Lane','Montgomery','2','1','3','1552','Single-Family','Fabulous new construction listing, minutes from Lake Conroe is waiting for you! This one story home features 3 bedrooms, 2.5 baths, 1 car garage with an open concept & 10\' ceilings. With abundant LED lighting & windows throughout, this home is sure to feel bright & airy all year long. Kitchen provides ample cabinet space, pantry closet, Samsung Stainless Steel Appliances, with 1 year warranty, including a 3 rack dishwasher & microwave. Kitchen also features a kitchen island, great for baking or entertaining. All 3 bedrooms are spacious with carpet, & the Primary bath includes granite countertops, separate vanity areas, linen closet & large walk-in closet. Home is less than a 10 minute drive to Lake Conroe Park, you\'ll be on the water in no time during the summer months & enjoy sunset dinners at the local lake restaurants all year long! Don\'t forget to ask the listing agent about preferred lender benefits!','0.1435','39','Starter Homes Of TX','','Electric Dryer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','S654001 - LAKE BONANZA 01, BLOCK 10, LOT 17','Subdivision Lot','','Other','','240','1','To Be Built/Under Construction','1','Electric Oven','0','','','Freestanding Range','','Composition','37 - Montgomery','LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Traditional','Lake Bonanza 01','228','1.825','Public Sewer,Septic Tank','2023','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','215558648','1675091336','215558648','2022-12-15T10:11:30.553','29752289','Rashad Ajalov','Walzel Properties','','','29.293559','-94.802577','19','77550','4','398000.00','Active','33rd','1327','Street','Galveston','2','0','3','1953','Single-Family','Gorgeous VINTAGE home with inviting front porch. COME ON IN to check this 3 bed and 2 bath home has to OFFER. You’ll be AMAZED with the delightful & inviting concept of the SPACIOUS living area—adorned with BEAUTIFUL kitchen cabinets and quartz countertops. ONE car garage and PLENTY of backyard space for FAMILY BBQ after a wonderful day at the beach. Minutes to Pleasure Pier, Moody Park, Schlitterbahn Waterpark, The Strand, & many more exciting attractions.','0.0818','33','','','','','No Disclosures','','','','East End','Central Gas','0','ABST 628 M B MENARD SUR S 42-3 FT OF LOTS 8 & 9 (1008-2) NE','Corner,Subdivision Lot','3562','Appraisal District','','','0','','','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Request Online Appointment','Appraisal District','2','Traditional','Galveston Outlots','5072','2.0161','Public Sewer,Public Water','1960','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','215563678','1675091336','215563678','2022-12-15T09:35:57.400','23948946','Lou Ann Martin','Main Properties','','','29.620831','-95.007938','49','77571','8','419000.00','Active','Seagrove','223','Street','Shoreacres','2','0','4','2524','Single-Family','4/2/2, mud room 23x8, shed 20x40 with shower, sink, commode and AC, 2 car garage with workshop. Large lot in Shoreacres with a peak toward Galveston Bay from the front yard. Flooring engineered hardwood and tile, Granite in the kitchen and bathroom. A great home with tons of amenities that you will absolutely love. Call today to see.','0.5372','7','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Shoreacres/La Porte','Central Gas','0','LTS 11 12 & 13 BLK 5 SHOREACRES','Subdivision Lot','23400','Appraisal District','','','0','','2','Double Oven,Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required','Seller','1','Traditional','Shoreacres','7958','2.8597','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','215581652','1675091336','215581652','2022-12-15T09:27:47.667','60105653','Chip Bubela','Bubela & Associates, Inc','','','29.683478','-97.107876','16','78941','4','299000.00','Active','4th','112','Street','Flatonia','2','0','3','1708','Single-Family','Charming home in an established neighborhood, within walking distance of the school. This 3-bedroom/2 bath home is a great size for a small, growing or the first home. Large living room with a large window overlooking the front yard. The updated kitchen & dining area flow seamlessly together for entertainment. There is ample space to add a kitchen island. The primary bedroom has an ensuite bathroom with a large garden tub & separate walk-in shower. Right off the kitchen find a tv room/office space/playroom that has access to the backyard. The attached garage comes off the kitchen with a utility area & storage space. The fenced backyard is large & spacious, with many possibilities. Don’t miss this one, call for a showing.','0.373','69','','','','','No Disclosures','','','','','Central Electric','0','CITY OF FLATONIA (400) LOT 3, FRC OF 4 BLK 39 0.373 130 X 12','Other','16250','Appraisal District','','','0','','1','','0','','','','','Composition','227 - Flatonia','FLATONIA ELEMENTARY SCHOOL','FLATONIA SECONDARY SCHOOL','FLATONIA SECONDARY SCHOOL','Appointment Required','Appraisal District','1','Other Style','City Of Flatonia 400','2734','1.8839','Public Sewer,Public Water','1953','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','215592455','1675091337','215592455','2022-12-15T09:58:26.190','50499482','Feras Rachid','Opendoor Brokerage, LLC','','','29.266604','-94.840876','21','77551','3','421000.00','Active','Dansby','37','Drive','Galveston','2','1','3','2301','Single-Family','Fantastic home in sought after location! Discover a bright and open interior with plenty of natural light and a neutral color palette, complimented by a fireplace. Step into the kitchen, complete with an eye catching stylish backsplash. Relax in your primary suite with a walk in closet included. Extra bedrooms add nice flex space for your everyday needs. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.','0.1937','33','','','','','Sellers Disclosure','1','','1','Near West End','Central Gas','1','ABST 121 HALL & JONES SUR LOT 37 BLK 1 COLONY PARK SEC 2','Subdivision Lot','8438','Appraisal District','','125','0','','2','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Colony Park','7207','2.0161','Other Water/Sewer','1978','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215594464','1675091337','215594464','2022-12-15T10:29:35.470','44639062','Victor Hartman','Prime Realty Group','','','29.701813','-95.225384','14','77506','3','190000.00','Active','Finfrock','621','Street','Pasadena','2','0','3','805','Single-Family','Just minutes from Hwy 225, 610 & downtown, this home can be your next investment property or starter home! Well established tenants willing to stay with the new owner. Come check out this property located on a corner lot with a spacious fenced-in back yard.','0.1894','6','','','','','No Disclosures','','','','Pasadena','Central Gas','0','LT 10 BLK 2 SINCO COURT','Subdivision Lot','8250','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','RICHEY ELEMENTARY SCHOOL','PASADENA HIGH SCHOOL','JACKSON INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','1','Traditional','Sinco Court','2936','2.6514','Public Sewer,Public Water','1952','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','215633718','1675091337','215633718','2022-12-15T10:54:10.527','10736273','Paul Wallace','Winhill Advisors - Kirby','','','29.708198','-95.405506','32','77030','3','849000.00','Active','Sheridan','1955','Street','Houston','3','1','3','3038','Single-Family','Exceptional Southgate Location! Walk to the Medical Center, Rice University & Rice Village. This classic 3 story townhome has 3 bedrooms, 3 1/2 baths. Each bedroom has its own en suite bathroom. It features an attached 2 car garage, New Elevator, Recently updated kitchen, beautiful solid wood floors and back yard green space. The versatile first floor bedroom can be used as a game room, workout room or home office. Open floor plan with Island kitchen, and separate Living and Dining rooms. Large primary bedroom & walk in closet. Primary bathroom features separate shower and garden tub. 3rd Bedroom and laundry round out the third floor.','0.0628','17','','','','','Sellers Disclosure','','','','Rice/Museum District','Central Gas','0','LT 4 BLK 1 MCCLENDON LANDING','Subdivision Lot','2734','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ROBERTS ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Lockbox Front','Appraisal District','3','Contemporary/Modern','Mcclendon Lndg','','','Public Sewer,Public Water','2013','Appraisal'); --> New record created successfully