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-12-19T15:37:31.057' ,`MLSNumber` = '23379319' ,`ListAgentFullName` = 'Anthony Jensen' ,`ListOfficeName` = 'ZAPP Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.257124' ,`Longitude` = '-94.866231' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'Izamal' ,`StreetNumber` = '2802' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Constructed in 2022, this custom coastal charmer is situated in Campeche Shores, a beautiful community across the street from Moody Gardens\' Golf Course and Evia. This amazing home offers breathtaking views of the golf course and Sydnor Bayou. Once you enter the home, you are welcomed by an open-concept floor plan with vast 10\' ceilings, a spacious living room and dining room with white oak wood flooring, a custom kitchen with stainless steel appliances, custom vent hood and island, quartz countertops and marble mosaic backsplash. The second floor offers a walk-in laundry room, 2 spacious guest bedrooms and guest bathroom and a spa-like primary retreat with a grande bedroom with views of the golf course, rich bathroom with custom cabinetry, marble tiled floors, quartz countertops and subway tiled tub surround. The exterior offers 2 decks, a covered patio on the ground floor and an oversized 1 car garage. This home will not disappoint so come see it today!' ,`Acres` = '0.1156' ,`Area` = '33' ,`BuilderName` = 'Cactusland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IZAMAL COURT AT CAMPECHE SHORES REPLAT (2016) LOT 52A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5034' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '207' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Izamal Court At Campeche Shore' ,`TaxAmount` = '539' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093209' WHERE `Matrix_Unique_ID` = '210476587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T16:44:15.447' ,`MLSNumber` = '78968868' ,`ListAgentFullName` = 'Judith Hayes' ,`ListOfficeName` = 'Designed Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.764883' ,`Longitude` = '-94.965987' ,`PhotoCount` = '47' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Horace Bonds' ,`StreetNumber` = '497' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peaceful and private! This stunning custom home is situated on 3.1 partially wooded acres! You will LOVE the stained concrete floors throughout the downstairs! Gourmet kitchen with island, tons of cabinets, walk in pantry, double ovens and granite counters with farm house sink and breakfast bar! Electric two sided fireplace with pivotal TV (which is removable if you want it to be) is situated between the family room and dining room so you get to enjoy it in both areas! Owner\'s retreat in rear of home features a spa like bath with double sinks, lg walk in shower and separate tub plus direct access to the utility room! Jr suite down features built in murphy bed and full private bath; upstairs features two bedrooms both with built in beds/drawers with jack and jill bath; built inn desk in the hallway; bonus room that also has a built in desk - perfect for gaming and relaxing for the kids upstairs. Plantation shutters. Outdoor kitchen and spa on the covered back porch!' ,`Acres` = '3.1' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 9 JOHN D BURKS SURVEY TRACT 16-1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '135036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'John Burks' ,`TaxAmount` = '4613' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093209' WHERE `Matrix_Unique_ID` = '210744736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T15:37:48.950' ,`MLSNumber` = '21711725' ,`ListAgentFullName` = 'Anthony Jensen' ,`ListOfficeName` = 'ZAPP Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.283994' ,`Longitude` = '-94.820981' ,`PhotoCount` = '19' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue P' ,`StreetNumber` = '5020' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Up for sale is this charming craftsman offering 2 bedrooms, 1 bathroom and a 2 bedroom, 1 bathroom garage apartment. The main home has tall ceilings, wood floors, central air/heat, and a large utility room. The garage apartment offers an open-concept floor plan with tile floors, updated kitchen and bathroom.' ,`Acres` = '0.124' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 21 & W 15 FT OF LOT 20 & E 5 FT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Denver' ,`TaxAmount` = '3616' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093209' WHERE `Matrix_Unique_ID` = '211464401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T16:46:55.637' ,`MLSNumber` = '91367400' ,`ListAgentFullName` = 'Jamie Bechtold' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.031317' ,`Longitude` = '-95.374212' ,`PhotoCount` = '48' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '269700.00' ,`Status` = 'Active' ,`StreetName` = 'Skyla' ,`StreetNumber` = '21514' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Skyla Circle, where you\'ll find the home of your dreams! This 4 bd, 2.5 bath home in Werrington is sure to surpass all your expectations of cozy living. The beautiful kitchen features a brand new dishwasher, and all appliances will stay with the home. Spend time with family or guests in the family room or host a cookout in the backyard - this home has it all! With easy access to 1960, 99, and 45, shopping, dining, and entertainment are always at your fingertips. Recent upgrades include a new HVAC and a new roof! Schedule a showing to see your future home today!' ,`Acres` = '0.1205' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 2 WERRINGTON SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Werrington' ,`TaxAmount` = '5804' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093210' WHERE `Matrix_Unique_ID` = '213394958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T16:40:42.200' ,`MLSNumber` = '79320198' ,`ListAgentFullName` = 'Justin Guyer' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.726325' ,`Longitude` = '-96.421266' ,`PhotoCount` = '49' ,`PostalCode` = '77465' ,`RoomCount` = '2' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Thunderbird' ,`StreetNumber` = '12' ,`StreetSuffix` = 'Drive' ,`City` = 'Palacios' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming coastal cottage on two lots in the gated resort style community of Cape Carancahua. Move-in ready, recently updated and full of function and style; this home is easy on the eyes and budget. Double paned windows and open concept floor plan create a cozy and light filled living space. The walls and ceilings have been retextured and painted along with new hardware and paint on all cabinets and doors. The kitchen is open to the dining/living area and features newer stainless steel appliances and pantry. Tucked around the corner, you\'ll find a stackable washer and dryer and utility storage. The partially covered wraparound deck is inviting and creates the perfect space for taking in the coastal breeze while escaping the summer sun. Several fruit trees dot the property, including citrus, fig and loquat. Neighborhood amenities include 2 swimming pools, 2 fishing piers, boat ramp, tennis courts, playground, community center, covered pavilion and relaxed atmosphere.' ,`Acres` = '0.36' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAPE CARANCAHUA #3, Lot 1248-1249, ACRES 0.36' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '15682' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cape Carancahua' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093210' WHERE `Matrix_Unique_ID` = '213698104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T15:06:06.160' ,`MLSNumber` = '61744039' ,`ListAgentFullName` = 'Fronnie Flowers' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809002' ,`Longitude` = '-95.489096' ,`PhotoCount` = '37' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Longridge' ,`StreetNumber` = '7957' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE IMPROVEMENT!! Time to take a second look! Complete remodel in the Spring Branch area. Beautiful open-concept living features a large open kitchen with an island, breakfast bar, refrigerator, stainless appliances, and tile floors. The spacious dining area off the kitchen also features tile floors and a patio door with lots of lights. The open living area features wood floors and is perfect for entertaining family and friends. Spacious primary retreat with new walk-in shower, large secondary bedrooms, secondary bath with new tub and shower combo, the garage was converted to a 4th bedroom with central A/C could be an office. The beautiful backyard offers plenty of room to roam. Ample storage shed with tons of storage. Newly added double-wide driveway. It is located on a nice corner lot a must-see. Ready for immediate move-in!! EASY ACCESS to I-10, I-610 & 290!' ,`Acres` = '0.1752' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 6 RIDGECREST SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgecrest Sec 05' ,`TaxAmount` = '5782' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093210' WHERE `Matrix_Unique_ID` = '213932204' --> 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','214177886','1675093210','214177886','2022-12-19T16:33:50.263','53035709','Albert Wade','RE/MAX The Woodlands & Spring','','','30.104057','-95.718634','32','77355','9','500000.00','Active','Klein','30503','Drive','Magnolia','2','0','3','1688','Single-Family','Enjoy quiet country living near the benefits of city amenities w/this sprawling 3.6 acre unrestricted property; located on partially-wooded cul-de-sac lot minutes from Magnolia & Tomball, approx 30mins to The Woodlands, & <1hr to Downtown Houston. Approx 570sf Casita w/studio-like living/bedroom space, kitchen, breakfast, full bath & utility room - perfect for in-laws, rental income (w/own electric meter for separate bill), or running a business. Charming 2-story main home offers 3 beds & 2 full baths, + spacious family room w/soaring vaulted ceilings & cozy fireplace. Chef\'s island kitchen boasts walk-in pantry, elegant granite counters, & modern SS gas oven/5-burner range. Breakfast bar & nearby dining space w/bay windows for ample seating. Huge 2nd floor Owner\'s Retreat boasts large walk-in closet, private balcony w/views of the gorgeous property, & en-suite bath w/jetted tub + separate shower. 2-car detached garage for ample parking. NO MUD tax or HOA dues!','3.6','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Tomball','Central Gas,Propane','0','A0005 - BROWN SOLOMAN, TRACT 17-B, ACRES 3.6','Cleared,Cul-De-Sac,Wooded','156816','Appraisal District','','','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','36 - Magnolia','J.L. LYON ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Brown Soloman','3949','1.8587','Aerobic,Public Water','1997','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T15:46:48.117' ,`MLSNumber` = '15862764' ,`ListAgentFullName` = 'Sylvia Reyes' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.126624' ,`Longitude` = '-95.554958' ,`PhotoCount` = '25' ,`PostalCode` = '77515' ,`RoomCount` = '7' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Quarter Horse' ,`StreetNumber` = '1019' ,`StreetSuffix` = 'Trail' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3790' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your future home sits on a 43,994 sq. ft. lot with amenities and upgrades that are sure to fit all your needs! No expense was spared; as the slab was poured with the most expensive and highest quality concrete available. Relax in either of your two living areas, have breakfast with a scenic view of your property in the breakfast area, or have a feast fit for a king in the dining room. The beautiful quartz countertops compliment the white porcelain tile floors perfectly, making it an awe-inspiring experience. Your new master bedroom has a separate sitting/office area for an ideal work-from-home situation. The possibilities are endless with this homes’ half-circle driveway and three-car garage. The septic tank holds 250 gallons and the extra large gas tank is sure to last. Your future home is waiting for you, all you need to do is take that first step; come and see it today!' ,`Acres` = '1.01' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BAR X RANCH SEC 2 (A0038 J B BAILEY) BLK 2 LOT 239 (A0053 CA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bar X Ranch Sec 2' ,`TaxAmount` = '8019' ,`TaxRate` = '1.6364' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093210' WHERE `Matrix_Unique_ID` = '215046717' --> 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','215140640','1675093211','215140640','2022-12-19T16:42:07.793','42545411','Judith Hayes','Designed Realty Group','','','30.465748','-94.839456','30','77327','5','399000.00','Active','Fm 2610','1146','','Cleveland','1','0','2','1360','Single-Family','Looking for peace and quiet? Ready to start a small farm? This property approx 1 hour north of Houston and just over 20 AC, already has the agricultural exemption providing LOW taxes plus it is HIGH and DRY - no flooding. No restrictions. Gated entry with home sitting back off the road for privacy. 2700 SF pole barn provides a concrete work area with power, prewired for whole home generator, 40x50 cattle sorting pens with loading shoot - your pets will be quite comfortable! 2 BR/1 BA home has spacious family room and open to kitchen area - large breakfast bar! Door leading to 224 SF covered patio and fenced in yard for the little fur babies and kiddos. 600 SF 3 car carport. The 9.099 Tract in rear is fully wooded. Tons of wildlife. Open field area behind home perfect for grazing livestock. Fully furnished all appliances included. Hardin ISD; SERC power grid. Approx 10 AC contains harvestable pine timber for an easy AG exempt roll over. Add\'l land available MLS #39086193. Watch video!','20.595','52','','','','','Sellers Disclosure','','','','Liberty County East','Central Electric','0','000103 J F DERUMAYOR, TRACT 231, 336, 287, 574 ACRES 20.595','Wooded','897118','Appraisal District','','','0','','','','0','','','','','Composition','107 - Hardin','HARDIN ELEMENTARY SCHOOL','HARDIN HIGH SCHOOL','HARDIN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','J F Derumayor','14','1.5764','Septic Tank,Well','1986','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','215357511','1675093211','215357511','2022-12-19T16:19:23.893','30421924','Patrick Carr','Patrick Carr Properties &','','','30.254031','-95.536716','43','77384','10','950000.00','Active','Lake','43','Drive','Conroe','3','1','5','3570','Single-Family','GORGEOUS UPDATED 5 BR HOME WITH 3.5 BR MODERNIZED STYLING IN THE LAKE CREEK FOREST COMMUNITY ,HEAT POOL/SPA NESTED ON 1.76 ACRES, MATURE TREES & LANDSCAPING. ZONED TO WOODLANDS*LOW TAX RATE*NO MUD TAXES*. LIVING IS 3,570 SFT. TOTAL UNDER ROOF SFT. INCLUDING COVERED PATIO\'S AND GARAGE IS 4,521 SFT. LUXURY VINYL PLANK FLOORING, INTERIOR FRESHLY PAINTED, ISLAND KITCHEN ,NEW KITCHEN WITH WHIRLPOOL AND GE APPLIANCES INCL.REFRIGERATOR, DOUBLE OVENS, QUARTZ TOPS & CUSTOM HERRINGBONE BACKSPLASH. UPDATED PRIMARY BATHROOM W/ NEW SOAKING TUB, FRAMELESS GLASS SHOWER, DOUBLE VANITY QUARTZ TOPS, PORCELAIN TILE & CUSTOM MIRROW. CUSTOM LIGHTING FIXTURES THROUGH-OUT. LARGE WALK-IN CLOSETS. PRIMARY BR IS LOCATED ON 1ST FLOOR W/ SCREEN IN COVERED PATIO OVERLOOKING THE POOL AREA. OVERSIZED 3 CAR GARAGE & WHOLE HOUSE WATER SOFTNER. POOL W/ CUSTOM WATERFALL SLIDE & WOOD DECKS FOR ENTERTAINING. STORAGE/WORKSHOP SHED. YARD W/IRRIGATION SYSTEM. PRIVATE GATED CONCRETE DRIVEWAY W/ADDITIONAL PARKING.','1.76','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','Lake Creek Forest 01, Block 2, Lot 87, ACRES 1.760','Subdivision Lot,Wooded','76666','Appraisal District','','264','0','','3','Electric Oven','1','Gunite','','Gas Cooktop','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Lake Creek Forest 01','11046','1.8488','Aerobic,Septic Tank,Well','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','215490834','1675093211','215490834','2022-12-19T15:48:05.287','98405463','Elisa Gonzalez','Keller Williams Professionals','','','29.781120','-95.755045','31','77450','10','315000.00','Active','Fincastle','22103','Drive','Katy','2','0','3','1963','Single-Family','Wonderful one-story, 3 bedroom, 2 bath home on a corner lot. Great updates throughout the home. Spacious living areas and large backyard perfect for gatherings! Granite countertops, stainless steel appliances and fresh neutral paint. Home come with refrigerator. Katy ISD and convenient access to major roads, highways, shopping, dinning, groceries and more. Schedule your showing TODAY!','0.1806','36','','','','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Katy - Southeast','Central Electric','1','LT 36 BLK 44 WEST MEMORIAL SEC 3 R/P','Corner,Subdivision Lot','7866','Appraisal District','','400','0','','2','Double Oven,Electric Oven','0','','','','','Composition','30 - Katy','WEST MEMORIAL ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','WEST MEMORIAL JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','First Pt West Memorial','5829','2.4233','Water District','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','215552706','1675093211','215552706','2022-12-19T15:36:47.597','83660204','Leticia Sandoval','Spirit Real Estate Group, LLC','','','29.504883','-95.425667','13','77583','8','380000.00','Active','Hollow Garden','13109','Lane','Rosharon','3','0','4','2515','Single-Family','Kick off the new year in this 4-bedroom brick beauty in the Lakes of Savannah subdivision.\r\n\r\nInside the front door, you’ll find tile floors, beautiful millwork, high ceilings and lots of natural light. The open kitchen/living/dining room features a stone fireplace, stainless steel appliances, granite countertops, a pantry & a big center island with bar-top seating.\r\n\r\nJust steps away, you can grill up dinner on the covered patio while the little ones play in the fenced-in backyard. Back inside, you’ll find hardwoods in the main-floor office and master suite, which boasts vaulted ceilings, double vanities, a soaking tub & a separate shower. Don’t forget about all the storage in the laundry room & the attached 2-car garage.\r\n\r\nLakes of Savannah is a safe & walkable neighborhood close to schools, shopping & dining. The community features a community pool and a splash pad for your family to enjoy. Call today to scedule your showing!','0.1452','5','','','Electric Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','Alvin North','Central Gas','1','SAVANNAH BEND SEC 2 (A0562 H T & B) BLK 3 LOT 34','Subdivision Lot','6325','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','SAVANNAH LAKES ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Contemporary/Modern','Savannah Bend Sec 2','9030','2.9567','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215577281','1675093211','215577281','2022-12-19T15:09:09.550','46584733','Charlie Kriegel','Winhill Advisors - Kirby','','','29.702242','-95.430194','16','77025','11','1995000.00','Active','Maroneal','3510','Street','Houston','3','1','4','5107','Single-Family','Stunning new construction property located in sought-after Braes Heights. A cornerstone of Roberson Building Group, you\'ll note exceptional detail in every inch of this thoughtfully and meticulously designed home. Highlights include custom cabinetry, a substantial kitchen island, quartz countertops, top-of-the-line finishes, loads of natural light through the generously-sized windows, and wide plank engineered flooring flowing throughout the open-concept plan. This 3-story elevator-capable masterpiece features the primary bedroom on second floor; the sizable en-suite sanctuary boasts a gorgeous primary bath that features dual vanities, a custom walk-in shower, stand-alone soaking tub, and a massive closet. The second level also holds 3 secondary bedrooms, each replete with full en-suite bathrooms, and an additional living area. A game room/flex space and full bathroom can be found on the third level. Close proximity to fine dining, shopping, and entertainment. Definitely a must see!','0.1675','17','Roberson Constructio','','','','No Disclosures','1','','','Braeswood Place','Central Gas','0','TR 5 BRAES HEIGHTS SEC 7','Subdivision Lot','7296','Appraisal District','','','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','27 - Houston','TWAIN ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','Braes Heights Sec 07','11869','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully