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-14T06:51:14.780' ,`MLSNumber` = '26156329' ,`ListAgentFullName` = 'Oscar Cruz' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.421830' ,`Longitude` = '-95.515205' ,`PhotoCount` = '14' ,`PostalCode` = '77318' ,`RoomCount` = '4' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '10719' ,`StreetSuffix` = 'Street' ,`City` = 'Willis' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect 2 bedroom one bath home on an ample neighborhood lot AND TWO 7,500 sf ADJACENT LOTS. Concrete floors throughout the house. Large kitchen with plenty counter space, electric cooktop. Close to Interstate 45, Lake Conroe, City of Conroe, Woodlands, restaurants and grocery stores. The adjacent two lots 7500 sf each are perfect to store those toys like RV\'s, boats, etc... Whether you want to live here permanently or use it as a vacation getaway, this is the property for you. Call to schedule a showing.' ,`Acres` = '0.1722' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'S591001 - HULON LAKES 01, BLOCK 3, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hulon Lakes 01' ,`TaxAmount` = '1779' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710398' WHERE `Matrix_Unique_ID` = '206183641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:25:15.540' ,`MLSNumber` = '34278171' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.308482' ,`Longitude` = '-95.451220' ,`PhotoCount` = '32' ,`PostalCode` = '77301' ,`RoomCount` = '22' ,`ListPrice` = '1975000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue F' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Avenue' ,`City` = 'Conroe' ,`BathsFull` = '9' ,`BathsHalf` = '1' ,`BedsTotal` = '11' ,`SqFtTotal` = '10800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Endless Possibilities- 5,508sf Grand Historical Home (including Garage Apartment) built in 1894 by Dr & Mrs. W. N. Hooper. Beautiful Grounds consist of 3 sprawling landscaped acres with a Carriage house ,a 1/2 Bath Outhouse, The property has many additions and improvements. Another home was added to the Property in 1972, 4,473sf the a pool house which has been converted into a 1/1 guest house with a full kitchen. Updates 2022... So many opportunities for this property like.... Upscale Restaurant with Airbnb residence, Wedding Venue, Family Estate, Multifamily with room to add more buildings, Executive offices. Please Self-verify all the data. Call for a tour!' ,`Acres` = '3' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SCIENCE HILL, BLOCK 1 W/2' ,`LotDesciption` = 'Corner' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Donavan\'s, Science Hill' ,`TaxAmount` = '9031' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1894' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710398' WHERE `Matrix_Unique_ID` = '208389063' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T06:54:07.517' ,`MLSNumber` = '20236561' ,`ListAgentFullName` = 'Reid Allen Nelson' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = 'Marylouise Caravella' ,`SellingOfficeName` = 'Caravella Coastal Div of REBCO' ,`Latitude` = '29.213972' ,`Longitude` = '-94.932609' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '549900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Stewart' ,`StreetNumber` = '13429' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this opportunity to experience life on the near west end of Galveston Island! This fully furnished 3/2 was constructed with premium building materials and has recent upgrades and amenities perfect for a primary residence, vacation rental or second home. HVAC system was replaced in June of 2022. There are many energy-efficient upgrades including LED lighting throughout, digital thermostat and insulated doors & windows. Elegant master en suite with southern deck access and stunning bath with soaker tub and separate shower. Modern kitchen features granite counters, designer backsplash, opens to great room with high ceilings. Peaceful, quiet natural setting with distant beach views and canal views, near town and upscale neighborhoods, including Laffite\'s Cove. Check out the handy flyer in Attachments for a list of the wonderful upgrades and amenities. AE Flood Zone!' ,`Acres` = '0.161' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR PT OF LOT 485 (485-2) TRIMBLE & LI' ,`LotDesciption` = 'Water View' ,`LotSize` = '7013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trimble & Lindsey Sec 2' ,`TaxAmount` = '6057' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710398' WHERE `Matrix_Unique_ID` = '208583495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T06:39:56.747' ,`MLSNumber` = '13517556' ,`ListAgentFullName` = 'Nusrat Ghafoor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877831' ,`Longitude` = '-94.347221' ,`PhotoCount` = '45' ,`PostalCode` = '77665' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Hamshire' ,`StreetNumber` = '16271' ,`StreetSuffix` = 'Road' ,`City` = 'Winnie' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine living on your Huge 1.7 Acre country estate with an inground pool with a separate full bathroom pool house! Home has been completely updated! Huge living room with a beautiful fireplace perfect for entertaining guests! Gorgeous kitchen with brand new cabinets, quartz countertops, backsplash and brand-new stainless appliances! A nice size second living room spacious dining area! Wood shaped Tile flooring in the whole house except bedrooms. Beautiful master suite with a completely updated master bath featuring quartz countertops! Two spacious additional bedrooms and a completely updated secondary bathroom! Office upon entry that can be used as a fourth bedroom. Two car detached garage and separate parking for Boat or RV! Brand new water pump! Beautiful Pool with a brand-new liner! Covered Patio in the backyard!' ,`Acres` = '1.7' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'KOCH 97 F VALMORE TR 8 1.70' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '74052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '110 - Hamshire-Fannett' ,`SchoolElementary` = 'HAMSHIRE-FANNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAMSHIRE-FANNETT HIGH SCHOOL' ,`SchoolMiddle` = 'HAMSHIRE-FANNETT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Theo F Koch/F Valmore League A' ,`TaxAmount` = '3994' ,`TaxRate` = '2.0781' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710398' WHERE `Matrix_Unique_ID` = '209217826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:26:43.620' ,`MLSNumber` = '26301885' ,`ListAgentFullName` = 'Lindsay Sterling' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982425' ,`Longitude` = '-95.147802' ,`PhotoCount` = '34' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Erasmus Landing' ,`StreetNumber` = '8418' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1716' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY! This beautiful and well maintained home is located in the fantastic lakeside community of Bridges on Lake Houston. A stone\'s throw from the lake and central to tons of great restaurants and nearby shopping/amenities, you\'ll enjoy breezy evening walks and sunsets over the water, along with the lakeside park, community pool and community center. This well-appointed home with an open concept floor plan has lots of countertop and cabinet space in the kitchen, along with a gas range, undermount lighting and an upgraded sink faucet to make dish washing a delight! The kitchen opens to the living room and has a breakfast bar for easy entertaining. Wind down in the spacious master retreat with an en-suite bath and soaking tub and a large walk-in closet. Enjoy the covered back porch and spacious backyard with NO REAR NEIGHBORS! Additional amenities include Nest wifi thermostat, tankless water heater, ceiling fans in all bedrooms and keypad deadbolt locks on front and back doors.' ,`Acres` = '0.1722' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 BRIDGES ON LAKE HOUSTON SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridges/Lk Houston' ,`TaxAmount` = '7213' ,`TaxRate` = '3.303' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710398' WHERE `Matrix_Unique_ID` = '209903849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:39:38.973' ,`MLSNumber` = '57474585' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953512' ,`Longitude` = '-95.194262' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '519990.00' ,`Status` = 'Active' ,`StreetName` = 'Arbeadie' ,`StreetNumber` = '15826' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Daniella Rae plan. Move in Ready! Your Energy Star Qualified Home is situated in the exclusive gated section of Balmoral. It offers 4 bedrooms, 3 baths, 2-car garage and upgraded, extended covered patio. The island kitchen is complete with stainless steel appliances and granite countertops. Enjoy entertaining in the family room which opens to the dining area. Create a room of your own with the first-floor flex room with a pocket office around the corner. The primary bedroom offers a luxurious bathroom with a garden tub and walk-in shower. Upstairs you’ll find two additional bedrooms, a full bathroom and spacious game room. Welcome home to Balmoral, a Land Tejas master-planned community situated with easy access to many major Houston employers. You’ll fall in love with the many amenities offered such as the legendary Crystal Clear Lagoon, Amenity Village and the Victory and Fitness Hub Parks. Schedule your appointment today to learn more about Balmoral!' ,`Acres` = '0.2703' ,`Area` = '1' ,`BuilderName` = 'Hamilton Thomas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '2404' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710398' WHERE `Matrix_Unique_ID` = '209988358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:42:00.213' ,`MLSNumber` = '39260978' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953376' ,`Longitude` = '-95.194625' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '501990.00' ,`Status` = 'Active' ,`StreetName` = 'Raemoir' ,`StreetNumber` = '12822' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Daniella Rae plan. Move in Ready! Your Energy Star Qualified Home is situated in the exclusive gated section of Balmoral. It offers 4 bedrooms, 3 baths, 2-car garage and upgraded, extended covered patio. The island kitchen is complete with stainless steel appliances and granite countertops. Enjoy entertaining in the family room which opens to the dining area. Create a room of your own with the first-floor flex room with a pocket office around the corner. The primary bedroom offers a luxurious bathroom with a garden tub and walk-in shower. Upstairs you’ll find two additional bedrooms, a full bathroom and spacious game room. Welcome home to Balmoral, a Land Tejas master-planned community situated with easy access to many major Houston employers. You’ll fall in love with the many amenities offered such as the legendary Crystal Clear Lagoon, Amenity Village and the Victory and Fitness Hub Parks. Schedule your appointment today to learn more about Balmoral!' ,`Acres` = '0.1364' ,`Area` = '1' ,`BuilderName` = 'Hamilton Thomas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '1648' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '209989997' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:29:52.617' ,`MLSNumber` = '85804401' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Gopi Khande' ,`SellingOfficeName` = '99 Mansions Realty' ,`Latitude` = '29.734185' ,`Longitude` = '-95.865518' ,`PhotoCount` = '28' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '451990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ryans Rock' ,`StreetNumber` = '3822' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KATY ISD ZONED! Perfect D.R. Horton Lorenzo Floorplan! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Gorgeous Kitchen with Silestone counters and 42\" Cabinets! There is a secondary bedroom wing for the kiddos with a study nook. Large covered patio, ready for week-end BBQ\'s with plumed gas! Included is everything you are looking for in a family friendly community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour!**PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN THEY DO NOT SHOW ACTUAL PROPERTY***At this time builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 90; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7366' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '210379334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:27:29.413' ,`MLSNumber` = '48408889' ,`ListAgentFullName` = 'Ozzie Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243101' ,`Longitude` = '-97.765758' ,`PhotoCount` = '17' ,`PostalCode` = '78704' ,`RoomCount` = '7' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldcrest' ,`StreetNumber` = '1100' ,`StreetSuffix` = 'Drive' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller is selling house \"as is\". \r\nThis hidden gem of a neighborhood in area code 78704, locally know as the “oh four”, provides a quiet neighborhood, great schools, recreation centers and entertainment. Walk to a variety of treats: restaurants, shops and music venues. Near major thoroughfares to get you across town, around town, or downtown.\r\nLarge corner lot with potential to remodel, expand and write your own Austin story!' ,`Acres` = '0.1687' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 28 BLK D SOUTHWOOD SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7349' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'DAWSON ELEMENTARY SCHOOL (AUSTIN)' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (AUSTIN)' ,`SchoolMiddle` = 'FULMORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Southwood Sec 02' ,`TaxAmount` = '19108' ,`TaxRate` = '2.1767' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '210897927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:37:33.507' ,`MLSNumber` = '50030368' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953362' ,`Longitude` = '-95.194513' ,`PhotoCount` = '11' ,`PostalCode` = '77346' ,`RoomCount` = '17' ,`ListPrice` = '553990.00' ,`Status` = 'Active' ,`StreetName` = 'Raemoir' ,`StreetNumber` = '12826' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Cayden plan. Fall completion! Beautiful home situated on oversized lot in the exclusive gated section of Balmoral. Two first floor bedrooms with en-suite baths. Home offers 4 bedrooms, 4 & 1/2 baths, 2-car garage & upgraded, extended covered patio. The island kitchen is complete w/stainless steel appliances, 42-inch cabinets & granite countertops. Entertain in the family room which opens to the kitchen. Primary bedroom offers a luxurious bathroom w/a garden tub & walk-in shower. Upstairs media & game rooms & additional 2 bedrooms w/2 baths. Front & backyard sod included! Energy Star Qualified Home.\r\n\r\n\r\nWelcome home to Balmoral, a Land Tejas master-planned community situated with easy access to many major Houston employers. You’ll fall in love with the many amenities offered such as the legendary Crystal Clear Lagoon, Amenity Village and the Victory and Fitness Hub Parks. Schedule your appointment today to learn more about Balmoral!' ,`Acres` = '0.1619' ,`Area` = '1' ,`BuilderName` = 'Hamilton Thomas Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 BALMORAL SEC 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7051' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '211147962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:39:10.067' ,`MLSNumber` = '6178105' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.902882' ,`Longitude` = '-95.735701' ,`PhotoCount` = '7' ,`PostalCode` = '77433' ,`RoomCount` = '15' ,`ListPrice` = '595990.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Coral' ,`StreetNumber` = '8634' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3214' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Cayden plan. Move in Ready! Your Energy Star Qualified Home is situated in the exclusive gated section of Marvida & offers 4 bedrooms, 3 baths, 3-car garage & upgraded, extended covered patio. Two 1st floor bedrooms w/en-suite baths. The island kitchen is complete w/stainless steel appliances, granite countertops & 42-inch cabinets. The family room opens to the kitchen area & has a gas fireplace. The primary bedroom offers a luxurious bathroom with a garden tub & walk-in shower. Upstairs enjoy 2 additional bedrooms, bathroom with dual sinks, game room, study & medial room! Fully sodded front & back yard. Marvida is Cypress, Texas’ newest community where residents can have it all. As a sister community to Miramesa, Canyon Lakes West & Stone Gate, residents have access to their incredible amenities including Marvida’s own amenity village with a lazy river pool. Premier location close to major roadways. Schedule your appointment today to learn more about Marvida!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Hamilton Thomas Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 MARVIDA SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7799' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '211149633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:39:24.327' ,`MLSNumber` = '86817547' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.953373' ,`Longitude` = '-95.194384' ,`PhotoCount` = '43' ,`PostalCode` = '77396' ,`RoomCount` = '9' ,`ListPrice` = '363990.00' ,`Status` = 'Active' ,`StreetName` = 'Raemoir' ,`StreetNumber` = '12827' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1702' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Rafe plan. Move in Ready! One-story situated in the exclusive gated section of Balmoral. Home offers 4 bedrooms, 3 & 1/2 baths, 2-car garage & upgraded, extended covered patio. The island kitchen is complete w/stainless steel appliances, 42-inch cabinets & granite countertops. Entertain in the family room which opens to the kitchen. Primary bedroom offers a luxurious bathroom w/a garden tub & walk-in shower. Front & backyard sod included! Energy Star Qualified Home. Welcome home to Balmoral, a Land Tejas master-planned community situated with easy access to many major Houston employers. You’ll fall in love with the many amenities offered such as the legendary Crystal Clear Lagoon, Amenity Village and the Victory and Fitness Hub Parks. Schedule your appointment today to learn more about Balmoral!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Hamilton Thomas Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5678' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1430' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.08' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '211523010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T07:49:07.197' ,`MLSNumber` = '95856695' ,`ListAgentFullName` = 'Katie Rothwell' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.611788' ,`Longitude` = '-95.888330' ,`PhotoCount` = '29' ,`PostalCode` = '77876' ,`RoomCount` = '2' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Edward' ,`StreetNumber` = '9654' ,`StreetSuffix` = 'Avenue' ,`City` = 'Shiro' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for the perfect farmhouse - THIS is IT! At just under an acre, this property is cleared and has a small fenced area off the back porch for pets. The 700sqft workshop is HUGE, heated, and has an additional half bath. Inside you\'ll find an updated kitchen and bathroom, two large bedrooms, and two additional rooms that can be used for living or office space. Improvements include all new plumbing, new HVAC system, and tree removal from the property. Schedule your appointment now to see the cutest farmhouse in Grimes County!' ,`Acres` = '0.8081' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S4300 - SHIRO, BLOCK 7, LOT 3,4,&5, (PART OF ALL LOTS)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '35200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '135 - Anderson-Shiro' ,`SchoolElementary` = 'ANDERSON-SHIRO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Shiro' ,`TaxAmount` = '1418' ,`TaxRate` = '1.6274' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1917' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663710399' WHERE `Matrix_Unique_ID` = '211589242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T06:58:08.703' ,`MLSNumber` = '56116990' ,`ListAgentFullName` = 'Scott Miller' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218943' ,`Longitude` = '-95.424740' ,`PhotoCount` = '10' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Whimbrel' ,`StreetNumber` = '10198' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story home that backs up to a greenbelt and has it all! This stunning home has a large island kitchen with granite countertops, stainless steel appliances, including a refrigerator and gas cooktop. With the kitchen being open to the living room, the natural light from the large windows bring a great sensation! The front office, with glass French doors, can be used as a dining room as well. Primary bedroom with enough space for a sitting area, also has walk-in closet and dual sinks. Two secondary bedrooms are split from Primary bedroom for privacy. NO back neighbors, with large patio and plenty of room for children to play!' ,`Acres` = '0.1393' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S720818 - MONTGOMERY CREEK RANCH 18, BLOCK 1, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 18' ,`TaxAmount` = '5651' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710400' WHERE `Matrix_Unique_ID` = '211726016' --> 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','212004269','1663710400','212004269','2022-09-14T07:38:31.473','33051044','Jared Turner','Turner Mangum,LLC','','','29.918915','-95.066038','18','77532','6','274995.00','Active','Lemon Balm','6307','','Crosby','2','1','3','1616','Single-Family','Ready to move-in! Crosby Park Village, located in the heart of Crosby, featuring the K. Hovnanian Homes\' Montgomery plan. This luxurious two-story home offers 3 bedrooms, 2.5 baths and 2 car garage on a cul-de-sac lot. First floor living area with all bedrooms located upstairs. Convenient media room tucked off foyer. Kitchen features beautiful maple cabinets and granite countertops with low bar top. Huge walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Schedule a tour today and give us an opportunity to tell you more! Offered by: K. Hovnanian of Houston II, L.L.C.','','1','K. Hovnanian','','','','No Disclosures','1','Gaslog Fireplace','1','Crosby Area','Central Gas','1','n/a','Subdivision Lot','5763','Appraisal District','','500','1','Never Lived In','2','Gas Oven','0','','','','','Composition','12 - Crosby','CROSBY ELEMENTARY SCHOOL (CROSBY)','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Builder','2','Traditional','Crosby Park Village','','2.61','Public Sewer,Public Water','2022','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','212131608','1663710400','212131608','2022-09-14T06:32:14.930','48229254','Nancy Rollings','Red Dirt Realty Group','Molly Slagle','BHHS Worldwide, REALTORS','30.170594','-95.828816','14','77447','6','317000.00','Option Pending','Rolling Forest','26023','Lane','Hockley','2','0','3','1532','Single-Family','This 1 acre lot is farther back into the neighborhood, which provides a peaceful nature filled setting! The front yard has a lot of potential to make it your own. The home has a split floorpan with large living room area in the center of the home, primary bedroom on one side of the house and two bedrooms on the other side. From the back patio your backyard view includes a large fenced in yard with thick wooded trees along the back fence','1','26','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','Hockley','Central Electric','1','S441106 COUNTRY LANE ESTATES 6 BLK 2 LOT 29 ACRES 1.0','Cleared,Subdivision Lot','43560','Appraisal District','','165','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','55 - Waller','FIELDS STORE ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Country Lane Estates 6','4205','2.0243','Aerobic,Public Water','2015','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','212186361','1663710400','212186361','2022-09-14T06:58:14.867','50188582','Bobby Allen','JMP Realty Partners LLC','Angela Lucas','J. Woodley Realty, LLC','29.609231','-95.493655','14','77489','7','225000.00','Option Pending','Timberlea Drive','15011','Drive','Houston','2','0','3','1562','Single-Family','One Story home in Willow Park community. Open space floor plan connecting family room, kitchen and breakfast area. Gas fireplace in family room.Fresh paint inside and out. Roof, water heater and plumbing have been recently replaced. No Carpet. Beautiful LVP, luxury vinyl planks and title. Kitchen new sink, fixtures and dishwasher. Covered rear 10x14 patio. Large fenced in back yard with storage shed. Well established neighborhood in the \"Chasewood\" area of Missouri City. Easy access to Ft. Bend Tollway and Sam Houston Pkwy.','0.1858','38','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','WILLOW PARK (RES A) SEC 2, BLOCK 2, LOT 8','Subdivision Lot','8094','Appraisal District','','145','0','','2','','0','','','','','Composition','19 - Fort Bend','BRIARGATE ELEMENTARY SCHOOL','WILLOWRIDGE HIGH SCHOOL','MCAULIFFE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos','Appraisal District','1','Ranch','Willow Park Residence A Sec 2','3553','2.2137','Public Sewer,Public Water','1976','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','212212872','1663710400','212212872','2022-09-14T07:55:59.890','96999763','April Maki','Gehan Homes Brokerage, LLC','','','30.538964','-96.288516','14','77845','6','599990.00','Active','Wallaceshire','4224','Court','College Station','3','0','4','2977','Single-Family','Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Villanova Plan has it ALL! It is a 1-story home offering 4 bedrooms, 3 baths & 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! Come out today and see this gorgeous home for yourself!','','61','Gehan Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','','Central Gas','1','Lot 7 Block 48 Section 210','Subdivision Lot','14488','Other','','750','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','153 - College Station','SPRING CREEK ELEMENTARY SCHOOL (College Station)','COLLEGE STATION HIGH SCHOOL','WELLBORN MIDDLE SCHOOL','Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment','Builder','1','Traditional','Castlegate II','','2.26','Water District','2022','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','212322274','1663710400','212322274','2022-09-14T07:12:38.317','38649561','Neocia Farris','eXp Realty, LLC','','','29.024869','-95.439065','8','77566','4','295500.00','Active','Corkwood','102','Street','Lake Jackson','3','0','4','1891','Single-Family','Are you ready to stop paying rent and call this former model home your new home?! This corner lot, one-story home offers 4 bedrooms, 3 full bathrooms and a 2-car attached garage. This home has an open floor plan from the family dining to the living room that is perfect for entertaining or family gatherings. The kitchen has a large island with granite countertops, custom tile backsplash, and ceramic tile flooring. Primary bedroom, Living room and Dining room offer details of a tres ceiling. Primary walk-in closet also offers custom drawers. Schedule your tour today!','0.2278','5','','','','','Sellers Disclosure','1','','','Lake Jackson','Central Electric','0','FLAGRIDGE SEC II (LAKE JACKSON), BLOCK 1, LOT 30','Corner','9923','Appraisal District','','','0','','2','','0','','','','','Wood Shingle','7 - Brazosport','ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)','BRAZOSWOOD HIGH SCHOOL','LAKE JACKSON INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Flagridge Sec I-Ii-Iii Lake J','5362','2.3371','Public Sewer,Public Water','2007','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','212389504','1663710400','212389504','2022-09-14T07:06:42.970','38500174','Max Burns','Max Realty Group','','','29.750903','-95.390727','10','77006','5','474900.00','Active','Willard','904','Street','Houston','1','0','2','975','Single-Family','This two bedroom Bungalow in the Montrose area with some updates. Kitchen, bath had been updated, hardwood floors thru out, house does need some TLC, good for investors, good lot value for the location. Refrigerator and full size washer & dryer included. Walking distance to several restaurants & shopping centers','0.0895','16','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Montrose','Central Gas','0','LT 6 BLK 7 CAVE E W','Subdivision Lot','3900','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY','LAMAR HIGH SCHOOL (HOUSTON)','GREGORY-LINCOLN MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Cave E W','10234','2.3307','Public Sewer,Public Water','1915','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','212389788','1663710400','212389788','2022-09-14T07:36:08.770','19428641','Janet Vittur','Texas All American Real Estate','','','29.827108','-95.074883','18','77049','5','449900.00','Active','Rio Villa','21511','Drive','Houston','2','1','3','1632','Single-Family','This home identifies as a TROPICAL PARADISE located on the San Jacinto River. Bring your family and friends and enjoy the peace and tranquility of river life at its best. The primary bedroom is on the second floor and has a separate balcony to enjoy laying out in the sun or watching the boat races. The closet space is massive and the primary bath has a separate shower and jacuzzi tub. The downstairs has a very open concept just waiting for family to come over and watch that game. There are washer and dryer connections upstairs and downstairs for your convenience. Lots of room for parking boats and other vehicles, There is lots of room to have get-togethers outside and best of all it is quiet. This home sits on 2 lots and has a beachfront that makes it easy to get in and out of the water. COME SEE YOU WILL FALL IN LOVE WITH THIS HOME AND NEIGHBORHOOD Seller is related to the agent','0.4132','2','','','','','Sellers Disclosure','','','','North Channel','Central Electric','1','LTS 24 & 25 BLK 24 RIO VILLA SEC 5','Waterfront','18000','Appraisal District','','300','0','','0','','0','','','','','Composition','46 - Sheldon','SHELDON ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','Rio Villa Sec 05','9590','2.2893','Public Water,Septic Tank','2018','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','212412051','1663710400','212412051','2022-09-14T07:25:44.333','20169018','Amanda Klam','Keller Williams Professionals','Linda Bocanegra','Fairdale Realty','29.868152','-95.877328','33','77493','10','325000.00','Option Pending','Elm Patch','305','Drive','Katy','2','1','4','2174','Single-Family','','0.2019','26','','','','','Mud','1','','','Brookshire','Central Gas','1','S491903 FREEMAN RANCH SECTION 3 BLK 1 LOT 13','Subdivision Lot','8796','Appraisal District','','348','0','','2','','0','','','','','Composition','44 - Royal','ROYAL ELEMENTARY SCHOOL','ROYAL HIGH SCHOOL','ROYAL JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Builder','2','Traditional','Freeman Ranch','','2.8667','Water District','2021','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','212440143','1663710400','212440143','2022-09-14T07:55:50.560','76109144','Pauline Mejia','Rose Above Realty','','','29.410404','-94.934520','16','77590','4','174646.00','Active','28th','2714','Avenue','Texas City','1','1','3','1287','Single-Family','Welcome to your perfect starter home, conveniently located with easy access to 146 and I45. This 3 bedroom, 1 1/2 bath has many updates to offer. 3 ton HVAC installed in 2021, New water heater installed in 2020, Tile installed in living room and hallway in 01/2022, a nice raised wood deck and a concrete pad in backyard perfect for your barbeque gatherings, security cameras with DVR is being left for the new homeowners. Schedule your appointment today, this home will not last long.','0.1443','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Texas City','Central Gas','0','ABST 142 R LOGAN SUR W 78 FT OF LOT 10 (10-1) MCCLAIN PARK S','Other','6287','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','52 - Texas City','GUAJARDO ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Accompany,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','Mc Clain Park 3','4456','2.5335','Public Sewer,Public Water','1975','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','212473879','1663710400','212473879','2022-09-14T07:26:20.800','34724505','April Maki','Gehan Homes Brokerage, LLC','','','29.507853','-95.004216','14','77573','5','449990.00','Active','Finns Landing','4922','Street','League City','2','0','3','1891','Single-Family','Enjoy coastal living at its finest at Coastal Point community. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. Stunning NEW construction Mahogany floor plan is a 1-Story, 3 beds, 2 baths & 2-car garage! The kitchen is open & bright offering beige kitchen backsplash, slate gray cabinets, brown itabaria granite countertops & graphite wood flooring. Fully Sodded Yard with Sprinkler System! Home will be ready for a December move-in!','','33','Gehan Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','League City','Central Gas','1','Lot 47 Block 3 Section 4','Subdivision Lot','6083','Other','','1000','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','SANDRA MOSSMAN ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment','Builder','1','Traditional','Coastal Point','','2.8','Public Sewer,Public Water,Water District','2022','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','212495970','1663710400','212495970','2022-09-14T07:07:24.307','78301819','Jason Nguyen','Nan & Company PropertiesChristie\'s International R','','','29.847958','-95.458521','47','77091','8','449000.00','Active','Savyon','5621','Drive','Houston','3','0','4','2300','Single-Family','Welcome to the beautiful new community of Green Oak Estates. Located at 3415 Paul Quinn Road, this development is situated near TC Jester and is comprised of 25 gorgeous new construction homes. These homes are 2,300 square feet, three to four bedrooms, and two to three baths. Each detail of these homes are thoughtfully designed and modern finishes all throughout. The ideal location of the community offers close proximity to inner city living and direct access to the 45 freeway. READY IN SEPTEMBER!!!','','9','SPRING W HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Northwest Houston','Central Gas,Zoned','1','LTS 12 & 13 BLK 21 HIGHLAND HEIGHTS ANNEX SEC 4','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Wood Shingle','27 - Houston','SMITH ELEMENTARY SCHOOL (HOUSTON)','SCARBOROUGH HIGH SCHOOL','BLACK MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Contemporary/Modern','Highland Heights','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully