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` = '2023-01-21T20:16:44.127' ,`MLSNumber` = '68764500' ,`ListAgentFullName` = 'Fiona Farhad' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000932' ,`Longitude` = '-95.478563' ,`PhotoCount` = '50' ,`PostalCode` = '77068' ,`RoomCount` = '6' ,`ListPrice` = '336000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Oak' ,`StreetNumber` = '3118' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular, 3 bed and 2.5 bath with office, brick home located on a large cul-de-sac lot. This home welcomes you with fresh paint as well as hardwood and tile flooring throughout. Two (2) new AC units installed. Granite countertops in the kitchen with a recently replaced dishwasher. Enjoy the double sided fireplace or soak in the jetted tub. Large closets provide ample storage space. High ceilings and multiple windows allow plenty of natural light. Nice covered patio. Convenient location with easy access to highways, airport, restaurants, shopping, and activities such as golf and trails. House located walking distance to gorgeous private park. The private park has several oak trees & one is over 150 years old! This park is exclusive and only shared by residence of this small community. You must see in person to appreciate. BRAND NEW ROOF WITH A 30 YEAR WARRENTY!!!' ,`Acres` = '0.1246' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 1 OAKTREE PLACE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5429' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1386' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oaktree Place' ,`TaxAmount` = '6112' ,`TaxRate` = '2.3299' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217246' WHERE `Matrix_Unique_ID` = '210337890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T19:58:00.550' ,`MLSNumber` = '74414771' ,`ListAgentFullName` = 'Cyndi De Palermo' ,`ListOfficeName` = 'Red Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.380388' ,`Longitude` = '-95.097782' ,`PhotoCount` = '39' ,`PostalCode` = '77510' ,`RoomCount` = '13' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Castle' ,`StreetNumber` = '4003' ,`StreetSuffix` = 'Drive' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live Like Royalty! Gorgeous 3-bedroom, 3-bathroom home located in the highly sought-after neighborhood of Castle Estates. Located on an end street lot there is ample parking with a stately circle drive out front and an extra wide driveway at the double car garage. This home boasts high ceilings and a large gourmet kitchen with a functional island and eat-at bar. The gorgeous master suite connects to your office or sitting area and offers a private exit onto the patio and pool area. A game/flex room also provides a second exit to fun in the sun on the patio, in the pool, or around the tiki bar. A full bath located within the garage helps keep those wet summer footprints out of the house. This home truly provides all the space needed for fun and relaxation with friends or family, inside or out, the choice is yours. Updates include new paint interior and exterior, updated primary bath, updated kitchen backsplash, new attic insulation, LED light fixtures and landscaping all in 2022.' ,`Acres` = '0.2479' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 47 L CRAWFORD SUR LOT 1 BLK 7 CASTLE ESTATES PHASE 3' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '174' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Castle Estates Ph 3 98' ,`TaxAmount` = '7291' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217246' WHERE `Matrix_Unique_ID` = '210894813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T20:06:42.747' ,`MLSNumber` = '44515258' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219259' ,`Longitude` = '-95.353196' ,`PhotoCount` = '39' ,`PostalCode` = '77378' ,`RoomCount` = '10' ,`ListPrice` = '420123.00' ,`Status` = 'Active' ,`StreetName` = 'Clementine Hall' ,`StreetNumber` = '14514' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Make lasting memories in this stunning Beazer home in the new master-planned community of Mavera, which boasts tile flooring, an open great room, a spacious primary suite, and an extended covered patio in a yard lacking neighbors to the rear. No recipe is a challenge in the kitchen, complete with quartz countertops, mosaic backsplash, large cove molding, 30” cooktop, 42” upper cabinets, and pendant lighting. Community comforts include a playground, clubhouse, pocket parks, greenbelt trails, a pool, and a splash park. Situated just off I-45, and SH 242, commuters enjoy easy access to nearby popular dining, shopping, and entertainment at Market Street and The Woodlands Mall. Zoned to the highly acclaimed Conroe ISD. Don’t miss your chance – call today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217246' WHERE `Matrix_Unique_ID` = '212334855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T20:06:10.220' ,`MLSNumber` = '56974096' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218674' ,`Longitude` = '-95.353694' ,`PhotoCount` = '48' ,`PostalCode` = '77378' ,`RoomCount` = '14' ,`ListPrice` = '450414.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemary Hill' ,`StreetNumber` = '15750' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Be entranced by this beautiful Beazer home in the new master-planned community of Mavera, featuring tile flooring, wrought iron spindles, a study with French doors, an open great room, a spacious primary suite, and an extended covered patio. Entertain your guests in the kitchen, fully equipped with quartz countertops, a mosaic backsplash, a 30” cooktop, and pendant lighting. Community comforts include a playground, clubhouse, pocket parks, greenbelt trails, a pool, and a splash park. Situated just off I-45, and SH 242, commuters enjoy easy access to nearby popular dining, shopping, and entertainment at Market Street and The Woodlands Mall. Nearby schools are a part of the highly acclaimed Conroe ISD. There’s no time to lose – call today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217247' WHERE `Matrix_Unique_ID` = '212334891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T19:34:55.233' ,`MLSNumber` = '68778113' ,`ListAgentFullName` = 'Jane Draughon' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436795' ,`Longitude` = '-94.912903' ,`PhotoCount` = '29' ,`PostalCode` = '77590' ,`RoomCount` = '7' ,`ListPrice` = '484000.00' ,`Status` = 'Active' ,`StreetName` = 'Brigantine Cay' ,`StreetNumber` = '5314' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a casual, carefree lifestyle in a vacation atmosphere in beautiful Grand Cay Harbour. This stunning canal front property has a private dock and easy access to the Gulf. The covered patio and deck, with heated spa, are perfect for entertaining. The family room, which has a cozy corner gas log fireplace, is open to the kitchen which features a massive granite island, stainless steel appliances. five burner gas cooktop, and plenty of cabinets. Other unique features include wood look tile & tray ceiling w/ crown molding in family room and prim. bedroom. Just off the foyer is a study which could also be used as a dining room or game room. The primary suite has a great view of the water with a soaking tub, large shower, and a long granite counter top w/ lots of cabinets and dual sinks. Other unique features are the built-in aquarium, mud room & three car garage w/ automatic back garage door w/ room for a workshop.' ,`Acres` = '0.152' ,`Area` = '33' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND CAY HARBOUR SEC 2 (2007) ABST 4, BLOCK 2, LOT 63, ACRE' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6638' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1083' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Cay Harbour Sec 2 2007' ,`TaxAmount` = '14854' ,`TaxRate` = '3.4335' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217247' WHERE `Matrix_Unique_ID` = '213082088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T20:31:30.100' ,`MLSNumber` = '5040313' ,`ListAgentFullName` = 'Maria Navejas' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.169945' ,`Longitude` = '-95.173081' ,`PhotoCount` = '47' ,`PostalCode` = '77357' ,`RoomCount` = '17' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Athens Drive' ,`StreetNumber` = '1810' ,`StreetSuffix` = '' ,`City` = 'Roman Forest' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2 story brick home on a huge lot featuring 4 bedrooms, 3.5 Bathrooms, 2 car garage plus a long driveway. This home not only has great front porch appeal with a covered patio of 24x7 but it also has an open layout perfect for hosting events with 10 ft ceilings, 8ft doors & a fireplace. The kitchen is equipped with a walk in pantry, quartz countertops, pot filler, stainless steel appliances, 30 inch gas range, under cabinet lighting & soft close drawer/cabinets. The spacious primary suite has a separate tub & shower with granite countertops. Try not to get lost in the spacious primary walk in closet with built ins. Second bedroom on 1st floor is an en-suite with a private bathroom with walk in closet, room could be used as the office/study. Now we head upstairs to the 2 bedrooms with more walk in closets plus the game room. Additional feature includes a covered back porch measuring 14x15. Located within a 30 minute drive to The Woodlands & Minute Maid Park.' ,`Acres` = '0.5941' ,`Area` = '40' ,`BuilderName` = 'BT Grace Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01, BLOCK 5, LOT 76' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '25879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '1241' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217247' WHERE `Matrix_Unique_ID` = '213789743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T20:37:19.000' ,`MLSNumber` = '34032762' ,`ListAgentFullName` = 'Retha Anderson' ,`ListOfficeName` = 'Owning The Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879012' ,`Longitude` = '-95.471061' ,`PhotoCount` = '22' ,`PostalCode` = '77088' ,`RoomCount` = '5' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Turfwood' ,`StreetNumber` = '5607' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2375' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 7 INWOOD FOREST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '298' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Inwood Forest Sec 15' ,`TaxAmount` = '4458' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217247' WHERE `Matrix_Unique_ID` = '214828892' --> 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','215220550','1675217248','215220550','2023-01-21T20:28:58.410','96711064','Jennifer Parks','Doug Erdy Group','','','29.925805','-95.294364','16','77396','3','159000.00','Active','Laramie','6314','Street','Humble','1','0','3','1024','Single-Family','Beautiful home in the greater Humble area with beautiful scenic backyard! NO HOA! Spacious kitchen and open living area. This charming home is nestled within a mature & quiet community, yet perfectly located 3 minutes from HWY 59 and beltway 8. Close to IAH, Metro, Lonestar, & quick commute to downtown Houston destinations. Family owned property, well maintained & offers the option to purchase the neighboring duplex property.(MLS #94977975) Home is fully fenced making it secure for pets and children- NEW exterior paint as well as NEW interior paint from ceilings to baseboards boasting a neutral color pallet - Lots of cabinet space, NEW exterior lighting, NEWer shower, ample parking space, detached outdoor storage space/shed in backyard. STAY DRY & COZY and ENJOY OUTDOOR LIVING- under the front covered patio W/ newly stained wood deck, wooden walkway and pergola. Together they make a great space to entertain guests, friends and family! Don\'t miss out on this wonderful opportunity!','0.1624','1','','','Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','0','','','Humble Area South','Space Heater,Wall Heater','0','LT 208 BLK 10 HUMBLE ROAD PLACE','Cleared,Subdivision Lot','7074','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','1 - Aldine','JOHNSON ELEMENTARY SCHOOL (ALDINE)','MACARTHUR HIGH SCHOOL (ALDINE)','ALDINE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Temporarily No Showings,Vacant/Unoccupied','Appraisal District','1','Ranch,Split Level,Traditional','Humble Road Place','1155','2.1553','Septic Tank,Well','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','215551313','1675217248','215551313','2023-01-21T20:11:22.603','51843538','Kimberly Handley','Coldwell Banker Realty','Lourdes Reynolds','Southern Style Realty','30.037706','-95.219610','50','77339','10','355000.00','Option Pending','Deer Springs','2223','Drive','Houston','3','1','4','2697','Single-Family','Rare find in the sought-after neighborhood in the front of Kingwood. Beautiful 4 bedroom, 3.5 bath home features split formals off the foyer, tile and hardwood floors throughout, spacious den,and gas-log fireplace. Kitchen has granite counters, stainless steel appliances with double oven, gas cook top, and dishwasher, with soft close drawers and separate breakfast room. Master on main level, master bath with granite counters, dual sinks, his and hers closets. Outside you\'ll enjoy the covered rear patio with flagstone steps surrounding pool/spa with waterfall, no neighbors on one side. Close to shopping, eateries and Hwy 59 & the Grande Parkway. This home is a MUST SEE!','0.2525','32','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Kingwood West','Central Gas','1','LT 14 BLK 30 TRAILWOOD VILLAGE SEC 4','Subdivision Lot,Wooded','11000','Appraisal District','','440','0','','3','Double Oven','1','In Ground','','Electric Range','','Composition','29 - Humble','FOSTER ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Trailwood Village','9563','2.5839','Public Sewer,Public Water','1976','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','216383358','1675217248','216383358','2023-01-21T20:13:59.487','61662130','Joanna Xie','KingFay Inc','','','29.652681','-95.587326','43','77477','8','286000.00','Active','Meadowdale Drive','11931','Drive','Meadows Place','2','0','3','1841','Single-Family','This beautiful one-storied house is located in Meadows subdivision and in Fort Bend County. Excellent access to Hwy 59, Hwy 90, Hwy 6 and Beltway 8! All windows are replaced since 1 year ago in 2022! New roofing is completed since Nov 2019! A lot of features and functions for this beautiful home! Take a look at this heart beating home and schedule a tour!','0.1892','29','','','Gas Dryer Connections','','Sellers Disclosure','1','','','Stafford Area','Central Gas','0','THE MEADOWS SEC 2, BLOCK 15, LOT 1','Corner','8240','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','MEADOWS ELEMENTARY SCHOOL (FORT BEND)','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Meadows Sec 2','2948','2.4949','Public Sewer,Public Water','1971','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','216634264','1675217248','216634264','2023-01-21T19:16:29.553','20625198','Roger Alvarez','RE/MAX Fine Properties','','','29.473835','-95.040179','19','77539','7','200000.00','Active','30th','4711','Street','Dickinson','2','0','3','1170','Single-Family','Wonderful property! long driveway mainly brick home with a covered patio at back. home features 3 bedrooms, 2 full baths, an updated kitchen with granite countertops, gas connection for a gas stove, tile flooring, a dining area next to the kitchen, great living area with tiles, good size backyard, updated bathrooms with shower only, tile flooring, granite countertops and cabinets. There is a storage shed in the backyard. You must see this home!','0.2066','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','0','','0','Dickinson','Central Gas','0','ABST 78 R HALL LOTS 16-17 & 18 BLK 230 WILLOW BEND S/D OUT O','Subdivision Lot','9000','Appraisal District','','','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','17 - Dickinson','SILBERNAGEL ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Nicholstone','2826','2.4615','Public Sewer,Water District','1976','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','216634782','1675217248','216634782','2023-01-21T19:36:06.133','86127768','Patrick Ashiofu','REALM Real Estate Professional','','','29.742974','-95.470016','0','77056','9','1099000.00','Active','Meadow Lake','5403','Lane','Houston','3','1','4','3272','Single-Family','','0.3776','22','','','','','Sellers Disclosure','','','1','Galleria','Central Gas','1','LT 3 BLK 3 DEL MONTE SEC 2','Corner','16450','Appraisal District','','360','0','','0','','0','','','','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Colonial,Contemporary/Modern','Del Monte Sec 02 Rep','26096','2.5304','Public Sewer,Public Water','1954','Appraisal District'); --> New record created successfully