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-14T12:42:12.907' ,`MLSNumber` = '44184268' ,`ListAgentFullName` = 'Evelyn Gordon' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836895' ,`Longitude` = '-95.289814' ,`PhotoCount` = '11' ,`PostalCode` = '77028' ,`RoomCount` = '5' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Hall' ,`StreetNumber` = '7629' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute house with well kept yard, Roof installed 2018. Has a large backyard for any upgrades. This property is Tenant occupied, temporarily no showings. Great investor special.' ,`Acres` = '0.1761' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 90 BLK 3 WEYBURN PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCGOWEN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Weyburn Place Sec 02' ,`TaxAmount` = '1647' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675134305' WHERE `Matrix_Unique_ID` = '206012528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T12:19:56.913' ,`MLSNumber` = '62453597' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724559' ,`Longitude` = '-95.872135' ,`PhotoCount` = '20' ,`PostalCode` = '77441' ,`RoomCount` = '8' ,`ListPrice` = '474357.00' ,`Status` = 'Active' ,`StreetName` = 'HAUTER WAY' ,`StreetNumber` = '28906' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2563' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWTON PLAN - This popular large 2 story home featuring 4 bedrooms, with 2 down. Expand your possibilities with this fantastic chef\'s kitchen featuring built-in stainless steel appliances, quartz counters, upgraded cabinets in Harbor Gray. Hardwood floors will greet you at the 8 ft. front door and 2 story foyer, move in the fantastic kitchen, breakfast room and family room where you will be amazed with all the natural light coming in from the Pointed Vault ceiling and wall of windows. Upstairs Game room and Media room. The attached covered patio is fantastic with a Large Backyard and no neighbors behind home.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '45' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134305' WHERE `Matrix_Unique_ID` = '207744313' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T12:50:13.450' ,`MLSNumber` = '81959687' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563879' ,`Longitude` = '-95.746960' ,`PhotoCount` = '40' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '497975.00' ,`Status` = 'Active' ,`StreetName` = 'Sweeny Valley' ,`StreetNumber` = '23714' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sophisticated design and easy elegance combine in The Marcann new home plan. Enjoy the exquisite sanctuary of your Owner’s Retreat, which features a splendid en suite bathroom and a walk-in closet. Each guest suite and spare bedroom presents a uniquely appealing place for growing personalities to flourish. The breakfast nook, covered patio, kitchen island, and open dining area offer a streamlined variety of mealtime settings. Flex your interior design skills in the limitless lifestyle potential of the upstairs retreat, the welcoming living area, and the deluxe family room. Everyday refinements include soaring ceilings, a downstairs powder room, and a delightful selection of built-in features. Make each day beautiful in this exceptional #LivingWeekley masterpiece home plan.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1' ,`LotDesciption` = 'Corner,Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134305' WHERE `Matrix_Unique_ID` = '211860535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T12:50:35.057' ,`MLSNumber` = '51458018' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564615' ,`Longitude` = '-95.746311' ,`PhotoCount` = '37' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '474331.00' ,`Status` = 'Active' ,`StreetName` = 'Travers Hill' ,`StreetNumber` = '23759' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2394' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ll be delighted by the attention to detail that makes The Pressler a remarkable luxury home plan. Enjoy the peaceful refuge of your glorious Owner’s Retreat. Pamper yourself and explore your wardrobe potential in the deluxe Owner’s Bath and walk-in closet. Your open-concept floor plan frames a beautiful backyard view with wide, energy-efficient windows. The chef’s specialty kitchen features ample room for storage, meal prep, cooking, and presentation. Each spare bedroom promotes bright imaginations and offers large closets for personal treasures. The covered patio acts as a glamorous entryway while mixing the comforts of home with outdoor relaxation. Your spacious study provides the FlexSpace? to design your ideal art space or a productive home office. What design decisions are you most looking forward to in this remarkable new home plan?' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 2' ,`LotDesciption` = 'Corner,Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134305' WHERE `Matrix_Unique_ID` = '212633671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T11:35:05.977' ,`MLSNumber` = '21531853' ,`ListAgentFullName` = 'Thai Klam' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157960' ,`Longitude` = '-95.610530' ,`PhotoCount` = '37' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '291700.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Brook' ,`StreetNumber` = '9953' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction 1 Story Saratoga Home, the Clover, located at Enclave at Dobbin. Home has 4 bedrooms, 2 Bathrooms and a 2 car attached garage. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks. Home to be complete Late August' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134306' WHERE `Matrix_Unique_ID` = '212950478' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T11:38:01.253' ,`MLSNumber` = '16234694' ,`ListAgentFullName` = 'Thai Klam' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157849' ,`Longitude` = '-95.609651' ,`PhotoCount` = '23' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '405400.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Brook' ,`StreetNumber` = '9925' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story home for sale. Open-concept layout boasts a large kitchen island and walk-in pantry that faces the family room. Formal dining room and separate breakfast area. The large family room with high ceilings and an open wall of windows is designed for creating cherished memories with your loved ones. Spacious primary suite with a grand walk-in closet. His and her sinks in the primary bath with a large walk-in shower and separate garden tub. Four upstairs secondary bedrooms and large game room. Covered front and back porch.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134306' WHERE `Matrix_Unique_ID` = '212951201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T11:35:56.003' ,`MLSNumber` = '22027306' ,`ListAgentFullName` = 'Thai Klam' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158656' ,`Longitude` = '-95.611282' ,`PhotoCount` = '32' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '325950.00' ,`Status` = 'Active' ,`StreetName` = 'Tammy' ,`StreetNumber` = '9965' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Laurel floor plan offers 4 spacious Bedrooms and 3.5 Bathrooms. This open design floor plan! A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing bathrooms with double sinks, separate tub and shower in the Primary Bath, ceramic tile surround with tub in Secondary Baths and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134306' WHERE `Matrix_Unique_ID` = '212951262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T11:00:59.377' ,`MLSNumber` = '34351390' ,`ListAgentFullName` = 'Rachael Garnett' ,`ListOfficeName` = 'Malone Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.660311' ,`Longitude` = '-95.129953' ,`PhotoCount` = '50' ,`PostalCode` = '77331' ,`RoomCount` = '8' ,`ListPrice` = '849000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Harbour' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Drive' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE FRONT GET-A-WAY! Located in the gated community of Cape Royale, this gorgeous home sits on over half an acre of beautiful Lake Livingston. The perfect spot for rest & relaxation, or an exciting adventure. Large circular driveway shaded with mature trees & plush landscaping. Open concept kitchen/living/dining. Two secondary bedrooms are on the second floor with a full bath. One bedroom below, could be a second primary, with patio access. The primary retreat has a wall of windows with the en-suite bath offering dual sinks, free-standing shower, large jetted tub and a huge walk-in closet. Study opposite of primary retreat with half bath and w/i closet (can be a 5th bedroom). Upstairs game room includes a fireplace & wet bar. Decking across entire back of home, with tons of shaded areas and a fenced yard. Boat house with boat/jet ski lifts. Firepit situated for perfect lake views near the bulkhead. Located on a calm canal, just seconds from open water.' ,`Acres` = '0.6082' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE ROYALE - PINE HARBOUR, BLOCK 6, LOT 42, ACRES .6082' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '26493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Cape Royale Pine Harbour' ,`TaxAmount` = '10736' ,`TaxRate` = '2.0554' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675134306' WHERE `Matrix_Unique_ID` = '213274931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T12:32:24.880' ,`MLSNumber` = '11685473' ,`ListAgentFullName` = 'Santa Creado' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683335' ,`Longitude` = '-95.114022' ,`PhotoCount` = '32' ,`PostalCode` = '77536' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '3101' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-maintained home! This home has a 6-year-old Roof. The A/C unit was replaced in 2018 with new ducting and furnace. Downstairs features one bedroom, formal living room and dining room, a large family room that opens to a spacious kitchen with plenty of cabinets for storage. Granite counter tops with Island Kitchen. Large Laundry room with cabinets. You\'ll love the covered patio with kitchen station, this will be perfect for entertaining your friends and family. Call today for your private showing!' ,`Acres` = '0.225' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 WILLOW SPRINGS R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Spgs R/P' ,`TaxAmount` = '6055' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675134307' WHERE `Matrix_Unique_ID` = '213307451' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T11:49:24.480' ,`MLSNumber` = '96783973' ,`ListAgentFullName` = 'Thai Klam' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.352263' ,`Longitude` = '-95.460276' ,`PhotoCount` = '37' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '292700.00' ,`Status` = 'Active' ,`StreetName` = 'Obispo' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Glendale Lakes! This Wren floor plan offers 3 spacious Bedrooms and 2 Bathrooms. A modern Kitchen featuring 42’’ shaker Kitchen flat panel cabinetry, Quartz countertops with ceramic tile backsplash, high quality Frigidaire appliances and Kitchen island. Relaxing bathrooms with double sinks, separate tub and shower in the Primary Bath, ceramic tile surround with tub in Secondary Baths and Quartz countertops. Energy efficiency features: 16 SEER carrier AC system with programmable thermostat, 40 gallon gas water heater. Full sod front and back landscape package included, Rear Patio, Brick fronts with stone accents per elevation and many more. If you are looking for a great community with easy access to outstanding shopping, dining, and majors freeways, in one of the best school districts, look no further! Set up your appointment today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 Block 1 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134307' WHERE `Matrix_Unique_ID` = '213534282' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T11:52:56.137' ,`MLSNumber` = '86169208' ,`ListAgentFullName` = 'Thai Klam' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480978' ,`Longitude` = '-95.454060' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '331900.00' ,`Status` = 'Active' ,`StreetName` = 'Escondido' ,`StreetNumber` = '6939' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story, new construction home for sale in Rosharon, TX. Open concept layout boasts a large Silestone™ quartz kitchen that opens up to the grand family room and dining area. The winding staircase leads to your spacious primary suite that features a large walk-in closet and his and her sinks. Three secondary bedrooms upstairs. Covered front porch and backyard patio.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 4 Section GL-9 Glendale Lakes' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675134307' WHERE `Matrix_Unique_ID` = '214138969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T12:58:56.007' ,`MLSNumber` = '421351' ,`ListAgentFullName` = 'Tyler Green' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105460' ,`Longitude` = '-95.218506' ,`PhotoCount` = '21' ,`PostalCode` = '77365' ,`RoomCount` = '3' ,`ListPrice` = '254800.00' ,`Status` = 'Active' ,`StreetName` = 'Pinecrest Ln' ,`StreetNumber` = '22997' ,`StreetSuffix` = '' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1566' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This darling house has been remodeled from foundation to roof and is turnkey ready for you to call home! Find peace and quiet while being surrounded by beautiful, mature trees. The previous owners took great care to see to every detail in this home renovation. The kitchen features all new granite counters and new cabinetry. Stay cool with the newly installed A/C unit and energy efficient with new windows! All bathrooms have been beautifully updated including new plumbing, tile and fixtures. Upgraded vinyl flooring is found through the whole home creating a seamless flow - no carpet here! Fresh paint, new trim and upgraded lighting and fans give the space a warm, bright feel. Foundation has been repaired with transferable warranty and new water heater added as well. Top it all off with a brand new roof and there\'s nothing not to love about Pinecrest Lane. Come take a tour today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HERITAGE OAKS, BLOCK 7, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'HERITAGE OAKS' ,`TaxAmount` = '4362' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675134307' WHERE `Matrix_Unique_ID` = '214898120' --> 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','214966433','1675134308','214966433','2023-01-14T11:11:50.953','24757077','Shelli Underwood','Keller Williams RealtyNortheast','','','30.131219','-95.295330','33','77365','7','275000.00','Active','Pine Post','18341','Court','Porter','2','1','4','2255','Single-Family','Welcome Home to this GORGEOUS 4 bedroom 2.5 baths located at the end of the cut-de;sac. Get ready to be WOWED! You won\'t find another place like this one. The great home has been updated and upgraded. Featuring quartz counters tiled flooring NO CARPET. You will love the open concept kitchen and the office nook flanking off the kitchen. Get ready to relax on your large covered back patio with a pool sized back yard. The community has a public pool as shown in pictures and park!! They are both within walking distance and so is the elementary school. It’s a great family community to call home. Minutes to shopping, food, 99 and FM1314. Washer and dryer are included.','0.184','40','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Porter/New Caney West','Central Electric','1','CUMBERLAND PHASE I, BLOCK 18, LOT 5','Cul-De-Sac','8015','Appraisal District','','450','0','','2','Single Oven','0','','','Freestanding Range','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Cumberland Ph I','7220','2.7931','Water District','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T12:16:49.017' ,`MLSNumber` = '67890121' ,`ListAgentFullName` = 'Hai Huynh' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860701' ,`Longitude` = '-95.572356' ,`PhotoCount` = '14' ,`PostalCode` = '77041' ,`RoomCount` = '4' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedarview' ,`StreetNumber` = '11039' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor and small business owners special, No HOA, No Restriction conveniently located near Beltway 8 and 290. Huge backyard that can be built additional guest house with separate entrance. This 4 bedrooms, 3 bathrooms perfect for you home base business or owner occupied the main house with 2 bedrooms and 1 bathroom then rent out the other 2 bedrooms and 2 bathrooms with separate entrance. This house has lots of possibilities that can generate additional incomes monthly. Easy access to Memorial Mall, City Center, Willowbrook Mall, Galleria, and Downtown Houston. Please schedule your showing today!' ,`Acres` = '0.1791' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK E JERSEY ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jersey Acres' ,`TaxAmount` = '3073' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675134308' WHERE `Matrix_Unique_ID` = '214974753' --> 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','215194884','1675134308','215194884','2023-01-14T12:29:13.723','30459510','Sandy Brabham','Keller Williams RealtyNortheast','','','29.916921','-95.160704','37','77044','5','269900.00','Active','Birney Point','13723','Lane','Houston','2','0','3','1603','Single-Family','Adorable single story home on a quiet cul-de-sac in the Master Planned Community of Summerwood. Conveniently located off Beltway 8, a short commute to Downtown Houston and minutes from IAH Airport. Family room has engineered wood floors, high ceilings and a gas fireplace. Kitchen has an island and is open to the family room for easy entertaining. Primary bedroom is spacious and offers a walk in closet. Primary bath has double sinks, garden soaking tub and separate shower. Additional features: 2 secondary bedrooms with walk in closets, full bathroom, large storage closet. Home has recently been painted and carpet replaced. Blinds throughout as well as ceiling fans. Covered front porch. Schedule your showing today!','0.1588','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Summerwood/Lakeshore','Central Gas','1','LT 12 BLK 3 SUMMERWOOD SEC 24 AMEND','Cul-De-Sac,Subdivision Lot','6917','Appraisal District','','840','0','','2','Single Oven','0','','','Gas Range','','Composition','29 - Humble','CENTENNIAL ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','WOODCREEK MIDDLE SCHOOL','Lockbox Front,No Appointment Required','Appraisal District','1','Traditional','Summerwood','6304','2.8532','Public Sewer,Water District','2007','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','215341470','1675134308','215341470','2023-01-14T12:16:29.847','59430101','Michael Knowles','Real Broker, LLC','','','29.501533','-95.391858','38','77578','9','349900.00','Active','Palm Villas','22','Drive','Manvel','3','1','4','2778','Single-Family','','0.1392','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Alvin North','Central Gas','1','RODEO PALMS PALM VILLAS SEC 1 (A0459 ACH&B)(MANVEL) BLK 4 LO','Subdivision Lot','6064','Appraisal District','','600','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Rodeo Palms, Palm Villas Sec 1','10006','3.5087','Water District','2006','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','215849912','1675134308','215849912','2023-01-14T12:02:31.760','85044784','Lizet Moreno','City Group','','','29.663910','-95.312514','11','77087','6','160000.00','Active','Westover','6522','Street','Houston','1','0','3','1311','Single-Family','Multiple Offers have been received, please send HIGHEST & BEST by 1/18/2023.\n\nSelling as is, no repairs will be made. There is no utilities on. Please submit highest and best. Seller is, “ The Estate of J. Manuel Cortes, deceased.” Seller started repairing the property with new upgrades but didn’t finish. Supra on back door.','0.1488','3','','','Gas Dryer Connections,Washer Connections','','Probate,Sellers Disclosure','1','','','Hobby Area','Central Gas','0','LT 1 BLK 4 OVERBROOK SEC 1','Subdivision Lot','6480','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','GARDEN VILLAS ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','HARTMAN MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Overbrook Sec 01','4015','2.3307','Public Water','1955','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','215931079','1675134308','215931079','2023-01-14T12:25:58.090','3704081','Sapana Patel','Keller Williams Realty -SW','','','29.610751','-95.620923','32','77478','10','610000.00','Active','Kingfisher','406','Drive','Sugar Land','3','1','3','2900','Single-Family','Welcome home to a Custom built, beautiful Waterfront home in Sugar Lakes with Open Floor Plan and Waterview from all rooms in home. Spacious home with lake frontage, lake acces, and tons of natural light in all areas. Step outside to your backyard oasis complete with beautiful lake views, lush landscaping, and large custom deck. Spacious Kitchen and walk-in pantry. Both kitchen and Breakfast area have lake views. Large living room with wet bar and game room with built in desk also have full lake views. Large Primary suite with with built-in Closet. Access 2nd floor with Curved floating staircase for two additional bedrooms with ensuite bathrooms, one with a balcony overlooking the backyard and lake. Added new to the house is a Back-Up Generator, dishwasher, pull out drawers in the cabinets, Insullation in the attic, Garage Floor epoxy, Built ins in the garage and full deck. Extremely convenient location with easy access to everything. Zoned to FBISD schools.','0.2462','29','','','','','Sellers Disclosure','1','','2','Sugar Land North','Central Gas','1','SUGAR LAKES SEC 4, BLOCK 1, LOT 2','Subdivision Lot,Water View,Waterfront','10724','Appraisal District','','832','0','','2','','0','','','','','Composition','19 - Fort Bend','HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Builder','2','Split Level,Traditional','Sugar Lakes Sec 4','8757','2.0094','Public Sewer,Public Water','1994','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216050562','1675134308','216050562','2023-01-14T11:42:59.360','45126740','Thai Klam','Compass RE Texas, LLC','','','29.499985','-95.408873','32','77578','11','561400.00','Active','Palmero','5','Way','Manvel','3','1','4','3079','Single-Family','Beautiful New Construction by Saratoga Homes in the exclusive gated community of Rodeo Palms! The beautiful Aurora floor plan is a 2-story home with 4 bedrooms, 3.5 baths, & attached oversized 2-car garage! The 1st floor features high ceilings, study, dining room, family room with fireplace, half bath, & in-house utility room! The eat-in kitchen is sure to be a crowd pleaser with soon-to-be installed granite countertops, tile backsplash, farmhouse sink, stainless steel appliances, double ovens, & shaker-style cabinets! The primary bedroom features an en-suite bath with dual sinks, vanity, soaking tub, separate shower, & walk-in closet! The second floor opens to 3 secondary bedrooms with a shared full bath, including a guest bedroom room, full bath & a game room! The backyard offers a covered patio and outdoor kitchen! Zoned to amazing Alvin ISD, this home is located in the Rodeo Palms subdivision within close proximity to FM-288 & Hwy 6!','0.225','5','Saratoga Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gaslog Fireplace','1','Alvin North','Central Gas','1','RODEO PALMS THE LAKES SEC 4 (A0299) (MANVEL) BLK 1 LOT 2','Subdivision Lot','9801','Appraisal District','','1100','1','Never Lived In','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card','Builder','2','Traditional','Rodeo Palms','1582','3.5087','Public Sewer,Public Water,Water District','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','216283573','1675134308','216283573','2023-01-14T11:26:51.970','88218445','Shannon DeGroat','New Home Star Texas, LLC','','','29.837664','-95.864807','4','77493','6','390500.00','Active','ALLEGRETTO SEA','2560','Drive','Katy','2','1','4','2407','Single-Family','**UNDER CONSTRUCTION, ESTIMATED APRIL 2023 COMPLETION** Welcome to the Tierra! The foyer welcomes guests into a spacious, open concept kitchen/café/family room area. This floor plan features a convenient first floor owners suite with an impressive en suite bath and a spacious closet connected to the home’s laundry room. Upstairs, you’ll find a versatile game room area and three more bedrooms, giving everyone their own space!','','25','Davidson Homes','','Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Katy - Old Towne','Central Gas','1','S800025 SUNTERRA 25 BLK 3 LOT 16','Subdivision Lot','','','','1800','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Craftsman,Traditional','Sunterra','','3.658234','Public Sewer','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','216284282','1675134308','216284282','2023-01-14T11:10:56.043','64753461','Shannon DeGroat','New Home Star Texas, LLC','','','29.837860','-95.865387','5','77493','6','394000.00','Active','ALLEGRETTO SEA','2548','Drive','Katy','2','1','4','2407','Single-Family','**UNDER CONSTRUCTION, ESTIMATED APRIL 2023 COMPLETION** Welcome to the Tierra! The foyer welcomes guests into a spacious, open concept kitchen/café/family room area. This floor plan features a convenient first floor owners suite with an impressive en suite bath and a spacious closet connected to the home’s laundry room. Upstairs, you’ll find a versatile game room area and three more bedrooms, giving everyone their own space!','','25','Davidson Homes','','Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Katy - Old Towne','Central Gas','1','S800025 SUNTERRA 25 BLK 3 LOT 19','Subdivision Lot','','','','1800','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Craftsman,Traditional','Sunterra','','3.658234','Public Sewer','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','216288335','1675134308','216288335','2023-01-14T12:29:01.963','42854060','Sonia Rendon','Coton House','','','29.814838','-95.696117','34','77084','7','365000.00','Active','Evergreen Falls','18715','Drive','Houston','3','1','4','3018','Single-Family','Welcome to 18715 Evergreen Falls, a stunning and spacious home nestled in a picturesque neighborhood. This property boasts over 3000sf of living space with an abundance of natural light and high celling\'s, creating a warm and inviting atmosphere. On the second floor a lovely game/media room that connects all the secondary bedrooms. The home features 4 bedrooms and 3 bathrooms, including a luxurious master suite with a large walk-in closet and en-suite bath. Additionally, the home features a large backyard with a patio and plenty of space for outdoor activities and gardening. This home is perfect for families or anyone looking for a spacious and serene home in a great location. Located close to renowned schools, shopping, dining, and entertainment. this is a rare opportunity to own a home in this sought-after area. Don\'t miss out on this opportunity, schedule a showing today and make this your dream home!','0.1846','25','','','','','Mud,Other Disclosures','1','Gas Connections,Gaslog Fireplace','1','Katy - North','Central Gas','1','LT 42 BLK 8 BARKERS RIDGE SEC 3 R/P','Subdivision Lot','8040','Appraisal District','','495','0','','1','','0','','','','','Composition','30 - Katy','SCHMALZ ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','MAYDE CREEK JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','Barkers Ridge Sec 03 R/P','7888','2.487','Water District','1991','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','216382860','1675134308','216382860','2023-01-14T11:54:02.793','75171426','Karen Nguyen','HomeSmart','','','29.976409','-95.400897','20','77073','6','235000.00','Active','Lansing Field','1310','Lane','Houston','2','0','3','1406','Single-Family','***Cute starter home*** Easy acess to I45, Hardy Toll Rd, the Woodlands, Grand Parkway 99. 3 berooms 2 bath 2 car-garage. Wood-made laminate flooring in all bedrooms. Ceramide tiles the rest of the house. Tiles backsplash in all two bathrooms with quartz stone countertops. Ceiling fans. Vaulted ceiling in bedroooms. Kitchen has brand new stainless steel appliances: cooktop, oven, dishwasher, microwave. Quartz stone kitchen countertops, tiles backsplash and single-bowl rectangular stainless steel sink. Extra cabinets in garage for storage/workshop. No front neighbor. Garage door opener. Don\'t miss.','0.101','12','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Aldine Area','Central Gas','1','LT 25 BLK 1 MEADOWVIEW FARMS SEC 7','Cleared,Subdivision Lot','4400','Appraisal District','','438','0','','2','Gas Oven,Single Oven','0','','','Gas Cooktop,Gas Range','','Composition','1 - Aldine','PARKER ELEMENTARY SCHOOL (ALDINE)','DAVIS HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Seller','1','Traditional','Meadowview Farms','4927','2.8445','Public Sewer,Public Water,Water District','2009','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','216395777','1675134308','216395777','2023-01-14T11:10:50.630','94653578','Justin Chakkalayil','MIH REALTY, LLC','','','29.632013','-95.187615','32','77504','9','364900.00','Active','Rainier','5219','Street','Pasadena','3','0','4','2941','Single-Family','Absolutely Gorgeous!! 1.5 story!! Well maintained 4 Bed 3 bath home with study, game room, and a covered patio with an additional kitchen !! in a stellar location. Recently freshened up with new paint. Dining room & family room are just off the kitchen and feature a fireplace. Oversized primary bedroom has a jetted tub and a walk-in closet. Secondary bedrooms have good sized closets. 2nd story consists of a game room and a full bath. Office room is large enough to fit your office furniture’s. Kitchen has an island, Granite counter top good size pantry and lots of cabinets. beautiful flooring throughout the house. Well maintained front yard. New Carrier 5-ton A/C installed in 2017. Engineered wood in the main living & dining area, New roof replaced in 2018, refrigerator, washer and dryer included. Short commute to downtown, medical center and Nasa area. Easy access to major highways. Law Tax rate !! Highly Rated Schools !!Call for your private tour.','0.1446','6','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Pasadena','Central Gas','1','LT 9 BLK 6 STRAWBERRY GLEN SEC 1','Subdivision Lot','6300','Appraisal District','','300','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','TEAGUE ELEMENTARY SCHOOL (PASADENA)','MEMORIAL HIGH SCHOOL (PASADENA)','BONDY INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Strawberry Glen Sec 01','8013','2.6514','Public Sewer,Public Water','2007','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','216395831','1675134308','216395831','2023-01-14T11:37:51.940','40046253','Anthony Vu','Realty Associates','','','29.836027','-95.312431','10','77016','6','309990.00','Active','Hoffman','8313','Street','Houston','2','1','3','1585','Single-Family','COMING SOON. MOVE IN READY BY MARCH 2023. Just north of 610 in Houston\'s growing neighborhood lies Triangle Gardens. Contemporary farm house with a private entry gate, balcony view and spacious backyard come together in an open concept floor plan. Upgraded finishes throughout including quartz countertops, eye-catching lighting, cabinets and stainless-steel appliances for both style and functionality. Unique tiled master bathroom with a soaker tub and walk-in-shower for a spa feeling time. This home awaits your arrival for the new lifestyle you’ve been looking for! Call today for more information.','','2','Hillstone','','Washer Connections','','No Disclosures','1','','','Northside','Central Gas','0','Lot 2 Block 1','Cleared','3720','Other','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','COOK ELEMENTARY SCHOOL (HOUSTON)','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Request Online Appointment','Builder','2','Contemporary/Modern','Triangle Gardens','','','Public Sewer,Public Water','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','216396485','1675134308','216396485','2023-01-14T11:42:08.770','66065200','Keith Griffin','Griffin Realty & Associates','','','29.496347','-94.930274','10','77539','6','194417.00','Active','Avenue C','1918','','Dickinson','1','0','2','1419','Single-Family','','0.3076','33','','','Electric Dryer Connections,Washer Connections','','No Disclosures,Sellers Disclosure','1','','0','Bacliff/San Leon','Window Unit','0','ABST 10 A EDWARDS LOT 1 TO 4 BLK 40 SAN LEON FEMA TRAILER','Corner,Subdivision Lot','13400','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','17 - Dickinson','SAN LEON ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','San Leon','2994','2.4137','Public Sewer,Public Water','1980','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','216397249','1675134308','216397249','2023-01-14T12:27:03.670','72122605','Jimmy Franklin','Newmark Homes','','','29.722199','-95.875004','22','77441','8','537336.00','Active','Meadow Terrace','29026','Drive','Fulshear','3','0','4','2259','Single-Family','MONTAGUE plan. This fabulous 2 story home features 4 bedrooms and 3 baths with a 2.5 car garage space. The front elevation of brick and stucco is majestic. Enter in and feast your eyes on this kitchen. Luxurious stacked cabinets and beautiful Quartz counters with stunning Matte black hardware. This is a chef\'s delight. The sweeping pointed vault ceiling in the family room will draw you in and usher you to the extended huge covered patio. Turn around and feast your eyes on the Wrought Iron spindles leading up to the game room on the second floor. Impressive view to the Family room. Home also includes tankless water heater and spray foam insulation.','','30','Newmark Homes','','Electric Dryer Connections','','Mud','1','','','Katy - Southwest','Central Gas','1','Lot 03, Block 01','Subdivision Lot','45','Other','','1300','1','To Be Built/Under Construction','','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Leave Business Card','Builder','2','Contemporary/Modern','Cross Creek Ranch','','','Water District','2023','Builder'); --> New record created successfully