Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:50:44.777' ,`MLSNumber` = '39474812' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008732' ,`Longitude` = '-96.287016' ,`PhotoCount` = '49' ,`PostalCode` = '77418' ,`RoomCount` = '4' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Creek' ,`StreetNumber` = '495' ,`StreetSuffix` = 'Road' ,`City` = 'Bellville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET, due to buyer backing out for a personal situation, seller is motivated!! This beautiful Austin stone home is nestled back on -/+2 acres in the desirable Piney Creek community. Boasting an abundance of tree coverage, perimeter & cross fencing, automatic entrance gate, workshop with extended RV parking, nicely structured storage shed, private pool and so much more! Within the walls of this home, you will find a sturdy build being structured by steel beams, updated interior throughout with cream-colored distressed cabinets and granite counter tops, wood like tile flooring, sprawling Austin stone fireplace and like new carpet in the bedrooms. Relax on your extended front porch overlooking the countryside and the amazing wildlife that runs through this property. Call us today to schedule your private tour.' ,`Acres` = '2.102' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PINEY CREEK SUB SECT II LOT 59 (PART OF) TRACT A ACRES 2.102' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '91563' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Creek Sub' ,`TaxAmount` = '7249' ,`TaxRate` = '1.8096' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180410' WHERE `Matrix_Unique_ID` = '209622364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:22:13.083' ,`MLSNumber` = '2998756' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880152' ,`Longitude` = '-95.798764' ,`PhotoCount` = '49' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Switchgrass Valley' ,`StreetNumber` = '24438' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 2998756 - Built by Highland Homes - Ready Now! ~ The 204 plan is a large 1-story home with 4 bedrooms, a study up front, an entertainment room, and an open living, kitchen, and dining space. You will love the soaring ceilings and enhanced gourmet kitchen. Relax on the covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 ELYSON SEC 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8510' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675180411' WHERE `Matrix_Unique_ID` = '209755626' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:54:26.210' ,`MLSNumber` = '13414936' ,`ListAgentFullName` = 'Noel Mosher' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = 'Noel Mosher' ,`SellingOfficeName` = 'Adams Homes Realty, INC' ,`Latitude` = '29.162130' ,`Longitude` = '-95.420521' ,`PhotoCount` = '12' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '233400.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bryan Way' ,`StreetNumber` = '240' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story 1717 sq.ft with tall ceilings with 2 car garage. 4 sides brick with Covered Back Patio. 3 bedrooms and 2 full baths. Coffered ceilings in Family and Primary bedroom. Dining room has a bay window. Granite kitchen with deep under mount sink and 36\" cabinets with crown molding. Stainless steel 5 burner gas range, microwave, dishwasher, 2\" blinds included!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adama Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '0/0/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '281' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kiber Reserve' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675180411' WHERE `Matrix_Unique_ID` = '210031871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:37:03.863' ,`MLSNumber` = '54373303' ,`ListAgentFullName` = 'Matthew Scharff' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800686' ,`Longitude` = '-95.836661' ,`PhotoCount` = '45' ,`PostalCode` = '77493' ,`RoomCount` = '15' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Cottonwood Crest' ,`StreetNumber` = '6611' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this gorgeous home at 6611 Cottonwood Crest Ln in Falls at Green Meadows, adjacent to Cane Island, in the prestigious Katy ISD! Home features 4 bedrooms, 4 full baths, gourmet kitchen, and a 3 car garage. Primary bedroom has an en-suite bathroom, one of the secondary bedrooms is a full guest suite with attached bathroom and walk in shower. Wood floors, oversized tile and carpet throughout. Gourmet kitchen has granite counters, huge island with room for bar seating, stainless steel appliances with double wall ovens, 5 burner gas cooktop, built in microwave and dishwasher; walk in pantry, and the refrigerator stays. If you love open concept homes, this one is for you! Formal dining room located near the kitchen, overlooks the family room and back yard. Covered patio perfect for outdoor grilling or BBQ. Dual tankless water heaters. Bonus area upstairs has a game room and a media room along with a full bathroom. There is so much to like about this home, come and see it today.' ,`Acres` = '0.2211' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S474805 FALLS AT GREEN MEADOWS SECTION5 BLK 1 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Green Meadows Sec' ,`TaxAmount` = '13073' ,`TaxRate` = '3.4277' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180411' WHERE `Matrix_Unique_ID` = '211923370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:52:11.087' ,`MLSNumber` = '8171917' ,`ListAgentFullName` = 'James Rowlett' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = 'Darlene McKinney' ,`SellingOfficeName` = 'United Real Estate' ,`Latitude` = '30.066805' ,`Longitude` = '-95.425653' ,`PhotoCount` = '43' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '350000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Spring Lakes' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Haven' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great one-story 3 bedroom home in gated Spring Lakes! Neutral paint and tons of natural light. Formal dining adjacent to the home office/study with French doors. Spacious living room with gas-log fireplace. Open concept! Kitchen with granite counters, tons of cabinet space, and black appliances. The flex room is great for a secondary living space or children\'s play area. Large master bedroom with sitting area and ensuite bathroom. The bathroom features dual sinks, vanity area, jetted tub, separate shower, and a large walk-in closet. Two secondary bedrooms with a shared hall bath. Spacious backyard with a patio! Wonderful view of the neighborhood lake, directly across the street from the property. Don\'t miss this one!' ,`Acres` = '0.2152' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 SPRING LAKES SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '897' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SALYERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lakes Sec 07' ,`TaxAmount` = '7327' ,`TaxRate` = '2.9067' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180411' WHERE `Matrix_Unique_ID` = '213322709' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:02:21.980' ,`MLSNumber` = '33088696' ,`ListAgentFullName` = 'Abbie Walsh' ,`ListOfficeName` = 'Walsh &Mangan Premier RE Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.563874' ,`Longitude` = '-96.335776' ,`PhotoCount` = '45' ,`PostalCode` = '77845' ,`RoomCount` = '13' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Durrand' ,`StreetNumber` = '11824' ,`StreetSuffix` = 'Street' ,`City` = 'College Station' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy 2.64 acres in the beautiful and private Great Oaks neighborhood on a huge corner lot right in the heart of Aggieland. The main house has over 3400 sqft of living space with three oversized bedrooms and four full bathrooms. The recently remodeled kitchen features a large island, huge walk-in pantry, tons of counter and cabinet space, and new granite countertops. Entertain family and friends in this open floor plan with plenty of room for everyone. The oversized bedrooms have large closets and their own private bathroom. The additional 540 sqft detached addition is a perfect multi-purpose space with tons of storage. Spend your afternoons on the screened in back porch overlooking the beautifully manicured flowerbeds and backyard complete with a new fence. The property is heavily wooded with complete privacy all around and the cutest potting shed on site. So many new details added to this home including Starlink Internet service and a new Generator. Schedule your showing today!' ,`Acres` = '2.637' ,`Area` = '61' ,`BuilderName` = 'Marriott' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating,Propane,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'GREAT OAKS PH 1, BLOCK 1, LOT 8, ACRES 2.637' ,`LotDesciption` = 'Corner,Other,Wooded' ,`LotSize` = '114868' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '204' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'RIVER BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Great Oaks Ph 01' ,`TaxAmount` = '12518' ,`TaxRate` = '2.2433' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180412' WHERE `Matrix_Unique_ID` = '213660688' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T18:05:35.493' ,`MLSNumber` = '59345789' ,`ListAgentFullName` = 'Kim Shoquist' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783902' ,`Longitude` = '-95.947180' ,`PhotoCount` = '18' ,`PostalCode` = '77423' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '3511' ,`StreetSuffix` = 'Street' ,`City` = 'Brookshire' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home\'s location is the BEST of both worlds! This darling 2/3 bedroom 1 bath home is located in the downtown established neighborhood of Brookshire. Wide streets, mature oaks, wonderful library on one corner and a park nearby, this is a great home for someone looking to downsize and live in a small community and yet be so close to city shopping, medical facilities and entertainment. This darling home has completely been redone - new flooring, new paint, granite counter-tops, new light fixtures, blinds and doors, new stove and updated landscaping. Neighbors are long-time residents and ready to welcome you! What a great neighborhood. Thinking about a VRBO? This home is in an ideal location and improvements have already been made. What are your dreams? Come take a look today - Country Life with City Sights so close!' ,`Acres` = '0.1607' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S412000 BROOKSHIRE TOWNSITE BLK 16 LOT 3' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookshire Townsite' ,`TaxAmount` = '4384' ,`TaxRate` = '2.7487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180412' WHERE `Matrix_Unique_ID` = '213691678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:47:30.840' ,`MLSNumber` = '40408176' ,`ListAgentFullName` = 'Charles Nassif' ,`ListOfficeName` = 'Loft Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691484' ,`Longitude` = '-95.133725' ,`PhotoCount` = '13' ,`PostalCode` = '77536' ,`RoomCount` = '3' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Clare' ,`StreetNumber` = '2217' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story brick home in secluded Erin Glen. Freshly painted inside. Lots of updates including stainless steel appliances, PEX Pumbing, granite countertops in kitchen, and elegant tile floors throughout with new carpet in bedrooms. Brand new garage door opener. Side access to backyard with extra parking for your RV or boat. Covered back patio and more.' ,`Acres` = '0.1841' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 ERIN GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'CARPENTER ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Erin Glen' ,`TaxAmount` = '5157' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180412' WHERE `Matrix_Unique_ID` = '213888836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T18:42:31.520' ,`MLSNumber` = '84171123' ,`ListAgentFullName` = 'Eliseo Chirinos' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496503' ,`Longitude` = '-94.958941' ,`PhotoCount` = '42' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '2739' ,`StreetSuffix` = 'Street' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful freshly updated Mediterranean style home in breezy San Leon just minutes from Galveston Bay and a few blocks from Galveston bay and public boat launch and pier. Experience the open layout and natural lighting throughout the house. A/C unit in garage, perfect for a third room conversion. Enjoy the fabulous bay breezes and sunsets in the large relaxing backyard. The home has full access to the lake in the back perfect for entertaining. Close to famous Gilhooley\'s Oyster Bar, Eagle Point Marina, Top Water, and Pier 6 Seafood. See list of upgrades in attachments. Schedule a showing today!' ,`Acres` = '0.1837' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA LAKE SUB (2006) ABST 10, LOT 21, ACRES 0.184' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Magnolia Lake Sub 2006' ,`TaxAmount` = '6168' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180412' WHERE `Matrix_Unique_ID` = '214791243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T17:54:31.017' ,`MLSNumber` = '10056769' ,`ListAgentFullName` = 'Kitako Kureyama' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.368104' ,`Longitude` = '-95.080655' ,`PhotoCount` = '10' ,`PostalCode` = '77510' ,`RoomCount` = '6' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = '21st' ,`StreetNumber` = '11911' ,`StreetSuffix` = 'Street' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special! LOTS TO LOVE ABOUT THIS HOME! SANTA FE ISD, QUIET NEIGHBORHOOD. WALKING DISTANCE TO A DAY CARE. 3 BEDROOMS, 2 FULL BATHS WITH NEWLY BUILT FENCED YARD, OPEN FLOOR PLAN, LAMINATE WOOD FLOORS IN LIVING AREAS AND BEDROOMS AND CERAMIC TILE IN BATHS, NO CARPET IN THE PROPEPRTY. CEILING FANS IN ALL BEDROOMS, INDOOR UTILITY ROOM, FENCED BACK YARD WITH STORAGE BUILDING, IN THE HEART OF SANTA FE, NEWER HOME, CALL NOW FOR AN APPOINTMENT - THIS ONE WILL GO FAST!!!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 149 E T MITCHELL SUR LOT 26 BLK 26 ALTA LOMA TOWNSITE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Alta Loma Townsite' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180413' WHERE `Matrix_Unique_ID` = '214939460' --> 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','215011411','1675180413','215011411','2023-01-16T17:31:51.310','97624390','Laura Becker','eXp Realty, LLC','','','30.069032','-95.377624','35','77373','10','382000.00','Active','Trinity Pass','3006','Court','Spring','2','1','5','2935','Single-Family','Home feautres recently updated carpet throughout the upstairs, fresh paint throughout the entire house including kitchen cabinets. Custom cabinets built on site in the front room - perfect for entertaining. Large playground equipment in the spacious backyard!','0.2527','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Spring East','Central Gas','1','LT 14 BLK 2 BRECKENRIDGE FOREST SEC 1','Cul-De-Sac','11006','Appraisal District','','400','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','48 - Spring','GLORIA MARSHALL ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Lockbox Front','Appraisal District','2','Traditional','Breckenridge Forest Sec 01','7628','2.8117','Water District','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-16T18:24:04.763' ,`MLSNumber` = '67878384' ,`ListAgentFullName` = 'Lisa Guy' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885256' ,`Longitude` = '-95.055904' ,`PhotoCount` = '22' ,`PostalCode` = '77532' ,`RoomCount` = '12' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Kodiak Brown Bear' ,`StreetNumber` = '13606' ,`StreetSuffix` = 'Street' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2451' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 Story home features a secluded primary bedroom downstairs with a full bath w/ separate shower. Also located downstairs is a Kitchen overlooking the family room, breakfast room and formal dining area, the primary living area and a half bath. Second floor features 3 bedrooms and a full bathroom as well as a den/game room area. Home also has a full home Generac generator, a security door on back door and large covered patio with a hot tub that seats 6. Lots of extras!! A MUST SEE!!' ,`Acres` = '0.1345' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 KODIAK CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '7849' ,`TaxRate` = '3.0343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675180413' WHERE `Matrix_Unique_ID` = '215100870' --> 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','215141857','1675180413','215141857','2023-01-16T18:16:02.487','12603655','Becky Schenk','HOM Realty','','','30.532509','-96.695831','36','77836','13','398500.00','Active','Hill','202','Street','Caldwell','2','1','3','3170','Single-Family','PRICE IMPROVEMENT! This is truly an opportunity you don\'t want to miss out on! With all of the recent renovations & NEW features, this home is sure to please. The custom cabinets in the kitchen & master bath offer a modern look while still maintaining its classic charm. Granite countertops/island, engineered wood floors & recessed lighting add to the updated feel of this incredible residence. The tankless water heater located in the garage will provide years of efficient energy savings. Large central Laundry room, office, 3 bedroom, 2.5 bathrooms & large Sunroom make this home an easy choice. The backyard of this home is incredible with an expansive deck, a pergola & large grassy yard area perfect for entertaining or just relaxing. Sprinkler system and freshly laid sod, perfect for those summer days when you want to enjoy the Texas sun. A foundation lifetime warranty. Come take a look for yourself & see why this home is perfect for you! Survey available.','0.45','59','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Gas','0','S1500 CITY OF CALDWELL BLK 4C 0.445 ACRES','Other','19384','Survey','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','209 - Caldwell','CALDWELL ELEMENTARY SCHOOL (CALDWELL)','CALDWELL HIGH SCHOOL','CALDWELL MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','City Of Caldwell','3863','2.1939','Public Sewer,Public Water','1971','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215293554','1675180413','215293554','2023-01-16T17:02:23.710','40993463','Elizabeth Minjarez','Elite Texas Properties','','','30.310648','-95.747188','47','77316','9','650000.00','Active','Crawford','11046','Circle','Montgomery','3','0','5','3151','Single-Family','Embrace the opportunity to own a gorgeous 5 bed/3 bath home on an expansive tree-lined acre in Montgomery! Located in Stone Ranch, you\'ll love the open floor plan that offers high ceilings and a beautiful stone fireplace. A breakfast and dining room rest near the kitchen creating a perfect layout for entertaining. A spacious granite kitchen with custom site-built cabinets boasts style and sophistication. 3 bedrooms, including the primary suite, are located on the first floor. A glorious retreat, the primary suite includes a sitting area, a whirlpool tub, an all-tile shower, and his/hers walk-in closets. Tile floors run continuously throughout the main areas of the 1st floor including the mud room. Two enormous bedrooms (OR a game room & media room) are located on the 2nd floor. The covered back patio overlooks the pool and wooded lot/acre. The property includes a storage shed and an extended parking area with a basketball goal. Call today to see about making this house YOUR home!','1.01','39','','','Electric Dryer Connections','','Exclusions,Sellers Disclosure','1','Wood Burning Fireplace','1','Montgomery County Northwest','Central Electric','1','S903103 - STONE RANCH 03, BLOCK 2, LOT 6','Subdivision Lot,Wooded','43996','Appraisal District','','100','0','','2','Electric Oven,Freestanding Oven','1','Gunite,In Ground','','Electric Range,Freestanding Range','','Composition','37 - Montgomery','MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Stone Ranch 03','8356','1.8242','Public Water,Septic Tank','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215584623','1675180413','215584623','2023-01-16T17:36:24.320','47314577','Mohammed Jaber','eXp Realty, LLC','','','31.593493','-95.421500','28','75844','8','299000.00','Active','An County Road 1237','117','','Grapeland','1','0','3','1536','Single-Family','This custom home is on the Hill. Situated on a large lakefront lot to enjoy the lake year-round for swimming, fishing, or just boating. This magnificent property feels like a model home. As you enter you are greeted by its high ceilings and openness, and amazing outdoor views of the lake. This waterfront property boasts a charming 2 story Barndominium. The kitchen with an island and gas cooktop is open to the breakfast area. Large windows give a Lovely waterfront view. The Primary suite features a large bath with a separate tub, a standalone shower, and his and hers custom closets. Up the beautiful custom-made aspen wood stairs, you have 3 bedrooms or a Game room. A newly built private dock on the lake for fishing and relaxing. An Oversized attached 2-car garage and double-wide driveway give you plenty of parking. a large balcony on the first floor overlooking the lake, and ample outdoor space Waterfront living at its best.','3.314','75','','','Electric Dryer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Elkhart Area','Propane,Space Heater','0','A0867 SADDLER, WILLIAM T BLOCK 247 TRACT 3BB','Cleared,Corner,Water View,Waterfront','144358','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Aluminum','65 - Slocum','SLOCUM ELEMENTARY SCHOOL','SLOCUM HIGH SCHOOL','SLOCUM HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Barndominium','NA','3258','1.6935','Aerobic,Water District','2012','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','216283934','1675180413','216283934','2023-01-16T17:32:58.373','306157','Ryan Kutter','Connect Realty','','','30.467199','-95.565666','25','77318','3','285000.00','Active','Ventura','13863','Road','Willis','2','0','3','1745','Single-Family','This lovely brick home located in the waterfront community of Corinthian Point is just waiting for you! NEW ROOF & gutters as of 2022. The home is graced with an open floor plan offering vaulted ceilings & a wood-burning fireplace in the family room. You will notice the abundance of windows throughout the house. The kitchen presents lots of upgraded cabinetry for all your storage needs & plenty of counter space for meal prep. An electric cooktop, a recently purchased dishwasher, fridge & microwave, a breakfast bar, & a large pantry round out the kitchen which opens to the dining room. The inviting Primary offers an ensuite bath with dual sinks, dual closets, & a separate tub & shower. The utility room has built-in storage. You\'ll love the large screened porch, perfect for entertaining or a morning cup of coffee. The peaceful backyard overlooks a wooded area. The home features a whole house water-softer system. Neighborhood clubhouse, sports, a pool, fishing pier, boat launch, & more!','0.1988','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Lake Conroe Area','Central Electric','1','CORINTHIAN POINT 02, BLOCK 14, LOT 221','Subdivision Lot','8658','Appraisal District','','81','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Corinthian Point','5609','2.2463','Public Sewer,Public Water','1993','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','216344604','1675180413','216344604','2023-01-16T18:17:04.573','41700715','Burl McCarley','McCarley Realty','','','29.650088','-95.370571','40','77051','8','355000.00','Active','Sunbeam','3521','Street','Houston','2','1','3','1714','Single-Family','Wonderful well-designed custom-built home in greater Sunnyside area with open floor plan and a soaring ceiling with beautiful designer fan in the living area; 10 foot ceilings and custom cabinets with granite countertops throughout, including kitchen, bathrooms, and utility room; the spacious kitchen features an island with a dining bar, stainless appliances, and a walk-in pantry; covered porches in both front and back; home backs up to a greenbelt with no back neighbors; large primary bedroom with tray ceiling and primary in-suite bathroom that boasts double vanities and a frameless glass shower; the garage floor has been sealed with epoxy; 4 minutes to the 288 freeway; 15 minutes to the Med Center; great location in an up and coming area with many newly built homes minutes from Downtown.','0.1641','3','Valenciana Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Medical Center South','Central Gas','0','LT 6 BLK 2 SCOTTCREST','Greenbelt,Subdivision Lot','7150','Appraisal District','','','1','Never Lived In','2','','0','','','','','Composition','27 - Houston','REYNOLDS ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Scottcrest','1262','2.3307','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216349786','1675180413','216349786','2023-01-16T17:53:40.910','44040949','Jorge Velasquez','Home Alliance Group','','','29.914153','-95.456659','29','77038','8','279990.00','Active','Tinas Terrace','2671','Drive','Houston','2','0','4','1896','Single-Family','Charming 4 bedroom, 2 bathroom, single-story home featuring an attached 2-car garage! Spacious Living Room, House Offers Tile thru-out the entire home. NO CARPET. Kitchen boasting granite countertops and breakfast nook. Primary room offers big living space, double vanity primary bathroom. Standing Shower. Close to 249,I-45,Beltway 8. Easy access to 610, Downtown. House is ready to move in. House has Never flooded.','0.1263','11','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Aldine Area','Central Gas','1','LT 16 BLK 6 FORESTWOOD SEC 3 AMEND','Subdivision Lot','5500','Appraisal District','','250','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','1 - Aldine','SAMMONS ELEMENTARY SCHOOL','EISENHOWER HIGH SCHOOL','GARCIA MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Forestwood Sec 03 Amd','5731','3.0953','Water District','2005','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','216420591','1675180413','216420591','2023-01-16T18:06:55.490','97225778','Octavio Figueroa','La Palma Realty','','','30.015093','-95.287162','10','77338','6','279800.00','Active','River Dale Canyon','8927','Lane','Humble','2','1','4','1940','Single-Family','Welcome to this beautiful updated 2 story home, with large wooden floors in the living room. It has 4 bedrooms, with the master bedroom located on the 1st floor, 2 baths which include shower and tub on master bathroom with double sinks. The kitchen is recently updated with granite countertops and wooden cabinets. This lovely home also offers an upstairs game room and a backyard that has an open concrete/masonry porch for small gatherings. The location of this home is on Deerbrook mall area with easy access to Eastex FWY & FM 1960.','0.1199','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Humble Area West','Central Gas','1','LT 14 BLK 5 DEERBROOK ESTATES SEC 6','Other','5223','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required','Appraisal District','2','Contemporary/Modern','Deerbrook Estates Sec 06','6819','2.7433','Public Sewer,Public Water','2012','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','216431997','1675180413','216431997','2023-01-16T17:13:33.477','56868250','Dan VanDeventer','VanDeventer Realtors','','','30.053649','-94.779581','35','77575','7','225000.00','Active','Jessica','104','Street','Liberty','2','0','3','1590','Single-Family','Located in a nice, quiet and secluded subdivision, this 3 bedroom 2 bath contemporary style home is located on a dead end, one block street with no through traffic. Very nice tile floor living room with wood burning fireplace, dining area, kitchen with breakfast bar, utility room in house, 2 car attached garage. Also included with this property is a very handy 16\' x 24\' workshop/storage building that is wired and cooled by window A/C units and a 8\' x 16\' above ground swimming pool to enjoy your hot summers in. Do not wait! Call to set up your appointment today!','0.241','52','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Wood Burning Fireplace','1','Liberty','Central Electric','0','Lot No 9, Block \"C\", Oak Place Subdivision','Subdivision Lot','10498','Appraisal District','','','0','','2','Electric Oven','1','Above Ground','','Electric Range','','Composition','73 - Liberty','LIBERTY ELEMENTARY SCHOOL (LIBERTY)','LIBERTY HIGH SCHOOL (LIBERTY)','LIBERTY MIDDLE SCHOOL (LIBERTY)','Appointment Required','Appraisal District','1','Contemporary/Modern','Oak Place','4516','2.5375','Public Sewer,Public Water','1983','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','216434734','1675180414','216434734','2023-01-16T17:44:28.607','66107321','Wendy Dozier','RE/MAX On The Water - Bolivar','','','29.417271','-94.697969','50','77650','6','569900.00','Active','Whaler','4410','Lane','Port Bolivar','2','0','3','1636','Single-Family','This wonderful 3 bedroom, 2 bathroom beach home (1,636 SF) is a MUST SEE and has so much to offer! Enjoy a cup of coffee on the deck to watch our gorgeous sunrise over the water or a nice glass of wine while enjoying the Gulf breezes & amazing views of the Gulf of Mexico from the top deck and large entertainment area below. It\'s on a large corner lot (8,672 SF) and only a 2 minute walk or golf cart ride to the beach on paved roads. The cargo lift is 2 1/2 years old & is very useful for a variety of reasons. This home has hurricane shutters, a relatively new HVAC system (only 1 1/2 years old) and also uses a regular sewer system, not septic. Downstairs has a large concrete parking area, an outside shower, lots of extra storage and space in 2 expanded garage areas. Furniture is negotiable, although some included. This home is ready for you and your family to move in &/or use as an investment home for rental income.','0.1991','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Port Bolivar','Central Electric','1','HOLIDAY SHORES REPLAT (2007) ABST 203, BLOCK 2, LOT 15, ACRE','Corner,Water View','8672','Appraisal District','','330','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Holiday Shores Rep 2007','7505','1.6113','Other Water/Sewer','2011','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','216441525','1675180414','216441525','2023-01-16T17:07:10.430','58785151','Patricia Ibarra','Coldwell Banker Realty','','','29.808562','-94.926401','6','77521','7','322966.00','Active','Bay Orchard','8407','Drive','Baytown','2','0','3','1848','Single-Family','Welcome home to your beautiful The Wetherby Floor Plan. This 3 bedroom and 2 bathroom, 1 story new home design features an open concept floor plan and offers a variety of amenities. Some of these include a spacious family room, a kitchen looking out to the family room and adjoined to the breakfast nook, a master suite with bay window and a large walk-in closet in the owners retreat, a study, a rear covered patio, and a walk-in utility room with convenient access to the attached garage. Cost and energy efficiency features: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, • Rheem® High Efficient Tankless Gas Water Heater, and Low E Windows that open to the inside of the home for Cleaning.','0.1635','2','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Baytown/Harris County','Central Electric','1','LT 18 BLK 7 HUNTERS CREEK SEC 8','Subdivision Lot','7121','Appraisal District','','480','1','To Be Built/Under Construction','','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','GENTRY JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Hunters Crk Sec 8','1202','3.63','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216443080','1675180414','216443080','2023-01-16T18:49:48.540','95993084','Amberly Savage','Ward Real Estate, Inc','','','28.953454','-95.975624','25','77414','3','344500.00','Active','Sailfish','1202','','Bay City','2','0','3','1751','Single-Family','Looking for a custom home but don\'t want to wait? This home features an open concept kitchen to living space, alvic cabinets & drawers throughout all with soft close, quartz counter tops, large island & stainless steel appliances. The living room boasts a large fan, decorative beams and built in entertainment center. Primary bedroom is spacious, the bathroom features double sinks, quartz counter tops and large closet. All bedroom closets have built-ins for extra storage. Ceramic tile that looks like wood allows every room to flow perfectly together. Don\'t miss this stunning new construction.','','54','RGV Summit Const.','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Gas','0','Bay Ridge Sec 2 Lot 5 Block 10','Subdivision Lot','','','','','1','Never Lived In','2','','0','','','Gas Range','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Traditional','Bay Ridge','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully