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-01T13:22:53.613' ,`MLSNumber` = '51882248' ,`ListAgentFullName` = 'Kristie Farmer' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.868598' ,`Longitude` = '-95.680654' ,`PhotoCount` = '31' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenhagen' ,`StreetNumber` = '17703' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 17703 Glenhagen Ct! This 3 bedroom, two full bathroom is located at a cul de sac. The house has been updated just recently with it\'s new roof in 2021, fence 2018, Water Heater in 2020, updated in the kitchen in 2019-2020 and even the HVAC in 2018. It has an elegant look with a high ceiling and hardwood flooring. The backyard is equipped with a swimming pool. It is also very easy to access being located near hwy 6, what else are you waiting for book a showing now!' ,`Acres` = '0.1171' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22X BLK 4 NORTHGLEN SEC 4 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '237' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northglen Sec 04 R/P' ,`TaxAmount` = '3315' ,`TaxRate` = '2.706' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086125' WHERE `Matrix_Unique_ID` = '208580871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:05:56.510' ,`MLSNumber` = '3898572' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764466' ,`Longitude` = '-95.888568' ,`PhotoCount` = '6' ,`PostalCode` = '77423' ,`RoomCount` = '10' ,`ListPrice` = '404497.00' ,`Status` = 'Active' ,`StreetName` = 'Willowmoor' ,`StreetNumber` = '9738' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautiful Kempton Floor Plan with 4 Bedrooms, 2 1/2 Baths, and 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Formal Dining Room, Half Bath, and the Primary Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms and another full bath. Tile and Carpet throughout. You will love the Kitchen with lots of cabinets with under the cabinet lighting, stainless steel appliances, and even a USB outlet. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, and Low E Windows that open to the inside of the home for cleaning. The community also offers recreational amenities for residents to enjoy including walking trails, a full-size Olympic pool, a splash pad, parks, and playground facilities. Convenient to I-10 and 99. Lamar CISD.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Creek Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.9348' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086125' WHERE `Matrix_Unique_ID` = '209569054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:02:40.377' ,`MLSNumber` = '15083031' ,`ListAgentFullName` = 'Loyce Hutson' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.977713' ,`Longitude` = '-95.568268' ,`PhotoCount` = '36' ,`PostalCode` = '77422' ,`RoomCount` = '7' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Riverview Ranch' ,`StreetNumber` = '1092' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make your appointment today to view this beautiful 4 bedroom 2.5 bath home. This home sits on 2 acres and boosts a bright open kitchen that opens up to the family room and is perfect for large gatherings. The primary bedroom is very large and opens to the large covered patio. There are 3 other nice size bedrooms in the home. One of the bedrooms can be used as an office. Recently replaced roof, A/C, water heater and new reverse osmosis and water softener. Attic above the garage is floored with permanent stairway. Relax on the covered patio where you can enjoy the serene sounds of your pond complete with fountain in your backyard. Residents have access to a private boat ramp. This one will not last long. Make your appointment today.' ,`Acres` = '2.034' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVERVIEW RANCH ESTATES SEC 1 (A0041 T B BELL) BLK 1 LOT 28-' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '88601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverview Ranch Estates Sec 1' ,`TaxAmount` = '5214' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086125' WHERE `Matrix_Unique_ID` = '211701738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T13:03:08.563' ,`MLSNumber` = '30875263' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.466130' ,`Longitude` = '-94.609937' ,`PhotoCount` = '22' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Pelican' ,`StreetNumber` = '968' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking interior design and top of the line furnishings are just the beginning for this Crystal Beach gem. Located in the highly sought after Holiday Beach subdivision this home is immaculate inside and out. 3 Bedroom and 2 bathrooms with 2 sets of queen over queens in the sleeper room puts this homes sleeping capacity to 12! Downstairs you will find a seating area and tiki bar! Only a short golf cart ride or walk to the direct beach access in the subdivision! This home would make an excellent second home or investment property' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 66 HOLIDAY BEACH' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = 'Holiday Beach' ,`TaxAmount` = '415' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086125' WHERE `Matrix_Unique_ID` = '212821919' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:04:29.103' ,`MLSNumber` = '74386724' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762259' ,`Longitude` = '-95.891657' ,`PhotoCount` = '20' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '384942.00' ,`Status` = 'Active' ,`StreetName` = 'Twisting Springs' ,`StreetNumber` = '30235' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful 1 Story, 4 Bedroom, 2 Bath, with a 2 Car Garage, Aintree floorplan. You will love the space in this open concept home. From the large island kitchen with stainless steel appliances to the flex space which can be a study, game room, or even a formal room. Tile and carpet throughout. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. The community also offers recreational amenities for residents to enjoy including walking trails, a full-size Olympic pool, a splash pad, parks and playground facilities. Convenient to I-10 and 99. Lamar CISD.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5610' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Willow Creek Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.9348' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086126' WHERE `Matrix_Unique_ID` = '213058132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T13:13:26.367' ,`MLSNumber` = '80565899' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477868' ,`Longitude` = '-94.576487' ,`PhotoCount` = '35' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '1400000.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Castle' ,`StreetNumber` = '3433' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '3900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR SPECIAL!! This MASSIVE unobstructed beach view home is ready for a new owner. The 3900 square foot home features 6 bedrooms and 5 baths, wet bars, a pool table, an outdoor grilling kitchen and bar, and 3,000+ square feet of ocean-view deck. This is one of the biggest rentals on the entire peninsula. It easily and comfortably sleeps 34 people - while still offering plenty of room to entertain and lounge. There’s a full-size pool table that is a guest favorite. There are 3 family rooms, two downstairs and one upstairs, so you can spread out with plenty of privacy. The home offers 3 wet bars, including one upstairs, one on the main floor, and even one outside near the grill.' ,`Acres` = '0.307' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 4 DUNES EAST' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '13373' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Dunes East Sub 95' ,`TaxAmount` = '14143' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086126' WHERE `Matrix_Unique_ID` = '213427968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T13:02:14.947' ,`MLSNumber` = '49801822' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.453700' ,`Longitude` = '-94.629660' ,`PhotoCount` = '27' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '849000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '1969' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom 3 bath home located in the popular Gulf Shores subdivision! Just seconds from the beach with beautiful beach views from both the main and upper decks. The main floor of the house features spacious living room kitchen featuring modern appliances bunk room (D/T) stackable Samsung washer and dryer and a bathroom. The upper level features 3 bedrooms and 2 bathrooms. The master bedroom located upstairs features a King bed twin daybed with twin trundle and en suite bathroom. Bedroom 2 is located upstairs and features 1 Queen bed. Bedroom 3 located upstairs features a D/D bunk bed. Bedroom 4 located on the main level features a D/T bunk.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 15 BLK 2 GULF SHORES SEC 1' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Gulf Shores 1' ,`TaxAmount` = '8418' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086126' WHERE `Matrix_Unique_ID` = '213832872' --> 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','213921471','1675086126','213921471','2022-12-01T13:07:34.817','3040360','Jamie Bechtold','RE/MAX Signature','','','30.452873','-95.416917','12','77378','5','239999.00','Active','Hughes','TBD','Loop','Willis','1','0','1','1760','Single-Family','Beautiful, UNRESTRICTED, 2.896-acre lot on Boggy Creek with bonus unfinished house.','2.896','19','','','','','No Disclosures','','','','Willis Area','No Heating','0','SANDY CREEK ADDITION #1 & #2, LOT 21, SECTION 1, ACRES 2.896','Cleared,Wooded','126150','Appraisal District','','','0','','0','','0','','','','','Other','56 - Willis','EDWARD B. CANNAN ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Sandy Creek #1 & #3','5251','1.9577','No Sewer,No Water','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:57:28.870' ,`MLSNumber` = '54666581' ,`ListAgentFullName` = 'James Rowlett' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821361' ,`Longitude` = '-95.678633' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr Glen' ,`StreetNumber` = '3623' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 2 story Pride Builders home in Barkers Crossing. 4 bedrooms, 2.5 baths with large gameroom upstairs. 2 car garage. Formal dining room. Large living room. Island kitchen with breakfast bar. Spacious master bedroom with en-suite bath. Dual sinks, soaking tub, and separate shower. Fully fenced backyard with patio.' ,`Acres` = '0.1078' ,`Area` = '8' ,`BuilderName` = 'Pride' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 BARKERS CROSSING SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Crossing Sec 6' ,`TaxAmount` = '5121' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086126' WHERE `Matrix_Unique_ID` = '214365737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T13:31:29.520' ,`MLSNumber` = '13912710' ,`ListAgentFullName` = 'Marie Castecka' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.726215' ,`Longitude` = '-95.552741' ,`PhotoCount` = '6' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M' ,`StreetNumber` = '907' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this well maintained home, with 4 bedrooms, 2 bathrooms, in downtown Huntsville. Home has a spacious family room open to the dining and kitchen area. This home has an office in the front part of the house and plenty of family room in the back part. Lots of storage. There is a new carport attached on the side. Also new CA&H was just installed a few months ago. Roof is a few years old. Home was built in 1965. There is a workshop and a nice large back covered patio. Close to SHSU, maybe 1/2 a mile. Great rental property also, for investor. Call and come and take a look for yourself. Walking distance to court, bank, post office and grocery store. Room sizes need to be verified by buyers.' ,`Acres` = '0.306' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HUNTSVILLE TOWNSITE, BLOCK 10, LOT 4, ACRES 0.306' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '13329' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntsville Townsite' ,`TaxAmount` = '3889' ,`TaxRate` = '1.8868' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675086127' WHERE `Matrix_Unique_ID` = '214373988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:57:43.033' ,`MLSNumber` = '54715622' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472950' ,`Longitude` = '-95.515680' ,`PhotoCount` = '9' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '999607.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage Light' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Verona floorplan - Incredible two-story plan with 5 bedrooms (2 down), 4.5 baths and a 3-car garage. This open concept design includes a formal dining room, study, large primary suite, dual walk-in closets, media room and game room. Benefit from a gourmet kitchen with a breakfast area and central island. Relax on the extended covered patio after a long day.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '1/9/36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13009' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086127' WHERE `Matrix_Unique_ID` = '214427686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:58:11.160' ,`MLSNumber` = '93920286' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472950' ,`Longitude` = '-95.515680' ,`PhotoCount` = '38' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '999347.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage Light' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lucca floorplan - There is room for everyone in this two-story home featuring 5 bedrooms, 4 ½ baths and a 3-car garage. Gather around the large formal dining room table for holidays, benefit from the open-concept family room with soaring ceilings to the 2nd story or work from home in the private study. Host Saturday night charades in the game room, catch a movie in the media room, and store all your games in the hidden storage. Enjoy the breeze on the back covered patio after a long day.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '1/10/36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12975' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086127' WHERE `Matrix_Unique_ID` = '214429446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T13:01:38.617' ,`MLSNumber` = '90381088' ,`ListAgentFullName` = 'Lou Ann Martin' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680136' ,`Longitude` = '-95.043379' ,`PhotoCount` = '37' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'L' ,`StreetNumber` = '12020' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'House sits on 2 acres in sought after Lomax. Rooms size approximate. Fridge, washer and dryer stay. Walk in to this awesome very large great room, including a kitchen with granite, island in the middle. Electric range, free standing. Laminate floors and carpet in the bedrooms. 5 stall barn with hayroom, approximately 25x40 as well as a workshop with cabinets 20x40. Both outside buildings have electricity and the workshop has AC.' ,`Acres` = '2' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 3L & 9 ABST 5 E BRINSON' ,`LotDesciption` = 'Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Porte Outlots' ,`TaxAmount` = '6571' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086127' WHERE `Matrix_Unique_ID` = '214516494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T13:33:37.983' ,`MLSNumber` = '91709328' ,`ListAgentFullName` = 'Glenda Johnson' ,`ListOfficeName` = 'A Action Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.803992' ,`Longitude` = '-95.067327' ,`PhotoCount` = '25' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Tree' ,`StreetNumber` = '272' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled 2 bedroom 2 bath in Cedar Point Subdivision. Home is situated on 4 lots with concrete parking and asphalt driveway. Interior of home has been completely remodeled, new wiring, new cabinets, new flooring, new appliances and more. Subdivision amenities include pool, 2 boat ramps, community center and play ground. Exterior of home has been freshly painted. Oversized storage building with loft storage. Concrete parking under carport. Asphalt driveway for additional parking.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 2 LOT 40 SERIAL# 12004361 HUD# TXS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9200' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '686' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cedar Point Sec 1' ,`TaxAmount` = '567' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086128' WHERE `Matrix_Unique_ID` = '214730081' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:45:20.713' ,`MLSNumber` = '16828205' ,`ListAgentFullName` = 'Kaleb Monroe' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217061' ,`Longitude` = '-95.432067' ,`PhotoCount` = '47' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Foursquare' ,`StreetNumber` = '16624' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Foursquare! With 4 Bedrooms, 2.5 Bathrooms has been freshly painted. A recent pool has been constructed in the home community perfect for family and friends BBQ evenings!. As you walk in there is beautiful grey wood and tile all throughout the first floor. It leads to a beautiful ope living room-kitchen concept with granite counter tops. All NEW light fixtures and NEW fans have been added throughout the home. There is carpet all throughout the second floor. A few gems around the area is the Woodlands Shopping Center at only 5 minutes away and a water park that is about 15 minutes out from this beautiful home. So many restaurants and stores at a short distance perfect for any occasion! DON’T miss out on this opportunity to call this house your home!' ,`Acres` = '0.1152' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720808 - MONTGOMERY CREEK RANCH 08, BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5017' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 08' ,`TaxAmount` = '7431' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086128' WHERE `Matrix_Unique_ID` = '214915392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-01T14:00:10.823' ,`MLSNumber` = '68219758' ,`ListAgentFullName` = 'Dominic Vu' ,`ListOfficeName` = 'HomePro Realty, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582164' ,`Longitude` = '-95.225061' ,`PhotoCount` = '8' ,`PostalCode` = '77089' ,`RoomCount` = '7' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Sageglow Drive' ,`StreetNumber` = '10311' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a nice one story home on corner lot, with open concept layout floor plan. New/Fresh paint inside the house. Huge living room area with high ceiling and fire-place. There is a wet bar next to breakfast and facing to the living room. Look at the spacious Parking on the back!' ,`Acres` = '0.198' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 18 SAGEGLEN SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '254' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sageglen Sec 02' ,`TaxAmount` = '5829' ,`TaxRate` = '2.356' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086128' WHERE `Matrix_Unique_ID` = '214969046' --> 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','215204406','1675086128','215204406','2022-12-01T13:47:24.823','8660460','Adam Olsen','eXp Realty, LLC','','','31.618597','-97.211361','13','76708','3','286655.00','Active','Peperak','10808','Court','Waco','2','0','3','1605','Single-Family','\"The Roosevelt is a single-story, 1605 sq. ft., 3-bedroom, 2-bathroom floorplan, designed to provide you and your family a comfortable place to call home. The inviting entryway opens into the spacious living area with a dining area that flows effortlessly to the bright and spacious kitchen. Enjoy preparing meals and spending time together gathered around the kitchen island. The Bedroom 1 suite is located off the family room and it includes a large walk-in closet and a relaxing spa-like bathroom. Other features include granite counter tops in the kitchen and Frigidaire® Stainless appliances. You’ll enjoy added security in your new DR Horton home with our Home is Connected features. Using one central hub that talks to all the devices in your home, you can control the lights, thermostat and locks, all from your cellular device. DR Horton also includes an Amazon Echo Dot to make voice activation a reality in your new Smart Home.','0.1969','83','DR Horton','','Electric Dryer Connections,Washer Connections','','Other Disclosures','','','','','Central Electric','0','Foxborough, lot 9, block 11','Subdivision Lot','','','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','358 - Bosqueville','BOSQUEVILLE ELEMENTARY SCHOOL','BOSQUEVILLE SCHOOL SECONDARY SCHOOL','BOSQUEVILLE SCHOOL SECONDARY SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Foxborough','','2.61','Public Sewer,Public Water','','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','215209751','1675086128','215209751','2022-12-01T13:46:43.280','77745876','Adam Olsen','eXp Realty, LLC','','','31.618597','-97.211361','17','76708','3','312050.00','Active','Peperak','10900','Court','Waco','2','0','3','2150','Single-Family','The Everett is a single-story, 2150 approximate square foot home featuring 3 or 4 bedrooms, 2 bathrooms, a study and a 2-car garage. The open kitchen includes granite counter tops, stainless steel appliances and open concept floorplan that opens to the dining area and family room. The Bedroom 1 suite is located off the family room and it includes a large walk-in closet and a relaxing spa-like bathroom. You’ll enjoy added security in your new DR Horton home with our Home is Connected features. Using one central hub that talks to all the devices in your home, you can control the lights, thermostat and locks, all from your cellular device. DR Horton also includes an Amazon Echo Dot to make voice activation a reality in your new Smart Home.','0.1966','83','DR Horton','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Electric','0','Foxborough, lot 6, block 11','Subdivision Lot','','','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Range','','Composition','358 - Bosqueville','BOSQUEVILLE ELEMENTARY SCHOOL','BOSQUEVILLE SCHOOL SECONDARY SCHOOL','BOSQUEVILLE SCHOOL SECONDARY SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Foxborough','','2.61','Public Sewer,Public Water','','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','215240684','1675086128','215240684','2022-12-01T13:00:45.513','59922863','Faiza Anwar','RE/MAX One','','','30.112616','-94.146378','16','77706','6','389900.00','Active','Stonebrook','7','Court','Beaumont','3','1','5','2905','Single-Family','Beautiful home in Brownstone Park off of Lucas in Beaumont\'s sought after Westend. This Five bedroom with office, 3 full and 1 Half bathroom and 2 car garage home is conveniently located close to shopping, restaurants and schools. Open floor plan with high ceilings throughout. Formal dining room and living and breakfast, family room kitchen combo has gorgeous marble floors. Kitchen has beautiful cabinets with granite countertops, gas stove with tile backsplash and SS appliances, a spacious island with breakfast bar that is open to the living room. Master bedroom is downstairs and has a oversized walk-in closet, double sink vanity in the master bath, tiled shower and separate air jet bathtub. Upstairs you will find three more bedrooms with 2 full bathrooms and a large game room that could be a 5thbedroom because it does have a closet. Beautiful home is a must see!!','0.1464','51','','','','','Sellers Disclosure','1','','','','Central Electric','0','BROWNSTONE PARK LOT 7','Cul-De-Sac','6377','Appraisal District','','','0','','2','','0','','','','','Composition','143 - Beaumont','REGINAL-HOWELL ELEMENTARY SCHOOL','WEST BROOK HIGH SCHOOL','MARSHALL MIDDLE SCHOOL (BEAUMONT)','Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1.5','Other Style','Brownstone Park','8206','2.645','Public Sewer,Public Water','2010','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','215243101','1675086128','215243101','2022-12-01T13:39:09.460','14451371','Cyndi Kornegay','Gatehouse Properties','','','29.945511','-95.689553','12','77433','13','988192.00','Active','Bachman Branch','18006','Drive','Cypress','4','1','5','4378','Single-Family','Welcome home! This fresh take on curb appeal will leave you amazed with the sleek stucco and brick combination. Your guests will be greeted by an elegant curved staircase flanked by the private home office and formal dining area. Natural light fills the spacious family room, gourmet kitchen, and breakfast nook through large windows lining the back of the home. Create the entertaining space of your dreams in the over-sized game room and huge media room with riser seating and nook at the back perfect for a snack bar, media storage, or extra seating. The family and guests will enjoy the extra roomy secondary bedrooms throughout this home and the immaculate primary bedroom suite. Enjoy the convenience of the smart home features and efficient design all within the gated Marina Bay subdivision in the unmatched boating community of Towne Lake.','','25','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','Lot 6 Block 2','Cul-De-Sac,Subdivision Lot','9464','Survey','','1674','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','RENNELL ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Accompany,Appointment Required,No Supra Keybox','Builder','2','Contemporary/Modern,Traditional','Towne Lake','','3.4','Water District','2022','Builder'); --> New record created successfully