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-10-12T05:17:03.763' ,`MLSNumber` = '45116606' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477250' ,`Longitude` = '-95.506663' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Knollwood' ,`StreetNumber` = '10027' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Model Plan: The LAYTON features 5 bedrooms, 2 down and 3 up, 4 full bath, 2 half bath. Open concept Kitchen and family presents a decorator’s delight. The gourmet kitchen features a corner walk in pantry and a full-function island. Stepping through sliding doors access: large covered patio which presents a sensational place for calm evenings and weekend cook-outs. A perfect sunlit study and the downstairs suite offers privacy and convenience for overnight guests. Step up Media room for family fun movie nights. Your glorious master bedroom features a large backyard view, expansive walk in closet, and a spacious bathroom. The spacious game room creates space for family fun. Color scheme includes Linen cabinets, cool quartz countertops, grey flooring with black hardware and light fixtures. Large cu de sac lot approx.13,536 sqft Pool size yard.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10309' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583888' WHERE `Matrix_Unique_ID` = '206566261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T04:28:53.083' ,`MLSNumber` = '70751269' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918800' ,`Longitude` = '-95.728800' ,`PhotoCount` = '48' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '462000.00' ,`Status` = 'Active' ,`StreetName` = 'Ottline Swamp' ,`StreetNumber` = '14822' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning 2-story 3 bedroom home. At entry you are greeted with stately wood floors that flow into the unforgettable kitchen with oversized island with impressive quartz countertops accented with stone backsplash. This open plan has natural light flowing from all angles, a must see. Owners retreat is conveniently  located downstairs. This awesome home showcases a dining, family and sunroom all surrounded by windows allowing natural light to flow . The second floor has a gracious retreat space with 2 additional bedrooms and a full bath. Make this it your own!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4961' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1284' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.62' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583888' WHERE `Matrix_Unique_ID` = '209652567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T05:16:20.083' ,`MLSNumber` = '21198257' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209379' ,`Longitude` = '-95.750782' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '389508.00' ,`Status` = 'Active' ,`StreetName` = 'Misterio Hills' ,`StreetNumber` = '42119' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Explore the remarkable lifestyle possibilities of the spacious and sophisticated Conway new home plan. Growing residents and out-of-town visitors will love the sizable junior bedrooms and the private guest suite. The study presents a sunlit opportunity for additional gathering space or the personally-designed home office you’ve been dreaming of. Culinary masterpieces and quick, easy meals are equally suited to the streamlined kitchen nestled at the heart of this home. Your open floor plan provides a beautiful expanse for you to fill with decorative flair and lifelong memories. Your Owner’s Retreat includes a sleek en suite bathroom and a walk-in closet to make it easy to rest and refresh in luxury. Enjoy refreshments and good company in the breezy leisure of your covered patio. Bonus storage, top-quality construction, and our EnergySaver™ features make it easy to love each day in this wonderful new home plan.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583888' WHERE `Matrix_Unique_ID` = '209858059' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T05:58:05.540' ,`MLSNumber` = '53786782' ,`ListAgentFullName` = 'Erica Mouton' ,`ListOfficeName` = 'Divine Dreams Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.609730' ,`Longitude` = '-95.236229' ,`PhotoCount` = '26' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Buena Park' ,`StreetNumber` = '9907' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME TAKE A LOOK AT THIS BEAUTIFUL 3 BEDROOM 2 BATH HOME. THIS 1 STORY HAS BEEN UPDATED WITH NEW FLOORING THROUGHTOUT THE HOUSE AND HAS BEEN FRESHLY PAINTED . SPACIOUS OPEN FLOOR PLAN IS GREAT FOR ENTERTAINING. MASTER BEDROOM IS A GREAT SIZE THAT HAS A LARGE WALK IN CLOSET SEPERATE SHOWER AND A SOAKING TUB. THE 2 SECONDARY BEDROOMS ARE GOOD SIZES WITH NICE SIZE CLOSETS. LIVINGROOM IS OPEN TO THE KITCHEN AND DINNING AREA. AGENTS DONT MISS OUT BRING YOUR CLIENTS QUICK, THEY WILL NOT BE DISAPPOINTED.' ,`Acres` = '0.1265' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 2 FUQUA LANDING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5512' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '24' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'ATKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fuqua Lndg' ,`TaxAmount` = '4989' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665583889' WHERE `Matrix_Unique_ID` = '211968985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T04:30:53.717' ,`MLSNumber` = '48637885' ,`ListAgentFullName` = 'Cynthia Ramos' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889840' ,`Longitude` = '-94.810445' ,`PhotoCount` = '32' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 401' ,`StreetNumber` = '199' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coming home to your own slice of country living with a beautiful residence that sits on 5 acres. This property has mature trees throughout two of the cleared, fenced acres. Even comes with a pecan and an apple tree! This home offers a relaxing atmosphere, with a cozy feel. The backyard boasts wide open spaces for gardening or animals. There is plenty of room for a swing set and/or firepit--fun for the whole family! This 4 bedroom, 2 bath, brick home is a must see! It has granite counter tops in the kitchen and a wood/gas fireplace in the living room. It also has a large covered patio, perfect for being outside. There is also a 12 by 24 storage building for storing all your supplies or lawn equipment! The countryside views are an excellent place to enjoy the outdoors, away from the hustle and bustle of everyday life. The three wooded acres can become anything you can dream of! Schedule a showing today…. and don\'t let this one slip away!' ,`Acres` = '5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WYLIE ESTATES, LOT 1, ACRES 5.0' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wylie Estates' ,`TaxAmount` = '7369' ,`TaxRate` = '1.7625' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583889' WHERE `Matrix_Unique_ID` = '213057498' --> 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','213411290','1665583889','213411290','2022-10-12T05:42:23.390','50321878','Treva Christopher','The Christopher Dynasty Real Estate Group','','','29.891831','-95.472085','35','77088','8','245000.00','Active','Windsor Forest','5514','Drive','Houston','2','0','3','1801','Single-Family','See what Pride In Home Ownership is! This Home creates the perfect ambiance and is well maintained. This gorgeous home features 3 bedroom, 2 baths, a formal dining and formal living with a den & covered back patio. Boasting the latest trend luxury vinyl flooring and open concept kitchen into spacious living areas with a wood burning fireplace. The generous size backyard is perfect for hosting backyard family events & sports activities. Easy access to Beltway 8 and 290 for shopping, dining, & entertainment. Schedule your showing today!!','0.1377','11','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Northwest Houston','Central Electric,Central Gas','1','LT 18 BLK 16 017*I5645955-005-016-018 INWOOD NORTH SEC 5','Subdivision Lot','6000','Appraisal District','','295','0','','2','Electric Oven','0','','','Electric Range','','Composition','32 - Klein','NITSCH ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Inwood North Sec 05','4705','2.6485','Water District','1983','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T05:43:11.873' ,`MLSNumber` = '73797237' ,`ListAgentFullName` = 'Anthony Jensen' ,`ListOfficeName` = 'ZAPP Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.257556' ,`Longitude` = '-94.873186' ,`PhotoCount` = '21' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = '103rd' ,`StreetNumber` = '2431' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1718' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly constructed 4 bedroom, 2 bathroom home sits on about 1/3 of an acre in the newly developed Neumann addition. The neighborhood will consist of 17 beautiful homes that are located down the street from Moody Gardens\' Golf Course, Sugar Bean, Buffalo Grille and just a short drive to the beach. This coastal charmer offers 10\' ceilings, luxury vinyl plank flooring, shaker style cabinets with quartz countertops, a custom vent hood, stainless steel appliances, and a primary suite with a custom-tiled shower and walk-in closet. Enjoy the coastal views from 2 vast 8\' deep decks on the front and rear.' ,`Acres` = '0.3788' ,`Area` = '33' ,`BuilderName` = 'Cactusland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 BLK 1 NEUMANN ADDN RPLT NO 1 (2021) ABST 121' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`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` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Neumann' ,`TaxAmount` = '503' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583889' WHERE `Matrix_Unique_ID` = '213436765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T05:26:34.607' ,`MLSNumber` = '56959242' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.352263' ,`Longitude` = '-95.460276' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '302990.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Rubia' ,`StreetNumber` = '7706' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction-The Camden Plan by D.R. Horton Homes! Beautiful stylish 1 Story Stucco & Brick Elevation! Wonderful Backyard W/Covered Patio! This Home welcomes you W/Gorgeous Entry with Luxurious Vinyl Wood Floors Throughout! Dramatic Gourmet Kitchen Boast Beautiful Silestone Counters, Stainless Steel Appliances, Eat-in Island W/Stainless Steel Undermount Sink, Tall Stunning Shaker Cabinets, Tile Backsplash, Move in Package-Free Fridge, Washer/Dryer, Garage Door Opener! Gourmet Kitchen Open to your Casual Dining Area & Family Rm W/Walls of Windows! Private Primary Suite W/High Ceilings & Luxurious Bath W/His & Her Undermount Sinks & Quartz Countertops, Massive Shower With Tile Surroundings & Huge Walk In Closet! 2\" Blinds! HERS Energy Rated, Tankless/On-Demand H2O Heater! The Smart Home Automation System allows you to control your home from Almost anywhere W/The Amazon Echo Dot! Amenity Center W/Pool, Lap Pool, Water Slides, Pavilion, Playground, Soccer Fields & more! No Flooding!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Caldwell Ranch Lot: 7 Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583889' WHERE `Matrix_Unique_ID` = '213506381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T04:20:53.450' ,`MLSNumber` = '24458853' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.352263' ,`Longitude` = '-95.460276' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Rubia' ,`StreetNumber` = '7823' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction- The Justin Floor Plan by D.R. Horton Homes! Stunning 1 Story Chic Stucco & Brick Elevation W/Covered Patio! Grand Foyer W/High Ceilings, Beautiful Vinyl Carefree Wood Floors throughout! Wonderful Open Floor Plan! Casual Dining area, Huge Family Rm with walls of windows that Flows into the Gourmet Kitchen! Gourmet Kitchen W/Beautiful Tall Shaker Cabinets, Tile Backsplash, Gorgeous Silestone Countertops, Huge Eat-in Working Station Island, Stainless Appliances & Move in Package (Free Fridge, Washer/Dryer, Garage Door Opener! Owner\'s Suite features Luxurious Bathroom W/His & Her Undermount Sinks W/Quartz Countertops, Massive Shower & Walk-in Closet! 3 Guest Bedrooms & 1 Full Bathroom W/Quartz Countertop & Undermount Sink! HERS Energy Rated & Tank-less Gas Water Heater! Smart Home Automation which allows you to control your home from anywhere W/The Amazon Eco Dot! No Flooding! Amenity Center w/Pool, Lap Pool, Water Slides, Pavilion, Playground, Soccer Fields & more!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Caldwell Ranch Lot: 10 Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665583889' WHERE `Matrix_Unique_ID` = '213517612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-12T05:29:10.107' ,`MLSNumber` = '21650297' ,`ListAgentFullName` = 'Laura Varley' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514075' ,`Longitude` = '-95.051851' ,`PhotoCount` = '23' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade View' ,`StreetNumber` = '525' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully well kept, spacious single story in the Lakes of South Shore Harbour on a cul de sac lot. Well manicured yard. Four Bedrooms, three baths, office/study, formal dining, Media/Library, covered patio, 2.5 car garage, open floor plan lots of windows. New roof in 2021, recently painted. Walking distance to the neighborhood pool, tennis courts and park. Quick access to walking trails along the lakes. Great views of the lake also! Zoned to CCISD.' ,`Acres` = '0.2119' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE HARBOUR SEC SF70-3 (2008) ABST 18, BLOCK 1, LOT' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9232' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour Sec Sf70-3' ,`TaxAmount` = '9430' ,`TaxRate` = '2.4521' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665583890' WHERE `Matrix_Unique_ID` = '213540084' --> 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','213547398','1665583890','213547398','2022-10-12T05:57:32.377','26988820','Brent Herman','Upside Realty','','','29.888669','-95.556882','27','77040','4','949000.00','Active','Ginger','15628','Lane','Jersey Village','4','1','4','3005','Single-Family','WOW!!!! Beautifully renovated with panoramic lake views and massive side yard. House also boasts a huge basement perfect for entertaining, game room, man cave, workshop, etc. which is not included in published square footage. Come see this recently renovated, beautiful Lakeside Estates charmer!! Hurry, It won\'t last long!!!','0.5566','10','','','Gas Dryer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Jersey Village','Central Gas','0','LT 3 LAKESIDE ESTATES-CY-FAIR','Subdivision Lot','24244','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','JERSEY VILLAGE HIGH SCHOOL','COOK MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','3','Traditional','Lakeside Estates-Cy-Fair','11514','2.7758','Public Sewer,Public Water','1994','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','213568256','1665583890','213568256','2022-10-12T05:01:38.240','28986210','Beverly Bradley','Weekley Homes','','','29.923800','-95.755600','44','77433','7','452000.00','Active','Mesquite Flats','18427','Trail','Cypress','2','1','3','2366','Single-Family','Innovative room placement and sophisticated style combine to create The Beckley luxury home plan. Vibrant space and limitless potential make the open-concept floor plan a decorator’s dream. Create your ideal specialty room for good conversation and great books in the cheerful sunroom. The streamlined kitchen features a presentation island and plenty of room for collaborative feast creation. Your upstairs retreat provides a lively place for a family theater or a fun and games lounge. The lovely spare bedrooms include plenty of living and closet space to support growing minds and personalities. Escape to the spectacular Owner’s Retreat and its deluxe bathroom with enough closet space to expand your wardrobe. Livability enhancements include a downstairs powder room, extra garage storage space, and a breezy side porch. Your Home Team is ready to begin building this impressive new home plan.','','25','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Mud','1','','','Cypress South','Central Gas,Zoned','1','Lot 41 Block 01','Subdivision Lot','','Survey','','1284','1','To Be Built/Under Construction','2','Convection Oven,Gas Oven,Single Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Request Online Appointment,Vacant/Unoccupied','Builder','2','Traditional','Bridgeland','','3.57','Water District','','Builder'); --> New record created successfully