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-17T11:15:58.440' ,`MLSNumber` = '84545768' ,`ListAgentFullName` = 'Maria Guzman' ,`ListOfficeName` = 'RE/MAX Pearland' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.202745' ,`Longitude` = '-96.263850' ,`PhotoCount` = '8' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '139000.00' ,`Status` = 'Active' ,`StreetName` = 'Wharton' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to start your business in El Campo! Property includes 2 buildings (an office/living space & warehouse) sitting on over a quarter of an acre. Building on the side has one bathroom, and one room available. So many possibilities! Call to schedule an appointment to view the property today!' ,`Acres` = '0.3365' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ENGHOLM--ODD LOT 2B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Engholm--Odd' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092118' WHERE `Matrix_Unique_ID` = '203337733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:04:46.490' ,`MLSNumber` = '50209395' ,`ListAgentFullName` = 'Paula Porterfield' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.171524' ,`Longitude` = '-94.999919' ,`PhotoCount` = '28' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Mitote Dr' ,`StreetNumber` = '4014' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction to be ready in time for Summer. June 1st is the estimated completion date. Spectacular Bay views! Large living room open to the kitchen. This home has a huge deck area for an entertainers delight. The kitchen will have white glazed cabinets and granite counter-tops. Three bedrooms, two full baths. Double pane low E windows and doors with customized and labeled window protectors. Nice garage under the home and there is plenty of additional parking on slab under the home for boats, jet ski\'s, visitors- even a small R.V. may fit. There is wiring in place for an elevator/lift. Some pictures are from an identical floor plan and will have the same colors/finishes unless a buyer is under contract and would like to customize. Come check this beach house out today!' ,`Acres` = '0.9869' ,`Area` = '33' ,`BuilderName` = 'LenLee Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 34 BLK 6 INDIAN BEACH SEC 1' ,`LotDesciption` = 'Water View' ,`LotSize` = '42991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Beach 1' ,`TaxAmount` = '688' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Aerobic,Public Sewer,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675092118' WHERE `Matrix_Unique_ID` = '206447436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T12:09:47.670' ,`MLSNumber` = '3923807' ,`ListAgentFullName` = 'Andy Rolf' ,`ListOfficeName` = 'Rolf Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665145' ,`Longitude` = '-95.007180' ,`PhotoCount` = '18' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '294900.00' ,`Status` = 'Active' ,`StreetName` = 'Carroll' ,`StreetNumber` = '508' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION IN LA PORTE NOT FAR FROM GALVESTON BAY AND THE SYLVAN BEACH PARK COMPLEX\r\nOPEN CONCEPT LIVING/BREAKFAST/KITCHEN AREAS - LARGE PRIMARY BEDROOM AND BATHROOM SUITE - SPLIT\r\nBEDROOMS - TRAYED CEILINGS - UPGRADED KITCHEN AND BATHROOM CABINETRY - UPGRADED TILE - CARPET\r\nIN THE BEDROOMS - FENCED BACK YARD - UTILITY ROOM IN HOUSE - ENERGY EFFICIENT HOME - LOCATED IN\r\nA QUIET, ESTABLISHED NEIGHBORHOOD - STONE COUNTERTOPS THROUGHOUT THE HOME - EASY LIVING AND JUST WAITING FOR YOU TO MOVE INTO - ROOM MEASUREMENTS ARE APPROXIMATE' ,`Acres` = '0.1435' ,`Area` = '7' ,`BuilderName` = 'BP COASTAL BUILDERS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 21 & 22, BLOCK 36' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BAYFRONT ADDITION TO LA PORTE' ,`TaxAmount` = '544' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675092118' WHERE `Matrix_Unique_ID` = '209534481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:13:18.280' ,`MLSNumber` = '9276204' ,`ListAgentFullName` = 'Sonny Tunstall' ,`ListOfficeName` = 'Sonny Tunstall Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.504465' ,`Longitude` = '-95.468485' ,`PhotoCount` = '17' ,`PostalCode` = '75844' ,`RoomCount` = '10' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'El Camino' ,`StreetNumber` = '808' ,`StreetSuffix` = 'Drive' ,`City` = 'Grapeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WONDERFUL THREE BEDROOM TWO BATH BRICK HOME NESTLED ON A QUIET STREET IN GRAPELAND. THIS OLDER HOME IS IN WONDERFUL CONDITION LOCATED ON A ONE ACRE TREE SHADED LOT. THREE BEDROOMS OFFERING ADDITIONAL BEDROOM OR HOME/OFFICE. NICE KITCHEN BREAKFAST COMBO WITH ELECTRIC COOKTOP AND DOUBLE OVENS. LARGE FAMILY ROOM WITH GAS FIREPLACE AND CUSTOM BUILT-INS. UTILITY ROOM WITH WALK-IN PANTRY. TWO CAR CARPORT AND SPACIOUS STORAGE BULIDING OUT BACK. METAL ROOF, AND VERY NICE CURB APPEAL.' ,`Acres` = '1' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'M P MEAD AB 717 1.00 AC' ,`LotDesciption` = 'Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = '00' ,`TaxAmount` = '2128' ,`TaxRate` = '2.1104' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092119' WHERE `Matrix_Unique_ID` = '210161003' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:06:45.390' ,`MLSNumber` = '45389742' ,`ListAgentFullName` = 'Pamela Castello' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298296' ,`Longitude` = '-94.920328' ,`PhotoCount` = '26' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '699907.00' ,`Status` = 'Active' ,`StreetName` = 'Neptune' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Circle' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great House in one of the most desired communities, with 4 bedrooms, fish from your backyard or go in your boat this one has 2 boat docks. Epoxy on deck floor garage area. Lots of time left in the summer to enjoy and have fun, come on down and take the tour. Hope to See You Soon!' ,`Acres` = '0.126' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 124 TIKI ISLAND SEC 8' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '5489' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tiki Island 8' ,`TaxAmount` = '10900' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092119' WHERE `Matrix_Unique_ID` = '210469039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:16:49.107' ,`MLSNumber` = '44410026' ,`ListAgentFullName` = 'Robbie Jansky' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472209' ,`Longitude` = '-96.936408' ,`PhotoCount` = '42' ,`PostalCode` = '77964' ,`RoomCount` = '11' ,`ListPrice` = '587500.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 77' ,`StreetNumber` = '1141' ,`StreetSuffix` = '' ,`City` = 'Hallettsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom-built Ranch-style home with over 4,000 square feet of living area consisting of 4 bedrooms, 3.5 bathrooms, chefs gourmet kitchen, office, craft room, dining room, living room, and more! This stunning 2.15-acre property is located just outside the city limits of Hallettsville, Texas and is a prime property with an abundance of features, such as serene and tranquil small-town living, magnificent sunsets, and early morning sunrises. This beautiful home brings the outdoors in with amazing natural lighting features and offers a beautiful, covered porch and backyard patio for that first cup of morning coffee, relaxation and entertaining. Country living with modern amenities, such as granite countertops, high ceilings, custom built-ins & cabinetry is a rare find. This property is ideally positioned within a few hours of the Texas Gulf Coast and halfway between San Antonio and Houston.' ,`Acres` = '2.15' ,`Area` = '68' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0355 LUKE J PRESNAL & A0006 JAMES CAMPBELL, ACRES 2.1500' ,`LotDesciption` = 'Cleared' ,`LotSize` = '93654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '179 - Hallettsville' ,`SchoolElementary` = 'HALLETTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HALLETTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'HALLETTSVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Luke Presnall Surv Abs #355' ,`TaxAmount` = '6244' ,`TaxRate` = '1.739' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092119' WHERE `Matrix_Unique_ID` = '210739216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T12:11:16.183' ,`MLSNumber` = '8588288' ,`ListAgentFullName` = 'Andy Rolf' ,`ListOfficeName` = 'Rolf Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663924' ,`Longitude` = '-95.014420' ,`PhotoCount` = '16' ,`PostalCode` = '77571' ,`RoomCount` = '5' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Kansas' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERFECT STARTER HOME - RECENTLY RENOVATED AND UPDATED - NEW KITCHEN CABINETS WITH GRANITE COUNTERTOPS - NEW CERAMIC TILE FLOORING IN KITCHEN - NEW CARPET IN THE LIVING ROOM AND BEDROOMS - BATHROOM UPDATED WITH NEW CERAMIC TILE TUB SURROUND AND FLOORING - LARGE CARPORT ALONG SIDE OF GARAGE FOR ADDITIONAL PARKING - COVERED STORAGE AREA IN \r\nTHE BACK YARD WITH A STORAGE - FRESHLY PAINTED THROUGHOUT - NICE QUIET AREA CLOSE TO SCHOOLS AND OLD DOWNTOWN LA PORTE - CALL TODAY TO SEE THIS CUTIE!!' ,`Acres` = '0.1793' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 8 & 9 & S 1/2 OF LT 7, BLK 215, LA PORTE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'La Porte' ,`TaxAmount` = '2195' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092119' WHERE `Matrix_Unique_ID` = '210965188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T12:57:30.110' ,`MLSNumber` = '59235807' ,`ListAgentFullName` = 'Richard Blount' ,`ListOfficeName` = 'The Cameran Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.323477' ,`Longitude` = '-95.453161' ,`PhotoCount` = '49' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Circle' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '25 Minutes from Surf Side, 15 Minutes from Pearland Town Center, 35 Minutes from Houston. Wow! Spa and Outdoor Kitchen on the Lake. What a life! Every inch of this beautiful home on acreage has been completely remodeled in 2019. Gourmet kitchen features island, quartz countertops and fairly new high end appliances. Primary bedroom downstairs is large and features his and hers walk-in closets. Spa-like master bath must be seen to be believed, with quartz counters, amazing tile work and new frameless shower. Three additional bedrooms upstairs, including one with it\'s own on-suite bath that could be a second primary. Game room upstairs provides plenty of room for activities, and there are two staircases for easy access.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE OAKS AT SUNCREEK ESTATES (A0067 & A0068 & A0069) BLK 5 L' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'The Oaks At Suncreek Estates' ,`TaxAmount` = '8098' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092120' WHERE `Matrix_Unique_ID` = '211303279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:56:53.433' ,`MLSNumber` = '56646216' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444999' ,`Longitude` = '-95.397934' ,`PhotoCount` = '3' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '719990.00' ,`Status` = 'Active' ,`StreetName` = 'Sanger' ,`StreetNumber` = '9527' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Shea Homes. Plan 6010. Est. Completion 1/2023. This inviting and spacious single-story home is the epidemy of comfort and versatility. This beautiful home offers 4 bedrooms, 3.5 bathrooms, and a 3-car tandem garage. Upon entering, the Great Room awaits at the end of the hall with 12\' ceilings, fireplace and stacked sliding doors that fill the space with natural light. An oversized Casual Dining Room leads out to the extended covered patio. Back inside, the gourmet Kitchen includes cabinets galore, double ovens, a 5-burner gas cooktop, large kitchen island and a huge walk-in pantry. The primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, shower with bench seat and freestanding tub. A Media Room w/wet bar will provide the perfect space to entertain family and friends. Come and Live the Difference in a Shea Home!\r\n\r\n\r\nCome live the difference in this gorgeous Shea home!' ,`Acres` = '0.2369' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 44 (A0282 & A0286) (MANVEL) BLK 2 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12823' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '2044' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675092120' WHERE `Matrix_Unique_ID` = '211952628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:53:22.763' ,`MLSNumber` = '20996493' ,`ListAgentFullName` = 'Marti Pattinson' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753957' ,`Longitude` = '-95.611069' ,`PhotoCount` = '32' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaconshire' ,`StreetNumber` = '1523' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2669' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your dreams to this incredible corner lot located in one of the most favorite neighborhoods in the Energy Corridor. Curb appeal is not the only thing going for this property! Enter this stunning 2 story home with towering ceilings! The home office is located privately to the left of the entry! Beautiful custom-painted walls throughout this gorgeous open concept. Formal dining features two nice walls for furnishings. The kitchen breakfast areas boast granite countertops and a dry bar for preparing beverages of your choice. As well as an informal eating area. The Upstairs primary suite includes an oversized sitting area. The ensuite bath features a fabulous closet and separate shower and large dual vanities. The spacious family area overlooks a gorgeous, landscaped back/side yard featuring a tranquil fountain. Covered patio for outdoor grilling. House did not flood the whole subdivision is elevated. This home is special and awaits its new owner!' ,`Acres` = '0.1187' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 85 STONEHENGE SEC 3 U/R R/P' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '5170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '798' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stonehenge Sec 03 U/R R/P' ,`TaxAmount` = '11195' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675092120' WHERE `Matrix_Unique_ID` = '211969925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T12:59:46.997' ,`MLSNumber` = '25816069' ,`ListAgentFullName` = 'Waynea Sheffield' ,`ListOfficeName` = 'A Action Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.928117' ,`Longitude` = '-95.364902' ,`PhotoCount` = '6' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Oaks' ,`StreetNumber` = '1657' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Horse heaven! Very nice 5.24 acres with small pond, stables, and barn. Over 4,000 sq ft. 6 Bedroom, 4 Baths, 2 wood burning fireplaces. Made up by connecting 2 Manufactured Homes. Possible to close off hallway to one home and rent. Has two kitchens, two living rooms, sunroom, and large covered porch. Conveniently located just a few minute drive to shopping, restaurants, and schools.' ,`Acres` = '5.24' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN OAKS, LOT 13 LABEL # RAD0955866' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '228254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Twin Oaks' ,`TaxAmount` = '4212' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092120' WHERE `Matrix_Unique_ID` = '212456729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:58:02.383' ,`MLSNumber` = '39896673' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.446709' ,`Longitude` = '-95.265578' ,`PhotoCount` = '33' ,`PostalCode` = '77511' ,`RoomCount` = '4' ,`ListPrice` = '339500.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 850b' ,`StreetNumber` = '1301' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3 bedroom home that sits on a 1 acre lot in a quiet cul-de-sac. The property features mature oak trees that hang beautifully over the driveway. Inside you will walk into the foyer that is open to the den, there is nice space for entertaining in the formal dinning room and formal living room that could also be used as a home office. Take a step out back through the french doors leading to the wonderful stamped patio with a gorgeous pergola. Kitchen updated 7-8 yrs ago with quartz countertops. Full house generator. Primary bathroom updated July 2022. Guest bathroom updated 2021. Recent foundation work completed 2022. Buyer to verify all information herein.' ,`Acres` = '0.98' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EMERALD MANOR (A0412 A C H & B) BLK 2 LOT 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '42689' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Emerald Manor' ,`TaxAmount` = '4775' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092121' WHERE `Matrix_Unique_ID` = '213229132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T11:02:29.523' ,`MLSNumber` = '5958437' ,`ListAgentFullName` = 'Edgar Rodriguez' ,`ListOfficeName` = 'Spark Real Estate Partners' ,`SellingAgentFullName` = 'Edgar Rodriguez' ,`SellingOfficeName` = 'Spark Real Estate Partners' ,`Latitude` = '29.876228' ,`Longitude` = '-95.469888' ,`PhotoCount` = '17' ,`PostalCode` = '77088' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Moss Glenn' ,`StreetNumber` = '5611' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Home Construction. Approximate Completion Date March 2023. Stunning Vaulted porch entrance. Split floor plan with open concept kitchen with large quarts countertop island, living area with mock electric fireplace and dining area with front yard view. 11 foot ceilings in Kitchen/Living/Dining and Primary Bedroom. Deluxe Primary bath with separate shower and soaking tub. Black casement windows. Primary Bedroom\'s walk in closet has a pocket door that leads to utility room and access to mud room and garage entrance. The Rear door leads to the covered Loggia and spacious backyard. Greater Inwood is in the heart of Beltway 8 (North) 610 N. Loop (South) 290 Fwy (West) I 45 North (East). 15 miles from Downtown Houston-Minute Maid Paid, 9.5 miles from Willowbrook Mall area, 12 miles to Galleria.' ,`Acres` = '0.2112' ,`Area` = '11' ,`BuilderName` = 'Canopy Home Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 5 INWOOD FOREST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest' ,`TaxAmount` = '4919' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675092121' WHERE `Matrix_Unique_ID` = '214542489' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T12:01:13.680' ,`MLSNumber` = '75955712' ,`ListAgentFullName` = 'Sandra Reed' ,`ListOfficeName` = 'Sandy Reed Country Prop.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929379' ,`Longitude` = '-96.824203' ,`PhotoCount` = '34' ,`PostalCode` = '78945' ,`RoomCount` = '9' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Hills East' ,`StreetNumber` = '3444' ,`StreetSuffix` = '' ,`City` = 'La Grange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom-built home offered on 3 acres located just outside LaGrange in the Forest Hills East Subdivision! With 1935 square feet, this 3 bedroom, 2 bath home includes a refrigerator, washer and dryer and is ready for you to move in! Other features include high ceilings, a stone fireplace, beautiful wood flooring and plantation shutters throughout. One bedroom has a built-in desk and shelves and could be used as an office. Covered front and back porches offer a great place to enjoy the spacious and irrigated front and back yard. There is a 360 sq. ft. guesthouse currently being rented out but is perfect for in-laws or guests. Also included is a spacious workshop with electricity and plenty of parking space with a 2-car garage plus a carport.' ,`Acres` = '3.005' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FOREST HILLS EAST (637) LOT 35, 3.005 AC, HSE, GAR, C/PORT,' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Hills East' ,`TaxAmount` = '2785' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092121' WHERE `Matrix_Unique_ID` = '214550318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-17T12:58:19.517' ,`MLSNumber` = '10722598' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578753' ,`Longitude` = '-95.540575' ,`PhotoCount` = '26' ,`PostalCode` = '77489' ,`RoomCount` = '4' ,`ListPrice` = '304900.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Valley East' ,`StreetNumber` = '2706' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2706 Quail Valley East! Seller spared no expense getting this home ready for it\'s new owner. As you walk into the home, you are greeting by the large open foyer w/ wood burning fireplace. On the other side of the fireplace is a dining room but this space would also make a great home office. The kitchen is open to another dining area & towards the back of the home is the living room w/ a 2nd fireplace. There are 2 bedrooms down and 2 bedrooms up. There is a Hollywood bathrm between rooms upstairs & downstairs. Large oversized corner lot. Detached garage. Updates include, New Vinyl plank flooring, new carpet in bedrooms, new kitchen/bathrm cabinetry, sparkling quartz counter tops, new Whirlpool Elec. stove & dishwasher, new lighting package, fresh paint, new hardware, sinks, faucets, 2in faux blinds & so much more. Seller says AC could be less than 3 yrs old. Conveniently located to HWY 90, US-59 ,Fortbend Tollway and Hwy 6. Must see to appreciate all this home has to offer!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Quail Valley East Sec 1 Block 7 Lot 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '9892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LANTERN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley East' ,`TaxAmount` = '5006' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675092121' WHERE `Matrix_Unique_ID` = '214689619' --> 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','215129236','1675092122','215129236','2022-12-17T11:44:17.963','55555707','Michael Afshari','Compass RE Texas, LLC','','','29.768242','-95.535543','50','77024','22','3799000.00','Active','Knippwood','11917','Lane','Houston','6','2','6','6628','Single-Family','Just completed by Ashton Gray Development with architecture by renown Robert Dame- The residence is situated at the end of a cul-de-sac block within Bunker Hill & flaunts an effortless flow between the home’s living spaces. An expansive foyer spills into open living spaces overlooking a lush courtyard & backyard space (ready for pool/spa) that awash the interiors with natural light. The home is completed with top tier appliances throughout, the island kitchen & breakfast area opens to a soaring open great room outfitted with a wet bar – all of which opens to a backyard through custom sliding doors. 1st level Owners suite features a massive showroom closet, a stunning bathroom w freestanding tub, dual elongated vanities & private garden. 2nd Level: 4 additional en-suite rooms (1 mini master) with walk-in closets & massive game-room + a half bath finishes the floor. Home is completed with detached guest house with full bath, outdoor living w summer kitchen & full automation systems.','0.4809','23','Ashton Gray Dev','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections,Gaslog Fireplace','2','Memorial Villages','Central Gas','0','TR 5 BLK 1 KNIPPWOOD','Cul-De-Sac,Subdivision Lot,Wooded','20950','Appraisal District','','','1','Never Lived In','3','Double Oven','0','','','Freestanding Range,Gas Range,Grill','','Composition','49 - Spring Branch','BUNKER HILL ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Builder','2','Contemporary/Modern,French,Other Style','Knippwood','26785','2.1865','Public Sewer,Public Water','2022','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215470029','1675092122','215470029','2022-12-17T11:50:29.373','75499493','Terin Varghese','XAG Properties, LLC','','','29.692914','-95.799769','28','77406','7','325000.00','Active','Giovanni','11726','Lane','Richmond','2','0','3','1645','Single-Family','Charming Home with 3 Bedrooms & 2 Bath in the most desirable Lakes of Bella Terra! Excellent curb appeal with all brick surrounds and stone accents. High ceilings with beautiful archways, 1.5” granite countertops, C-tile backsplash, 42” maple cabinets, crown moldings, all rooms with ceiling fans, wood floors and a gas log fireplace are the few stunning features of this home. Primary Bedroom en-suite with dual vanity, walk in closet, soaking tub and a standing separate shower. Backyard is a gardeners retreat with a patio and garden seating area. Lakes of Bella is situated with miles of walking trails, stunning amenities such as Work out center, volleyball and tennis courts with a dog park. This home never flooded and has easy access to Westpark Toll and 99. Zoned to highly rated schools! Come see this home today!','','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','LAKES OF BELLA TERRA SEC 21, BLOCK 1, LOT 17','Subdivision Lot','5937','Appraisal District','','975','0','','2','Freestanding Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','33 - Lamar Consolidated','HUBENAK ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Lakes Of Bella Terra Sec 21','3759','3.0848','Water District','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','215542290','1675092122','215542290','2022-12-17T12:06:19.293','66310671','Brandy Hadley','RE/MAX ONE - Premier','','','30.699510','-95.075335','13','77351','3','295000.00','Active','Autumn','750','Lane','Livingston','2','0','3','1625','Single-Family','A Rewarding Escape peacefully situated with a water-view from primary bedroom, living-room and back porch. Resting on a 7050 square foot lot. Estimated completion date sometime in January 2023. This house has 3 bedrooms and 2 bathrooms. Vaulted ceilings in living room and primary bedroom. LVP flooring throughout. Kitchen will be equipped with quartz counter-tops, white custom cabinets and matte gold fixtures. Spray foam under roof. Stained faux beams in living room and primary bedroom. Access to amenities including clubhouse, swimming pool, private community boat launch, picnic and playground area. Better call your favorite realtor to visit this one fast!','0.1618','44','Costa Project Mang.','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Lake Livingston Area','Central Electric','1','MEMORIAL POINT BLK 8 LOT 45','Water View','7050','Appraisal District','','129','1','To Be Built/Under Construction','2','','0','','','Electric Range','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access','Builder','1','Traditional','Memorial Point','68','2.7745','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215656932','1675092122','215656932','2022-12-17T12:35:52.947','32025847','Carolyn Lentini','eXp Realty, LLC','','','29.433575','-95.416496','32','77583','11','749990.00','Active','Granite','10315','Court','Iowa Colony','4','1','5','4476','Single-Family','Spectacular 2 Story luxurious home built by Shea Homes. Before you enter this home, notice the big covered porch and extra wide door, the grand entry boast soaring high ceilings and wood floors in the main areas, including dramatic curved staircase steps, master bedroom, study and upstairs hallway. A secondary bedroom downstairs with full bath, great for multi-generational families. Gourmet Kitchen boasts lots of counter space, spacious island for entertaining, Stainless steel appliances including a 5 burner cooktop, double oven, walk in pantry. Luxurious family room with wall of windows and beautiful stone surround fireplace. Primary bedroom has wood floors and bay wdw and leads to spacious bath with dual sinks and long countertops and 2 walkin closets. Upstairs has 3bedrooms, full bath and a Jack and Jill bath. The gameroom fits a full size pool table and the media room is pre wired for surround and projector. Prewired for outdoor camera. Look no more, relocating/priced to sell','0.2267','5','','','Electric Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Alvin North','Central Gas','1','MERIDIANA SEC 70 (A0513 HT&BRR) (IOWA COLONY) BLK 1 LOT 24 (','Cul-De-Sac,Subdivision Lot','9875','Appraisal District','','1050','0','','3','Double Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Builder','2','Contemporary/Modern','Meridiana Sec 70 A0513 H&Brr','17906','3.5438','Public Sewer,Public Water,Water District','2019','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','215676787','1675092122','215676787','2022-12-17T12:56:31.707','73018670','Francisco Leal','Eastwood Realty','','','29.732955','-95.331395','39','77023','6','429000.00','Active','Jefferson','4725','Street','Houston','2','0','3','1340','Single-Family','Recently updated charming and spacious home in the heart of Eastwood. Three bedrooms and two baths. Centrally located, just minutes away from Downtown Houston, Medical Center and University of Houston. Right cross the street from Austin High School.','0.1148','4','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','East End Revitalized','Central Gas','0','LT 31 LAWNVIEW','Subdivision Lot','5000','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','27 - Houston','CAGE ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (HOUSTON)','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Lockbox Back,Lockbox Left Side','Appraisal District','1','Traditional','Lawnview','3482','2.3307','Public Sewer,Public Water','1940','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','215700603','1675092122','215700603','2022-12-17T12:03:53.343','85762177','Christina Thurlow','Texas Legacy Properties','','','29.488117','-95.769260','30','77469','4','330000.00','Active','Prairie Dog Fork','5347','Lane','Richmond','2','1','4','1940','Single-Family','Only 2 year old lennar home with brick & stone exterior in Still Creek Ranch! Charming 1 story, 4 bedroom, 2 bath home. Open concept with a large island in the kitchen with granite countertops, and stainless steel appliances including breakfast nook! Kitchen overlooks large family room. Master suite offers a huge joining master bath with garden tub, separate shower, separate toilet and large walk-in closet! Luxury vinyl plank flooring throughout main living areas, & carpet in bedrooms, 2\" wood mini blinds, ceiling fans & energy efficient system and so much more. Appliances included. This home is a Wi-Fi certified smart home featuring integrated automation and voice control with Amazon Alexa. You will love entertaining others while you sit back & enjoy your very own private premium lot with a beautiful lakeview under your covered porch! Easy access to HWY 59! Several new developments in the area starting at 400K for 3 bdrms.','0.1515','30','','','','','Mud,Sellers Disclosure','','','','Fort Bend South/Richmond','Central Electric','1','STILL CREEK RANCH SEC 1, BLOCK 2, LOT 21','Subdivision Lot,Water View','6600','Other','','450','0','','2','','0','','','','','Composition','33 - Lamar Consolidated','CULVER ELEMENTARY SCHOOL','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Still Creek Ranch','7295','2.9148','Water District','2020','Builder'); --> New record created successfully