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-19T20:33:52.567' ,`MLSNumber` = '94081393' ,`ListAgentFullName` = 'Suzanne Mason' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Sarah Savard' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.122046' ,`Longitude` = '-95.620226' ,`PhotoCount` = '31' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '549900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lost Creek' ,`StreetNumber` = '13202' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to this charming TRADITIONAL STYLE GEM so close to the heart of Tomball! This home has lots of traditional and vintage style that the most savvy buyers seek! Pride of ownership shows through on this family home that has been very well maintained (check update list in attachments). This property is move-in ready and the perfect family home within the desirable HUNTERWOOD Subdivision as well as located right in the heart of the much sought after TOMBALL ISD! Rest assured there is plenty of \"flex\" space here for all your family needs with ROOM TO GROW!. Beautiful natural sunlight pours in from multiple double French doors! Stunning corner lot, circle drive with separate side entrance to boot and mature trees, all lead to a spectacular nearly one acre yard that will lend nicely to the green thumb of the family! No flooding here! Call for more details or any questions. I am available, make your pre-appointment today!' ,`Acres` = '0.9298' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 HUNTERWOOD SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '40502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunterwood Sec 01' ,`TaxAmount` = '7746' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093271' WHERE `Matrix_Unique_ID` = '213832834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T20:18:40.273' ,`MLSNumber` = '70461621' ,`ListAgentFullName` = 'Santa Creado' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.389861' ,`Longitude` = '-94.939798' ,`PhotoCount` = '19' ,`PostalCode` = '77590' ,`RoomCount` = '3' ,`ListPrice` = '174500.00' ,`Status` = 'Active' ,`StreetName` = 'Vance' ,`StreetNumber` = '3018' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! 3 beds, 2 baths & 1-car attached garage. Well maintained single story home with nice upgrades. New interior paint, New bathroom, A/C 3 years.' ,`Acres` = '0.1388' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 R LOGAN SUR LOT 13 BLK 4 CLAIREMONT ADDN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6048' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clairmont' ,`TaxAmount` = '3406' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093272' WHERE `Matrix_Unique_ID` = '214174056' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T19:17:59.417' ,`MLSNumber` = '11327805' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515202' ,`Longitude` = '-95.488683' ,`PhotoCount` = '48' ,`PostalCode` = '77545' ,`RoomCount` = '15' ,`ListPrice` = '3289000.00' ,`Status` = 'Active' ,`StreetName` = 'Darby' ,`StreetNumber` = '2003' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '9596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNBELIEVABLE OPPORTUNITY to own this INCREDIBLE 6.7 acre estate only 20 minutes from the galleria area! Everything has been redone from top to bottom with sleek, modern finishes throughout- it\'s basically a new home! Double iron doors lead to a glamorous estate filled w/custom chandeliers/lighting, wood floors, iron doors, and top notch finishes . The formal living room has sliding doors that open to the backyard - perfect for entertaining! Elegant formal dining room w/butlers pantry & wine closet! Modern staircase with glass railing. The kitchen is a work of art w/floor to ceiling custom cabinets, exotic marble counter tops & high end appliances. Large family room with tile fireplace & wall of windows to take in the grounds. Luxurious master suite w/spa-like master bath and two oversized closets. 2 bedrooms down! Newpoint Estates is a luxury acreage community minutes from shopping & dining! Low tax rate & horses allowed. Bring your pickiest buyers! Call the Aida Younis Team today!' ,`Acres` = '6.759' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'NEWPOINT ESTATES SEC 3, BLOCK 2, LOT 1, ACRES 6.759' ,`LotDesciption` = 'Other,Subdivision Lot,Wooded' ,`LotSize` = '294422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Newpoint Estates' ,`TaxAmount` = '27124' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093272' WHERE `Matrix_Unique_ID` = '214889392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T20:04:54.340' ,`MLSNumber` = '34835763' ,`ListAgentFullName` = 'Dany Zelaa' ,`ListOfficeName` = 'Zarco Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048884' ,`Longitude` = '-95.590307' ,`PhotoCount` = '19' ,`PostalCode` = '77375' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Moose Cove' ,`StreetNumber` = '19719' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 BD, 4.5 BTH completely remodeled home in the quaint Northern Point Subdivision offers quiet and seclusion while still being centrally located to the city. Upon entry, you will notice the open and inviting floor plan and abundant natural light pouring in from the many windows. The first floor includes a sizeable enclosed office space, a large adjoining powder bath, spacious dining and living space, and a kitchen made for entertaining with an U-shaped kitchen, large island, and a new appliances including dishwasher, oven and microwave, also master bedroom and master bathroom located on the first floor. Next, head upstairs to the playroom plus 4 other bedrooms which 2 of those bedrooms upstairs offers private/exclusive new bathrooms. Conveniently located near Interstate 99 and 249, this home is centrally located and move-in ready! \r\nAPPRAISAL DONE ABOUT 60 DAYS AGO!!' ,`Acres` = '0.1197' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 2 NORTHERN POINT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5214' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northern Point Sec 1' ,`TaxAmount` = '7256' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093272' WHERE `Matrix_Unique_ID` = '215072026' --> 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','215574996','1675093272','215574996','2022-12-19T19:31:39.937','32208495','Ronnie Matthews','D.R. Horton Homes','Jared Turner','Turner Mangum,LLC','29.970491','-94.901828','6','77535','5','363990.00','Pending Continue to Show','Blanco','432','Lane','Dayton','2','1','4','2562','Single-Family','BEAUTIFUL NEW D. R. HORTON BUILT 4 BEDROOM! 3 CAR GARAGE! Great Cul-de-Sac Lot! Open Kitchen with Light Gray Cabinetry, Quartz Counters, & Stainless Appliances! Spacious Primary Suite is Privately Tucked Away & Offers Lovely Garden Bath with Separate Tub & Shower! Home Automation System! Great Location in Rapidly Growing Dayton Area - Easy Access to the Grand Parkway + 146!','','52','D. R. Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Dayton','Central Gas','1','RIVER RANCH MEADOWS, SEC 1, BLOCK 3, LOT 9, ACRES .2004','Cul-De-Sac,Subdivision Lot','8729','Appraisal District','','800','1','To Be Built/Under Construction','3','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','74 - Dayton','KIMMIE M. BROWN ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','River Ranch Meadows','','','Public Sewer,Water District','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','215743379','1675093272','215743379','2022-12-19T20:18:15.203','17873221','Robert Roland','Realty Associates','','','29.634201','-95.144909','32','77505','6','350000.00','Active','Summer Oak','5127','Drive','Pasadena','3','1','4','2639','Single-Family','Excellent Home in the Baywood Oaks West Section. Open Floor Plan, Formal Dining Room, Gourmet Kitchen w/bar overlooking Family Room and High Ceilings. Stainless Appliances, Large Master Suite, Jacuzzi tub, Walk-in Closet. Upstairs Gameroom, Large Secondary Bedrooms w/Walk-in Closets. 3rd bedroom has full bath. Oversized Covered Patio with Ceiling Fan waiting for your Hammock and Outdoor Kitchen. Huge Storage Building. Solar Screens. Sprinkler system front & back yards.','0.1515','6','','','Electric Dryer Connections','','Sellers Disclosure','1','','1','Pasadena','Central Gas','1','LT 5 BLK 3 BAYWOOD OAKS WEST SEC 4','Subdivision Lot','6600','Appraisal District','','315','0','','2','Freestanding Oven,Gas Oven','0','','','','','Composition','41 - Pasadena','TURNER ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Baywood Oaks West Sec 04','8785','2.6514','Public Water','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215744433','1675093272','215744433','2022-12-19T20:01:34.807','77343647','Kandas Graham','eXp Realty, LLC','','','28.767042','-95.635485','30','77414','4','350000.00','Active','County Road 204','548','','Sargent','2','0','3','1570','Single-Family','Welcome to your 3bedroom 2 bath home minutes from the ICW and Matagorda Bay! Featuring TWO lots with your own private boat ramp! This home boasts over 1500 sq. ft offering plenty of room for entertaining! A large kitchen off the living room with a breakfast nook. The master suite greets you with floor to ceiling windows, entry to the patio, and high ceilings. Come see what Sargent has to offer!','0.276','54','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','1','DOWNEY CANEY CREEK SEC 12, LOT 213 & 214','Water View,Waterfront','12022','Appraisal District','','24','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','134 - Van Vleck','VAN VLECK ELEMENTARY SCHOOL','VAN VLECK HIGH SCHOOL','O H HERMAN MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Downey Caney Creek','5566','2.325','Water District','1985','Appraisal District'); --> New record created successfully