Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T05:32:00.337' ,`MLSNumber` = '34923569' ,`ListAgentFullName` = 'Alice Ellisor' ,`ListOfficeName` = 'Alice Ellisor Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.708616' ,`Longitude` = '-95.443653' ,`PhotoCount` = '17' ,`PostalCode` = '77320' ,`RoomCount` = '5' ,`ListPrice` = '394900.00' ,`Status` = 'Active' ,`StreetName` = 'Ida Olivia Ln' ,`StreetNumber` = '23' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Log Cabin was designed & created by an artisan skilled in working with wood. Wood log details in the cabinetry, stairs, high ceilings, & island in kitchen. Home has an open concept living room, island bar height eating, kitchen with ample cabinets & utility area. Primary bedroom is on lower level with 12\'X8\' closet featuring large custom built-in dresser, additional 6\'x3\' closet & linen closet. The primary bath is uniquely designed with toilet & one sink with opening off living area for guest & separate portion of bath with sink, tub/shower & separate shower. Beautiful staircase up to loft that is 12.6\'X17\' with built-in storage across entire side of loft & a sink/shower bath area. This is a wonderful area for a child or great office space. Additional ensuite bedroom under construction! Logs: completely dried (dead standing) timber from Satterwhite Logs in Longview. Large covered back porch overlooking three acres with pond shared with neighbor at back corner of property line.' ,`Acres` = '3' ,`Area` = '43' ,`BuilderName` = 'Jim McKenzie' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Tract 8, WM Lindley (A-323), being 3 acres' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'none' ,`TaxAmount` = '2378' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711164' WHERE `Matrix_Unique_ID` = '205965960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T04:27:53.383' ,`MLSNumber` = '28633551' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841713' ,`Longitude` = '-95.217227' ,`PhotoCount` = '35' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Unison' ,`StreetNumber` = '12220' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic 1.44-acre property in Houmont Park features a 3-bedroom, 2-bathroom home and a huge steel-framed metal shop on a concrete slab that can be used for a variety of purposes. The home features new carpet and ceramic tile, a recently replaced roof, new A/C unit, brick-surround fireplace, study with French doors, completely redone bathrooms, a formal dining room, and an open great room with wood paneling. The kitchen is complete with matching granite countertops and backsplash, a double oven, gas cooktop, and breakfast bar. The sprawling outdoor space includes a patio, covered porch, large car port, iron fencing with sliding gate, water well, and mature trees. Transform the home into a comfortable office space or utilize the metal shop for commercial purposes! Conveniently located off U.S. 90 and Beltway 8, this property has easy access to East Houston and major business centers. Minutes from Herman Brown Park, Sheldon Lake, and multiple golf courses. Zoned to Sheldon ISD.' ,`Acres` = '1.4403' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 43 & TR 42B BLK 7 HOUMONT PARK SEC 1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '62740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houmont Park' ,`TaxAmount` = '5358' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711164' WHERE `Matrix_Unique_ID` = '210519607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T05:42:12.130' ,`MLSNumber` = '49061512' ,`ListAgentFullName` = 'Vi Tran' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '27.647430' ,`Longitude` = '-97.362460' ,`PhotoCount` = '36' ,`PostalCode` = '78414' ,`RoomCount` = '3' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Vista Del Sol' ,`StreetNumber` = '2614' ,`StreetSuffix` = '' ,`City` = 'Corpus Christi' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bed 2 bath Single Story. Create opportunities for closeness with your family in an open floor plan. Entertain in style in the large living area and inviting kitchen space. Just off the living room you will find your way into the large master suite with huge closet, double vanity and rain shower in bathroom. Head into the backyard with new fence and enjoy your day under the covered terrace or start the BBQ and end enjoy with family and friends in your cozy covered back yard. The location is great with the Oso Preserve just down the way and lovely walking paths nearby which makes for wonderful outdoor adventures with your family or pets. Airport is 20 min away, shopping and restaurants only 5 to 10 min away.' ,`Acres` = '' ,`Area` = '85' ,`BuilderName` = 'na' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'UNIT 3 BLK 8 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '440 - Corpus Christi' ,`SchoolElementary` = 'KOLDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VETERANS MEMORIAL HIGH SCHOOL (CORPUS CHRISTI)' ,`SchoolMiddle` = 'KAFFIE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'SALIDA DEL SOL' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663711164' WHERE `Matrix_Unique_ID` = '211436904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-16T05:27:08.383' ,`MLSNumber` = '65724550' ,`ListAgentFullName` = 'Craig Jones' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.707678' ,`Longitude` = '-94.880993' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Eastern' ,`StreetNumber` = '185' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come enjoy the quite country living in this log home style house in the Crystal Lake Estates subdivision. This home features a rustic wood look throughout and sits on 2 lots. One lot is wooded beside the home. The home can be used as a 3-bedroom one bath with a loft. The open concept kichen and living room has plenty of space to entertain guests. The large porch can also be utilized for coffee drinking or relaxing in a rocking chair. There is also plenty of additional storage under the home for lawn mowers or any other items. A metal roof was installed in 2020 and the AC was replaced in 2022. Vrbo is allowed and can be a great source of additional income. The home sits just a few miles east of Livingston and only about 10 miles from the Naskila Casino where you can test your luck with bingo gaming. Lake Livingston is also a short drive from the home where you can enjoy water sports and fishing. Come take a look at the neat home that has a ton of character as soon as you can!' ,`Acres` = '0.6375' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CRYSTAL LAKES SECTION 3 LOT 66' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27769' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Crystal Lakes' ,`TaxAmount` = '1770' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663711164' WHERE `Matrix_Unique_ID` = '211758307' --> 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','211888213','1663711164','211888213','2022-09-16T04:00:05.793','10161244','Peter Filler','HomeSmart','','','30.040828','-95.455616','17','77388','4','360000.00','Active','Candleknoll','3218','Drive','Spring','2','1','4','2809','Single-Family','Welcome home! Impressive and Charming family home in Spring, Texas available in the desirable Candlelight Hills neighborhood! The home is spacious and has many custom interior upgrades, and landscaping. The large den is welcoming with beautiful French doors. The spacious living room has a fireplace, features wood paneling, solid wood ceiling beams, and a built in bookcases for your library! The kitchen has an eat in kitchen an island and lots of cabinet space. The dining room is large enough for the family gatherings. The bonus room for an extra bedroom or more office space is next to the utility room. The large backyard has a covered porch and a covered breezeway to the 2 car garage. Upstairs the 2 guest bedrooms and bathroom are great for visiting family. The primary bedroom is just right with a huge walk in closet and built in cabinets. The primary bathroom is wonderful with double vanities and a large jetted tub! Please schedule your appointment today!','0.3234','13','','','','','Sellers Disclosure','','','1','Spring/Klein','Central Gas','1','LT 39 BLK 4 CANDLELIGHT HILLS SEC 2','Cul-De-Sac','14086','Appraisal District','','350','0','','2','','0','','','','','Composition','32 - Klein','HAUDE ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Request Online Appointment','Appraisal District','2','Ranch','Candlelight Hills','4994','2.124','Public Sewer,Public Water','1976','Appraisal'); --> 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','212167751','1663711164','212167751','2022-09-16T05:56:23.490','57439362','Jason Vo','Walzel Properties','Carmen Rodriguez','City Insight Houston','29.928664','-95.555628','32','77064','6','270000.00','Option Pending','Springsong','11046','Drive','Houston','2','0','3','1562','Single-Family','Welcome to a beautiful and cozy 3 bed, 2 baths, and 2 car garage home located in the well-established Harvest Bend community. Great location with less than 5 minutes to major business parks. Easy access to highway FM-1960, Beltway 8, Highway 249, and 290. In addition, this home features recent updates throughout with new paints, new flooring, a kitchen upgrade with a new countertop and sink, bathrooms are completely remodeled with standing showing in the master, and new faucets, as well as the countertop. Split-plan layout with a separate area for formal living, formal dining, and family area. The home is surrounded by mature trees, with no backyard neighbors, green space, and a gazebo in the back that is ready for weekend friends and family gatherings. What are you waiting for? CALL NOW FOR A PRIVATE SHOWING.','','10','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Willowbrook South','Central Gas','1','LT 31 BLK 5 HARVEST BEND THE VILLAGE 3 R/P','Subdivision Lot','6600','Appraisal District','','407','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WILLBERN ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Harvest Bend Village 03 R/P','4054','2.4','Public Sewer,Public Water,Water District','1991','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','212329969','1663711164','212329969','2022-09-16T05:07:24.270','19164733','Jared Turner','Turner Mangum,LLC','','','29.777349','-95.041369','34','77520','7','385000.00','Active','Red Bud','131','Lane','Baytown','3','0','4','3453','Single-Family','Plenty of space for the whole family in this well maintained 4 bedroom/3 bath, one-story home on half an acre, with a pool!! Roof was replaced in 2019 and sellers installed a whole home generac generator in 2022. Home boasts beautiful tile flooring throughout living, kitchen and wet areas. The study/4th bedroom has gorgeous wood paneling and custom built-ins. Floor to ceiling brick fireplace, with large hearth decorates the enormous living room, and large windows with custom blinds, and sky lights keep the home feeling bright and welcoming. Granite countertops and stainless steel appliances in kitchen and home was recently painted throughout. Extended driveway with carport makes for easy parking. No HOA and boat ramp access for the waterfront community of Lakewood. This is truly a gem, with so, so much to offer! Call today to schedule your private tour!','0.5','2','','','','','Sellers Disclosure','','','1','Baytown/Harris County','Central Gas','0','TR 4A CANAAN','Subdivision Lot','21780','Appraisal District','','','0','','2','','1','In Ground','','','','Composition','23 - Goose Creek Consolidated','TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','BAYTOWN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lakewood Estates','','2.97','Water District','1979','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','212362945','1663711164','212362945','2022-09-16T05:03:05.370','23570758','Rachel Jones','RE/MAX Metro','','','29.789823','-95.407788','36','77008','6','825000.00','Active','Alexander','1032','Street','Houston','2','0','3','1120','Single-Family','Please do not disturb tenants.1120sqft 2 bedroom/1 bath bungalow and 646 sqft 1 bed/bath garage apartment, completed in 2015 are both currently leased. Enjoy the Heights with income on property! This immaculately maintained bungalow is zoned to great schools in the heart of the Heights! With fresh paint and a new completely modernized garage apartment, this will be a low-maintenance investment. Recent a/c and heating, electrical wiring and panels, composition shingles, plumbing and sewer line, new kitchen, wood flooring and more.','0.1377','9','','','Gas Dryer Connections,Washer Connections','','No Disclosures','','','1','Heights/Greater Heights','Central Gas','0','LT 5 BLK 7 WEST HEIGHTS','Subdivision Lot','6000','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','LOVE ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany','Appraisal District','1','Traditional','West Heights','12695','2.3307','Public Sewer,Public Water','1936','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','212584589','1663711164','212584589','2022-09-16T05:18:58.707','20703040','Binh Vo','eXp Realty, LLC','','','29.808044','-95.493433','31','77055','4','595000.00','Active','Montridge Drive','8205','','Houston','2','1','3','2440','Single-Family','Beautiful 3 bed 2.5 bath home with a game room located in great location of Spring Branch. Home features very spacious kitchen with 42 inch lit display cabinet. Open breakfast area with abundant natural light. Dining room has chair railing and tray ceiling. The so called game room can be used as flex room, or media room or man cave, or private office to work from home. Home also features covered patio, wood flooring, tesla charging station, sprinkler system, sink in the utility room. Easy access to 610, I10, short distance to the Galleria area, and downtown.','','24','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Spring Branch','Central Gas','0','LT 51 BLK 6 RIDGECREST SEC 1','Subdivision Lot','8016','Appraisal District','','','0','','2','','0','','','','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required,Lockbox Left Side,Supra Keybox','Appraisal District','1','Traditional','Ridgecrest Sec 01','10789','2.4415','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully