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-15T15:33:45.007' ,`MLSNumber` = '20859314' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.317830' ,`Longitude` = '-95.455420' ,`PhotoCount` = '26' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '619000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland Pass' ,`StreetNumber` = '18626' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You are instantly welcomed as you enter the bright, airy 2-story foyer that leads you into the open-concept island kitchen, breakfast room, and 2-story family room. Tons of windows to enjoy watching the deer in your huge backyard! A spacious guest bedroom with a full bath downstairs, secluded from the main living area. The luxurious primary suite with an oversized bathroom and 2 walk-in closets welcome you. Upstairs you will find two additional bedrooms, a full bathroom as well as an oversized game room with a covered balcony!' ,`Acres` = '1.001' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'The Oaks at Suncreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675154302' WHERE `Matrix_Unique_ID` = '209719960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T16:03:35.930' ,`MLSNumber` = '53550895' ,`ListAgentFullName` = 'Vyanae Martinez' ,`ListOfficeName` = 'Houston Center Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926930' ,`Longitude` = '-95.031261' ,`PhotoCount` = '39' ,`PostalCode` = '77532' ,`RoomCount` = '7' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Bohemian Hall' ,`StreetNumber` = '16811' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely home located in Crosby Tx with easy access to Hwy 90 on 3 acres of land .Home offers 3 bedrooms with a spacious living room and dinning area including a beautiful playground. Great space to relax and have a great time with family and friends. Desirable for horses and livestock with a workshop in the backyard. Home has some mature fruit trees including pear, walnut, peach, fig and lemon. Don\'t miss your country living home!' ,`Acres` = '3' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 9 ABST 391 HT&BRR CO SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B Rr Co Sec 1' ,`TaxAmount` = '2375' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1929' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675154302' WHERE `Matrix_Unique_ID` = '213011547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T15:13:32.017' ,`MLSNumber` = '42606469' ,`ListAgentFullName` = 'Sandy Brabham' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.227644' ,`Longitude` = '-95.189272' ,`PhotoCount` = '26' ,`PostalCode` = '77372' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Vaughn' ,`StreetNumber` = '15024' ,`StreetSuffix` = 'Road' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodeled home on one acre of unrestricted land. The large family room has decorative wood paneling, high vaulted ceilings, wood burning fireplace also surrounded by decorative wood and French doors that lead to the backyard and covered carport. Primary suite is spacious and features a walk in closet and recently replaced carpet. Primary bathroom has tile floors, free standing garden tub, separate tiled shower and double sinks. Kitchen is open to the family room and has \"never been used\" stainless appliances. Secondary bedrooms have walk in closets and recently replaced carpet. Laundry room and walk in pantry located off the kitchen. Property also includes a storage building. Please ask agent for a list of all updates. Here are just a few: paint, trim, crown molding, flooring, deck, stairs, doors, fixtures, appliances, granite, tub, faucets, sinks and toilets.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0594 - WILLS WILLIAM, TRACT 1, SERIAL # PH174179A, TITLE #' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PINEY WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wills William' ,`TaxAmount` = '1049' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675154302' WHERE `Matrix_Unique_ID` = '213089565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T15:00:27.373' ,`MLSNumber` = '33873419' ,`ListAgentFullName` = 'Eduardo Garza' ,`ListOfficeName` = 'GAREBA Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647653' ,`Longitude` = '-95.937463' ,`PhotoCount` = '6' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '790000.00' ,`Status` = 'Active' ,`StreetName` = 'Wellborn' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction. Home greets you with massive IRON double doors, towering front porch, king size brick and wood accents. High ceilings and wood beams will continue inside throughout the oversized hallway that provides unobstructed view of the backyard thru a wall full of sliding doors that open towards the massive and high-ceiling covered patio. Kitchen will include pot filler, quartz countertops, matte black hardware, designer paint/backsplash, oversized range hood and KitchenAid appliances package. High ceilings with exposed beams also in primary bedroom, dining, family, game room and foyer. You will love the owners\' ensuite, it boasts a two person walk-in shower with independent temp valves and freestanding tub. Laundry is centrally located and includes luxury pet shower and direct access to primary closet! Built-in Pest Defense system, 10 year structural warranty, gutters and sprinkler system also included. Low taxes! Ask for list of upgrades!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'GAREBA Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Reserve At Weston Lakes Sec 1, BLOCK 2, Lot 13' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '11282' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Reserve at Weston Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675154302' WHERE `Matrix_Unique_ID` = '213516341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T15:01:29.197' ,`MLSNumber` = '57442584' ,`ListAgentFullName` = 'Eduardo Garza' ,`ListOfficeName` = 'GAREBA Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648870' ,`Longitude` = '-95.935812' ,`PhotoCount` = '6' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '787500.00' ,`Status` = 'Active' ,`StreetName` = 'Waterfowl' ,`StreetNumber` = '32707' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction. Home will greet you with massive IRON double doors, towering front porch, king size brick and wood accents. High ceilings and wood beams will continue inside throughout the oversized hallway that provides unobstructed view of the backyard thru a wall full of sliding doors that open towards the massive and high-ceiling covered patio. Kitchen will include pot filler, quartz countertops, matte black hardware, designer paint/backsplash, oversized range hood and KitchenAid appliances package. High ceilings with exposed beams also in primary bedroom, dining, family, game room and foyer. High ceilings and wood accents continue in 2nd story! You will love the owners\' ensuite, it boasts a two person walk-in shower with independent temp valves and freestanding tub. Laundry is centrally located and includes luxury pet shower and direct access to primary closet! Built-in Pest Defense system, 10 year structural warranty, gutters and sprinkler system also included. Low taxes!' ,`Acres` = '0.2456' ,`Area` = '30' ,`BuilderName` = 'GAREBA Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RESERVE AT WESTON LAKES SEC 1, BLOCK 1, LOT 29' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '10700' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Reserve At Weston Lakes Sec 1' ,`TaxAmount` = '1411' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675154303' WHERE `Matrix_Unique_ID` = '213517154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T16:28:04.067' ,`MLSNumber` = '29272224' ,`ListAgentFullName` = 'William Shipman' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.193224' ,`Longitude` = '-95.396635' ,`PhotoCount` = '32' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Clark' ,`StreetNumber` = '12049' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GRAND COUNRTY LIVING IN A BEAUTIFUL LOG CABIN! Sitting on a corner lot with large front and back yard. Completely updated including granite counter tops and a gorgeous spa tub for relaxing. The home also has stainless appliances, beautiful flooring and plush carpet. And for the college student or the grand parents part of the garage has been converted to a bedroom and a living space. Slip away to your new piece of country heaven just minutes from the Woodlands!' ,`Acres` = '0.7672' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0597 - WILBURN MATILDA, TRACT 48-E, ACRES 0.7672' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '33419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Matilda Wilburn Surv Abs # 597' ,`TaxAmount` = '3326' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675154303' WHERE `Matrix_Unique_ID` = '213643741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T15:50:40.147' ,`MLSNumber` = '25095336' ,`ListAgentFullName` = 'Kami Baez' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046011' ,`Longitude` = '-95.220462' ,`PhotoCount` = '36' ,`PostalCode` = '77339' ,`RoomCount` = '11' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Thousand Pines' ,`StreetNumber` = '2110' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this French beauty where you have a front courtyard, you can enjoy a beverage from the balcony off of the primary bedroom, snuggle in with two fireplaces (one in the primary bedroom!), enjoy a game in the game room, and enjoy the huge backyard with covered patio. All of the rooms are very large and perfect for a person that loves space.' ,`Acres` = '0.2507' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 14 TRAILWOOD VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Trailwood Village Sec 02 R/P' ,`TaxAmount` = '7601' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675154303' WHERE `Matrix_Unique_ID` = '213812462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T16:28:04.347' ,`MLSNumber` = '65138385' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.898478' ,`Longitude` = '-95.738601' ,`PhotoCount` = '15' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '422709.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Tuna' ,`StreetNumber` = '21318' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2309' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features four bedrooms, three bathrooms, and a massive family room for entertaining!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16, Block 2, Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7229' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675154303' WHERE `Matrix_Unique_ID` = '214485775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T15:56:00.220' ,`MLSNumber` = '30459661' ,`ListAgentFullName` = 'Christina Lopez' ,`ListOfficeName` = '1st Class RE Luxury Living,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.553035' ,`Longitude` = '-95.505365' ,`PhotoCount` = '32' ,`PostalCode` = '77358' ,`RoomCount` = '5' ,`ListPrice` = '149000.00' ,`Status` = 'Active' ,`StreetName` = 'Mockingbird' ,`StreetNumber` = '49' ,`StreetSuffix` = 'Road' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home or add to your investment portfolio! This house is now turn-key ready. Close to Interstate-45, no HOA and no restrictions. 3 Bed/2 Ba Manufactured home on cleared 0.29 acres. Full interior rehab was completed to include flooring boards replaced and newly installed carpet/laminate flooring throughout, replaced kitchen cabinets and appliances (dishwasher, stove and exhaust), front & back doors, bathroom showers and cabinets, interior paint, heat pump/window AC unit. FHA eligible Jan 6th, 2023.' ,`Acres` = '0.296' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'EMERALD WOOD RANCHETTES, BLOCK 12, LOT 30 & 31, MH 31.1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'EMERALD WOOD RANCHETTES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675154304' WHERE `Matrix_Unique_ID` = '214774060' --> 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','215205264','1675154304','215205264','2023-01-15T15:42:33.863','65528273','Melissa Mee','BHGRE Gary Greene','','','29.729619','-95.387725','44','77002','14','1495000.00','Active','Travis','5000','Street','Houston','4','1','4','3010','Single-Family','This 3-story home boasts a versatile floor plan for easy living and entertaining. The 1st level open concept design offers an open floor plan living ; dream kitchen w/stainless KichenAid appliances including double ovens, refrigerator & wine cooler; double sink and custom cabinetry with interior lighting, and a spacious formal dining . The 2nd level owner\'s retreat features a reading area, large bay window, tranquil master bath & large walk-in closet. The 2nd level also offers two additional bedrooms w/ spacious bath & closet. The 3rd level is home to a 4th bedroom; full bathroom; a wonderful bonus room with a walk in closet and abundance of natural light. Outdoor space with sitting area shaded by a stunning mature oak tree . Walking distance to MFAH, Herman Park, Contemporary & Rienzi Arts Museum, Glassell School of Art & TX MedCenter .','0.0689','17','','','Gas Dryer Connections','','Sellers Disclosure','1','Freestanding,Gas Connections,Gaslog Fireplace','1','Rice/Museum District','Central Gas,Zoned','0','TR 2A BLK 3 SOUTH END VILLA','Subdivision Lot','3000','Appraisal District','','','0','','2','Convection Oven,Electric Oven','0','','','Electric Range,Freestanding Range','','Composition','27 - Houston','MACGREGOR ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','3','Contemporary/Modern,Traditional','South End Villa','','','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','215650119','1675154304','215650119','2023-01-15T16:32:06.763','93211666','Edith Eldridge','Coldwell Banker Realty','','','29.760902','-94.677162','41','77514','3','249500.00','Active','Kansas','1209','','Anahuac','2','0','3','1874','Single-Family','Very Well Maintained 3/2 on a huge lot in the heart of Anahuac. So many important improvements have been completed in recent years. A new 30 year roof with 143 MPH shingles in 2022, new fence and sewer line in 2021, a new custom kitchen with Kitchen Maid soft close drawers, quartz countertops and new appliances in 2018, along with a new air conditioner in that same year. In 2016 a new gas line was installed from the meter to the house. In 2015 the seller installed all new energy efficient vinyl windows and also replaced the water heater and electrical panel. The seller also widened the doorways into the primary and secondary bathrooms to make them ADA compliant and raised the ceiling in the secondary bath. And last but not least, foundation work done in 2005 is still under a 20 year warranty! You will be making a great investment with this solid house sitting on a large beautiful lot - all you need to do is put your own personal touches on the interior to call this house a home!','0.3596','53','','','','','Mud,Sellers Disclosure','','Gas Connections','1','Chambers County East','Central Gas','0','20 4 BELTON LANE','Subdivision Lot','15664','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','4 - Anahuac','ANAHUAC ELEMENTARY SCHOOL','ANAHUAC HIGH SCHOOL','ANAHUAC MIDDLE SCHOOL','Accompany,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal','1','Traditional','Belton Lane Add','5306','2.8128','Public Sewer,Public Water,Water District','1961','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','215772328','1675154304','215772328','2023-01-15T15:03:41.667','20609604','Ana Veronica Detorres','HomeSmart','','','29.395929','-95.762411','49','77461','8','470000.00','Active','Zamanek TBD','12438','Road','Needville','3','1','4','2508','Single-Family','Gorgeous renovated home sits on One Acre. Fully updated and move in ready. Surrounded by beautiful landscaping. Recently painted exterior and interior with soft neutral paint. The luxury vinyl plank floor runs through the entirely first floor and six inches baseboard. New drywall. Stylish vault ceiling at formal dining and primary bedroom. New roof (2022), new water heater, new ceiling fans and recessed lighting. Water pump replaced April 2022 and new water filter. Septic Pump repair (Nov 2022). New propane Tank. Double Pane windows. Kitchen features quartz countertops and stainless-steel appliances. Foundation inspection was performed Oct 2022 and No foundation damage was found. Updated bathrooms with quartz vanity tops, stylish cabinetry and light fixtures. HVAC System has 2 new condenser, 2 new evaporator coil, new furnace, etc. Brick exterior and back has new hardie plank siding. Location is peaceful country living.','1','30','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','','0','','Propane','0','0562 A C SIRVIERE, ACRES 1.00','Cleared','43560','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal','2','Traditional','A C Sirviere','6840','1.8957','Well','2004','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','216038200','1675154304','216038200','2023-01-15T15:33:45.397','75259195','Lanre Bolatiwa','REALM Real Estate Professional','','','29.702397','-95.668197','23','77083','6','230000.00','Active','Sierra Vista','16022','Drive','Houston','2','0','3','1692','Single-Family','Cozy home located on cul desac. Home has recent carpet, paint, wood floor, nice bar area, open kitchen with island kitchen. Subdivision is close to Hwy 6, shopping centers and Westpark tollway.','0.1148','37','','','','','Sellers Disclosure','','','1','Mission Bend Area','Central Gas','1','LT 45 BLK 3 MISSION BEND LOS PATIOS SEC 1','Subdivision Lot','5000','Appraisal District','','525','0','','2','','0','','','','','Composition','2 - Alief','PETROSKY ELEMENTARY SCHOOL','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Mission Bend Los Patios Sec 01','4877','2.437','Water District','1982','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','216050279','1675154304','216050279','2023-01-15T15:42:01.947','96481032','Candy Poon','Homesource Investments Group','','','29.925795','-95.660732','35','77095','9','374800.00','Active','Cobalt Falls','10510','Drive','Houston','2','1','4','2657','Single-Family','Spectacular golf course setting in gated neighborhood! Well-maintenance 4 bedrooms 2-1/2 baths home located on cul-de-sac street, in a gate community on the Houston National Golf Course (hole #16). Three living areas, high ceiling, gourmet islanded kitchen, cast stone fireplace, game room upstairs and wood floors throughout main living areas. Roof (Dec 2020), Exterior & Interior paint, carpet (Nov 2021), Gas stove (2016). The super-sized covered patio right on Sterling Golf Course overlooks an ocean of green, iron fenced backyard allow unrestricted view of golf course, enjoy your cup of morning coffee and wind down after a long day of work watching the gorgeous sunset over the greens! Trendy shops and restaurants of the Boardwalk at Towne Lake are just minutes away. Excellent CyFair schools. Don\'t miss this gem in a desirable neighborhood!\r\nThis is it; your search will stop here!','0.1791','8','Solomon','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Copperfield Area','Central Gas','1','LT 45 BLK 2 STONE GATE SEC 11','On Golf Course,Subdivision Lot','7800','Appraisal District','','1140','0','','2','Freestanding Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','BIRKES ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Controlled Access,Supra Keybox','Appraisal District','2','Traditional','Stone Gate Sec 11','','','Water District','2003','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','216176715','1675154304','216176715','2023-01-15T15:02:00.583','46619908','Brian Hamill','Walzel Properties','','','30.420521','-95.649497','23','77356','7','539995.00','Active','Lake','37','Bluff','Montgomery','3','0','4','2459','Single-Family','New Construction Located in the Golf and Lakeside Community of Bentwater, Interior Features include 4 Bedrooms , 3 Baths , 2 Car and Golf Cart Garage . This Home has a Formal Dinning Room , Study/ Office . The Kitchen has all Stainless Steel Appliances and a Large Oversized Island. The Kitchen is Open to the Living Area Perfect for Entertaining. Come Relax in the Master Suite , The Master Bathroom has a Large Walk in Shower and Stand Alone Tub, 2 Walk in Closets and Double Sinks . Exterior Features include a Large Backyard with a wrought Iron Fence , Large Covered Porch and an Extra Patio Area , The Home Has Gutters and a Fully Landscaped Yard with a Sprinkler System','0.2572','39','Tx Best Home Builder','','Electric Dryer Connections,Washer Connections','','Mud','1','','1','Lake Conroe Area','Central Gas','1','BENTWATER 64, BLOCK 6, LOT 1','In Golf Course Community,Water View','11202','Appraisal District','','187','1','Never Lived In','2','Freestanding Oven','0','','','Freestanding Range','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Bentwater','1146','2.1142','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','216242353','1675154304','216242353','2023-01-15T15:49:54.393','93579969','Dennis Pow-Sang','Compass RE Texas, LLC','','','29.709575','-95.416587','6','77030','12','2850000.00','Active','Southgate','2438','Boulevard','Houston','6','2','5','5250','Single-Family','Stunning new construction by Crestview Homes, L.L.C. designed by George Allen Cole, in sought after Med-Center location to break ground in spring 2023. This gorgeous contemporary home is currently available for your buyer to customize with their personal selections. Builder Yigal Kass leads a team of outstanding designers, artisans and dedicated craftsmen & women to create this unique home characterized by thoughtful curated finishes, refined & elegant details. This 5-6 bedrooms with open & ingenious floorplan features desirable spaces such as a separate study, a dirty kitchen, an oversized 16x18 formal dining room, wet bar & mud room. The spacious kitchen/dining/ living rooms feature expansive views of the yard which has plenty of room for a beautiful pool w/spacious 19’x10’ covered back porch. Primary suite w/a high sloped ceiling,wet bar & very spacious bath & closet with island. 4 secondary bedrooms with ensuite baths plus 6th bedroom/party room with roof deck. Elevator capable.','0.1515','17','Yigal Kass Crestview','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Mock Fireplace','1','Rice/Museum District','Central Gas','0','TRS 30 & 31A BLK 2 BRANTWOOD','Subdivision Lot','6600','Appraisal District','','','1','To Be Built/Under Construction','2','Convection Oven,Electric Oven,Freestanding Oven','0','','','Gas Cooktop','','Other','27 - Houston','ROBERTS ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal','3','Contemporary/Modern','Brantwood','','','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','216288667','1675154304','216288667','2023-01-15T15:01:45.140','39186988','David Fonseca','Full Circle Texas, LLC','','','29.598263','-95.212201','22','77089','3','240000.00','Active','Sagegrove','11518','Lane','Houston','2','0','3','1575','Single-Family','Beautiful remodeled home in the sought after Sagemont neighborhood. Beautiful inside and out. Entirely remodeled. Nestled near Memorial Hermann Southeast Hospital and only minutes from Downtown Houston.','0.1641','3','','','Gas Dryer Connections','','Sellers Disclosure','1','','0','Southbelt/Ellington','Central Gas','1','LT 5 BLK 14 SAGEMONT SEC 3','Subdivision Lot','7150','Appraisal District','','50','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','41 - Pasadena','STUCHBERY ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Lockbox Left Side','Appraisal District','1','Contemporary/Modern','Sagemont Sec 03','4489','2.6863','Public Sewer,Public Water','1965','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','216308115','1675154304','216308115','2023-01-15T16:58:26.140','25621260','Debbie Almaguer','Coldwell Banker Realty','','','30.186548','-95.548999','38','77382','13','1375000.00','Active','Cantwell','15','Way','The Woodlands','4','1','4','4413','Single-Family','Outstanding custom home located in the prestigious gated community of Carlton Woods. This lovely home with a Mediterranean flair features a flowing floor plan perfect for entertaining inside and out. Downstairs features an open concept with a Living Room, Formal Dining Room, Family Room, Private Study with built-ins and a Chef\'s Dream Kitchen with a Breakfast Area. An abundance of natural light, neutral colors, soaring ceilings, fantastic curb appeal and the impressive entrance thru Cantera Doors that will take your breath away. The downstairs Primary Bedroom Suite has a beautiful view of the outside pool and spa and opens to the covered patio & deck. The Primary Suite includes his and her closets. Primary Bath has oversized shower & separate soaking tub. A second bedroom downstairs offers an en-suite full bath. Upstairs features two secondary bedrooms, Study Niche and a huge Game Room perfect for fun and relaxation. Large Texas Basement. A+ schools nearby. This is a home you must see!','0.3247','15','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','The Woodlands','Central Gas','1','WDLNDS VIL OF CARLTON WOODS 05, BLOCK 1, LOT 8','Cul-De-Sac,In Golf Course Community,Subdivision Lot','14143','Appraisal District','','4250','0','','3','Convection Oven,Double Oven,Electric Oven','1','Gunite','','Gas Cooktop','','Composition','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Wdlnds Village Of Carlton Woods 05','22746','2.1816','Water District','2001','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','216348338','1675154304','216348338','2023-01-15T16:20:41.227','42815664','Kelly Ammons','Realty Associates','','','29.623762','-95.726713','13','77406','10','285000.00','Active','Rock Fence','1914','Drive','Richmond','3','0','3','2050','Single-Family','Look no further! Pecan Grove is a master planned golf community and this home is waiting for you! It has so much potential! You can update it just the way you want it to be! There is a beautiful atrium in the home. A huge wall of built-ins in the breakfast area that are great for storage! And such a big back yard! Make your appointment today!','0.1828','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','1','Fort Bend County North/Richmond','Central Gas','1','PECAN GROVE PLANTATION SEC 4, BLOCK 23, LOT 25','In Golf Course Community,Subdivision Lot','7964','Appraisal District','','209','0','','2','','0','','','Electric Cooktop','','Composition','19 - Fort Bend','PECAN GROVE ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Pecan Grove Plantation Sec 4','4793','2.2979','Water District','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','216412474','1675154304','216412474','2023-01-15T16:01:49.557','76113184','Karina Rojas','Keller Williams Metropolitan','','','29.872517','-95.066608','7','77532','11','395000.00','Active','Pecan','406,406#A','Avenue','Crosby','5','0','7','','Single-Family','The imperial automatic double gate will welcome you when accessing this beautiful unique property that has two beautiful single-width mobiles each with independent electric meters and entrances with electric gates and remote controls. Detached parking spaces with oversized carport. Without restrictions. The possibilities are great here. One mobile can be used to live and the other to generate additional income in case you want to rent or airbnb. Both properties are on asphalt and concrete which makes it more stable. Never flooded. Not HOA.','0.1435','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Crosby Area','Central Electric,Other Heating','0','LT 110 and LT 111 ARCADIAN GARDENS SEC 1','Subdivision Lot','12500','Survey','','','0','','9','Electric Oven','0','','','Electric Range','','Aluminum','12 - Crosby','DREW ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Seller','1','Traditional','Arcadian Gardens Sec 01','3136','3.0343','Public Water,Septic Tank','2017','Seller'); --> New record created successfully