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-14T15:58:20.307' ,`MLSNumber` = '15161396' ,`ListAgentFullName` = 'Laura Cooper' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775353' ,`Longitude` = '-95.375749' ,`PhotoCount` = '22' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Sabine' ,`StreetNumber` = '2012' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This contemporary 3 bedroom, 3-1/2 bathroom home is located in the desirable Sawyer Heights area. It\'s in a 14-home gated community right on the the Heights Hike & Bike Trail. You\'ll have easy access to Washington Ave, Downtown and I-10. This large split floor plan has 4th floor kitchenette that\'s perfect for entertaining guests while enjoying the rooftop deck overlooking downtown Houston. The downstairs bedroom features a full bathroom and the other bedrooms are separate from the living/kitchen level, making it a great home for roommates or a family. Plus, it comes with a home warranty included!' ,`Acres` = '0.0407' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 GREGORY SQUARE AMEND' ,`LotDesciption` = 'Other,Patio Lot' ,`LotSize` = '1772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Gregory Square Amd' ,`TaxAmount` = '10508' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675135442' WHERE `Matrix_Unique_ID` = '212749411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T16:17:43.720' ,`MLSNumber` = '7389224' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724541' ,`Longitude` = '-95.871868' ,`PhotoCount` = '18' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '491384.00' ,`Status` = 'Active' ,`StreetName` = 'Hauter Way' ,`StreetNumber` = '28902' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newmark Homes offering The NAVARRO plan in Cross Creek Ranch. This home is a show stopper. It is the Model plan featuring 4 Bedrooms (2 downstairs) and 3 full bathrooms. As you enter the front door, behold the curved wrought iron stairs. An elegantly appointed secondary bedroom awaits you on the first floor. The exquisite Chef\'s kitchen with Quartz countertops, stainless steel appliances, 5 burner gas cooktop, built in microwave and oven with pots and pans drawer. The awesome family with point vault ceiling lets in tons of natural light. The main bedroom downstairs is the ideal space with it\'s luxurious bathroom with double sinks. Upstairs game room with sound sound prewire and secondary bedrooms are guaranteed to delight you. This huge backyard is perfect for your future pool and any other structures you desire to enjoy the day. Don\'t let this one get away.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 02' ,`LotDesciption` = '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` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135443' WHERE `Matrix_Unique_ID` = '213175833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:53:21.683' ,`MLSNumber` = '96685777' ,`ListAgentFullName` = 'Rachael Parker' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.091037' ,`Longitude` = '-94.022003' ,`PhotoCount` = '15' ,`PostalCode` = '75931' ,`RoomCount` = '2' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluejay' ,`StreetNumber` = '55' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookeland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Affordable fish camp/vacation rental near the shores of Big Sam! Located in Audubon Hills within minutes to boat launches. This 2 bedroom 1 bath, open concept mobile home is being sold furnished and is located in a great subdivision on the southeast side of the lake. Membership gives you access to all the county club amenities including, swimming pool, tennis, basketball and pickleball courts, golf course, driving range, country club and soon to come lazy river. Call today to schedule your showing!' ,`Acres` = '0.18' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 55 SEC MH-1 RAYBURN COUNTRY 1123/206 0.18 ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rayburn County Sec Mh-1' ,`TaxAmount` = '759' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135443' WHERE `Matrix_Unique_ID` = '213638333' --> 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','213773858','1675135443','213773858','2023-01-14T15:21:11.427','49729244','Quinton Milner','HomeSmart','','','29.128275','-95.538533','6','77515','6','499900.00','Active','Colt','302','Trail','Angleton','2','1','3','2425','Single-Family','This amazing single story new construction will be ready to move-in upon the completion projected in December 2022. The Bramblewood floorplan showcases 3 bedrooms 2 and a half bathrooms and a 2 car garage! This home boasts a gorgeous kitchen, vaulted ceilings and gorgeous skylights sharing plenty of natural light. The living room has a wood burning stove and double doors which open up into the covered patio with fireplace. There are beautiful finishes, wet bar, double sinks in the bathrooms with a spa tub and separate shower in the primary bathroom. The highly popular Bar Ranch neighborhood has plenty of deer roaming also a pool and tennis courts and club house.','1.26','5','DML Real Estate Inv','','Electric Dryer Connections','','Mud','1','Wood Burning Fireplace','1','Angleton','Central Electric','1','BAR X RANCH SEC 7 (A0053 S CARTER) BLK 1 LOT 80 ACRES 1.26','Subdivision Lot','54886','Appraisal District','','400','1','To Be Built/Under Construction','2','Single Oven','0','','','','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','No Appointment Required','Builder','1','Traditional','Bar X Ranch Sec 7','355','1.6364','Septic Tank,Well','2023','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:18:12.920' ,`MLSNumber` = '2268880' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427195' ,`Longitude` = '-95.451773' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '395990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10623' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Edward-a one of a kind floor plan you must see. As you walk through the front door, a study sits off to the right. The extended foyer leads you past two bedrooms, the laundry room, and not just one, but two bathrooms. A set of stairs off of the garage takes you up to the additional bonus room, unfinished to add your own special touch. The kitchen overlooks the family room and offers plenty of countertop and cabinet space. The café is connected to the kitchen and offers direct access outside to the covered patio. Directly off of the family room is the owners suite with a double sink vanity, a soaking tub and separate shower with a big walk-in closet.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 1 LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135443' WHERE `Matrix_Unique_ID` = '214330899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:17:58.180' ,`MLSNumber` = '10617363' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.376190' ,`Longitude` = '-95.456813' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '439990.00' ,`Status` = 'Active' ,`StreetName` = 'Plumas Run' ,`StreetNumber` = '10530' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hello George! From the long entry way leading to the front door, to the extended foyer leading into the family room and kitchen area, this one-story home has it all. The first two bedrooms are located at the front of the home that are split by a full sized bathroom. Further down, off the foyer, is the laundry room, access to the 3-car garage and the third bedroom that has its own bathroom. Work from home with no interruptions in the study or turn that space into a formal dinning room. The kitchen is open to the family room and the café area with a door leading out to the covered back patio. The owners suite includes a double sink vanity, a separate shower and soaking tub with a huge walk-in closet.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 3 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675135443' WHERE `Matrix_Unique_ID` = '214332999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:17:34.467' ,`MLSNumber` = '57013567' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432837' ,`Longitude` = '-95.445460' ,`PhotoCount` = '10' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1818' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hello George! From the long entry way leading to the front door, to the extended foyer leading into the family room and kitchen area, this one-story home has it all. The first two bedrooms are located at the front of the home that are split by a full sized bathroom. Further down, off the foyer, is the laundry room, access to the 3-car garage and the third bedroom that has its own bathroom. Work from home with no interruptions in the study or turn that space into a formal dinning room. The kitchen is open to the family room and the café area with a door leading out to the covered back patio. The owners suite includes a double sink vanity, a separate shower and soaking tub with a huge walk-in closet.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 4 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9307' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675135444' WHERE `Matrix_Unique_ID` = '214336109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:17:02.223' ,`MLSNumber` = '21891510' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434451' ,`Longitude` = '-95.444383' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Homewood Point' ,`StreetNumber` = '1806' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Philip, a charming two-story home. Work from home? No problem, a study is located on the main level, tucked away from the rest of the home to get work done in peace and quiet. Stainless steel appliances, 42\" upper cabinets, a gas range and a huge walk-in pantry are all included in the kitchen. Large windows line the family room and café area to let in an ample amount of sunshine. The laundry room and owners suite are conveniently located on the main level as well. Up to the second floor, you will find an enormous game room, two additional bedrooms that share a full sized bathroom and an en suite with a walk-in closet.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 4 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8011' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135444' WHERE `Matrix_Unique_ID` = '214336537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:16:33.193' ,`MLSNumber` = '74655499' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426263' ,`Longitude` = '-95.451590' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '410990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10707' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Elizabeth! This modern one-story, open-concept floor plan is the perfect house to call home. A short foyer leads into the kitchen that is open to the café and family room. An en suit is conveniently located in the front of the house perfect for hosting guests. Two additional bedrooms are located off of the family room, separated by a full bathroom. The owners suite features a huge bathroom with a double sink vanity, separate shower and a soaking tub with a big walk-in closet that leads to the laundry room. This one-story plan also includes a 3-car garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 1 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8114' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135444' WHERE `Matrix_Unique_ID` = '214336889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:16:11.557' ,`MLSNumber` = '4823205' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427331' ,`Longitude` = '-95.451196' ,`PhotoCount` = '14' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '495990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Philip, a charming two-story home. Work from home? No problem, a study is located on the main level, tucked away from the rest of the home to get work done in peace and quiet. Stainless steel appliances, 42\" upper cabinets, a gas range and a huge walk-in pantry are all included in the kitchen. Large windows line the family room and café area to let in an ample amount of sunshine. The laundry room and owners suite are conveniently located on the main level as well. Up to the second floor, you will find an enormous game room, two additional bedrooms that share a full sized bathroom and an en suite with a walk-in closet. This home also includes an extended back patio.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 2 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135444' WHERE `Matrix_Unique_ID` = '214337428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:15:50.667' ,`MLSNumber` = '60739756' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430290' ,`Longitude` = '-95.448741' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '495990.00' ,`Status` = 'Active' ,`StreetName` = 'Tioga View' ,`StreetNumber` = '1723' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Philip, a charming two-story home that backs to the lake. Work from home? No problem, a study is located on the main level, tucked away from the rest of the home to get work done in peace and quiet. Stainless steel appliances, 42\" upper cabinets, a gas range and a huge walk-in pantry are all included in the kitchen. Large windows line the family room and café area to let in an ample amount of sunshine. The laundry room and owners suite are conveniently located on the main level as well. Up to the second floor, you will find an enormous game room, two additional bedrooms that share a full sized bathroom and an en suite with a walk-in closet.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 3 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8374' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135445' WHERE `Matrix_Unique_ID` = '214490464' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T15:15:20.950' ,`MLSNumber` = '45139238' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.425392' ,`Longitude` = '-95.450931' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10731' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Philip, a charming two-story home. The big covered front patio is perfect for enjoying your morning cup of coffee at. Work from home? No problem, a study is located on the main level, tucked away from the rest of the home to get work done in peace and quiet. Stainless steel appliances, 42\" upper cabinets, a gas range and a huge walk-in pantry are all included in the kitchen. Large windows line the family room and café area to let in an ample amount of sunshine. The laundry room and owners suite are conveniently located on the main level as well. Up to the second floor, you will find an enormous game room, two additional bedrooms that share a full sized bathroom and an en suite with a walk-in closet.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 1 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11248' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.489' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675135445' WHERE `Matrix_Unique_ID` = '214529175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T16:08:21.747' ,`MLSNumber` = '79598757' ,`ListAgentFullName` = 'Desiree Harrod' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.077758' ,`Longitude` = '-95.199964' ,`PhotoCount` = '30' ,`PostalCode` = '77339' ,`RoomCount` = '5' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Gardens' ,`StreetNumber` = '5206' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for the right home under 300k? This is the one! This fully renovated, one story, three-bedroom, two-bath home is ready for a new owner. Located in the heart of Kingwood, which is known for it’s 75+ mile green belt system. Short bike ride or walk to Restaurants and Shopping. Zoned to the Sought After Kingwood Schools. Upgrades include but not limited to; Roof, HVAC, Windows, Exterior/Interior Paint, LVP Flooring, All Bathrooms Reno, Light Fixtures, Appliances, Bullnose Corners, Shed w/ Electric, Covered Patio, 2 islands with seating, Custom Cabinetry w/ Sliding Shelves, Pots and Pan Drawers, Utensil Drawer, Spice Cabinet. Close attention to detail was put into this home! Schedule your private tour today!!' ,`Acres` = '0.1666' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 17 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '398' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '4545' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675135445' WHERE `Matrix_Unique_ID` = '214659148' --> 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','214997341','1675135445','214997341','2023-01-14T15:35:45.313','59334858','Cesar Espinoza','Equity Real Estate','','','29.648682','-95.550394','46','77031','4','289900.00','Active','Petersham','11914','Drive','Houston','2','0','4','2180','Single-Family','The spacious updated single-story home is located in the established Glenshire Subdivision is ready for immediate move-in. This recently painted home features 4 bedrooms & 2 bathrooms! It has a spacious living area that flows into the kitchen. The property features lots of natural light and tile flooring throughout the main areas and in all the bedrooms. The exterior includes a premium size backyard. Location of this home is ideally located close to endless premier shopping, dining, entertainment, & major freeways for an easy commute.','0.2586','20','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Brays Oaks','Central Gas','1','LT 16 BLK 6 GLENSHIRE SEC 1','Subdivision Lot','11266','Appraisal District','','520','0','','2','','0','','','Gas Range','','Composition','27 - Houston','BELL ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Glenshire Sec 01','5555','2.3307','Public Sewer,Public Water','1971','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215158859','1675135446','215158859','2023-01-14T15:54:46.513','45966357','Jon Harper','Towne Lake Custom Sales, LLC','','','30.284462','-95.579510','13','77316','8','489900.00','Active','Greatwood Glen','148','Court','Montgomery','3','0','4','2773','Single-Family','Spectacular one-story home built by Perry Homes. (Over 2700 sq. ft.) High ceilings in nearly every room. Wide open concept, Kitchen/breakfast room/Family room with 12 ft. ceiling. Formal dining with hardwood floors, spacious Primary bedroom with hardwood floors, large library with French Doors and hardwood floors, three large secondary bedroom, 3 full baths. Large cul-de-sac lot, big covered-patio and extra concrete patio space. Great home for living and entertaining.\r\nWell-maintained and ready for move-in.\r\nRoom sizes are approximate and should be verified.','0.238','39','Perry Builders','','','','Mud','1','','1','Conroe Southwest','Central Gas','1','S965242 - WOODFOREST 42, BLOCK 2, LOT 3','Cul-De-Sac,Subdivision Lot','10366','Appraisal District','','1265','0','','2','Electric Oven','0','','','Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Woodforest 42','9628','2.6888','Water District','2015','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','215197861','1675135446','215197861','2023-01-14T15:44:29.707','20043503','JR Shipp','JLA Realty','','','29.647885','-98.111393','31','78130','8','345999.00','Active','Legend Hill','3826','Street','New Braunfels','2','1','3','2402','Single-Family','WELCOME HOME to your new delightful 3 Bd 2.5 Bath home with NO back neighbors!!! Front room off of the entrance could be your formal dining room or study, you choose. Downstairs you will enjoy the spacious living space that provides an open concept for easy entertaining. All bedrooms and laundry room are located upstairs for your convenience. Extra space upstairs could be used for a game room or extra living space, you choose. Oh, the possibilites!!! So many opportunities to make this place a HOME for the whole family to enjoy! Schedule your showing today and fall in love with your new home! Buyer to purchase new survey. All room sizes are approximate.','0.1188','83','','','','','HOA First Right of Refusal','1','','1','','Central Electric','1','LEGEND POND-LEGEND POINT PH #1 BLOCK 2 LOT 13 .1188 AC','Cleared','5175','Appraisal District','','360','0','','2','','0','','','','','Composition','142 - New Braunfels','KLEIN ROAD ELEMENTARY SCHOOL','NEW BRAUNFELS HIGH SCHOOL','NEW BRAUNFELS MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','Legend Pond-Legend Point Ph #1','6823','1.9532','Public Sewer,Public Water','2014','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','215389992','1675135446','215389992','2023-01-14T16:07:43.870','68637509','Farhat Farooq','REALM Real Estate Professional','','','28.821203','-96.979850','25','77901','8','279000.00','Active','Terrace Av','2404','Avenue','Victoria','2','1','4','2064','Single-Family','LIKE NEW!!! This home features 4 bedrooms and 2.5 baths completely transformed into a beautiful NEW home!\r\n\r\nNew Paint, new doors, new flooring, new cabinets, new counter-tops, new sinks, new toilets inside the house, new fixtures and lighting and ceiling fans. Attic ladder also replaced. It also includes new REFRIGERATOR and DISHWASHER. This beauty was transformed and remodeled allowing for the next owner to be felt at home instantly. This home is in a great location with easy access to schools, highways and amenities. Enjoy the Video!','0.2545','66','','','Electric Dryer Connections','','Sellers Disclosure','1','','','','Central Gas','0','BROWNSON TERRACE I, BLOCK 5, LOT 28','Subdivision Lot','11088','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition,Tile','191 - Victoria','SMITH ELEMENTARY MAGNET','VICTORIA EAST HIGH SCHOOL','STROMAN MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Brownson Terrace I','4549','2.2664','Public Sewer,Public Water','1958','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','215449055','1675135446','215449055','2023-01-14T16:08:48.000','76686400','Desiree Harrod','JLA Realty','','','30.615597','-95.170021','29','77331','4','199500.00','Active','State Highway 156','10499','','Coldspring','2','0','4','1344','Single-Family','If you’re looking to escape the city, I’ve got the perfect home. Four Bedrooms, Two-Full Bathrooms, situated on almost half an acre. Fully fenced. Two entry gates (16ft & 20ft). RV Hook-Ups. Shop has electric and plumbing one side is currently being utilized as a salon but the possibilities are endless, ramp for equipment on the left side. Refrigerator and Salon bowl are negotiable. You don’t want to miss this one. Schedule your tour today.','0.4084','64','','','','','Sellers Disclosure','1','','0','Lake Livingston Area','Central Electric','0','CEDAR RIDGE, LOT 1, ACRES .4084','Other','17790','Appraisal District','','','0','','0','','0','','','','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment','Appraisal District','1','Traditional','Cedar Ridge','254','1.5516','Public Water,Septic Tank','2021','Seller'); --> 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','216180364','1675135446','216180364','2023-01-14T16:28:55.950','91887148','Kevin Do','Kinh Do Realty','','','29.501508','-95.401768','23','77578','4','372000.00','Active','Carmel','77','Drive','Manvel','2','0','3','2100','Single-Family','This beautiful home is nested in Rodeo Palms gated section with a lake view from the backyard.. Home features brick/stone elevation. The floor plan comes with 3 bedrooms, 2 bathrooms a large dining room. The owner\'s suite featuring a beautiful bay window. The gourmet kitchen comes with a large island. Covered patio with a gas sub ready for the outdoor kitchen. Builder warranty is transferable to the next homeowner. Make this gem your home today','0.1584','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alvin North','Central Gas','1','RODEO PALMS THE LAKES SEC 2 (A0299) (MANVEL) BLK 2 LOT 7','Subdivision Lot','6900','Appraisal District','','1500','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','DON JETER ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','RODEO PALMS JUNIOR HIGH SCHOOL','Accompany,Supra Keybox','Appraisal District','1','Traditional','Rodeo Palms The Lakes Sec 2','3483','3.5087','Public Sewer,Public Water,Water District','2021','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','216348301','1675135446','216348301','2023-01-14T15:21:31.877','80683874','Alejandro Carrillo','Fratelli Properties International','','','30.150848','-95.652247','50','77362','10','429000.00','Active','Hillside','33603','Drive','Pinehurst','2','0','4','2171','Single-Family','Situated in the fabulous Britwood Estates, this one story, 4 bedrooms and 2 baths home will impress you from the moment you arrive! Step inside and be greeted by the formal dining room area. Open design kitchen is equipped with stainless steel appliances, gas cooktop, gorgeous bold cabinets, & granite countertops. The kitchen overlooks the family room for an open concept. Live in a quiet, private, country setting without the hassles of big city living. This is your opportunity. This property has 1.5 acres fully fenced with lots of privacy. Backdoor leads out to the sprawling covered patio, enjoy outdoor entertaining and warm summer nights! Super low tax rate, not in the flood zone and is ready for a new owner to call home.','1.5181','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Tomball','Propane','1','BRITWOOD ESTATES, BLOCK 1, LOT 1, ACRES 1.5181','Cul-De-Sac,Subdivision Lot','66128','Appraisal District','','100','0','','2','Electric Oven','0','','','Gas Cooktop','','Wood Shingle','53 - Tomball','DECKER PRAIRIE ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Ranch,Traditional','Britwood Estates','3522','1.9215','Septic Tank','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','216383327','1675135446','216383327','2023-01-14T16:11:17.443','92220711','Claudia Cooper','City Group','','','30.059603','-95.429515','33','77373','6','320000.00','Active','Cypresswood','20102','Glen','Spring','2','1','5','2260','Single-Family','Full renovation just completed with brand new EVERYTHING! Beautiful and spacious home in a gated community with 5 full bedrooms, brand NEW windows, granite, HVAC in attic, water heater and all NEW appliances -- unheard of at this price point. Epoxy flooring in garage, CUSTOM cabinetry and water-efficient plumbing fixtures. Community offers nice outdoor pool, beach volleyball court, and walking/running path around the lake. This is must-see property and won’t last long!','0.1085','12','','','Electric Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring East','Central Gas','1','LT 26 BLK 3 CYPRESSWOOD LAKE SEC 3','Subdivision Lot','4725','Appraisal District','','733','0','','2','','0','','','Electric Range','','Composition','48 - Spring','GINGER MCNABB ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Cypresswood Lake Sec 03','5383','2.4967','Public Sewer,Public Water','2002','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','216400654','1675135446','216400654','2023-01-14T15:00:18.953','98590273','Jorge Bolio','Texas Premier Realty','','','29.456701','-95.470593','21','77583','12','369000.00','Active','Vaulted Oak','403','Street','Rosharon','2','1','4','2874','Single-Family','You don’t want to miss this gorgeous Lake Ridge Builders home in the desirable community of Huntington Place! Nestled on a spacious lot, this property boasts a premium elevation, tile flooring, wrought iron spindles, a fireplace with a stone surround, and a covered patio for outdoor entertaining and leisure. Perfect your culinary creations in the stunning kitchen, complete with granite countertops, a tile backsplash, stainless steel appliances, and 42” cabinets. Unwind in the spa-like primary suite, equipped with dual vanities, a 42” tub, and separate shower. Commuters enjoy easy access to major roadways, such as FM 1462, TX 288, and Highway 6. Explore nearby shopping, dining, and entertainment at Pearland Town Center. Students attend Angleton Independent School District. This is the home of your dreams – call today!','0.1907','38','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','Gaslog Fireplace','1','Sienna Area','Central Gas','1','HUNTINGTON PLACE SEC 3, BLOCK 1, LOT 34','Greenbelt','8308','Appraisal District','','523','0','','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required','Appraisal District','2','Contemporary/Modern','Huntington Place Sec 3','12067','3.2629','Water District','2020','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','216402767','1675135446','216402767','2023-01-14T16:38:53.650','34585649','George Agaybi','Texas Premium Realty','','','29.801155','-95.179872','24','77015','9','267500.00','Active','Rampchester','13714','Lane','Houston','2','0','4','1526','Single-Family','Beautiful 4 bedroom/ 2 bath Home, COMPLETE REMODEL, NEW ROOF, CARPET, KITCHEN AND VANITY CABINETS, APPLIANCES, PAINTING, UPDATED BATHROOMS','0.1761','2','','','Electric Dryer Connections,Washer Connections','','Mud,Owner/Agent','1','Gas Connections','1','North Channel','Central Electric,Central Gas','1','LT 26 BLK 70 WOODFOREST SEC 19','Subdivision Lot','7670','Appraisal District','','','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range','','Composition','21 - Galena Park','HAVARD ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Woodforest Sec 19','3918','2.5294','Public Sewer,Public Water,Water District','1975','Appraisal District'); --> New record created successfully