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-26T00:16:55.933' ,`MLSNumber` = '77191012' ,`ListAgentFullName` = 'Mark Maniha' ,`ListOfficeName` = 'Mark Maniha, Broker Experts' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824967' ,`Longitude` = '-95.431501' ,`PhotoCount` = '31' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '2275000.00' ,`Status` = 'Active' ,`StreetName` = 'Althea' ,`StreetNumber` = '1237' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home starting construction soon. Stunning 5/6 Bed, 6 Bath, 3 CAR GARAGE, Two Primary bedrooms, massive master retreat, outdoor kitchen, guest qtrs, and pool bath! This beautiful home has 12\' ceilings and hardwood floors throughout. Premium features, Solid Wood Cabinetry, Chef Kitchen, 48\' range, SS appliances, double ovens, wine bar/chiller, 10ft custom island, crown molding and trim work, designer plumbing fixtures, insulated walls of windows offering tons of natural light. Master Retreat offers private coffee/wine bar, huge walk-in closet, oversized shower, separate soaking tub, his and her vanities. Oversized secondary bedrooms all w/private baths. Study w/attached full bath optional 6th bed down for guest. Mudroom entry off garage. Large laundry room, Dog washing station, tons of storage. Tankless Hotwater heaters, Spray foam insulation, 6in exterior walls, Whole Home Dehumidification System, Smart Home and Solar Panel Ready, Alarm/security cameras and Surround included.' ,`Acres` = '0.2397' ,`Area` = '9' ,`BuilderName` = 'New Oak Homes llc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 5 OAK FOREST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '12160' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman,Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '9848' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675258652' WHERE `Matrix_Unique_ID` = '210029782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T23:13:13.263' ,`MLSNumber` = '2564904' ,`ListAgentFullName` = 'Hieu Tieu' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Hieu Tieu' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.693231' ,`Longitude` = '-95.463833' ,`PhotoCount` = '46' ,`PostalCode` = '77401' ,`RoomCount` = '7' ,`ListPrice` = '1399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Holly' ,`StreetNumber` = '4908' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful Diamond Custom Homes built in 2006 that did not flood during Harvey! Located in the exclusive Bellaire Oaks subdivision within walking distance of Bellaire High School. A Mediterranean style masterpiece with travertine throughout the first floor and marble/granite countertops. Interior was recently painted and LED bulbs installed for a brighter and updated feel. High ceilings and large primary bedroom on the first floor. Custom cabinetry and shelving built into the primary bedroom\'s spacious walk in closet. Oversized primary bathroom with Mediterranean mosaic and motif throughout. Kitchen has a Viking gas range/grill and Viking refrigerator with matching trim is included. Large game room with a spacious bar upstairs. The fifth bedroom is actually a guest suite located towards the front courtyard and has a mini kitchen complete with a sink, refrigerator and Viking microwave. Perfect for guests, in-laws, or maid/staff quarters! This home is definitely a must see!' ,`Acres` = '0.225' ,`Area` = '17' ,`BuilderName` = 'Diamond Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 20 & 21A BLK 5 BELLAIRE OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Bellaire Oaks' ,`TaxAmount` = '35077' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675258652' WHERE `Matrix_Unique_ID` = '211077567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-25T23:11:02.320' ,`MLSNumber` = '11113858' ,`ListAgentFullName` = 'Tami Shipley Govreau' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Joel Beauchamp' ,`SellingOfficeName` = 'Keller Williams Hou Preferred' ,`Latitude` = '29.822020' ,`Longitude` = '-95.027027' ,`PhotoCount` = '37' ,`PostalCode` = '77562' ,`RoomCount` = '7' ,`ListPrice` = '185000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Goldenrod' ,`StreetNumber` = '2207' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is tucked away in Highlands, close to everything, but feels like small town living. Three bedrooms, two bathrooms with a formal living room and enormous family room. Recently painted interior, tons of closet space, and a wood burning fireplace. The guest bathtub has two handrails to assist those with disabilities. The backyard is HUGE and completely fenced in with updated fencing, also includes a wide gate to drive into the back. Also inside the fenced yard is a detached, oversized garage that includes extra shop space. Extra parking in the front driveway allows for guest parking. This home is ready for a new family to move in and put their personal touch on it. Call today to schedule your personal showing.' ,`Acres` = '0.4098' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 79 TR 23 G BLK 83 ELENA FRUIT & COTTON FARMS A COUNTRY TE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Terrace U/R' ,`TaxAmount` = '3586' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675258652' WHERE `Matrix_Unique_ID` = '212800351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-26T00:44:56.240' ,`MLSNumber` = '50799023' ,`ListAgentFullName` = 'Brooke Mason' ,`ListOfficeName` = 'Cross-Town Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.494579' ,`Longitude` = '-96.468722' ,`PhotoCount` = '20' ,`PostalCode` = '77878' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Trace' ,`StreetNumber` = '233' ,`StreetSuffix` = '' ,`City` = 'Snook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1429' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This new-build home, never lived in home, in the Grand Lake Community, is MOVE IN READY and has a desirable, open floor plan and includes 3 bedrooms and a covered patio space out back. This rural community is a hidden gem. Enjoy the privacy while being within a driving distance of Bryan/College Station, Brenham or Austin. 15 minutes to the grocery store, 20 minutes to Texas A&M and Kyle Field.' ,`Acres` = '' ,`Area` = '59' ,`BuilderName` = 'WJH, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S3451 GRAND LAKE OF SNOOK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8189' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '192 - Snook' ,`SchoolElementary` = 'SNOOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SNOOK SECONDARY SCHOOL' ,`SchoolMiddle` = 'SNOOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lake of Snook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675258652' WHERE `Matrix_Unique_ID` = '214457062' --> 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','216711065','1675258653','216711065','2023-01-25T23:03:22.290','3871529','Jared Turner','LennarVillageBldr-JaredTurner','','','30.300767','-95.418404','14','77301','6','215000.00','Active','Mallorca','2921','Drive','Conroe','2','0','3','1186','Single-Family','NEW! Lennar Homes Cottage Series, \'\'Brook II\'\' Plan with Elevation \'\'B\'\' in Ladera Trails. The beautiful 1-story 3 bedroom, 2 bathroom Brook floor plan features a welcoming front porch, a spacious family room with an adjoining casual dining area and kitchen. The spacious primary bedroom boasts an en suite bathroom and ample closet space. The Brook floor plan also features two additional bedrooms with a second full bath.','','19','Lennar','','','','Mud','1','','0','Conroe Southeast','Central Gas','1','SEC 0003 BLK 003 LOT 003','Subdivision Lot','','','','625','1','To Be Built/Under Construction','2','','0','','','','','Composition','11 - Conroe','RUNYAN ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Ladera Trails','','2.79','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','216712181','1675258653','216712181','2023-01-25T23:03:08.233','35970726','Jared Turner','LennarVillageBldr-JaredTurner','','','30.300767','-95.418401','15','77301','8','325990.00','Active','Sagedale','2760','Drive','Conroe','2','0','4','1932','Single-Family','NEW! Lennar Homes Wildflower Series, \'\'Clover II\'\' Plan with Elevation \'\'C\'\' in beautiful Ladera Creek. This lovely single-story home showcases a generous open floorplan shared between the family room, dining room and kitchen, leading directly to a covered patio for seamless indoor-outdoor living. A flex room off the foyer is perfect as a home office or bonus room. Four bedrooms complete this home.','','19','Lennar','','','','Mud','1','','0','Conroe Southeast','Central Gas','1','SEC 0009 BLK 001 LOT 007','Subdivision Lot','','','','625','1','To Be Built/Under Construction','2','','0','','','','','Composition','11 - Conroe','RUNYAN ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Ladera Creek','','2.79','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','216715336','1675258653','216715336','2023-01-25T23:09:18.850','88023418','Tammy Locke','Texas Diamond Realty','','','29.946682','-94.840203','30','77535','5','159000.00','Active','County Road 4431','210','','Dayton','2','0','3','1736','Single-Family','Three bedroom two bath manufactured home sits on a beautiful corner lot with mature trees. Home has front and back decks. Plenty of storage with plenty of cabinets, pantry and broom closet. Property is 1.71 acres and is on a corner lot on a dead end street. Property has a shed out back and is on a well and septic. Schedule your showings!','1.71','52','','','','','No Disclosures','','','','Dayton','Central Electric','0','WEST LAKE, LOT 69 70 SEC C, ACRES 1.71, MH LABEL# RAD0881192','Cleared,Corner','74488','Appraisal District','','','0','','0','','0','','','','','Composition','74 - Dayton','KIMMIE M. BROWN ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Other Style','West Lake','1754','1.7625','Septic Tank,Well','1996','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','216750421','1675258653','216750421','2023-01-25T23:29:24.757','64322940','Michael Weaster','Graham & Company Realty Group','','','29.787784','-95.191938','32','77015','6','129900.00','Active','Granada','13230','Street','Houston','2','0','3','1296','Single-Family','Fantastic opportunity in Home Owned Estates! This home is a single story, 3 bedroom, 2 bath with 2 garages, one attached and one detached! The interior has lots of potential for buyers to make this their own! Large lot. This home will not last, so come see today!!','0.186','2','','','','','Corporate Listing,No Disclosures,Real Estate Owned','','','','North Channel','Central Electric','0','LT 2267 BLK 78 HOME OWNED ESTATES SEC 6','Subdivision Lot','8100','Appraisal District','','','0','','2','','0','','','','','Composition','21 - Galena Park','GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)','NORTH SHORE SENIOR HIGH SCHOOL','CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)','Appointment Required','Appraisal District','1','Traditional','Home Owned Estates','5091','2.5789','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216752497','1675258653','216752497','2023-01-25T23:23:35.873','87319271','Tami Bedinger','Save 1900 Realty, LLC','','','29.763848','-94.675225','44','77514','6','395000.00','Active','Donna','206','Street','Anahuac','2','1','3','1800','Single-Family','The home you have been looking for is here! This home has under gone a major transformation. Updated kitchen with new stove and refrigerator, refrigerator included. New Flooring throughout including paint inside and out. The pool just received a new liner last month, all ready for summer fun in the sun. There is even a pool bathroom outside, no wet feet in the house. If you are looking for a home walking distance to the elementary this one is your home. Need a daycare there is one right around the corner, love going to High School football games this home is in a perfect spot for that too. If you love the small town feel and neighbors that look out for each other then look no further. Give me a call today to tour this beautiful home.','0.3015','53','','','Gas Dryer Connections','','Sellers Disclosure','1','Freestanding','1','Chambers County East','Central Electric','0','9 4 PENICK 68X134 OF LT 9','Subdivision Lot','13132','Appraisal District','','','0','','0','Gas Oven','1','Vinyl Lined','','Gas Cooktop','','Composition','4 - Anahuac','ANAHUAC ELEMENTARY SCHOOL','ANAHUAC HIGH SCHOOL','ANAHUAC MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Contemporary/Modern','Charles Wilcox 2/3 League & La','4295','2.8128','Public Sewer,Public Water','1977','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','216756419','1675258653','216756419','2023-01-26T00:04:27.047','63446011','Edgardo Martinez','Lucky Money Real Estate','','','30.366680','-95.494049','50','77304','9','420000.00','Active','Oak','3515','Landing','Conroe','2','1','4','2711','Single-Family','Beautiful home in White Oak Landing sitting on OVER half an acre. HUGE backyard with an awesome swimming pool and hot tub with child proof fencing around the pool. The fencing can be removed quickly. Home features primary suite down stairs with walk in closet, separate tub and shower, BIG game room up, high ceilings, wood floors, dining, breakfast, stainless steel appliances, and study down stairs. Minutes away from Lake Conroe for some fun in the sun. Conveniently located near I-45, Fishing and Boating on the lake, Shopping, and Hospitals! You do not want to miss this great home! Request your private showing!','0.5789','19','','','','','Sellers Disclosure','','Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','WHITE OAK LANDING 01, BLOCK 1, LOT 8','Subdivision Lot','25217','Appraisal District','','500','0','','2','','1','Gunite','','','','Composition','56 - Willis','LAGWAY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','White Oak Landing','8715','2.1823','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','216758035','1675258653','216758035','2023-01-26T00:26:35.177','24604782','Kenny Truong','Walzel Properties','','','29.113387','-95.086672','38','77554','9','569000.00','Active','Sausalito','25131','Drive','Galveston','2','1','3','1611','Single-Family','MLS# 24604782 ~ New Construction~. If you’re looking for a beautiful home to live or invest in a vacation rental, look no further! There is direct tunnel access to walk, bike or drive a golf cart to the beach. This gorgeous 2 story, 3 bedroom home with 2.5 baths. PRIMARY BEDROOM is on 1st floor. The open-concept is perfect for entertaining! When you’re away, you also have the option to AirBNB and create a moneymaking asset! The kitchen comes with all new Frigidaire stainless steel appliances. refrigerator are included. All cabinetry comes with soft-closing hardware. Plenty of parking for visitors with a double-wide driveway, covered parking and 1-car garage. The outdoor shower helps keep sandy feet at bay, and the 450sf covered porch is ready for lounging and beautiful sunsets! Both front and back patio come with gorgeous views.','0.1357','33','Vintage Residential','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 4 BLK 2 LAGUNA SAN LUIS I SUB','Subdivision Lot','5912','Appraisal District','','750','1','Never Lived In','1','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied','Builder','2','Contemporary/Modern','Laguna San Luis 88','470','1.9875','Public Sewer,Public Water','2022','Builder'); --> New record created successfully