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-10T20:14:24.327' ,`MLSNumber` = '79233024' ,`ListAgentFullName` = 'Elaine Gerren' ,`ListOfficeName` = 'Integrity Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.531265' ,`Longitude` = '-96.700010' ,`PhotoCount` = '26' ,`PostalCode` = '77836' ,`RoomCount` = '2' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Alligator' ,`StreetNumber` = '600' ,`StreetSuffix` = 'Street' ,`City` = 'Caldwell' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 2-bedroom 1 bath home with hardwood floors. Large attached 3 car garage. Close to the schools.' ,`Acres` = '0.1377' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S1500 CITY OF CALDWELL BLK 10A LOT 5 0.1377 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '209 - Caldwell' ,`SchoolElementary` = 'CALDWELL ELEMENTARY SCHOOL (CALDWELL)' ,`SchoolHigh` = 'CALDWELL HIGH SCHOOL' ,`SchoolMiddle` = 'CALDWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'City Of Caldwell' ,`TaxAmount` = '1572' ,`TaxRate` = '2.1939' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675112002' WHERE `Matrix_Unique_ID` = '210456310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T19:56:12.047' ,`MLSNumber` = '52022356' ,`ListAgentFullName` = 'Blanca Resendez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573203' ,`Longitude` = '-95.250877' ,`PhotoCount` = '24' ,`PostalCode` = '77089' ,`RoomCount` = '8' ,`ListPrice` = '420069.00' ,`Status` = 'Active' ,`StreetName` = 'Matilda Gardens' ,`StreetNumber` = '1969' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2759' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Meritage Home Pearl plan with upgrades including extended covered patio, bay window in primary bedroom, fireplace in the family room. Additional upgrades include beautiful mud room wood bench shelf by garage door entrance, crown molding and chair railing throughout the first floor, custom built in bookshelf cabinet in den, primary bedroom closet updated with custom wood cabinets with self closing drawers.' ,`Acres` = '0.1578' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 5 RIVERSTONE RANCH AT CLEAR CREEK SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone Ranch/Clear Crk Sec' ,`TaxAmount` = '9909' ,`TaxRate` = '3.6869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112002' WHERE `Matrix_Unique_ID` = '211149364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T20:05:00.637' ,`MLSNumber` = '54868499' ,`ListAgentFullName` = 'Buddy Novak' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.715377' ,`Longitude` = '-94.935113' ,`PhotoCount` = '32' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Beatty' ,`StreetNumber` = '905' ,`StreetSuffix` = 'Avenue' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2583' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large unique 5 BR 2 BA- 2,583\' square foot Historic home built in 1905 centrally located in downtown Livingston. Features a large kitchen, wonderful formal dining and den with Master BR & bath downstairs. 4 large bedrooms and another full bath upstairs. Has a 2 car carport and storage building. New Roof installed in 2021. AC was replaced 2018. This home is a Historic Landmark designated by the Polk County Heritage Society known as the \"Ray Brock\" home. Come take a look and own a slice of History! The potential of this home is unlimited!' ,`Acres` = '0.303' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 15 M L CHOATE SURVEY SEC 1 SUB LOT 91' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '2276' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1905' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112002' WHERE `Matrix_Unique_ID` = '211261643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T20:18:10.770' ,`MLSNumber` = '20564842' ,`ListAgentFullName` = 'Kelly Willis' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.626772' ,`Longitude` = '-95.633962' ,`PhotoCount` = '48' ,`PostalCode` = '77498' ,`RoomCount` = '20' ,`ListPrice` = '841000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '519' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom home in the historic neighborhood, The Hill. This waterfront property boast a grand 2 story foyer with a private home office and beautiful formal dining room. A butler\'s pantry and walk-in pantry connect the dinning room to the heart of the home. The kitchen with its 9ft quartz island and gas cooktop are open to the family room and breakfast area with large windows giving you your waterfront view. The Primary suite features a large bath with quartz counters, separate shower and jetted tub, and his and hers custom closets. Up the beautiful spiral stairs you have 3 bedrooms w/walk in closets. A large game room with wet bar open to the media room perfect for entertaining. Bonus room upstairs can be used as gym, craft room, or library. Home is prewired for 8 cameras and 20+ speakers. Oversized 2 car and single detached garage and double wide driveway give you plenty of parking. Brand new Elementary school & historic Sugar factory museum all within walking distance.' ,`Acres` = '0.228' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '0097 S M WILLIAMS, ACRES 0.228' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9932' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'S M Williams' ,`TaxAmount` = '14588' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675112002' WHERE `Matrix_Unique_ID` = '211301660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T20:02:46.917' ,`MLSNumber` = '62989123' ,`ListAgentFullName` = 'Buddy Novak' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.755815' ,`Longitude` = '-95.035929' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '13' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Southcreek' ,`StreetNumber` = '453' ,`StreetSuffix` = 'Park' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Custom 3 BR, 3 BA home with large 3 car attached garage on 7 wooded acres in the highly sought after Four Corners subdivision. This 2,356 square feet home features a nice kitchen with lots of counter and cabinet space & walk-in pantry that contains a wine fridge. Home has a spacious master bedroom with walk in closets, jacuzzi tub and walk in shower. Living room has an Austin stone, wood burning fireplace. Home features an office and an extra/flex room. Engineered hard-wood floors and tile throughout. Lots of wildlife to view from your fully fenced backyard - whitetail deer, squirrels, ducks, and many variety of birds. Property has a half-acre pond stocked with both large/small mouth bass & perch. Great central location to Livingston, Onalaska, & Huntsville. Home has sprinkler system for the yard & water filtering system for the entire home. Bring the kids, pets, fishing poles, binoculars and come see this serene property in the middle of a forest - it will not disappoint!' ,`Acres` = '7.034' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOUR CORNER ESTATES LOT 51' ,`LotDesciption` = 'Subdivision Lot,Water View,Wooded' ,`LotSize` = '306401' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Four Corner Estates' ,`TaxAmount` = '6431' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112002' WHERE `Matrix_Unique_ID` = '213832267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T20:43:14.270' ,`MLSNumber` = '75474518' ,`ListAgentFullName` = 'Eric Haugen' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707388' ,`Longitude` = '-95.773547' ,`PhotoCount` = '37' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Springs' ,`StreetNumber` = '22747' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW carpet just installed January 2023! A \"must see\" luxurious Perry Home nestled in the elegant master plan community of Grand Lakes! Just minutes from Grand Parkway-99, Westpark 1093, and I-10, this 2,540 SqFt home has a Formal Dining Room, spacious garage, high 2-story ceilings in the Living Room, and an enormous backyard Covered Patio! You\'ll love the open floorplan and the layout of the Master Bedroom DOWNstairs, with the Game Room plus additional 3 bedrooms all UPstairs! Low tax rate of 2.46, Katy mailing address, zoned to Alexander Elementary, Beckendorff Junior High, and Seven Lakes High School! The community has pools, playgrounds, tennis courts, and lots of sidewalks and lakes to enjoy relaxing walks. Not on a Flood Plain and has NEVER flooded!' ,`Acres` = '0.1659' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES SEC 10, BLOCK 3, LOT 48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Sec 10' ,`TaxAmount` = '6810' ,`TaxRate` = '2.4613' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112003' WHERE `Matrix_Unique_ID` = '214238002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T20:00:52.057' ,`MLSNumber` = '39427772' ,`ListAgentFullName` = 'Buddy Novak' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704413' ,`Longitude` = '-95.086133' ,`PhotoCount` = '17' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayway' ,`StreetNumber` = '126' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute clean 3BR with 1.5 baths in a great lakeside neighborhood. Super nice 2-1/2 car detached garage for the toys and boat. This is a perfect weekend, fulltime or investment property. Property has a brand new roof installed 4/2022. Home comes with a nice storage building for all your needs. If one clears all the brush in back could have a limited canal view of the Lake. Bring the kids, boats, fishing poles and come enjoy Lake Livingston' ,`Acres` = '0.3' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'BAY HAVEN SECTION 2 BLK 3 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Haven #2' ,`TaxAmount` = '1714' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112003' WHERE `Matrix_Unique_ID` = '214697378' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T19:00:38.140' ,`MLSNumber` = '76963350' ,`ListAgentFullName` = 'Rodrigo Avila' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.268733' ,`Longitude` = '-95.122411' ,`PhotoCount` = '41' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 3749d' ,`StreetNumber` = '21694' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New MODEL FLEETWOOD HOME, 3 BEDROOM 2 BATHS spend relaxing evenings, this property is close to nature parks, COVER PATIO, LAMINATE FLOORING THROUGH-OUT, LAUNDRY ROOM INSIDE, FEATURE WALL IN LIVING, MASTER & MASTER BATH, WALK-IN CLOSET, MASTER BATH DOUBLE SINK, TUB / SHOWER, NEW KITCHEN APPLIANCES, LED CAN LIGHTS, PROPERTY IS LOCATED ON A QUIET STREET, NO RESTRICTIONS, NO HOA AND NO FLOOD ZONE.' ,`Acres` = '0.5' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTHERN CROSSING, SEC 5, LOT 40, ACRES 0.5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Southern Crossing, Sec 5' ,`TaxAmount` = '297' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675112003' WHERE `Matrix_Unique_ID` = '214815957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-10T19:25:35.027' ,`MLSNumber` = '58512584' ,`ListAgentFullName` = 'Amanda Johnson' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577646' ,`Longitude` = '-95.126335' ,`PhotoCount` = '29' ,`PostalCode` = '77062' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Seahorse' ,`StreetNumber` = '15406' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'As soon as you walk into this house it feels like home!! This home is immaculate, it has been beautifully renovated and feels very up tp date. The family, dining and kitchen all flow very well, all of the natural light make it feel very open and has a great utilization of space. The bay windows over looking the pool from the breakfast area give a perfect amount of light and visibility of the pool from the kitchen to keep an eye on those kiddos or still be part of the fun! The back yard has plenty of green space for the four legged family members, plenty of room to BBQ and lay out in your new back yard oasis.' ,`Acres` = '0.1937' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 6 OAKBROOK WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8439' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CLEAR LAKE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakbrook West Sec 03' ,`TaxAmount` = '6844' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675112003' WHERE `Matrix_Unique_ID` = '214920333' --> 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','215406972','1675112004','215406972','2023-01-10T19:40:11.237','3702907','Madeline Franqui','REALM Real Estate Professional','','','29.696132','-95.437073','7','77025','9','1989000.00','Active','Drummond','3762','Street','Houston','5','1','5','4836','Single-Family','Beautiful transitional style home on a great corner lot. Spacious streets and walking distance to Mark Twain elementary school and parks nearby. Conventional stucco (w/ added rain screen for moisture prevention) and Hardie siding. Open concept living, dining, and kitchen. Downstairs has a large guest/flex room & bath with an option for future kitchen(pre wired & plumbed) and it has a separate entrance. Front closet is prepped for future wine room option & could open from dining rm. Tile and wood flooring, quartz countertops, high ceilings, front porch. Covered side patio that opens to large side yard with an outdoor kitchen. Room for a future pool.','','17','LINEA','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gaslog Fireplace','1','Braeswood Place','Central Gas','0','LT 31 BLK 27','Corner','8875','Appraisal District','','','1','To Be Built/Under Construction','2','Double Oven','0','','','Gas Cooktop','','Composition','27 - Houston','TWAIN ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Builder','2','Contemporary/Modern','Braes Heights','','','Public Sewer,Public Water','2022','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','215973288','1675112004','215973288','2023-01-10T19:04:03.680','34701909','Heather Coggin','eXp Realty, LLC','','','30.483074','-94.758180','17','77327','1','40000.00','Active','R 2721','428','','Cleveland','0','0','0','','Single-Family','Property is being sold at land value only, sold \"as is\" no information available on the conduction of any of the improvements that have been made on the property, land is off of an asphalt road. Beautiful trees throughout this fulling fenced property. Looking for a weekend getaway or ready for full time country living with nearby fishing','0.574','52','','','','','No Disclosures','','','','Liberty County East','No Heating','0','BIG THICKET LAKE ESTATES, LOT 239 240 241 242 SEC 18, ACRES','Wooded','25003','Appraisal District','','','0','','','','0','','','','','Other','107 - Hardin','HARDIN ELEMENTARY SCHOOL','HARDIN HIGH SCHOOL','HARDIN JUNIOR HIGH SCHOOL','Vacant/Unoccupied','','0','Other Style','Big Thicket Lake Estates','27','1.5764','Public Water,Septic Tank,Well','',''); --> 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','216135881','1675112004','216135881','2023-01-10T20:38:26.600','63004525','Michaelle Wiggins','NW Realty','','','29.383861','-94.976370','19','77591','4','475000.00','Active','Norton St','5722','Street','Texas City','2','1','4','2344','Single-Family','Welcome Home to 5722 Norton St! This unique ranch style home sits cozy on approximately 1/2 an acre. You will arrive to find 4 bedrooms and 2.5 baths. ALL APPLIANCES INCLUDED, OVERSIZED garage, BAR, flex room, office and workshop. This property boasts 6 beautiful mature oak trees, fully fenced and secluded. It offers plenty of parking for boats, RV and additional vehicles. No HOA, NO MUD and NO neighbors. Bring ALL your horses and other farm friends to enjoy a relaxing lifestyle. Just minutes from Interstate-45, expressway, shopping, dining, gym facility, College of the Mainland, Bayou Golf Course, Galveston Beaches and Texas City dike.','0.4656','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Texas City','Central Electric','0','ABST 197 T TOBY SUR PT OF LOT 4 (4-2) WILLIAM BELL SUB','Cleared,Cul-De-Sac,Wooded','20280','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Wood Shingle','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Lockbox Right Side','Appraisal District','1','Other Style,Ranch,Traditional','Bell Wm','4086','2.491','Public Sewer,Public Water','1986','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','216189589','1675112004','216189589','2023-01-10T19:50:10.633','53970934','Carol Cantu','Houston Preferred Properties','','','29.818205','-95.175880','34','77049','12','275000.00','Active','Berncrest','14914','Lane','Houston','3','0','5','2275','Single-Family','Welcome to this incredible townhome located in a gated community right off the Beltway and minutes from Downtown Houston. This remarkable 2 story 5 bedrooms townhome is a must see with hardwood floors running throughout the first floor, tile in the bathrooms, entryway and in the kitchen. Plenty of cabinet space for all your dishes in the kitchen with a walk in pantry, gas range, and microwave. Livingroom is separated from the kitchen by a high stool bar. Spacious primary suite upstairs includes double sinks, glass shower, soaker tub and a large walk in closet. The laundry room is conveniently located upstairs where the majority of the bedrooms are located. All bedrooms are equipped with ceiling fans. Carpet is a neutral color and all walls are freshly paint. Just like New! The backyard features an over-sized patio, room for entertaining. Never has flooded. Move in Ready!','0.0909','2','H Kovnanian','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','','','','North Channel','Central Gas','1','LT 27 BLK 1 NEW FOREST WEST SEC 3','Subdivision Lot','3958','Appraisal District','','125','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','21 - Galena Park','DR SHIRLEY J WILLIAMSON ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Lockbox Front,No Appointment Required,Vacant/Unoccupied','Appraisal District','2','Traditional','New Forest West Sec 03','6483','2.9394','Public Sewer,Public Water','2008','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','216235615','1675112004','216235615','2023-01-10T19:01:50.427','60659933','Jared Turner','LennarVillageBldr-JaredTurner','','','29.844439','-95.845174','6','77493','8','350000.00','Active','Tan Briar','4934','Drive','Katy','2','0','4','1908','Single-Family','NEW! Village Builders Bristol Collection \'Donovan\' Plan with Elevation B in Sunterra! This delightful single-story home has a comfortable layout that offers endless possibilities. Three bedrooms share a full bathroom at the front of the home. Down the hall is the open concept living area which features a kitchen, dining room and family room with access to a covered patio. Tucked into the back corner of the home is the owner’s suite which includes a full bathroom and walk-in closet. Virtual tour is a representation of the floor plan and not of the actual home. **ESTIMATED COMPLETION APRIL 2023**','','25','Village Builders','','','','Mud,Other Disclosures','','','','Katy - Old Towne','Central Gas','1','SEC 0017 BLK 003 LOT 009','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','2','','0','','','','','Composition','30 - Katy','MCELWAIN ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sunterra','','','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216241841','1675112004','216241841','2023-01-10T19:32:46.540','46677212','Jared Turner','LennarVillageBldr-JaredTurner','','','30.164062','-95.190639','10','77357','7','225000.00','Active','Masella Ridge','20858','Drive','New Caney','2','0','3','1248','Single-Family','NEW Cottage Collection \'\'Mayfield II\" Elevation-B by Lennar in Gorgeous Tavola! This single-story home is designed for low-maintenance living with generous room to grow. Upon entry is an open-concept family room that flows to the connecting dining room and kitchen in a cohesive layout, ideal for modern living and entertainment. On the opposite side is the private owner’s suite with an adjoining full-sized bathroom and two secondary bedrooms for restful retreats. Completing the home is a two-car garage. **Home Estimated to be Complete, April, 2023**','','40','Lennar Homes','','','','Mud,Other Disclosures','1','','','Porter/New Caney East','Central Gas','1','SEC 0046 BLK 001 LOT 014','Subdivision Lot','','','','800','1','To Be Built/Under Construction','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Tavola','','3.5826','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216245553','1675112004','216245553','2023-01-10T19:34:16.143','11662868','Jared Turner','LennarVillageBldr-JaredTurner','','','30.194267','-95.210435','28','77357','7','305000.00','Active','Birchfield Grove','22118','Lane','New Caney','2','0','3','2086','Single-Family','NEW! Lennar Wildflower Collection \"Hanover II-B\" Plan in Pinewood at Grand Texas! This amazing single-story home has a modern open living area that invites gathering, along with a covered patio for outdoor leisure. Two bedrooms and a study offer versatility near the entry, while the primary suite is tucked in the back corner for added privacy, complete with a luxe bathroom and walk-in closet.\r\n**Home Estimated to be Complete, February, 2023**','','40','Lennar Homes','','','','Mud','','','','Porter/New Caney West','Central Gas','1','SEC 0002 BLK 004 LOT 017','Subdivision Lot','','','','500','1','To Be Built/Under Construction','2','','0','','','','','Composition','47 - Splendora','TIMBER LAKES ELEMENTARY SCHOOL','SPLENDORA HIGH SCHOOL','SPLENDORA JUNIOR HIGH','Accompany,Appointment Required','Builder','1','Traditional','Pinewood at Grand Texas','','3.35','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216256041','1675112004','216256041','2023-01-10T19:42:14.020','97612126','Jared Turner','LennarVillageBldr-JaredTurner','','','30.164029','-95.190662','10','77357','8','310000.00','Active','Sonora Chase','19095','Drive','New Caney','2','0','4','1932','Single-Family','NEW! Lennar Homes Wildflower Series, \'\'Clover II\'\' Plan with Elevation \'\'C\" in Beautiful Tavola! Fantastic Single Story with 4 Beds/2 Baths/2 Car Garage! Entry Foyer opens to a roomy Family Room/Dining Room/Kitchen and a Large Study or Flex Room! Amazing Kitchen w/ 36\'\' Designer Cabinets, Sparkling Countertops, Island/Breakfast Bar, & Great Appliance Pkg! Master Bedroom has Master Bath with Shower and Walk-in Closet! Lovely and Resilient Hard Surface Flooring in Main & Wet Areas. Walk-in Utility Room! Covered Patio, Fully Sodded Yard, Landscape Pkg! Energy Efficient w/ 16 SEER HVAC System & MORE!','','40','Lennar Homes','','','','Mud','1','','','Porter/New Caney East','Central Gas','1','SEC 0041 BLK 004 LOT 006','Subdivision Lot','','','','800','1','To Be Built/Under Construction','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Tavola','','3.5826','Public Sewer,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216258547','1675112004','216258547','2023-01-10T19:40:09.350','83963725','Jared Turner','LennarVillageBldr-JaredTurner','','','29.837056','-94.991262','6','77521','8','320000.00','Active','Stoney Terrace','4711','Trail','Baytown','2','0','3','2093','Single-Family','BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Wildflower IV Collection Homes in Sterling Point! The Poppy, Elevation \"A\" is a single-level home that features a spacious open floorplan where the kitchen, nook and family room flow into one another for seamless family-style living and entertaining. A covered patio is ideal for enjoying mild-weather afternoons with a good book or meal. Double doors open up to a versatile study, while three bedrooms provide plenty of space for the household. Among the bedrooms, the owner’s suite is a restful sanctuary with a cozy bedroom, an en-suite bathroom and a walk-in closet.\r\n**Estimated Completion Date, May 2023**','','2','Lennar Homes','','','','Mud,Other Disclosures','','','','Baytown/Harris County','Central Gas','1','SEC 0003 BLK 001 LOT 003','Subdivision Lot','','','','950','1','To Be Built/Under Construction','3','','0','','','','','Composition','23 - Goose Creek Consolidated','PUMPHREY ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Sterling Point','','3.68','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216258820','1675112004','216258820','2023-01-10T19:38:57.140','53983840','Jared Turner','LennarVillageBldr-JaredTurner','','','29.840524','-94.991075','6','77521','10','330000.00','Active','Allendale Arbor','4819','Trail','Baytown','3','1','5','2721','Single-Family','BRAND NEW LENNAR Community - STERLING POINT!!! New Lennar Wildflower II Collection Homes in Sterling Point! The Dewberry II, Brick Elevation \"B\" is a two-story home that offers an inviting foyer that flows into the family room with an adjoining breakfast nook. The open kitchen features bar seating and overlooks the family room. Nearby is the owner’s suite which includes an en suite bathroom large walk-in closet. Upstairs are more bedrooms, bathrooms and a game room.\r\n**Estimated Completion Date, May 2023**','','2','Lennar Homes','','','','Mud,Other Disclosures','','','','Baytown/Harris County','Central Gas','1','SEC 0001 BLK 003 LOT 047','Subdivision Lot','','','','950','1','To Be Built/Under Construction','2','','0','','','','','Composition','23 - Goose Creek Consolidated','PUMPHREY ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Sterling Point','','3.68','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216262130','1675112004','216262130','2023-01-10T19:30:07.923','75503131','Matthew Guzman','RE/MAX Universal','','','30.137111','-94.906743','6','77535','12','383325.00','Active','Road 6615','163','','Dayton','2','1','4','2293','Single-Family','PLEASE SEE 3D SAMPLE VIRTUAL TOUR! 1.66 LOW TAXES!!! 24 HOUR/7 DAYS A WEEK MANNED GUARD GATE!!!! NO FENCES HERE!!!!! Beautiful 2 Story, The Kempton Floor Plan with 4 Bedrooms, 2 1/2 Baths, with a 3 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, Half Bath, and the Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms with a full Bath. Tile and Carpet flooring. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, black appliances, and even a USB outlet. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Aerobic Septic System, Community Well, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Do not wait! Call now for your private tour.','0.689','52','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','Wood Burning Fireplace','1','Dayton','Central Electric','1','ENCINO ESTATES, SEC 2, BLOCK 8, LOT 2, ACRES 0.689','Cleared','30013','Appraisal District','','450','1','To Be Built/Under Construction','3','Electric Oven','0','','','Electric Range','','Composition','74 - Dayton','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Appraisal District','2','Traditional','Encino Estates','854','1.6575','Public Sewer,Public Water,Septic Tank','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216263245','1675112004','216263245','2023-01-10T20:50:48.247','74004233','Pamela Roth','Roth & Company Real Estate','','','29.906704','-95.721324','39','77433','11','385000.00','Active','Creekdale Bend','20359','Drive','Cypress','2','1','3','2472','Single-Family','FANTASTIC 3 bedroom 2 1/2 bath home nestled inside the highly sought after Miramesa community in Canyon Lakes West. The kitchen features granite countertops, stainless steel appliances, dining/breakfast area, and a huge island for those large gatherings. The spacious living room has a bay of windows to the backyard which has no backyard neighbors! The first floor primary bedroom is generous in size. The primary en suite has a relaxing soaking tub and separate shower. It also has dual sinks and a fantastic size primary closet. Upstairs you will find 2 more spacious bedrooms with large walk in closets. The ginormous game room is sure to be an entertainment hot spot or a quite place to read and study. The home is compatible with Amazon Alexa voice control. The home is zoned to top rated Cypress-Fairbanks schools. The community boasts pools, splashpads, walking trails, and a club house. With quick access to major highways, shopping, entertainment, and dining - it is a must see!','0.1291','25','Lennar','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Cypress South','Central Gas','1','LT 19 BLK 1 MIRAMESA SEC 9','Subdivision Lot','5625','Appraisal District','','1000','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','POSTMA ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Miramesa at Canyon Lakes West','8477','3.041','Water District','2019','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','216264062','1675112004','216264062','2023-01-10T20:49:02.170','87144374','Mohammad Khatri','G+A Real Estate','','','29.528529','-95.753743','50','77469','8','419990.00','Active','Whitewing Rd','6120','','Rosenberg','2','1','4','2700','Single-Family','Brand New, never been lived-in house that is Conveniently located by Highway 59 and Bryan Rd. Forma living upon entering the house with carpet floor. Powder room downstairs for the guests. 4 bedrooms, 2.5 baths with a Primary Bedroom downstairs. Separate family room and dining room next to the kitchen.3 large bedrooms upstairs with a game room. Kitchen with SS appliances and lots of cabinets. Huge Corner lot for entertainment. Call today to schedule an appointment.','','30','KB Homes','','','','Mud,Sellers Disclosure','1','','0','Fort Bend South/Richmond','Central Gas','1','Bryan Crossing Sec 3, BLOCK 2, Lot 1','Corner,Subdivision Lot','','Appraisal District','','650','1','Never Lived In','2','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','ARREDONDO ELEMENTARY SCHOOL','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern,Traditional','Bryan Crossing','','','Water District','2022','Appraisal District'); --> New record created successfully