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-09-05T15:13:07.110' ,`MLSNumber` = '62088761' ,`ListAgentFullName` = 'Lee DeForke Jr.' ,`ListOfficeName` = 'Lee DeForke Jr.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.324230' ,`Longitude` = '-94.941619' ,`PhotoCount` = '40' ,`PostalCode` = '77563' ,`RoomCount` = '7' ,`ListPrice` = '542000.00' ,`Status` = 'Active' ,`StreetName` = 'Warsaw' ,`StreetNumber` = '619' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for summer fun and boating, this wonderful home has all you need for family and friends. Large open concept with living room, dining room and kitchen open to one another. Granite countertops, large pantry and lots of cabinet space. Plenty of windows for water views. Large party deck as well as pergola with bench seating for a number of guests and entertaining. Master suite has its own private balcony, private full bath and walk in closets. Enjoy the sunrises and sunsets from your private balcony off the master. Boat dock, lift and fish cleaning station, while the garage is set up for workshop and benches. . Do not miss this one.' ,`Acres` = '0.1056' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 619 NEW BAYOU VISTA ADDN 4B' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 4b' ,`TaxAmount` = '8916' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707111' WHERE `Matrix_Unique_ID` = '208728533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T14:52:54.347' ,`MLSNumber` = '15018763' ,`ListAgentFullName` = 'Ruben Magtoto' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928445' ,`Longitude` = '-95.281954' ,`PhotoCount` = '50' ,`PostalCode` = '77396' ,`RoomCount` = '11' ,`ListPrice` = '364900.00' ,`Status` = 'Active' ,`StreetName` = 'Ellis Springs' ,`StreetNumber` = '14334' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NESTLED ON PRIVATE CUL-DE-SAC...stunning Highland Home in family friendly neighborhood - close to school, parks, pool. Move in ready with tons of upgrade. Lovely, well maintained, 2-Story; open floor plan home. Gourmet Island Kitchen with lots of cabinets with granite countertops and breakfast bar opens to wonderful family room with high ceiling and fireplace. Large Formal Dining Room. Large Master Suite. Master Bath with double sinks. Secondary Bedrooms are a nice size. Covered back porched. Home has plenty of natural light. Recent neutral interior paint, new laminate flooring in first floor. Easy access to local shopping, schools, Hwy 59, Airport & Downtown Houston.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 2 FALL CREEK SEC 34' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '8955' ,`TaxRate` = '2.99' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707111' WHERE `Matrix_Unique_ID` = '209282245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T15:24:37.027' ,`MLSNumber` = '4231667' ,`ListAgentFullName` = 'Stephen Reed' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076339' ,`Longitude` = '-95.532580' ,`PhotoCount` = '43' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '499930.00' ,`Status` = 'Active' ,`StreetName` = 'Avalon Queen' ,`StreetNumber` = '21418' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate Home in Lakes of Avalon Village! Stunning floor plan with room to entertain, Wrought Iron Staircase, Study w/French Doors, Formal Dining, Large Family Room w/Gas Fireplace! HVAC system has been replaced in 2022, insulation added to attic for energy efficiency. Home features tons of upgrade and is close to like-new condition. An abundance of cabinet space, Breathtaking quartz countertops. Natural light engulfs the Breakfast room! Large Primary bedroom, En-Suite Bath, His & Her Vanities, Tub, Separate Shower & Large Walk-in Closet! Generously sized secondary bedrooms share a second bathroom, large vanity & dual sinks. Game Room upstairs for extra entertaining space, NEWER roof, Upgraded Ceiling Fans, Chandeliers & Light Fixtures. New Paint, Carpet and flooring throughout. Entertain your friends and family with your Large Private Backyard with a covered patio! No Rear Neighbors! Acclaimed Klein ISD, with quick access to the Grand Parkway HWY-99.' ,`Acres` = '0.151' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 LAKES AT AVALON VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Avalon Village Sec 1' ,`TaxAmount` = '6804' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707111' WHERE `Matrix_Unique_ID` = '209646367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T14:15:40.220' ,`MLSNumber` = '20955415' ,`ListAgentFullName` = 'Roman Rodriguez' ,`ListOfficeName` = 'Green Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162158' ,`Longitude` = '-95.203658' ,`PhotoCount` = '34' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Genova Bay' ,`StreetNumber` = '18877' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2139' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Property is occupied with a tenant until Oct 31st, 2023. Paying $1,800/month. No showings until executed contract* Come live in the wonderful Tavola community. This property is a spectacular 4 bed, 2.5 bath property located in New Caney, TX. This gorgeous property has great curb appeal, open concept layout, and tons of space. The home opens into a huge, open living area with great lighting and flows into the kitchen. Kitchen has trendy white cabinets with granite counter tops, pantry, and easy access to breakfast area and laundry room. Master bedroom is located on the first floor, has high soaring ceilings, and on-suite primary bathroom. Primary bathroom has dual sink vanity, stand up shower, soaking jet tub, and massive walk in closet. Upstairs has a large game room area with tons of natural light. Guest bedrooms are all well sized and each have great closet spaces. Huge guest bedroom with large dual sink vanity. Great fenced in backyard with no back neighbors.' ,`Acres` = '0.1148' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S921120 - TAVOLA 20, BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola 20' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707111' WHERE `Matrix_Unique_ID` = '210641465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T15:10:41.873' ,`MLSNumber` = '61835892' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858305' ,`Longitude` = '-95.774771' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Light Lane' ,`StreetNumber` = '23022' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1521' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The charming Fresno plan boasts a smartly designed layout with plenty of entertaining and private living space. At the heart of the home, an open-concept layout includes a great room—with access to an optional covered patio—a casual dining area and a spacious kitchen boasting a center island and pantry. Off the kitchen, you’ll enjoy access to three inviting secondary bedrooms, a full hall bath and a two-bay garage. Toward the back of the home, a secluded primary suite comes with a roomy walk-in closet and private bath. Conveniently located closed to shopping, dining, entertainment, and grocery. Easy access to major thoroughfares such as FM 529, I-10 and 99 Grand Parkway. Please schedule your showing today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 AURORA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707111' WHERE `Matrix_Unique_ID` = '211744737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T15:10:06.743' ,`MLSNumber` = '69225073' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858327' ,`Longitude` = '-95.774524' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Bright Light Lane' ,`StreetNumber` = '23014' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction home, never lived in 1-story 3 bedrooms, 2 bathrooms in a fast selling community that offers open floorplan perfect for entertainment. Kitchen features 42 in cabinetry, granite countertop, open to the casual dining room and the living room. Beautiful vinyl and tile flooring throughout the house. Conveniently located near major thoroughfares such as FM 529, I-10 and 99 Grand Parkway. Minutes away from shopping, dining, entertainment and grocery. Please schedule your showing today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 AURORA SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707112' WHERE `Matrix_Unique_ID` = '211744821' --> 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','211862012','1663707112','211862012','2022-09-05T14:08:26.143','69272884','Jennifer Thomas','Point of View Realty','','','29.370297','-94.976522','14','77568','4','125000.00','Active','Linden','1006','Street','La Marque','1','0','2','768','Single-Family','Cute Bungalow tenant occupied and awaiting its new owner. Easy access to I-45, College Of the Mainland or Galveston Island with No HOA. Granite Counters in Kitchen and Bath. Good sized lot, with partially fenced back yard.','0.1747','33','','','','','Other Disclosures,Sellers Disclosure,Tenant Occupied','0','','0','La Marque','Central Electric','0','ABST 150 J D MOORE SUR LOT 1 LINDEN STREET SUB','Cleared,Subdivision Lot','7612','Appraisal District','','','0','','0','Freestanding Oven','0','','','Freestanding Range','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Call Occupant,Controlled Access,No Photos/No Videos,No Supra Keybox,Request Online Appointment','Appraisal District','1','Traditional','Linden','2204','2.6428','Public Sewer,Public Water','1965','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211862187','1663707112','211862187','2022-09-05T14:16:42.540','47111515','Jennifer Thomas','Point of View Realty','','','29.386431','-94.914982','22','77590','5','155000.00','Active','2nd','1409','Avenue','Texas City','1','0','2','1134','Single-Family','Tenant Occupied investment opportunity! Great home located in the heart of Texas City with -in walking distance of TCHS, Stingaree Stadium, Natatorium and Convention Center. This home feature an attached 1 car garage with an additional 2 car detached in the back. Large Fence yard.','0.1716','33','','','','','Sellers Disclosure,Tenant Occupied','0','','0','Texas City','Central Electric','0','ABST 205 PAGE 3 LOT 12 BLK 8 WAYSIDE PLACE','Subdivision Lot','7475','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','KOHFELDT ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required,Call Occupant,Controlled Access,No Photos/No Videos','Appraisal District','1','Traditional','Wayside Place 1','3094','2.5335','Public Sewer,Public Water','1951','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','211932465','1663707112','211932465','2022-09-05T15:06:18.970','60403523','Erick Harbert','Realty Right','','','30.070365','-94.797735','12','77575','4','115000.00','Active','Travis','1504','Street','Liberty','2','0','4','1320','Single-Family','Amazing opportunity for a fixer-upper in the heart of Liberty that just needs some TLC. This home has solid bones and is ready to be finished out in the style and finishes that you desire. Home was originally setup as a 4bed 2 bath home. You can put it back together anyway you like. This home is perfect for a handyman, investor, contractor, etc. Fixed up homes nearby sell up to double the current asking price.','0.2273','52','','','','','Other Disclosures,Sellers Disclosure','','','','Liberty','No Heating','0','PARTLOW L-LIB, BLOCK 11, LOT 4, ACRES .2273','Subdivision Lot','9901','Appraisal District','','','0','','0','','0','','','','','Composition','73 - Liberty','LIBERTY ELEMENTARY SCHOOL (LIBERTY)','LIBERTY HIGH SCHOOL (LIBERTY)','LIBERTY MIDDLE SCHOOL (LIBERTY)','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Other Style','Partlow L-Lib','2150','2.6826','Public Sewer,Public Water','1970','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','212088763','1663707112','212088763','2022-09-05T14:12:17.430','89232911','Ashley Ruby','Walzel Properties','','','30.042506','-95.329203','32','77373','6','240000.00','Active','Brookgate','6627','Drive','Spring','2','0','3','1446','Single-Family','Beautifully remodeled 3 Bed 2 Bath home in a quiet neighborhood in Spring, Tx! Many upgrades for peace of mind including a BRAND NEW ROOF, New flooring throughout, New granite countertops in the Kitchen and Bathrooms! NEW fence to enclose the large and lovely backyard, come see this beauty!','0.1791','12','','','','','Sellers Disclosure','','','1','Spring East','Central Electric,Central Gas','1','LT 7 BLK 24 GREENGATE PLACE SEC 4','Subdivision Lot','7800','Appraisal District','','450','0','','2','','0','','','','','Composition','48 - Spring','ANDERSON ELEMENTARY SCHOOL (SPRING)','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch','Greengate Place Sec 04','4787','2.6867','Water District','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212187073','1663707112','212187073','2022-09-05T15:36:25.900','61947222','Karla Zermeno','RE/MAX RESULTS','','','29.645582','-95.125676','31','77505','5','425000.00','Active','Arcadia','7310','Drive','Pasadena','3','0','5','2766','Single-Family','This home has everything you could want in a one story! Located in DPISD, this home features 5 bedrooms, 3 full baths, formal dining, split floorplan, tile in all wet areas and wood floors throughout. In addition, this home is located on the corner and is walking distance to the community pool. DID I MENTION THE BACK YARD?? You will have an amazing space to entertain. Some other highlights include: New roof (2022), New fence (2022) New tankless water heater (2022)','0.1928','6','','','','','Sellers Disclosure','1','Gas Connections','1','Pasadena','Central Gas','1','LT 1 BLK 2 VILLAGE GROVE EAST SEC 1','Corner,Subdivision Lot','8400','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','16 - Deer Park','JP DABBS ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','FAIRMONT JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Village Grove East Sec 01','9360','2.8798','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212192414','1663707112','212192414','2022-09-05T14:30:20.577','82935803','Halima Obeid','HomeSmart','','','29.726862','-95.933438','29','77423','11','375000.00','Active','Timber Point','32655','Drive','Fulshear','2','1','5','2719','Single-Family','Great 4/5 Bedroom home in country style neighborhood of Vanbrooke. This home has 4 bedrooms and a bonus room with a connected bathroom could be used as a 5th bedroom or study. The home has great features inviting grey tone colors. The home has beautiful grey cabinets through out. The large formal dinning is just off the kitchen making it easier for entertaining. The breakfast nook has large windows with lots of light. The backyard has a large patio for summer entertaining and relaxation. This home has been very well kept and feels like a new home. Washer/Dryer and Refrigerator included. The neighborhood has easy access to FM 359, minutes from FM 1093 and I10. Schedule your appointment to view this gem of a home.','0.1281','30','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Fulshear/South Brookshire/Simonton','Central Gas','1','VANBROOKE SEC 1, BLOCK 5, LOT 15','Subdivision Lot','5578','Appraisal District','','800','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Vanbrooke Sec 1','7653','3.2948','Public Sewer,Water District','2018','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','212192977','1663707112','212192977','2022-09-05T14:50:44.197','38417035','Beverly Bradley','Weekley Homes','','','30.204470','-95.332360','10','77302','7','628208.00','Active','Candy Apple','15607','Street','Conroe','3','1','4','3294','Single-Family','Experience living at its finest in the remarkable comfort and style of The Leeward new home plan. Enjoy evening leisure and weekend social gatherings from the backyard paradise of your expansive outdoor living patio. Design your ideal lifestyle in the gorgeous, open concept living and dining area, featuring dramatic vaulted ceilings. The gourmand kitchen supports culinary adventures with its extended countertops and walk in pantry. Begin and end each day in your stunning owners retreat, which includes a luxurious bathroom and a deluxe walk in closet. The spare bedrooms provide walk in closets and a Jack-and-Jill bathroom, while the guest suite offers a private bathroom. Bonus features include a versatile study, spacious 4-car garage, and retreat.\r\n\r\n\r\nContact the David Weekley at ARTAVIA Team to learn about the amazing community amenities you’ll enjoy after moving into this lovely new home in Conroe, Texas!','','19','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Spring Northeast','Central Gas,Zoned','1','Lot 17 Block 05','Subdivision Lot','','Survey','','995','1','To Be Built/Under Construction','4','Convection Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Artavia','','3.19','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','212194993','1663707112','212194993','2022-09-05T15:57:09.673','32361357','Karla Zermeno','RE/MAX RESULTS','','','29.683797','-95.246928','34','77017','4','299900.00','Active','Cripple Creek','5230','Court','Houston','2','1','4','2694','Single-Family','Great location!!! This little gem is looking for a new owner! Located in HISD, this home features 4 bedrooms, 2.5 baths, HUGE living room, granite in kitchen, tile flooring throughout, both formals and a beautiful back yard with detached garage. In addition, you are minutes away from downtown, tons of shopping and restaurants.','0.2205','3','','','Washer Connections','','Sellers Disclosure','1','','1','Hobby Area','Central Electric','0','LT 6 BLK 3 MEADOWCREEK VLG 12 R/P EXTN','Subdivision Lot','9605','Appraisal District','','50','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','PATTERSON ELEMENTARY SCHOOL (HOUSTON)','CHAVEZ HIGH SCHOOL','STEVENSON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Meadowcreek Village 12 Rp & Ext','5739','2.3307','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully