Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:00:55.357' ,`MLSNumber` = '25459368' ,`ListAgentFullName` = 'Marie Janke' ,`ListOfficeName` = 'Janke and Co Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.233716' ,`Longitude` = '-94.890037' ,`PhotoCount` = '14' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1317000.00' ,`Status` = 'Active' ,`StreetName` = 'STARFISH' ,`StreetNumber` = '11374' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is under construction, but don\'t let this stop you, make selections before it\'s too late!. This amazing 2,220 sq ft luxury vacation home has BEACHSIDE construction features that include 4-5 bedrooms and 3 full baths, DOUBLE BALCONIES, standing seam metal roof, a walk in closet in the primary bedroom with a walk out porch to enjoy your morning coffee! Also included in the home are stainless kitchen appliances, pendant lighting over the kitchen island, easy care vinyl plank flooring, designer tile in bathrooms, custom wood kitchen cabinetry, quartz countertops and large kitchen island. Enjoy a bonus room and many more luxury amenities throughout the home. Call ASAP today for additional details on this beauty! Photos are from a sister property and may differ from actual buildout.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'SANDPIPER HOMES INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 609 SECTION 6' ,`LotDesciption` = 'Water View' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '313' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'BEACHSIDE VILLAGE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664220122' WHERE `Matrix_Unique_ID` = '208318599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:57:34.750' ,`MLSNumber` = '76963351' ,`ListAgentFullName` = 'Amin Dawood' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688719' ,`Longitude` = '-95.483212' ,`PhotoCount` = '43' ,`PostalCode` = '77096' ,`RoomCount` = '8' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Beechnut' ,`StreetNumber` = '5463' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the opportunity to own a lovely 1 story home in Houston. Located on Beechnut in the Maplewood neighborhood. A spacious family room & dining room great for entertaining. Elegant backyard equipped with paver patio and luxurious inground pool surrounded by Beautiful Landscaping and half court fenced in basketball court, and a nice wooden deck. Step outside to enjoy an expansive backyard! Relax on the pool and all the space you\'ll have for outdoor barbecues! Enjoy access to US 59 and 610 Loop for easy commuting.' ,`Acres` = '0.2497' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 MAPLEWOOD SEC 10' ,`LotDesciption` = 'Other' ,`LotSize` = '10875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Maplewood Sec 10' ,`TaxAmount` = '7565' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220122' WHERE `Matrix_Unique_ID` = '208988584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:10:13.080' ,`MLSNumber` = '74949116' ,`ListAgentFullName` = 'Christine Routt' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Farideh Pirali' ,`SellingOfficeName` = 'PRG, Realtors' ,`Latitude` = '29.748756' ,`Longitude` = '-95.615871' ,`PhotoCount` = '31' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Westhorpe' ,`StreetNumber` = '12926' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained gem of a single story home on quiet street with very little traffic. Walking distance to good schools, shopping, and the Energy Corridor. Popular neighborhood with community pool. Replaced windows, new paint throughout, section of sewer line replaced, duck work 2011, water heater 2017, Osmosis Water Filter 2018, microwave, recent stainless refrigerator, washer/dryer stay. Nice kitchen with granite counter tops with tile backsplash, wood cabinets, two pantries and breakfast room. Living room and dining room leveled so there is no step-down. Covered back patio with private, serene, fenced backyard large enough for a pool and detached, two car garage. Movtivated sellers, being all offers.' ,`Acres` = '' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 & TR 13A BLK 5 ASHFORD WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7705' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'ASHFORD WEST' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220122' WHERE `Matrix_Unique_ID` = '209455969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:13:52.493' ,`MLSNumber` = '50504247' ,`ListAgentFullName` = 'Timothy Dean' ,`ListOfficeName` = 'Blackshear Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.335976' ,`Longitude` = '-95.435464' ,`PhotoCount` = '30' ,`PostalCode` = '77301' ,`RoomCount` = '4' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant' ,`StreetNumber` = '1057' ,`StreetSuffix` = 'Bend' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come find out why Conroe is one of the fastest growing cities in Texas! You are going to love this beautiful 4 bedroom 2 bathroom home that is located in the highly sought after neighborhood of Briar Grove. Come and see all the home has to offer. This home has a large open kitchen, living and dinning area, a great primary bedroom with a soaking tub and a separate shower. It also has plenty of room to raise a family with four bedrooms and large backyard for the kids to play. The owner recently added a new stove and dishwasher. You also have quick access to shops and restaurants and interstate 45.' ,`Acres` = '0.1659' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S267404 - BRIAR GROVE 04, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Grove 04' ,`TaxAmount` = '4152' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220122' WHERE `Matrix_Unique_ID` = '210320185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:05:22.540' ,`MLSNumber` = '68995160' ,`ListAgentFullName` = 'Nicholas Hughley' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888683' ,`Longitude` = '-95.724838' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Honey Pine' ,`StreetNumber` = '7507' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious and open floor plan located in a cul de sac! This home is ready for you to make your own with SOLAR PANELS to help fight the rising cost of energy bills. Updated TANKLESS WATER HEATER! Plus the WASHER, DRYER and REFRIGERATOR will stay with the home. BRAND NEW stainless steel range/oven. Come enjoy the quiet Canyon Village At Cypress Springs subdivision with its highly rated schools and school district. Spacious bedrooms and game room upstairs make this a great home in a great neighborhood! Schedule your appointment before it’s too late!' ,`Acres` = '0.1503' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 3 CANYON VILLAGE AT CYPRESS SPRINGS SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6545' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Spgs' ,`TaxAmount` = '6749' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220122' WHERE `Matrix_Unique_ID` = '210566476' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:13:17.523' ,`MLSNumber` = '71505016' ,`ListAgentFullName` = 'Matthew Everett' ,`ListOfficeName` = 'Matthew Everett Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687575' ,`Longitude` = '-95.474014' ,`PhotoCount` = '41' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '609000.00' ,`Status` = 'Active' ,`StreetName` = 'Darnell' ,`StreetNumber` = '5218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Traditional exterior with an interior that has been modernized and custom fitted, beautiful finishes. Sought after schools, open concept living area, close to everything, custom cabinetry throughout, walk-in closets, huge master bathroom, upstairs entertainment room with it\'s own private bedroom and shower, perfect for a teenager, giant oak trees. Looks modern but has tons of charm. Must see!' ,`Acres` = '0.1974' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 23 MEYERLAND SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '411' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '13984' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220122' WHERE `Matrix_Unique_ID` = '210907975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:05:16.263' ,`MLSNumber` = '16241765' ,`ListAgentFullName` = 'Monica LaFuente' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'Ced Thomas' ,`SellingOfficeName` = 'Legacy Homes & Properties, LLC' ,`Latitude` = '29.986879' ,`Longitude` = '-95.512022' ,`PhotoCount` = '37' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '334990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Glen Erica' ,`StreetNumber` = '13506' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous remodeled, well taken care of home located in the well established Huntwick neighborhood!! This beauty offers a stunning well landscaped front and backyard with full sprinkler system with double pane windows and a detached 2 car garage. The home has fresh paint throughout and 2 bedrooms downstairs with 3 bedrooms upstairs. The extra bedroom downstairs makes for a great nursey, study, or aging parent room. Schedule your appointment today!!' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 5 HUNTWICK FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest' ,`TaxAmount` = '5279' ,`TaxRate` = '2.4306' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220123' WHERE `Matrix_Unique_ID` = '210919529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:35:02.880' ,`MLSNumber` = '73514776' ,`ListAgentFullName` = 'David Myres' ,`ListOfficeName` = 'Myres Properties LLC' ,`SellingAgentFullName` = 'Ye Zhang' ,`SellingOfficeName` = 'Opendoor Brokerage, LLC' ,`Latitude` = '29.791959' ,`Longitude` = '-95.580604' ,`PhotoCount` = '22' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '449000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sherwood Park' ,`StreetNumber` = '1422' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location. This home is in the energy corridor, near City Center, Memorial City, and near all the restaurants and shopping you will ever need. Beautiful gated neighborhood, high ceilings, double driveway to attached garage. Primary bedroom on 1st floor, Gameroom with two bedrooms upstairs. The back yard is fenced with plenty of space for kids, pets and entertaining.' ,`Acres` = '0.106' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 SHERWOOD PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Park' ,`TaxAmount` = '8217' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220123' WHERE `Matrix_Unique_ID` = '210987178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:37:04.423' ,`MLSNumber` = '65627659' ,`ListAgentFullName` = 'John Mai' ,`ListOfficeName` = 'Altus Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.132990' ,`Longitude` = '-95.058215' ,`PhotoCount` = '24' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '819000.00' ,`Status` = 'Active' ,`StreetName` = 'Miramar' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Customer built with open premium floor plan and Lots of personal upgrades! Vacation Home!!!Private walking staircase to main floor. Two lots combine premium existing lot!! The house is fully furnished with all appliances, TV, and furnitures. Huge master bedroom with private balcony and wood fired place. 14 feet above ground, exquisite cargo lift and spiral staircase to go up first floor. Custom cat5 every room, Pre-wired entertainment in living room and security throughout house. premium trex decking throughout house to view beach side and bay side. Subdivision has private public pool, fishing, and outdoor boat ramp! Soaring crown molding ceiling with chandelier and custom granite counters, water softener, 5 tons energy efficiency A/C. Private security surround house included. Agent is related owner. Ready to move in !!' ,`Acres` = '0.2838' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOTS 140 & 141 (141-0) TERRAMAR BE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '12362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Terramar Sec 7' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664220123' WHERE `Matrix_Unique_ID` = '211236706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:29:34.160' ,`MLSNumber` = '83676866' ,`ListAgentFullName` = 'Ruben Chan' ,`ListOfficeName` = 'Intercontinental, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699138' ,`Longitude` = '-95.329898' ,`PhotoCount` = '41' ,`PostalCode` = '77021' ,`RoomCount` = '2' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Beekman' ,`StreetNumber` = '5511' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bedroom 1 bath home in Macgregor Place. Quick commute to the Downtown, the Medical Center and UofH.' ,`Acres` = '0.1653' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 81 BLK 4 MACGREGOR PLACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Macgregor Place Sec 03' ,`TaxAmount` = '2898' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220123' WHERE `Matrix_Unique_ID` = '211276537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:44:46.600' ,`MLSNumber` = '91286449' ,`ListAgentFullName` = 'Ashley Whitehead' ,`ListOfficeName` = 'Home Sweet Home RE Group' ,`SellingAgentFullName` = 'Juana Castillo' ,`SellingOfficeName` = 'Thompson & Associates' ,`Latitude` = '30.418077' ,`Longitude` = '-95.413222' ,`PhotoCount` = '50' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '160000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Royal West' ,`StreetNumber` = '12488' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute mobile home in highly sought after Royal Forest neighborhood! This home has 4 bedrooms, a great open floor plan and a oversized detached garage. Updated floors and bathrooms. Priced to sell quickly, so don\'t wait!' ,`Acres` = '0.2153' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROYAL FOREST 02, LOT 2060, MH SERIAL # TXFL2AD458402045, TIT' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Forest 02' ,`TaxAmount` = '950' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220123' WHERE `Matrix_Unique_ID` = '211364374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:52:00.567' ,`MLSNumber` = '12267300' ,`ListAgentFullName` = 'Marisa Bowe' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807412' ,`Longitude` = '-95.827334' ,`PhotoCount` = '40' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '499495.00' ,`Status` = 'Active' ,`StreetName` = 'Fawnlake' ,`StreetNumber` = '6002' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Zoned to home of THE Katy Tigers, this MOVE IN READY 5/3.5/2 CAR GARAGE corner lot (with lakes views) beauty has every single major ticket expense taken care of starting with a completely redone HVAC (2020), BRAND NEW CARPET, newer radiant barrier roof (2019), and new water heaters (2021), and that’s just the mechanical operations of the home. This home offers PLENTY OF SPACE starting with a grand entry leading you to a formal living/dining and study. Engineered hardwood in your living area goes perfectly with the new built-in that serves as perfect spot to store those Katy Tiger trophies for the world to see and compliments your freshly painted crisp white kitchen. The rest of your home is MASSIVE and offers a primary suite with new French doors leading to the very new decked porch, and an en suite with separate tub and shower. Walk upstairs and you will find a Texas sized game room/media room, FOUR secondary bedrooms with walk-in closets and access to TWO FULL secondary baths.' ,`Acres` = '0.195' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 FAWNLAKE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '11108' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fawnlake' ,`TaxAmount` = '8420' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664220123' WHERE `Matrix_Unique_ID` = '211377075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:59:28.583' ,`MLSNumber` = '89494718' ,`ListAgentFullName` = 'Leticia Guzman' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Gay Milliorn' ,`SellingOfficeName` = 'RE/MAX Eastside' ,`Latitude` = '29.675759' ,`Longitude` = '-95.093467' ,`PhotoCount` = '12' ,`PostalCode` = '77536' ,`RoomCount` = '6' ,`ListPrice` = '219000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '2609' ,`StreetSuffix` = 'Trail' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Schedule to Tour this lovely home ready for a new family to call this home. Add your touch to this conveniently located home in Deer Park. All tile and laminate flooring throughout. Spacious Kitchen with a breakfast bar. In need of some TLC but has a lot of potential. Near schools and great Neighborhood. Call your Realtor today to schedule your showing.' ,`Acres` = '0.163' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 9 MEADOW VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (LA PORTE)' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Village Sec 01' ,`TaxAmount` = '4791' ,`TaxRate` = '2.7308' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664220124' WHERE `Matrix_Unique_ID` = '211543240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:10:51.837' ,`MLSNumber` = '10893194' ,`ListAgentFullName` = 'Jason Nguyen' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750497' ,`Longitude` = '-95.402013' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '7' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunlavy' ,`StreetNumber` = '1725' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Montrose, IKLO homes bring you six modern-inspired homes. Each provides an open concept second-floor living space which is great for entertaining. Large windows throughout the home offer abundant natural light. At the same time, cooking your favorite meals in the expansive kitchen outfitted with Bosch appliances, quartz countertops & custom cabinets. The large living room features high ceilings with a stone veneered gas fireplace and a balcony overlooking the neighborhood. Don\'t forget about the primary bedroom, which features a double tray ceiling and large windows. Get ready each day in the luxurious spa-inspired primary bathroom with Italian porcelain tile flooring, mosaic backsplash, dual rain showerheads, and a separate soaking tub. Enjoy evenings on your fourth-floor rooftop deck decorated with teak wood & turf flooring while overlooking views of Houston.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'IKLO Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 4 Block 1 Dunlavy Landing' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1525' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Dunlavy Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664220124' WHERE `Matrix_Unique_ID` = '211570014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:09:40.217' ,`MLSNumber` = '12497656' ,`ListAgentFullName` = 'Thomas Eureste' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750497' ,`Longitude` = '-95.402013' ,`PhotoCount` = '45' ,`PostalCode` = '77006' ,`RoomCount` = '8' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunlavy' ,`StreetNumber` = '1801' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the heart of Montrose, IKLO homes bring you six modern-inspired homes. Each provides an open concept second-floor living space which is great for entertaining. Large windows throughout the home offer abundant natural light. At the same time, cooking your favorite meals in the expansive kitchen outfitted with Bosch appliances, quartz countertops & custom cabinets. The large living room features high ceilings with a stone veneered gas fireplace and a balcony overlooking the neighborhood. Don\'t forget about the primary bedroom, which features a double tray ceiling and large windows. Get ready each day in the luxurious spa-inspired primary bathroom with Italian porcelain tile flooring, mosaic backsplash, dual rain showerheads, and a separate soaking tub. Enjoy evenings on your fourth-floor rooftop deck decorated with teak wood & turf flooring while overlooking views of Houston.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'IKLO' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 Block 1 Dunlavy Landing' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1525' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Dunlavy Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664220124' WHERE `Matrix_Unique_ID` = '211570184' --> 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','211593284','1664220124','211593284','2022-09-26T07:28:50.393','19306736','Asha Charles','Blue Diamond Realty','','','30.024222','-95.536243','50','77379','9','544000.00','Active','Borough','17438','Lane','Spring','3','1','5','4118','Single-Family','This beautiful, spacious 5 Bedroom/3.5 Bath, is located in the quiet subdivision of Memorial Northwest. There are two staircases in the home which gives easy access to any area. The master bedroom is located on the main floor and has a beautiful view of the private pool in the backyard. The office is very spacious and perfect for someone working from home. The backyard has a private swimming pool and spa and is ideal for relaxing after a long day\'s work. The game room has a Pool/Tennis table that is great for entertaining guests. There is an additional play room on the second floor which can be potentially a nursery or 6th bedroom. Four bedrooms are located on the second floor and each room is connected with a Jack and Jill bathroom.','0.1857','13','','','Electric Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Champions Area','Central Electric','1','LT 15 LESS SW 6 FT BLK 1 MEMORIAL NORTHWEST SEC 25','Subdivision Lot','8087','Appraisal District','','696','0','','3','Electric Oven','1','Enclosed','','Electric Range','','Composition','32 - Klein','THEISS ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','DOERRE INTERMEDIATE SCHOOL','Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Memorial Northwest','9620','2.5085','Public Sewer,Public Water','1998','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:11:32.800' ,`MLSNumber` = '31807216' ,`ListAgentFullName` = 'Jennifer Cassidy' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769464' ,`Longitude` = '-95.565161' ,`PhotoCount` = '31' ,`PostalCode` = '77024' ,`RoomCount` = '11' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Traviata' ,`StreetNumber` = '12934' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic one-story ranch style home located in sought after Memorial Bend boasts gleaming original (per seller) hardwood floors, two spacious living areas, beautiful wood beams in formal dining and family room, and shutters throughout. Yard features old growth trees and iron gate in back for privacy. Per seller, NEVER FLOODED. Conveniently located near Terry Hershey Park and fabulous dining and shopping at Town & Country and City Centre. Zoned to exemplary Spring Branch ISD schools and easy access to Beltway 8, tollway, and freeways…location, location! *Room sizes are approximate. Buyer to verify room dimensions and school information.' ,`Acres` = '0.1983' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 11 MEMORIAL BEND SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '411' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Memorial Bend Sec 02' ,`TaxAmount` = '11165' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220124' WHERE `Matrix_Unique_ID` = '211770946' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:52:23.327' ,`MLSNumber` = '89544198' ,`ListAgentFullName` = 'Jonathan Layton' ,`ListOfficeName` = 'Luxely Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.631305' ,`Longitude` = '-95.360941' ,`PhotoCount` = '30' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '105900.00' ,`Status` = 'Active' ,`StreetName` = 'Edgar' ,`StreetNumber` = '11903' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all DIY buyers & investors, come and see this wonderful gem in the rough with lots of value add potential, boasting an open living area and spacious floor plan with lots of natural light—all bedrooms down with large baths. Don\'t miss this excellent value add opportunity with tons of upside! HURRY AND MAKE YOUR APPOINTMENT TODAY!\r\nTWO PHOTOS ARE VIRTUALLY STAGE. multiple offer and best & final due 9.26.2022 at 5:00pm.' ,`Acres` = '0.1983' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 7 PARADISE VALLEY' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8637' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Paradise Valley' ,`TaxAmount` = '2427' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664220124' WHERE `Matrix_Unique_ID` = '211803171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:46:11.180' ,`MLSNumber` = '86829100' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568738' ,`Longitude` = '-95.064339' ,`PhotoCount` = '27' ,`PostalCode` = '77586' ,`RoomCount` = '3' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Shirleen' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2420' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HONEY STOP THE CAR! WOW! Lovely 3-bedroom 2 bath COMPLETELY updated…. Granite counters throughout…NEW Driveway…Stainless steel appliances… new carpet in all bedrooms… Gorgeous standing shower in master bathroom…Open Kitchen to family room with fireplace… HUGE Living area perfect for family gatherings!... Beautiful neighborhood only 5 minutes from the Water! This is a dream home looking for it\'s new owner DON’T miss out!' ,`Acres` = '0.1928' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 EL CARY ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'El Cary Estates' ,`TaxAmount` = '6241' ,`TaxRate` = '2.2819' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220124' WHERE `Matrix_Unique_ID` = '211808014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:10:13.943' ,`MLSNumber` = '7236951' ,`ListAgentFullName` = 'Amy Vanterpool' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136872' ,`Longitude` = '-95.061072' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Martes' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All one level three bedrooms two bathrooms, canal front home in Terramar Beach. Windows have storm shutters you will really enjoy all the deck and patio space as well as the downstairs storage and yard area. Terramar community offers a pool, boat ramp, beach access, frisbee golf course, and pavilion area. Terramar is close to Sea Isle restaurant, marina, & stores. Buyer to verify room dimensions and details of the property. Everything stays with the sale of the property. Property is being sold AS IS.' ,`Acres` = '0.123' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 12 LOT 6 BLK 8 TERRAMAR BEACH SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Terramar 4' ,`TaxAmount` = '7438' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220125' WHERE `Matrix_Unique_ID` = '211902844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:21:47.943' ,`MLSNumber` = '61250211' ,`ListAgentFullName` = 'Shannon Hall' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.371415' ,`Longitude` = '-95.386349' ,`PhotoCount` = '47' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Red Stag' ,`StreetNumber` = '12412' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1.5 story home situated on 1 acre cul-de-sac homesite featuring saltwater pool/spa and 35x30 metal building! 4 bedrooms, 2.5 baths and oversized 2 car garage with tons of storage! Recent improvements throughout including paint, 2\" blinds, light fixtures, storm door, added closet to make 4th bedroom, Carrier 5 Ton/16 Seer condenser/heat pump/Remi Halo & Attic tent/ w/ 10 year warranty (All in July 2022). Open study/formal dining area with built-in display/book case. Large living room features wood floors, stone fireplace all open to the remodeled kitchen w/ huge island! Outside you\'ll find a large covered patio with outdoor fireplace and a half bath overlooking the pool area! The metal building is well insulated and includes an extra 10\' of covered space on the backside, there is also a storage shed for lawn equipment! This amazing property has it all, make your appointment today! Too many upgrades to list here call today for full list!' ,`Acres` = '1.005' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S400800 - DEER TRAIL 01, BLOCK 1, LOT 32, ACRES 1.005' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '43778' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '288' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Trail 01' ,`TaxAmount` = '5960' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220125' WHERE `Matrix_Unique_ID` = '211974943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:47:57.260' ,`MLSNumber` = '13402823' ,`ListAgentFullName` = 'Anh Tran' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545331' ,`Longitude` = '-95.095776' ,`PhotoCount` = '16' ,`PostalCode` = '77058' ,`RoomCount` = '4' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Saxony' ,`StreetNumber` = '1502' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1765' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This corner lot home surrounded by beautifully trimmed mature trees in sought after Nassau Bay. Home features huge living area highlighted by large windows, a gas log fireplace and has lots of natural lights. Updates include kitchen boasts quartz counters, beautiful backsplash and stainless appliances. New luxury vinyl planks and tile floorings. Updated baths, ceiling fans, light fixtures, faux wood blinds. Fresh interior and exterior paints. Never Flooded. Nassau Bay offers many amenities, parks, lakes, trails and wildlife reserve. Hurry! This is what you are looking to call home.' ,`Acres` = '0.2696' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1O NASSAU BAY SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11745' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Nassau Bay Sec 01' ,`TaxAmount` = '6142' ,`TaxRate` = '2.4882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220125' WHERE `Matrix_Unique_ID` = '212151384' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:49:45.740' ,`MLSNumber` = '25715144' ,`ListAgentFullName` = 'Evelyn Martinez' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.491613' ,`Longitude` = '-95.160985' ,`PhotoCount` = '31' ,`PostalCode` = '77573' ,`RoomCount` = '0' ,`ListPrice` = '264999.00' ,`Status` = 'Active' ,`StreetName` = 'Woodvale' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**WELCOME HOME ! ** You’ll fall in love with this charming, beautiful and cozy one story home nestled in League City. This 3 bedroom and 2 bath home offers a brick exterior, high ceilings, formal dining room, granite counter tops in the kitchen and a living room that features a brick wood burning fireplace. This home has a relaxing primary suite that features a walk-in closet and a spacious backyard perfect for entertaining. Residents enjoy a short walking distance to Clear Creek, tennis courts, a swimming pool, walking trails, and parks. Located off I-45, commuters are a short drive from Clear Lake, Galveston Bay, and the Kemah waterfront., Space Center Houston and Baybrook Mall are all minutes away. Nearby schools are a part of Clear Creek ISD. \r\n\r\nThis home will not last long! OPEN HOUSE SATURDAY 9/10 & SUNDAY 9/11 12PM - 3PM' ,`Acres` = '0.1737' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR LOT 44 BLK 5 COUNTRYSIDE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7568' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '346' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryside' ,`TaxAmount` = '3699' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220125' WHERE `Matrix_Unique_ID` = '212325444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:42:33.970' ,`MLSNumber` = '80422077' ,`ListAgentFullName` = 'Jonathan Holley' ,`ListOfficeName` = 'Dash Realty' ,`SellingAgentFullName` = 'Rhan Pruitt' ,`SellingOfficeName` = '1st Texas, Realtors' ,`Latitude` = '29.485434' ,`Longitude` = '-95.128453' ,`PhotoCount` = '9' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '237500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Orion' ,`StreetNumber` = '2604' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home priced to sell. This quaint home features a large den with windows in back looking on to deck and yard. Good sized primary bedroom that is split from other 2 rooms for that little extra privacy. Dining area open to family room and kitchen. Family room has a nice corner fireplace and breakfast bar. Kitchen has extra door to side yard. Big back yard with beautiful oak tree. There is a storage unit in back as well. 2 car garage in good condition. Dont miss out on this opportunity' ,`Acres` = '0.16' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 PAGE 7 LOT 14 BLK 3 THE LANDING SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Landing 2' ,`TaxAmount` = '4371' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220125' WHERE `Matrix_Unique_ID` = '212390909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:22:00.283' ,`MLSNumber` = '39714615' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693750' ,`Longitude` = '-95.468363' ,`PhotoCount` = '34' ,`PostalCode` = '77401' ,`RoomCount` = '16' ,`ListPrice` = '1849000.00' ,`Status` = 'Active' ,`StreetName` = 'Valerie' ,`StreetNumber` = '5102' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this 5/6 bedroom home situated on a \"half-acre\" lot in Bellaire\'s most esteemed area, Braeburn Country Club Estates! This move-in ready home offers an exceptional floor plan! On the 1st floor you\'ll find a grand entrance w/dramatic staircase, private office/library, game room, formal dining & living room, an open plan family room & kitchen w/eat in breakfast area. The large first floor game room w/en-suit bathroom could serve as an in-law suite (6th bedroom). The second floor features 5 bedrooms plus a study desk & second floor loft area, perfect for games & reading. The primary bedroom suite w/vaulted ceilings includes a spacious bathroom, large walk-in closet & private balcony. The huge backyard provides a private setting w/two covered patios, a beautiful pool, large mature trees & plenty of green space left over for pets and play. Additional features include a sport court situated behind a double wide driveway gate & mosquito system, excellent storage & more! No flooding!' ,`Acres` = '0.4339' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BRAEBURN CNTRY CLUB ESTS SEC B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Cntry Club Estates Se' ,`TaxAmount` = '36169' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220126' WHERE `Matrix_Unique_ID` = '212506280' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T06:53:29.987' ,`MLSNumber` = '68271094' ,`ListAgentFullName` = 'Jeri Bailey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.617070' ,`Longitude` = '-95.059849' ,`PhotoCount` = '21' ,`PostalCode` = '77331' ,`RoomCount` = '13' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Paradise' ,`StreetNumber` = '40' ,`StreetSuffix` = 'Trail' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME TO PARADISE! SPECTACULAR WATERVIEW TWO STORY HOME. This one of a kind home is situated on 2 lots (over 1/2 acre) and the home sits high on a hill giving you fantastic views of Lake Livingston. Layout is open and spacious w/living area open to the views and lots of natural light. Austin stone wood burning fireplace. Kitchen has stainless steel appliances, granite countertops, walk-in pantry & desk area w/ lots of cabinets. Updates include new paint, awning over sunroom, AC units, windows throughout house w/lifetime warranty, PEX plumbing in attic from upstairs bathroom to hot water heater. Updated bathrooms include walk-in shower, fixtures, flooring & paint. Oversized detached 2 car garage w/ full bathroom & upstairs unfinished bonus room. Views from every bedroom! Neighborhood is small, quiet & friendly w/amenities - boat ramp, park, swimming area & private pier. Sit on your wrapped porch or entertain in the sunroom. Come live where you are always \"Living on Lake Time\"' ,`Acres` = '0.6984' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARADISE COVE, BLOCK 7, LOT 25 & 26, ACRES .6984' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '30422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas 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,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Paradise Cove' ,`TaxAmount` = '5190' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220126' WHERE `Matrix_Unique_ID` = '212517553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:04:54.520' ,`MLSNumber` = '26132545' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.017560' ,`Longitude` = '-95.301660' ,`PhotoCount` = '28' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Chancewood' ,`StreetNumber` = '8135' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1800+ Square feet of room and a recently remodeled interior! This MOVE-IN ready home has granite countertops in the kitchen and bathrooms, and new and modern laminate flooring. This home features 3 bedrooms, 2 and a half bathrooms, a large kitchen pantry, and a covered back patio. Plenty of room for fun and entertainment in this home. With the half bathroom downstairs, your guests will never have to go upstairs. There is room in the driveway for parking 2 cars. You won\'t find a larger backyard for this price! This one is ready to be your next home or investment property. Schedule your showing today!' ,`Acres` = '0.0964' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 KENSWICK FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Forest' ,`TaxAmount` = '4225' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220126' WHERE `Matrix_Unique_ID` = '212572007' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:19:21.497' ,`MLSNumber` = '84356562' ,`ListAgentFullName` = 'Nguyen Vo' ,`ListOfficeName` = 'Branford Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465363' ,`Longitude` = '-95.103740' ,`PhotoCount` = '13' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Dale Ridge' ,`StreetNumber` = '243' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! The Canterbury is a single family one-story house floor plan with three bedrooms and 2 bathrooms, a spacious family room with a kitchen adjoined to the breakfast area. The master suite have a large walk-in closet in the owners retreat, and a walk-in utility room with convenient access to the attached garage. A prime location in Dickinson, within easy reach of all the options for retail, dining, and health care. Come and schedule your private tour today!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Anglia Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 3 Bay View Sec 4 (2018) ABST 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay View' ,`TaxAmount` = '7440' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220126' WHERE `Matrix_Unique_ID` = '212591817' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:38:10.973' ,`MLSNumber` = '89291055' ,`ListAgentFullName` = 'Daicel Prat' ,`ListOfficeName` = 'J.D. Realty' ,`SellingAgentFullName` = 'Kharter Romero' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '29.873041' ,`Longitude` = '-95.474162' ,`PhotoCount` = '49' ,`PostalCode` = '77088' ,`RoomCount` = '11' ,`ListPrice` = '289000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Antoine' ,`StreetNumber` = '7531' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunningly Renovated 4 Bedrooms, 2 1/2 Baths home overlooking the golf course in Inwood Forest! This beautiful home has received a Complete makeover for your enjoyment. Newly installed roof w/warranty & Newly installed HVAC system w/warranty. As soon as you walk in, the open-concept floor plan greets you to the beautiful golden fixtures/finishes. Just placed porcelain tile flooring on the 1st floor, newly installed carpet in bedrooms on the 2nd floor & laminate floor in Primary Suite. Entertain a family meal in the updated kitchen displaying Quartz countertops & new appliances. Recessed lights all throughout & white walls to indulge in the light-filled living area. Unwind under the rain shower in Primary Ensuite bathroom displaying newly installed tempered glass sliding shower glass doors. From recently placed Electrical Panel, new garage doors w/remote, toilets, & freshly painted interior/exterior.' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Frst Sec 7' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664220126' WHERE `Matrix_Unique_ID` = '212610885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:06:44.703' ,`MLSNumber` = '45386364' ,`ListAgentFullName` = 'Jasmine Alexander' ,`ListOfficeName` = 'Collective Realty Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518218' ,`Longitude` = '-95.439107' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Plumtree Trace' ,`StreetNumber` = '4741' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious, single story plan built by Lennar located just 25 mins from Downtown Houston. This like new home features a dramatic front porch and inviting entry foyer. The office features beautiful french-style doors. The Beautiful open island kitchen offers granite counter tops and 42 inch cabinets, with access to a walk-in pantry and the walk-in utility room. Enjoy a open concept family room with track lighting. The primary bedroom offers cathedral ceilings, double door bathroom, double vanity sinks, and spacious walk in closet. Enjoy your new backyard oasis complete with an extended covered patio. A tandem garage boasts additional storage space, and also offers convenient access to the walk-in utility room.This home is equipped with smart technology and includes a sprinkler system. Schedule your tour TODAY!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0012 BLK 004 LOT 010' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '5032' ,`TaxRate` = '3.3694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220126' WHERE `Matrix_Unique_ID` = '212640329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:20:23.710' ,`MLSNumber` = '51622915' ,`ListAgentFullName` = 'Stephanie Vega' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = 'Tamara Robert' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.861889' ,`Longitude` = '-95.691058' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '237000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Willow Bluff' ,`StreetNumber` = '6231' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1251' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this tastefully remodeled home located in the established Brenwood Park Subdivision. This home features high ceilings, open floor plan and kitchen large enough to entertain your guests. Kitchen includes new countertops, peninsula and spacious island and modern backsplash. Primary bathroom features oversized walk in frameless shower with a bench and double sink vanity. Other upgrades include water heater (2019), HVAC with all new air ducting (2020), modern accent fireplace wall and upstairs carpet (2021). Backyard is spacious and includes a large storage room that can be multi-purposed.' ,`Acres` = '0.1056' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 6 BRENWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood Sec 01' ,`TaxAmount` = '3541' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220127' WHERE `Matrix_Unique_ID` = '212750770' --> 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','212796128','1664220127','212796128','2022-09-26T06:22:39.643','56421715','Arantza Egana','Rice Realty Group LLC','','','29.639270','-95.518477','22','77071','3','280000.00','Active','Barbara','15351','Circle','Houston','3','0','3','1826','Single-Family','Beautiful and spacious house right here in Houston!! Just minutes away from Highway 90 and Beltway 8!! Close to Medical Center!! Backyard has an enormous amount of space for the perfect family gatherings!! Kitchen outside is available for Grilling!! Jacuzzi will also be included with purchase of home!! Two extra rooms were added to garage!! Includes a restroom and a shower as well!! Hurry!! This beautiful home wont last long!!','0.2011','20','','','','','Mud,Sellers Disclosure','1','','1','Missouri City Area','Central Electric','1','LT 1 BLK 23 FONDREN PARK SEC 5','Corner','8760','Appraisal District','','315','0','','1','','0','','','','','Wood Shingle','27 - Houston','GROSS ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','WELCH MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Fondren Park Sec 05','4799','2.7379','Public Water','1963','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:27:04.500' ,`MLSNumber` = '7272376' ,`ListAgentFullName` = 'Rosemary Choi' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.532128' ,`Longitude` = '-95.024183' ,`PhotoCount` = '9' ,`PostalCode` = '77565' ,`RoomCount` = '8' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Kemah Oaks' ,`StreetNumber` = '1722' ,`StreetSuffix` = 'Drive' ,`City` = 'Kemah' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1823' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated kitchen. 4 Bedroom with custom porch. A must see! Will go fast!' ,`Acres` = '0.1446' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 LOT 6 BLK 1 KEMAH OAKS SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Kemah Oaks Sub 92' ,`TaxAmount` = '4431' ,`TaxRate` = '2.0134' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220127' WHERE `Matrix_Unique_ID` = '212810412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:35:08.127' ,`MLSNumber` = '53745935' ,`ListAgentFullName` = 'Bonnie Schinnerer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.846580' ,`Longitude` = '-94.847636' ,`PhotoCount` = '39' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Broadmoor' ,`StreetNumber` = '4010' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Wilburn Ranch Subdivision. One of the most sought out subdivisions in Mont Belvieu, TX. Over 3000 sq ft 1 story beautiful home has 4 large bedrooms, 3 1/2 bathrooms, dining room, office/study and sits on a little over 1/4-acre lot, large enough for a swimming pool. As you walk through the front door you will notice the 12ft ceilings, hard wood floors and crown molding throughout the home. Open concept gourmet kitchen extends into the living room perfect for entertaining family and friends. Kitchen features dark expresso cabinets, granite counter tops, breakfast nook and a white stone wrap around island with granite countertop. The master bedroom has a huge master bath with a jetted jacuzzi tub and an oversized master closet. One of the bedrooms includes an ensuite bathroom. Large backyard patio and a 10x20 shed. Enjoy morning or nightly walks on the walking trail. Prime location for dining, shopping and only 30 minutes to Houston. Low Taxes, A+ Rating BHISD' ,`Acres` = '0.378' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 5 LT 35 WILBURN RANCH S/D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16466' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilburn Ranch Sub' ,`TaxAmount` = '8304' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664220127' WHERE `Matrix_Unique_ID` = '212816595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:03:00.830' ,`MLSNumber` = '51685536' ,`ListAgentFullName` = 'Jennifer Cannon' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448282' ,`Longitude` = '-95.098405' ,`PhotoCount` = '12' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Springs' ,`StreetNumber` = '217' ,`StreetSuffix` = 'Court' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2197' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 Bedroom Move-In Ready 2 STORY with game-room in Bay Colony! CORNER LOT AND NEVER FLOODED! Large primary located on 1st Floor with Formal Dining, Breakfast and Living. Upgraded kitchen appliances with a fireplace to keep you warm this winter. 3 bedrooms upstairs with large closets, game-room and a full bath. Come see this property and its many upgraded features! New HVAC in 2016 with brand new condenser coil this past month. New AC evaporator coil in 2020. Solar Screens on all windows. Extra wide driveway with concrete sidewalk all the way to the backyard. Huge back patio slab that runs beyond the entire length of the home. Double gates for for vehicle access to the backyard. Work bench and shelves built into the garage. Home is wired for 30 amp generator plug and breaker for portable generator backup. Come by to see all this lovely home has to offer!' ,`Acres` = '0.1369' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAY COLONY POINTE SEC 2 (2000), ABST 19, BLOCK 3, LOT 10, AC' ,`LotDesciption` = 'Corner' ,`LotSize` = '5962' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '296' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Colony Pointe West' ,`TaxAmount` = '6473' ,`TaxRate` = '2.8897' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220127' WHERE `Matrix_Unique_ID` = '212824743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:58:21.440' ,`MLSNumber` = '60829042' ,`ListAgentFullName` = 'Judy Foster' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.651687' ,`Longitude` = '-95.663539' ,`PhotoCount` = '37' ,`PostalCode` = '77498' ,`RoomCount` = '8' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce River' ,`StreetNumber` = '15803' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2164' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculately maintained one story home on a cut de sac in Village of Oak Lake. Gorgeous granite countertops in both the kitchen and bathrooms, gleaming hardwood floors and tile through out the home. High ceilings and lots of Natural light flow through the Open Concept Living Area. Primary closet features custom closet system. Radiant Barrier and extra insulation in the Attic. This home features a gas fireplace and gas range. Refrigerator and Washer/Dryer stay! Rooms are generously sized and include beautiful crown molding. Zoned to great Fort Bend ISD schools, walking distance to the Elementary school, club house, tennis court and pool. Features a very private backyard with only one neighbor, extra room could be the 4th bedroom, flex room or office/study. Come see this one, you will not be disappointed!' ,`Acres` = '0.1739' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGE OF OAK LAKE R/P, BLOCK 1, LOT 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '7575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Of Oak Lake R/P' ,`TaxAmount` = '4937' ,`TaxRate` = '2.2529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220127' WHERE `Matrix_Unique_ID` = '212835920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:12:37.213' ,`MLSNumber` = '10412240' ,`ListAgentFullName` = 'Ana Correa' ,`ListOfficeName` = 'All Star Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.061929' ,`Longitude` = '-95.387077' ,`PhotoCount` = '24' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '218000.00' ,`Status` = 'Active' ,`StreetName` = 'Farm Hill' ,`StreetNumber` = '24027' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to your new home in the well-established neighborhood of North Spring! Zoned to Spring Schools! This Charming single story is a 3/2/2 that offers an open concept plan with high ceilings in the living room. Updates include a new roof 11/21, HVAC 2017, Garage & garage floor painted 9/22. The family room has a laminate wood flooring, with a cozy gas, brick fireplace. Easy access to I-45, Hardy Toll Road and major shopping centers & entertainment. 17 mins to IAH, 15 mins to Exxon Campus, 20 mins to The Woodlands Mall/Market Street/Waterway, 40 min commute to Downtown' ,`Acres` = '0.1671' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 6 NORTH SPRING SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Spring Sec 06' ,`TaxAmount` = '4339' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220127' WHERE `Matrix_Unique_ID` = '212849352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-26T07:43:12.160' ,`MLSNumber` = '15303012' ,`ListAgentFullName` = 'Khai Tran' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747584' ,`Longitude` = '-95.574384' ,`PhotoCount` = '20' ,`PostalCode` = '77042' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Forest' ,`StreetNumber` = '11203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Timeless style meets modern convenience. This spectacular home sits on a corner lot. Covered patio provides a perfect outdoor space to lounge and entertain. Notable features include: French entry door, Luxury vinal wood floors, Spacious family room, Formal dining, Large primary suite, Custom bathroom design with his and her closets, New soft-close cabinets and Quartz counter-tops throughout, Large kitchen island, Breakfast bar, Samsung stainless appliance package, Modern colorway, Floating iron staircase, All new fixtures, 2 car garage. Located within the energy corridor. Shopping, entertainment and restaurants just a few minutes away. Schedule your showing today!' ,`Acres` = '0.0818' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 EXECUTIVE ROW T/H' ,`LotDesciption` = 'Corner' ,`LotSize` = '3562' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Executive Row' ,`TaxAmount` = '5690' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664220128' WHERE `Matrix_Unique_ID` = '212861734' --> 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','212868777','1664220128','212868777','2022-09-26T06:08:56.313','78717429','Marie Janke','Janke and Co Properties','','','29.233716','-94.890037','15','77554','9','1317000.00','Active','STARFISH DR','11376','','Galveston','3','0','4','2350','Single-Family','STUNNING Home is under construction, but don\'t let this stop you, make selections before it\'s too late! SHORT TERM RENTALS ALLOWED . This amazing 2,350 sq ft luxury vacation home has BEACHSIDE construction features that include 4-5 bedrooms and 3 full baths, DOUBLE BALCONIES, standing seam metal roof , a walk in closet in the primary bedroom with a walk out porch to enjoy your morning coffee! Also included are stainless kitchen appliances, pendant lighting over the kitchen island, easy care vinyl plank flooring, designer tile in bathrooms, custom wood kitchen cabinetry, quartz countertops and large kitchen island. Enjoy a bonus room and many more luxury amenities throughout . Be the first to make an offer and make floor plan selection if done prior to framing. This neighborhood is highly sought after and does allow short term vacation rental opportunities for additional income. Photos are from a sister property & may differ from actual buildout. Pool is optional, inquire for details.','','33','SANDPIPER HOMES INC','','Electric Dryer Connections','','No Disclosures,Other Disclosures','1','','','West End','Central Gas','1','Lot 606','Subdivision Lot,Water View','4800','Survey','','313','1','To Be Built/Under Construction','1','Freestanding Oven','0','','','Freestanding Range','','Aluminum,Other','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany','Builder','1','Traditional','BEACHSIDE VILLAGE','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212889789','1664220128','212889789','2022-09-26T06:53:32.293','34056729','Veso Kossev','The Kossev Group','','','29.920668','-95.573198','34','77064','9','325000.00','Active','Pony Express','10223','Road','Houston','2','1','3','2487','Single-Family','Fabulous 2 story home, 3 bedroom 2.5 bath home zoned to Cy-Fair ISD and move in ready! This open concept floor plan, perfect for entertaining, offers an abundance of natural light and laminate floors. Open kitchen design w/granite counters, natural stone backsplash, stainless appliances and a breakfast bar/pass through to the living room. Completing the 1st floor are a formal living and dining room, and family room with vaulted ceiling and fireplace. The 1st floor primary is spacious with 2 walk-in closets and an en-suite bathroom with dual sinks and a separate walk-in shower and bathtub. The 2nd floor is complete with 2 secondary bedrooms, 1 bathroom and a game room that overlooks the family room. The easily maintained backyard is fully fenced. The Neighborhood Park and pool are a short walk away and the home is conveniently located close to 290, Beltway 8 and SH249. Make an appointment to see this home today! Roof replaced in 2020.','0.1213','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Jersey Village','Central Gas','1','LT 2 BLK 3 WILLOW POINTE SEC 4','Subdivision Lot','5285','Appraisal District','','500','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','BANG ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Willow Pointe','6243','2.641','Water District','1995','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','212958850','1664220128','212958850','2022-09-26T06:25:22.800','87212824','Gayla Gayden','REALM Real Estate Professional','','','29.819780','-94.820866','31','77523','10','299990.00','Active','Lost Creek','610','Drive','Baytown','2','0','3','1409','Single-Family','The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story home with Amazing Stucco & Brick Elevation! Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Lush Carpeting in all the Bedrooms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING','','53','D.R. Horton','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Chambers County West','Central Gas','1','Raintree Lot: 17 /Block: 2','Subdivision Lot,Wooded','6600','Survey','','700','1','Never Lived In','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Leave Business Card,No Appointment Required,No Supra Keybox','Builder','1','Contemporary/Modern,Ranch,Traditional','Raintree','','1.69','Public Sewer,Public Water','2022','Builder'); --> New record created successfully